SSH databse backup

[lasto]

anyone know of a tutourial as i aint got a clue how to do this and phpmyadmin crashes out after 1.5 megs

[NTLDR]

Backup:

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

Restore:

mysql -uUSERNAME -p DATABASE-NAME < /path/to/restore.sql

Change USERNAME to your MySQL username, and DATABASE-NAME to the name of the DB to backup/restore allong with a valid path and filename.

[filburt1]

<a href="http://www.vbulletin.com/manual/movingservers.html" target="_blank">http://www.vbulletin.com/manual/movingservers.html</a> (basically what NTLDR said, though)

[lasto]

cheers NTLD and filburt is much appreciated as been messing on this all morning thinkin phpmyadmin was messed up

Ive now suzzed it using the hack that is in beta shame they may not work on vb3 when it is finally released though.

Thanks for help though :)

[filburt1]

FWIW, phpMyAdmin and any PHP-based method is extremely unreliable. I never did understand why Jelsoft included a link in the admin CP to make backups...and as a result I believe they added a warning to the link that is in vB3. SSH, Telnet, or via your host are the most reliable ways. :)