Ben's House of Pancakes

Tuesday Aug 07, 2007

Dump your MySQL database

mysqldump --databases [dbname] -u [username] -p > [destfilename.ext]

Ahh, backups. Time for some modifications!

Comments:

Want some more fun? Send your dump back;

mysql -u [username] -p [-h hostname] [dbname] < backupdump.sql

You can also enter the database and do a source if you are on the same server.

Posted by Jesse Bethke on November 09, 2007 at 10:36 AM CST #

Post a Comment:
  • HTML Syntax: Allowed

Calendar

Feeds

Search

Links

Navigation

Referrers