Backing up and restoring a MySQL database is a relatively easy proposition provided you have adequate access priviledges to the database. The following commands write and read to the current directory. You'll also need sufficient access priviledges in your current directory to execute these. Note:Italic words are user variables.

Backup (a.k.a. Dump)

$ mysqldump -u username -p databasename > outputfile.sql

Restore

$ mysql -u username -p --database=databasename < outputfile.sql

That's it, short and sweet. Told ya it was easy!

• Add New
• Search
• RSS

Comments (0)

Write comment

Your Contact Details:

Name:

Email: do not notifynotify Gravatar enabled

Website:

Comment:

Title:

UBBCode:         -color-aquablackbluefuchsiagraygreenlimemaroonnavyolivepurpleredsilvertealwhiteyellow -size-tinysmallmediumlargehuge

Message:

Security

Please input the anti-spam code that you can read in the image.