Next question: How do I backup my database?

mommie_geek · 18th February 2003, 06:29 PM

I think that's a self-explanatory topic. I'm poking around PHPmyAdmin but I don't see how to backup my database. Do I have to export it somehow?

Euge · 18th February 2003, 07:07 PM

Yes. Go to the export tab and select "Structure and data", "Select All", "Save As" and optionally a compression scheme.

All it really does is create CREATE TABLE statements and INSERT statement for all the rows. So technically you can use the script to export to any other SQL database as well.

To restore go to the SQL tab and browse the file you created.

I've successfully transferred entire databases between providers using this simple tool.

mommie_geek · 18th February 2003, 07:09 PM

Will this pretty much leave my database intact though? I only want to back it up because I'm going to be adding more tables, and I don't want to be totally hosed if I screw up.

UH-Matt · 18th February 2003, 07:22 PM

So long as you backup structure+data and select all then you will be fine.

Make sure you end up with a .sql file