How to backup mysql databases (mysqlhotcopy, mysqldump)
By jeltsch on Sat, 12/16/2006 - 18:43There are different possibilities. If you have access to the machine where mysql is running, you should use:
mysqlhotcopy
On our RedHat 8 server you just type:
/usr/bin/mysqlhotcopy --user=root --password=sdjksjd journal /path/to/backup/directory
Alternatively:
/usr/local/mysql/bin/mysqldump --user=username -p phpgedview >phpgedview
The path of the command is specific for the mysql install on a MacOS X machine.