This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
computing:migratewp [2019/08/17 19:58] – oemb1905 | computing:migratewp [2019/12/30 02:37] – 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 | ||
Line 62: | Line 67: | ||
DROP USER ' | DROP USER ' | ||
- | --- //[[netcmnd@jonathanhaack.com|oemb1905]] 2019/06/15 23:42// | + | --- //[[jonathan@haacksnetworking.com|oemb1905]] 2019/12/30 02:37// |
| |