This shows you the differences between two versions of the page.
Next revision | Previous revisionNext revisionBoth sides next revision | ||
computing:migratewp [2019/02/18 05:45] – created oemb1905 | computing:migratewp [2019/08/17 19:58] – oemb1905 | ||
---|---|---|---|
Line 11: | Line 11: | ||
------------------------------------------- | ------------------------------------------- | ||
- | This tutorial is designed to step one through how to migrate a self-hosted Word Press site manually. | + | This tutorial is designed to step one through how to migrate a self-hosted Word Press site manually. |
sudo -i | sudo -i | ||
Line 30: | Line 30: | ||
> mysqldump-all-databases.sql | > mysqldump-all-databases.sql | ||
- | The spacing is optional and thanks | + | Use scp to get the file to the new host: |
+ | |||
+ | 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 " | ||
+ | |||
+ | CREATE DATABASE newdatabase DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci; | ||
+ | GRANT ALL ON newdatabase.* TO ' | ||
+ | FLUSH PRIVILEGES; | ||
+ | EXIT; | ||
+ | CREATE USER ' | ||
+ | GRANT ALL PRIVILEGES ON *.* TO ' | ||
+ | |||
+ | Now, time to import that database into the new host: | ||
- | mysql -u user -h localhost -p < /path/to/mysqldump-all-databases.sql | + | mysql -u newdatabaseuser |
| | ||
This will take some time. Once it finishes, log into the mysql command mode and verify the databases made it over: | This will take some time. Once it finishes, log into the mysql command mode and verify the databases made it over: | ||
- | mysql -u user -p | + | |
> SHOW DATABASES; | > SHOW DATABASES; | ||
> EXIT | > EXIT | ||
- | Run this command on both machines, and the output should be identical. | + | If possibly, run this command on both machines, and the output should be identical. |
- | scp -r / | + | |
| | ||
- | Put the files in the appropriate locations, | + | Put the files in the appropriate locations, |
- | --- // | + | DROP DATABASE newdatabase; |
- | + | DROP USER ' | |
+ | |||
+ | --- // | ||
| |