Re: Back-up & restore. How?

[Claude Martin]

one very simple way is using mysqldump and mysql.
try something like this:

export data:
mysqldump -u USERNAME -p PASSWORT -h localhost DBNAME > /var/backup/DBNAME.sql

note: use compatible=mysql323 if you want to import in mysql version 3. if you have problems with comments in the dunpfile use: --skip-opt

to import:
mysql --user=USERNAME --pass=PASSWORD --host=SERVERHOST DATABASE < /PATH/FILE.SQL

http://animalliberation.tk http://veganismus.ch
http://maqi.de http://tierrechtskochbuch.de