Wordpress Website Database Error - Blog

WordPress Website Database Error

By admin 0 Comment March 5, 2019

Webhosting met gratis support

Razendsnelle webhosting op Nederlandse SSD servers

  • Gratis domeinnaam
  • Gratis website software
  • Betrouwbare webhosting

Bestel

Webhosting Pakketten

Je wil een website maken zonder bezig te zijn met de technische kant? Onze pakketten vragen geen technische kennis en zijn ontworpen voor de beste prestaties. Dankzij onze razendsnelle SSD opslag is je website supersnel. Dat zorgt niet alleen voor blije bezoekers, maar Google neemt dit ook mee voor de ranking. Bovendien is elk pakket inclusief e-mail en krijg je van ons het eerste jaar een gratis domeinnaam cadeau.

Extra specificaties

Wat zit er in een webhosting pakket?

SSD opslag

Alle inhoud op je website moet opgeslagen worden. Hier wordt een harde schijf voor gebruikt net zoals in een PC of laptop. Bij Argeweb gebruiken we SSD (Solid State Drive) opslag. Een SSD is tot wel 5x sneller dan een normale harde schijf (HDD). Zo heb je altijd een snelle website.

We bieden opslag capaciteit van 5GB, 25GB en 50GB. Hoeveel je nodig hebt is afhankelijk van de hoeveelheid inhoud die je online gaat plaatsen (afbeeldingen, video’s en andere inhoud). De meeste mensen hebben genoeg aan 5GB opslag, maar je kan natuurlijk zelf de beste inschatting maken van de opslagcapaciteit die je nodig hebt.

Dataverkeer

Het dataverkeer kan je vergelijken met een mobiel abonnement. Het is een databundel die bestaat uit GB’s (Gigabytes) die je kan verbruiken om onder andere het internet te bezoeken, afbeeldingen te bekijken of video’s af te spelen.

Bij webhosting is het dataverkeer bestemd voor de bezoekers van je website. Elke keer als iemand op je website zit wordt er data gedownload. We bieden dataverkeer capaciteit aan van 20GB, 50GB en 250GB. De hoeveelheid dataverkeer die je nodig hebt is afhankelijk van het aantal bezoekers en hoeveel inhoud online staat.

Zakelijke e-mail

Bij een webhosting pakket hoort ook een zakelijke e-mail box. Je kan dan al je contacten met een professioneel e-mailadres mailen waar je bedrijfsnaam in voorkomt. Daarnaast kan je je collega’s of elke afdeling een eigen e-mailadres geven.

Wij bieden 15, 50 of 100 e-mailadressen aan. Om het te installeren heb je geen technische kennis nodig. Wij regelen dit voor je, zodat je e-mailadressen direct klaar voor gebruik zijn.

Gratis domeinnaam en verhuisservice

Het eerste jaar krijg je een domeinnaam van ons. Daarnaast zit er in je webhosting pakket subdomeinen, e-mailadressen met je eigen naam en uitgebreide webstatistieken. Wil je je website verhuizen naar Argeweb? Fijn! Met onze gratis verhuisservice verhuis je een website zonder downtime. Wij nemen het technische gedeelte uit handen zodat jij je geen zorgen hoeft te maken over termen als FTP, MySQL, databases en configuratiebestanden.

A Step By Step Guide to Migrating Your WordPress Website to a New Web Host

Moving your website to a new host can be a daunting and stressful experience, but it doesn’t need to be.

Many people are faced with the need to move to a new host because of problems with their current provider and have just had enough. But all too often, migrating to a more reliable host is delayed time and again for fear of making a mistake and damaging your site(s).

To get around the problem, people will either pay a professional to move their site for them, find a new host that offers the service as part of a new hosting package, or take the third option of having a go at it themselves.

If you spend a little time preparing your own website, migrating is nothing to be concerned about. It can be a very straightforward project if approached correctly and can easily be reversed out of should any problems occur.

Let’s run through the steps required to move your WordPress website to a new host.

Step 1: Back Up Your Website’s Files

The very first step of any project such as this is to back up every aspect of your site. This step is good practice before any major change but it is also a requirement of migrating your WordPress installation.

There are many plugins out there that will completely backup your site for you. This backup however, requires a more manual approach. Using an FTP program (such as Transmit), connect to your web host and copy all files under your website’s directory to a folder on your local computer.

This includes the .htaccess file that is set to be hidden. Consult your FTP program’s help file to have it display hidden files if you are unable to see this file.

Depending on the number of media uploads you have in your site, this could take some time. While this download is underway we can begin step two and make a copy of your database.

Step 2: Export The WordPress Database

