Differences

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

--- computing:migratewp [2019/12/30 02:37] – oemb1905
+++ computing:migratewp [2022/07/31 17:42] – oemb1905
@@ Line 11: / Line 11: @@
 -------------------------------------------
-This tutorial is designed to step one through how to migrate a self-hosted Word Press site manually.  First, completely set up LAMP and TLS and DNS, etc., before you begin migration, and review [[https://jonathanhaack.com/dokuwiki/doku.php?id=computing:apachesurvival|Apache Survival]] if you are unclear on how to do that.  Now, once that is set up, authenticate as root on the //old host// and backup your entire database (thanks to @jjscha for this mysqldump syntax):
+This tutorial is designed to step one through how to migrate a mysql database to another host. First, use mysqldump to dump the entire database:
   sudo -i
@@ Line 41: / Line 41: @@
   EXIT;
   CREATE USER 'newdatabaseuser'@'%' IDENTIFIED BY 'temporarypassword';
-  GRANT ALL PRIVILEGES ON *.* TO 'newdatabaseuser'@'%' WITH GRANT OPTION;
+  GRANT ALL ON newdatabase.* TO 'newdatabase'@'localhost' IDENTIFIED BY 'temporarypassword';
 Now, you need to create databases and grant privileges to the surrogate user for each of them.  You do this as follows:

Haack's Wiki