Yahook
06-21-2005, 09:09 AM
Subj:
mysqldump --databases database1 [database2 database3...] > my_databases.sql
xariton
06-22-2005, 11:36 AM
I use this command to make dump from some tables
mysqldump --add-drop-table --quote-names --extended-insert --quick 'DATABASE' TABLE1 TABLE2 TABLE3 TABLE4 --host='HOST' --user='USERNAME' --password='PASSWORD' > 'FILE.sql'
And you can add your dump in mysql by this command:
mysql --host='HOST' --user='USERNAME' --password='PASSWORD' --database='DATABASE' < 'FILE.sql'
ghood
07-06-2005, 10:46 PM
NOTE, that there can be incompatibility beetween different MySQL versions, e.g. 4.0 vs 4.1.
Check out the manual.