https://briansnelson.com/index.php?action=history&feed=atom&title=How_to_Create_a_MySQL_Database_BackupHow to Create a MySQL Database Backup - Revision history2026-06-04T12:27:42ZRevision history for this page on the wikiMediaWiki 1.24.1https://briansnelson.com/index.php?title=How_to_Create_a_MySQL_Database_Backup&diff=548&oldid=prevBrian: Created page with "==How to Create a MySQL Database Backup== Create a backup is something you should do nightly or weekly, that way if the database ever crashes beyond repair you will have a ba..."2014-03-12T21:25:05Z<p>Created page with "==How to Create a MySQL Database Backup== Create a backup is something you should do nightly or weekly, that way if the database ever crashes beyond repair you will have a ba..."</p>
<p><b>New page</b></p><div>==How to Create a MySQL Database Backup==<br />
<br />
Create a backup is something you should do nightly or weekly, that way if the database ever crashes beyond repair you will have a backup.<br />
<br />
===How to backup the entire database===<br />
<br />
Backing up the entire database<br />
<br />
mysqldump –u <username> –p <databasename> > dump.sql<br />
<br />
''Example:''<br />
<br />
mysqldump -u brian -p briansnelsonwiki > briansnelsonwiki-backupdate.sql<br />
<br />
===How to backup just a table in a database===<br />
<br />
Backing up just the users tables in database briansnelsonwiki<br />
<br />
mysqldump -u<username> -p <databasename> <databasetable> > dumptable.sql<br />
<br />
''Example:''<br />
<br />
mysqldump -u brian -p briansnelsonwiki users > briansnelsonwiki.users-backupdate.sql</div>Brian