Programming Life

How can you dump a MySQL database

from the shell command prompt type:

mysqldump -h SERVER_NAME DATABASE_NAME > BACKUP_FILE.sql

where:
- SERVER_NAME – is the database server name (usually localhost)
- DATABASE_NAME – is the name of the database to be dumped
- BACKUP_FILE – is the name of the file (usualy the name of the database plus the backup date)

Tags: backup, command line, dump, MySQL, server, sql file