Exporting your database is a simple process that only requires a few steps to complete. Login to the cPanel account of your web server and open the phpMyAdmin application. Select the database that contains your WordPress installation from the list on the left hand sidebar and once selected click on the Export tab on the navigation menu.

The default settings of a Quick export and the SQL format for the export are sufficient for what we need. Click the Go button and the database export process will begin and a file will be downloaded to your local computer.

Once the database export and the FTP transfer of your files have both completed, you are ready to move onto the next stage.

Step 3: Create The WordPress Database On Your New Host Server

Before we can begin the migration to the new web host, we need to create an environment for a WordPress installation. To do this you must create a database that you can import your SQL data into.

Login to your new web host with the user credentials they have supplied you and connect to the cPanel software. For our guide we will be using the MySQL Databases application. If your web host doesn’t have that application running then you will should contact their support team to discover their method of creating new databases.

The steps to create a database are quite simple:

  • Open MySQL Database and create a new database with an appropriate name for your website.
  • Create a new MySQL user (with a secure password).
  • Add this user account to the new database and grant it All Privileges.

Write down the database name, the new MySQL username and its password. You will need them soon.

Step 4: Edit the wp-config.php File

Browse to the folder on your local computer where you downloaded your website files to. In that folder there is a file called wp-config.php that controls the access between WordPress and your database.

Make a copy of this file and store it in another folder on your local computer. This is necessary for restoring the changes we are about to make should something go wrong later.

Open the original version of the file with your favorite text editor and make the following three changes:

1. Change The Database Name

Locate the following line:

The db_name portion of this line will currently be set to the MySQL database name of your old web host. This must be changed to the name of the new database you have just created.

2. Change the Database Username

Below this you will find the line:

In this line you need to change the db_user portion from the username of your old host to match the new username you have just created.

3. Change The Database User Password

Finally, edit the third line:

As with the others the db_pass section of this line must be changed to the new secure password you created for your MySQL user.

Save wp-config.php and close the file.

Step 5: Import Your Database

Now that you have a new database to work with we can begin the import process.

Launch phpMyAdmin from the cPanel software on your new server and select your new database from the list on the left hands sidebar. Once it opens select the Import tab from the navigation menu.

In the File to Import section click the Choose File button and select the SQL file you exported previously.

Un-tick the Partial Import check box, make sure the format is set to SQL and then click the Go button. The database import will now begin.

The time this import takes varies depending on the size of your database. You should receive a message informing you of the success of the import when it has finished.

Step 6: Upload The WordPress Files To Your New Host

Now that you have the new database prepared and you’ve reconfigured the wp-config.php file, it is time to begin uploading your website’s files.

Connect to your new web host using your FTP program and browse to the folder that your website is going to be held. If this is the primary, or only site being installed on this web server then uploading the files to the public_html folder is the usual directory.

With the remote directory selected you can upload your website files that should now include the updated version of wp-config.php. As with the earlier download, this process can take some time.

Don’t delete these files from your local computer once the upload finishes. They are still needed until the final steps have been completed.

Step 7: Linking to New URL & Defining New Domain

If you are moving to a new/different domain then you should read over this step, if not, then you can skip this because you don’t have to update your site to point to a different domain.

One issue people always seem to have when moving their site is that they’ve added links to other posts on their site or inserted images directly by pointing to a URL on the server, causing these to break when moved over to a new domain. If you want to quickly and easily search for any instances of your old domain name and replace with the new name we suggest you take a look at the Search Replace DB script on github. This will allow you to do this with great ease. Just make sure you DELETE it when your are done (for security reasons) and don’t place it in your root domain, create a temp folder with a random name to host the script.

Changing Site URL: By doing a search and replace for the old domain and replacing with the new domain you’ll also be altering the site_url and home url values in the database (Changing the Site URL) which will ensure that when you try to log into your site on the new domain it doesn’t try and redirect you over to the old domain.

Step 8: The Final Touches

This step actually includes two separate things with (potentially) several days between them.

Before you can use the site on your new host you will need to reconfigure your domain’s DNS settings. They will be set to point to your old host and you will need to point the correct records to the new server IP address.

This process will depend on where you have your domain registered. The details of completing this process are too varied to discuss in this post, but your domain registrar should have all of the details you need to make this change.

DNS changes can take up to 48 hours to fully propagate. It’s best to do this at a period when you expect lower levels of traffic. During this 48 hour window you should avoid making any changes to your website as you may be changing the old version of the site.

After the 48-hour period has expired you should now be accessing the new web host when you go to your website. It’s at this point you can connect to your old web host to delete the files and database. You should still have a local backup copy of these files and the database export, along with the original wp-config.php file in case you need to roll back the migration. It can be a good idea to hold onto these files for a an extended period just to be on the safe side.

