• 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

#1
Hi,

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

I've got this ...
phpmyadmin.jpg

Do I need anything more?

Many thanks
JohnH
 
F

Floris

Guest
#2
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.
 

Lawrence

Well-known member
#5
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.