PDA

View Full Version : Database Backup: is Copy and Paste ok?


Tradjick
05-18-2004, 02:32 PM
I usually go into the directory from the mysql installation and copy/paste the database. So far it went very smooth without any problems. (Note, there aren´t any users other than myself).
Is this ok what i´m doing? Or is there a risk that anything could go wrong?

Rick Sample
05-18-2004, 02:44 PM
I usually go into the directory from the mysql installation and copy/paste the database. So far it went very smooth without any problems. (Note, there aren?t any users other than myself).
Is this ok what i?m doing? Or is there a risk that anything could go wrong?


hmmm.....I usually find it easier to go into my adminCP and make a backup their. Just takes a second like that!

NTLDR
05-18-2004, 03:41 PM
The ACP backup will possibly fail when importing, its best to backup via the command line:

mysqldump --opt -uUSERNAME -p database_name > /path/to/backup.sql