2

I have quite large and rather important DB to backup.

First off, whats best way to do it?

Secondly, easiest way I know is to export it through phpmyadmin, but, i'm worried about options, although I'm quite sure this "Add DROP DATABASE" will not drop actual databases, I'm interested what are these options for? (see pic)

Thanks.

enter image description here

Improve this question
5
  • Adding DROP DATABASE will create code to drop the database before creating it. PHPMyAdmin creates backups by writing code that INSERT's the data into your DB. You can try out all the statements, PHPMyAdmin will just generate the SQL code to do the backup. You have to execute the query before something happens :)
    – Morten Jensen
    Apr 16, 2013 at 12:02
  • You mean it will generate code for those along with insert code (which is backup)? What are those for, in first place?
    – el ninho
    Apr 16, 2013 at 12:05
  • It will insert DROP statements before the INSERTs. Sometimes that's useful for filling up a DB with certain data before a test-run or whatever.
    – Morten Jensen
    Apr 16, 2013 at 12:34
  • So it will bi used for droping db/tables in case of restoring? Thanks.
    – el ninho
    Apr 16, 2013 at 12:35
  • 2
    Yes, but you can try out the different settings and see what difference it makes in the output SQL :)
    – Morten Jensen
    Apr 16, 2013 at 12:36

2 Answers 2

Reset to default
2

The best (and IMO the only suitable) tool for backuping a MySql database is mysqldump

The PhpMyAdmin options you are referring to are meant only to alter the generated statements in your dump (but will not touch your actual data). You might want to refer to this FAQ at PhpMyAdmin.

Improve this answer
0

simply create a dump file of your database. mysqldump can be created very easily in phpMyAdmin. at the home page of the database in phpMyAdmin, click export and select quick or custom as your choice and dump it into sql file format. A simple dump of your database would be created and then you can easily restore it again.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.