• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

backup dump with phpMyAdmin - confirm details needed


just about to go from Beta1 > Beta2, could someone please give me some advice about settings for phpMyAdmin dump?

I've got this ...

Do I need anything more?

Many thanks


That's all you need.

You select all the tables, say its sql, select to include structure, and include data, and to save as a file.

The default are fine.

If you can have shell access, ignore phpmyadmin completely and just use the shell to dump - no timeout limits, etc.


Well-known member
I would select Add Drop Table. This way if a newer DB modified fields, when (if) you decide to Import your back-up, the importing process will drop any existing tables to replace them with the copy you are importing.