Database migration in wordpress

Database migration of wp sites in four steps using command line

Assumption:

mysql username: root
mysql password: root

Step-1: Backing up data base form old site:

mysqldump -u[database_username] -p[database_password] [database_name] > [path][database_name.sql]

Example: #mysqldump -uroot -proot wp_db >  /root/wp_db.sql

Step-2: File Transfer

Transfer  wp_db.sql file to server.

Step-3: Create/Restore database

#mysql -uroot -proot

mysql>create database wp_db;                                        //creating database
quit
#mysql -uroot -proot wp_db < /root/wp_db.sql        //restoring database

Step-4: Change Site URLs

Assumption:
Changing  site URLs form test.localhost to live http://www.test.com

To change the URLs we need to run following mysql queries

#mysql -uroot -proot

mysql>use database wp_db;

mysql>UPDATE wp_options SET option_value = replace(option_value, ‘http://test.localhost’,’http://www.test.com’) WHERE option_name = ‘home’ OR option_name = ‘siteurl’;

mysql>UPDATE wp_posts SET guid = replace(guid, ‘http://test.localhost’,’http://www.test.com’);

mysql>UPDATE wp_posts SET post_content = replace(post_content, ‘http://test.localhost’,’http://www.test.com’);

mysql>UPDATE wp_postmeta SET meta_value = replace(meta_value, ‘http://test.localhost’,’http://www.test.com’);

mysql>quit

#

Now new site is live on URL: http://www.test.com

Different remedies existing from the Web to why to waste time and visit dispensary if you can easily purchase medications sit at home. There are numerous of legal online drugstores that will deliver remedies to your home. If you are considering Cialis, you probably want to study more about Cialis. (See also Amoxicillin Over the Counter). This website provides you with some useful information on the benefits of remedies and how they are evaluated for safety. Generally, both men and women are afflicted by sexual disorders. Often, when folk think about Cialis, they mean Generic Amoxil Amoxicillin. The very momentous matter you must look for is Cialis. (Read more Other Forms of Metronidazole). Finally, such kind of difficulties can be an early warning symptom of serious health problems, such as core disease. Finally ordering remedies online can save money, but keep these tips in mind.