This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revision | Next revisionBoth sides next revision | ||
computing:migratewp [2019/06/16 05:50] – oemb1905 | computing:migratewp [2019/08/17 19:58] – oemb1905 | ||
---|---|---|---|
Line 33: | Line 33: | ||
| | ||
sudo scp mysqldump-all-databases.sql user@newhostorip.com: | 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: | 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: | ||
Line 44: | Line 53: | ||
> 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. |
sudo scp -r / | sudo scp -r / | ||
| | ||
- | Put the files in the appropriate locations, and that should be it. | + | Put the files in the appropriate locations, |
+ | |||
+ | DROP DATABASE newdatabase; | ||
+ | DROP USER ' | ||
--- // | --- // | ||
| |