Conclusion

As you can see, when broken down into the above simple steps, the process isn’t that difficult. All it really requires is for you to be careful at each step and give yourself the option to go back to the original version until the last possible moment (in case of any problems).

Have you migrated your WordPress website recently? Let us know your experience with the process in the comments section below!

How To Restore WordPress Website From Backup Swiftly and Safely

WordPress backup is one of the most important processes in regular WordPress maintenance. There are lot of ways you can backup your WordPress website. Based on the method you choose to backup, the process to restore WordPress website also varies. If you are restoring your WordPress website after a security issue or a hack, then you have to be very cautious in the process to restore WordPress website. In this post we are going to see all the best possible ways to restore your WordPress website swiftly and also safely.

[tables_content title=”Table of Contents”][table_content link_type=”custom-link” title=”Types Of WordPress Backup Process” link=”#types”][table_content link_type=”custom-link” title=”How to Restore WordPress Website With a Plugin” link=”#plugin”][table_content link_type=”custom-link” title=”- How To Restore WordPress From BackupBuddy Backup” link=”#buddy”][table_content link_type=”custom-link” title=”- How To Restore WordPress From UpdraftPlus Backup” link=”#draft”][table_content link_type=”custom-link” title=”How to Restore WordPress Site From Cpanel” link=”#cpanel”][table_content link_type=”custom-link” title=”How to Restore WordPress Site Using phpMyAdmin” link=”#php”][/tables_content]

Note: In this post it is consider that you have made a complete backup of your site. If you have made only partial backup, make sure you download all the files from your server database before proceeding to restore WordPress website. To avoid loss of data and files.

Types Of WordPress Backup Process

As said before the restore process is based on the type of backup process you made. In general, the backup can be done by two methods

  • Backup with a plugin – the most common and the easiest way
  • Manual Backup – the professional way

If you made a backup with a plugin then with the same plugin only you can restore the backup. It is always wise to keep a regular backup even if your site is hacked or contains any malware you can easily restore the version that is free from the malicious software and programs.

[pro_tip title=”Pro Tip:”]Always maintain different sets of backups in different locations. Even if you have a problem with one backup, there is another to help you out.[/pro_tip]

How to Restore WordPress Website With a Plugin

If you have made a backup with a plugin, you can easily restore WordPress website easily with that plugin itself. The most commonly preferred and used backup plugins are

  • BackupBuddy – premium backup plugin
  • UpdraftPlus – freemium WordPress backup plugin

I will explain with these plugins, for now, most of the backup plugins provide the restore options and restoring process varies.

How To Restore WordPress From BackupBuddy Backup

BackupBuddy is a premium plugin they made the restoring process simpler, that is you can restore your complete site within few clicks.

After creating a backup for your site and downloading the backup ZIP file to your system, go to BackupBuddy > Restore/Migrate there download the importbuddy.php file.You will be prompted to enter your password. This file is going to act as a one-click install manager to restore WordPress database from backup.

After downloading the backup ZIP file and the importbuddy.php file. Log into your cPanel and delete all the pre-existing database files in the root directory.

Now your WordPress website root directory is clean as a slate. You can now upload your backup ZIP file and the importbuddy.php file.

After the upload is complete add importbuddy.php to your website’s URL path. For example, the page URL will be like this https://www.restoresite.com/importbuddy.php

Now the window will ask your importbuddy password to begin the restoring process. Enter the password and authenticate the process.

On the next screen, you will see the backup ZIP file you uploaded. In case if you have chosen a wrong backup ZIP file you can select the correct one from the Upload a backup file option.

Select whether you want to restore the files or database. In my case, I choose both the option and click restore backup

When you are restoring the website, you need to create a new database and have to provide the URL path to the database to store.

We have already emptied your WordPress website’s database. For a hacked site it is better to create a new database.

Now importbuddy files get into action to restore WordPress from the backup. Unzipping of the backup ZIP files and placing them in the new database all are done automatically. After completing the restoring process following window will be shown.

Clear Extra Files Came With Your Backup

Since it is an automated process now your database will have additional files in your database; these files helped you in the automation. You can clean this additional files by clicking the Finish Cleanup.

Before clicking the Finish clean up, verify your site. Check your restored website for any errors. If you are restoring your website from partial backup, don’t forget to upload the rest of the files you have downloaded separately.

How To Restore WordPress From UpdraftPlus Backup

UpdraftPlus stands second to the BackBuddy based on the number of users it has. It is a freemium plugin; you can do a primary backup and restore it in the free version itself. In the premium version, you get advanced functionality like a vault, migrating option, remote storage.

First, you need to create a backup with the UpdraftPlus plugin. Log into your cPanel, delete all pre-existing database files in the root directory.

Now your website will look like a fresh install. Configure your WordPress dashboard with new username and password. Log into your WordPress dashboard, install the updraftplus plugin.

Go to Settings > UpdraftPlus Backups and click on the restore button. In that select the Upload backup files option

Select the backup ZIP file downloaded and click restore. You will get a popup asking you to select the components you need to restore.

The extraction of the backup ZIP files starts now, and the process to restoring your WordPress website begins. After completing the WordPress website restore process, the success page appears.

How to Restore WordPress Site From Cpanel

If you made a manual backup; restore WordPress site from Cpanel is the simplest and the most comfortable way. Log into your cPanel, under file section click the backups. In it, under the Restore a MySQL database option choose the Backup ZIP file you have created.

Click restore database. Now you have restored your WordPress website from the manual backup you have created.

How to Restore WordPress Site Using phpMyAdmin

Restore WordPress from the cPanel is a manual process to restore your WordPress website. If you manually backup your WordPress website then use this method.

In this method, you can restore your WordPress website in two ways. Either by entirely dropping your database and creating a new one, or you can just drop the files in the database and import the files to the existing database.

The first one is identical to a hacked website. For more reliable and secure process I will go by creating a new database.

Drop all the database and files from your root directory as mentioned in the BackupBuddy process. After clicking the MYSQL database, the following screen appears.

After creating a database, you will be asked to create a new user and a password. After creating a new user to the database, you have to add that user to the database.

From the drop-down menu select the new database created and assign it to the new user you have created. Now your new database is ready.

Next, we have to get into the phpMyAdmin option. In the phpMyAdmin panel select the import option. In that choose the backup ZIP file you have manually created.

Now you have to configure the new database to the WordPress, for that you need to add your new database settings into your wp-config.php file. You can create a wp-config.php file easily from the wp-config-sample.php file. The sample config file will be there by default when you make the WordPress install on the server.

In the wp-config-sample.php file do the following changes

[code language=”php”]
// ** MySQL settings – You can get this info from your web host ** //
/** The name of the database for WordPress */
define( ‘DB_NAME’, ‘database_name_here’ );

/** MySQL database username */
define( ‘DB_USER’, ‘username_here’ );

/** MySQL database password */
define( ‘DB_PASSWORD’, ‘password_here’ );

/** MySQL hostname */
define( ‘DB_HOST’, ‘localhost’ );
[/code]

Place the new database name, username and password in the required field and save the file by removing sample and as wp-config.php

Restore Your WordPress Website

So these are the most commonly used methods to restore WordPress website database and files. Again if you made a partial backup; before starting to restore WordPress website make sure that you download all the files that are not covered in your partial backup.

The most common problems that hit while restoring the WordPress websites are

If you have any problem like these, never fear we are here to help you with our WordPress support services. If you are not aware of our 30 mins free job for new WP Team Support users, you can fix small issues with our experts easily.

Until next time; Cheers.

WordPress Web Developer, Content Writer. Love new web design and working with several companies related to different niche to make their website meet the present-day audience needs.

Autostart MySQL After a Crash : Solve WordPress Database Connection Error

WordPress Error establishing a database connection is frequently faced problem. In our previous guides, we pointed to properly configure my.cnf, that is adding [mysqld_safe] stanza at the end of my.cnf file with socket, PID. For newer versions of MYSQL, we written guide for Percona MySQL to auto-restart. Newer Ubuntu, Debian installations do not automatically create the required debian-sys-maint user for restart. In that installation guide, we tried address it. However, still MySQL may fail to auto restart after a crash! Here is one fallback way to autostart MySQL after a crash.

Autostart MySQL After a Crash : Reasons of Failure

Unfortunately, MySQL may start to fail depending on the error the crash happened!. In the above paragraph, we described one type of errors in configuration and absense of the required user to execute the work.

Corrupt MySQL binary can cause the MySQL server to fail. Ownership and permissions of the MySQL files such as binaries, logs may get itself changed during a version upgrade, which may lead to errors. The /tmp directory should be checked for permission, space. Lack of disk space, not enough memory may fail the automatic restart process. A badly coded WordPress plugin may create odd situation. Self hosted analytics plugins may invite trouble.

Autostart MySQL After a Crash : Fallback Bash Script and Cron

Depending upon your situation, a fallback bash script and cron job to execute the script may act as additional layer for peace when chance to manually check the site too longer! You’ll notice during upgrades that Percona identifies ownself as :

Add Comment

Your email address will not be published. Required fields are marked *