MySQL Forums
Forum List  »  Backup

Re: Back-up & restore. How?
Posted by: Claude Martin
Date: March 27, 2005 03:31AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
3824
March 27, 2005 02:33AM
Re: Back-up & restore. How?
2683
March 27, 2005 03:31AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.