backup dump with phpMyAdmin - confirm details needed

[otfordnet]

Hi,

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
JohnH

 

[Floris]

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.

 

[Jake Bunce]

Those settings shown in the picture will work fine. You've got all tables selected, SQL format, data and structure included. Looks good. I have made backups with phpmyadmin before and the appropriate settings are usually selected by default. You just select all tables and go.

edit - for your information:

http://xenforo.com/community/threads/how-to-backup-and-restore-your-forum.7213/

 

[otfordnet]

Thanks Floris and Jake too .. here goes ..

 

[Lawrence]

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.