Differences

This shows you the differences between two versions of the page.

--- computing:migratewp [2019/06/16 05:50] – oemb1905
+++ computing:migratewp [2019/12/30 02:37] – oemb1905
@@ Line 33: / Line 33: @@
   sudo scp mysqldump-all-databases.sql user@newhostorip.com:
+Before your import the mysqldump databases into the new database, you need to create what I call a "surrogate" user and database to do the heavy lifting for you first.  You will also grant this surrogate user super privileges.  Make sure the name you pick is unique and was not present in the database backup and/or a restricted user name.
-Now, time to import that database into the new host:
+  CREATE DATABASE newdatabase DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
+  GRANT ALL ON newdatabase.* TO 'newdatabaseuser'@'localhost' IDENTIFIED BY 'temporarypassword';
+  FLUSH PRIVILEGES;
+  EXIT;
+  CREATE USER 'newdatabaseuser'@'%' IDENTIFIED BY 'temporarypassword';
+  GRANT ALL PRIVILEGES ON *.* TO 'newdatabaseuser'@'%' WITH GRANT OPTION;
+Now, you need to create databases and grant privileges to the surrogate user for each of them.  You do this as follows:
-  mysql -u user -h localhost -p < /path/to/mysqldump-all-databases.sql
+  CREATE DATABASE restoreddb1 DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
+  GRANT ALL ON restoreddb1.* TO 'newdatabaseuser'@'localhost' IDENTIFIED BY 'temporarypassword';
-This will take some time.  Once it finishes, log into the mysql command mode and verify the databases made it over:
+If there are others, then repeat the commands above for each one, replacing restoreddb1 with the name of the databases you are importing and bringing in.  Now, time to import that database into the new host:
+  mysql -u newdatabaseuser -h localhost -p --database=newdatabase < /path/to/backup-databases.sql
+Once it finishes, log into the mysql command mode and verify the original databases made it over:
   sudo mysql -u user -p
@@ Line 44: / Line 58: @@
   > EXIT
-Run this command on both machines, and the output should be identical.  Now, it is time to migrate the website //files// over to the new host:
+If possibly, run this command on both machines, and the output should be identical.  Now, it is time to migrate the website //files// over to the new host:
   sudo scp -r /var/www/website.com/public_html user@newhostorip.com:/var/www/newwebsite.com/
-Put the files in the appropriate locations, and that should be it.  Definitely reboot, and I have found it is helpful to restart the router, modem, and workstations on the network.  If the old host is on the same network, this is helpful.
+Put the files in the appropriate locations, restart the mysql service and reboot.  Lastly, once you verify the original databases made it over and the website is restored and functioning, you can delete the surrogate user and database as follows:
+    DROP DATABASE newdatabase;
+    DROP USER 'newdatabaseuser'@'localhost';
- --- //[[netcmnd@jonathanhaack.com|oemb1905]] 2019/06/15 23:42//
+ --- //[[jonathan@haacksnetworking.com|oemb1905]] 2019/12/30 02:37//

Haack's Wiki

User Tools

Site Tools

Differences

Page Tools