This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revision | Next revisionBoth sides next revision | ||
computing:migratewp [2019/08/17 19:58] – oemb1905 | computing:migratewp [2019/08/17 20:06] – oemb1905 | ||
---|---|---|---|
Line 42: | Line 42: | ||
CREATE USER ' | CREATE USER ' | ||
GRANT ALL PRIVILEGES ON *.* TO ' | GRANT ALL PRIVILEGES ON *.* TO ' | ||
+ | | ||
+ | Now, you need to create databases and grant privileges to the surrogate user for each of them. You do this as follows: | ||
- | Now, time to import that database into the new host: | + | CREATE DATABASE restoreddb1 DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci; |
+ | GRANT ALL ON restoreddb1.* TO ' | ||
+ | |||
+ | 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. | ||
mysql -u newdatabaseuser -h localhost -p --database=newdatabase < / | mysql -u newdatabaseuser -h localhost -p --database=newdatabase < / | ||
- | | + | |
- | This will take some time. | + | Once it finishes, log into the mysql command mode and verify the original |
sudo mysql -u user -p | sudo mysql -u user -p |