submitted by:
MySQL: Backing up a large database with MySQL Dump
Backup large databases with the MySQLDump command line utility. PhpMyAdmin is a great tool but can choke on large databases such as active forums.
code snippet:
mysqldump -u username -p password database_name > backup.sql notes:
You will need to run this from the command line. It will create a full backup (structure and data) to the file backup.sql
