Difference between revisions of "User:Woozle/MySQL migration"
Jump to navigation
Jump to search
| Line 2: | Line 2: | ||
<bash>mysqldump -uroot -p ispda_en_mw | ssh cloud4 "cat > /mnt/cloud4-01/migrate/ispda_en_mw.sql"</bash> | <bash>mysqldump -uroot -p ispda_en_mw | ssh cloud4 "cat > /mnt/cloud4-01/migrate/ispda_en_mw.sql"</bash> | ||
| − | Import one database schema from cloud1 to local folder | + | Import one database schema from cloud1 to local folder: |
| − | <bash>ssh | + | <bash>ssh cloud1.hypertwins.net "mysqldump -uroot -p woozalia_mw" > /mnt/cloud4-01/migrate/woozalia_mw.sql</bash> |
==Notes== | ==Notes== | ||
* [https://www.maketecheasier.com/ssh-pipes-linux/ How to Use SSH Pipes on Linux] | * [https://www.maketecheasier.com/ssh-pipes-linux/ How to Use SSH Pipes on Linux] | ||
Revision as of 14:08, 5 July 2017
Export one database schema from local machine to cloud4's attached storage: <bash>mysqldump -uroot -p ispda_en_mw | ssh cloud4 "cat > /mnt/cloud4-01/migrate/ispda_en_mw.sql"</bash>
Import one database schema from cloud1 to local folder: <bash>ssh cloud1.hypertwins.net "mysqldump -uroot -p woozalia_mw" > /mnt/cloud4-01/migrate/woozalia_mw.sql</bash>