Knowledgebase Home | Glossary | Favorites Knowledgebase Home | Glossary | Favorites
Backup a MySQL database
Article Details

Last Updated
17th of August, 2010

Requirements
Creating a database, Accessing your container with SSH

Level
Intermediate
Would you like to...
Print this page Print this page
Email this page Email this page
Post a comment Post a comment
Subscribe me
Add to favorites Add to favorites
Remove Highlighting Remove Highlighting
Edit this Article Edit this Article
Edit this Article Quick Edit
Export to PDF
User Opinions (3 votes)
66% thumbs up 33% thumbs down
How would you rate this answer?
Helpful
Not helpful

Prerequisites:

Creating a database
Accessing a container with SSH

Once connected to the container via ssh, run the following command:

mysqldump -u db_05hubs2 -p -h db1.slc1.stackable.com 
--databases db_05hubs2 > backupFeb092010.sql


in explanation, this command has the following flags:
  • -u (this is the database username)
  • -p (this indicates that you will be prompted for the database password.)
  • -h (this is the database Hostname.)
  • --databases (This is the database name)
  • > filename.sql (The > denotes output redirection, to dump the contents of your database into a file.)
The information listed above can be found on your dashboard when you click the database you've created.

dbscreenshotdashboard1.jpg
Visitor Comments
No visitor comments posted. Post a comment
Post Comment for "Backup a MySQL database"
To post a comment for this article, simply complete the form below. Fields marked with an asterisk are required.
   Your Name:
* Your Comment:
* Enter the code below:
 
Related Articles
No related articles were found.
Attachments
No attachments were found.

Continue