C:\Program Files\MySQL\MySQL Server 4.1\bin>mysqldump --user=rootOf course, this assumes a Windows environment and that the installation directory is the same.
--password=mypassword --databases mydbname
Friday, June 8, 2007
Quck and Dirty MySQL Database Backup
Here is a quick and dirty way to backup a database in MySQL, structure and data included. Run this from the command line, NOT the MySQL Client command line: