Managing Your Database Using phpMyAdmin

Migrating WordPress website is certainly not something that we have to do every day, but it is not significant to know that this is done in three mouse clicks?  We would go on the assumption that you know all install WordPress, create a database, you connect to the database, do an export and import with phpMyAdmin. Here are certain steps to know how to install WordPress?

1 - Backup your data

If you do not frequently back up your WordPress site, you need to know the following steps as well as save your files, the data stored in your database.

 1.1 - Recover WordPress files

Nothing complicated. Arm yourself with your favorite FTP client, that’s our FileZila; login; repatriate all directories necessary for the proper functioning of your site. 

 1.2 - Recover data from Phpmyadmin

  1. Login to cPanel.
  2. Click  phpMyAdmin icon in the Databases section.  This will take you to phpMyAdmin page. 
  3. You can view the list of available databases on the left side.
  4. Check the given below screenshot.


phpmyadmin



save





2 - Transferring your data

 

Now you have downloaded all your data(backup file) on your computer, you should go ahead in reverse process. This time, you transfer your data (sql, zip, files) to the FTP server and choose the Import tab in phpMyAdmin.

 

3 - Small Changes friends

Once you have completed the data transfer to the new server successfully, you may face some obligation to make some small adjustments.

3.1 - I changed database

If you have changed the server, there may be high chances that the password for connecting to MySQL is not correct.  Once you moved the database to the new server, you must edit the config file login details by replacing the old details with the new login details.

3.2 - I have not changed my domain name
In this case, you don’t need to change any further details. Your site will run smoothly without any error.


3.3 - I changed domain name

Just Query this SQL command through PHPmyAdmin:-

UPDATE wp_posts SET guid = replace(guid, 'http://www.old-domain.com','http://www.new-domain.com');
UPDATE wp_posts SET post_content = replace(post_content, 'http://www.old-domain.com', 'http://www.new-domain.com');
UPDATE wp_postmeta SET meta_value = replace(meta_value, 'http://www.old-domain.com', 'http://www.new-domain.com');
UPDATE wp_options SET option_value = replace(option_value, 'http://www.old-domain.com', 'http://www.new-domain.com') WHERE option_name = 'home' OR option_name = 'siteurl';

  • 1 Els usuaris han Trobat Això Útil
Ha estat útil la resposta?

Related Articles

How do I deny IP address access?

Do you want to block someone from viewing your website? This tool will prevent anyone to view...

How to Change DNS Zones (MX, CNAME, and A records)

SharedWith cPanel 11.34, customers are provided accessibility to make some of these changes from...

How do I create and delete a cron job?

To create a cron job:    Simply, Log into -> cPanel.    In the...

Local, Backup, and Remote Mail Exchanger

 This is a setting that informs Reprise Hosting how to handle your inbound e-mails. We...

How to generate/download a full backup

A complete back-up is a back-up of all of your information, e-mail, data source, etc. To run a...