User:Woozle/MySQL migration

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
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 "mysqldump -uroot -p woozalia_mw" > /mnt/cloud4-01/migrate/woozalia_mw.sql