Backing up the database

jsavage · Post by **jsavage** » Thu 21. Oct 2004, 21:11

When backing up the mysql database should the backup contain the drop table command ? I am planning to use phpMyBackupPro for this btw.

James

Pappnase · Post by **Pappnase** » Thu 21. Oct 2004, 21:20

hello

yes if you wanna overwrite all! then set the drop table. if not then wihout!

jsavage · Post by **jsavage** » Wed 24. Nov 2004, 12:53

Hi Pappnase,
My database contains more than just phpwcms stuff. When you say that drop tables will overwrite them all do you mean that drop table will drop all tables in the complete database or just those in the backup set?

James

Pappnase · Post by **Pappnase** » Wed 24. Nov 2004, 18:17

hello

it only add the drop table statement to the tables you backup. so if you only backup the phpwcms tabels they will backuped and overwritten when you restored the phpwcms tabels.