User:Woozle/MySQL migration
Jump to navigation
Jump to search
Export one database schema from local machine to cloud4's attached storage:
mysqldump -uroot -p ispda_en_mw | ssh cloud4 "cat > /mnt/cloud4-01/migrate/ispda_en_mw.sql"
Import one database schema from cloud1 to local folder:
ssh cloud1.hypertwins.net "mysqldump -uroot -p woozalia_mw" > /mnt/cloud4-01/migrate/woozalia_mw.sql
Notes
- How to Use SSH Pipes on Linux
- Add a link from MySQL/porting/data at some point.