Differences

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

--- computing:migratewp [2022/07/31 17:48] – oemb1905
+++ computing:migratewp [2022/07/31 17:50] – oemb1905
@@ Line 42: / Line 42: @@
   EXIT;
-Now that you have created a temporary database and database user with full privileges, it is time to import the backup.
+Now that you have created a temporary database and database user with full privileges, it is time to import the backup. The second command is what I used on some temperamental instance. The first command below is simple enough and should work. I retain both just in case an instance talks back to me.
-  mysql -u newdatabaseuser -h localhost -p --database=newdatabase < /path/to/backup-databases.sql
+  mysql -u tempuser -p temp < /path/to/backup-databases.sql
+  mysql -u tempuser -h localhost -p --database=temp < /path/to/backup-databases.sql
 Once it finishes, log into the mysql command mode and verify the original databases made it over:

Haack's Wiki