{"id":873,"date":"2010-05-04T16:54:19","date_gmt":"2010-05-04T16:54:19","guid":{"rendered":"http:\/\/kedar.nitty-witty.com\/?p=873"},"modified":"2018-02-14T14:30:26","modified_gmt":"2018-02-14T14:30:26","slug":"steps-to-move-copy-rename-mysql-database","status":"publish","type":"post","link":"https:\/\/kedar.nitty-witty.com\/blog\/steps-to-move-copy-rename-mysql-database","title":{"rendered":"Steps to Move Copy Rename MySQL Database"},"content":{"rendered":"

Moving, copying or renaming database is a very basic activity. I have just noted a few commands for reference to quickly follow the required operation.<\/p>\n

1. Rename database on Linux Machine:
\n<\/strong>
\nA. Use RENAME DATABASE Command [MySQL 5.1].<\/p>\n

RENAME DATABASE db_name TO new_db_name;<\/p><\/blockquote>\n

B.<\/p>\n

mysql -uroot -pPASSWORD -e “drop database if exists NEW-DB-NAME; create database NEW-DB-NAME” && mysqldump -uroot -pPASSWORD SOURCE-DB-NAME | mysql -uroot -pPASSWORD NEW-DB-NAME && mysql -uroot -pPASSWORD -e “drop database SOURCE-DB-NAME”<\/p><\/blockquote>\n

2. Create Duplicate of a database:
\n<\/strong><\/p>\n

mysql -uroot -ppassword -e “drop database if exists DB_TO_BE_CREATED;create database DB_TO_BE_CREATED;” | mysqldump -uroot -ppassword DB_TO_BE_COPIED | mysql -uroot -ppassword DB_TO_BE_CREATED<\/p><\/blockquote>\n

3. Copy MySQL Database to Remote MySQL Server:<\/strong><\/p>\n

\n

3A. By using -h (hostname) option.<\/p>\n

Create MySQL Dump:<\/p>\n

mysqldump -uroot -ppassword –databases DB_TO_BE_COPIED > DB_TO_BE_COPIED.sql<\/p><\/blockquote>\n

Load MySQL Dump:<\/p>\n

mysql -uroot -ppassword -hHOSTNAME < DB_TO_BE_COPIED.sql OR Using Single Command: mysql -uroot -ppassword -e “drop database if exists DB_TO_BE_CREATED;create database DB_TO_BE_CREATED;” | mysqldump -uroot -ppassword DB_TO_BE_COPIED | mysql -uroot -ppassword -hHOSTNAME DB_TO_BE_CREATED 3B. By moving dump file to remote server. Create MySQL Dump: mysqldump -uroot -ppassword –databases DB_TO_BE_COPIED > DB_TO_BE_COPIED.sql<\/p><\/blockquote>\n

Copy SQL file to remote MySQL Server:<\/p>\n

scp DB_TO_BE_COPIED.sql username@remote-machin:\/path\/to\/copy<\/p><\/blockquote>\n

Login to remote-machin.<\/p>\n

Load MySQL Dump:<\/p>\n

mysql -uroot -ppassword DB_TO_BE_CREATED < \/path\/to\/copy\/DB_TO_BE_COPIED.sql<\/p><\/blockquote>\n

Here, I haven’t considered copying and moving data-files for MyISAM databases as these are just the commands-way.<\/p>\n","protected":false},"excerpt":{"rendered":"Moving, copying or renaming database is a very basic activity. I have just noted a few commands for reference to quickly follow the required operation. 1. Rename database on Linux…\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[8,377],"tags":[235,33,233,76,234],"class_list":["post-873","post","type-post","status-publish","format-standard","category-mysql","category-mysql-articles","tag-copy-mysql-databaes","tag-database","tag-move-mysql-database","tag-mysqldump","tag-rename-mysql-database"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t