Loading and Dumping a MySQL Database Dec 5th, 2010 | Comments You can dump the database into a file using: 1 mysqldump -h hostname -u user --password=password databasename > filename You can load the dump into the database using: 1 mysql -h hostname -u user --password=password databasename < filename