Backing Up A Database...
Okay excuse my ignorance.....but I really don't know anything about backing up a database.
To back up a MySql database, so I use the export option? Can I save the database to my hard drive this way?
Does exporting leave the database intact on the server? (God that sounds like a dumb question!)
If this isn't it, then how to I get a backup copy on my hard drive?
Roo
Abhishek Reddy posted this at 19:35 — 3rd November 2006.
He has: 3,348 posts
Joined: Jul 2001
Are you using phpMyAdmin? I'll assume you are.
Yes, exporting usually is how you make a backup. It's like a "Save As" operation. It will not touch the database, only copy it. When you hit the "Go" button on the Export page, you'll be offered a download, which will be the database's exported file, that you can save to disk.
You can export it in several formats; stick with SQL, CSV or XML for portability. That is, the database in exported form is basically a text file (like HTML is), and it will have it be read back in if you try to import the backup. SQL, CSV and XML are easily read in, whereas LaTeX, PDF, Excel, etc may not be.
Hope that helps.
Roo posted this at 19:59 — 3rd November 2006.
She has: 840 posts
Joined: Apr 1999
Thank you!
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.