Text* Snippets: backup code

Never been to TextSnippets before?

Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world (or not, you can keep them private!)

About this user

« Newer Snippets

Older Snippets »

1 total XML / RSS feed

mysql backup / restore

// description of your code here
exports given database to a textfile which can then be zipped and downloaded or sent somewhere (mailing pending)

mysqldump -u <username> -p -q --single-transaction <db_name> > <backup_filename>

To restore the database (be sure to create the target DB before running this)

mysql -u <username> -p <db_name> < <backup_filename>

To backup and restore data only, use -t, no table data

mysqldump -u <username> -p -q --single-transaction -t <db_name> > <backup_filename>

Then restore from command line as usual.

mysql -u <username> -p <db_name> < <backup_filename>

to mysql backup administration by deckard on Apr 12, 2007