Page 1 of 1

Backing up the database

Posted: Thu 21. Oct 2004, 21:11
by jsavage
When backing up the mysql database should the backup contain the drop table command ? I am planning to use phpMyBackupPro for this btw.

James

Posted: Thu 21. Oct 2004, 21:20
by Pappnase
hello

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

Posted: Wed 24. Nov 2004, 12:53
by jsavage
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

Posted: Wed 24. Nov 2004, 18:17
by Pappnase
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.