I have had a problem with one of my test installs of TP and thought I was OK because I had done both a file and database backup. For reasons I don't understand fully, OK I don't understand at allÃƒÆ’Ã¢â‚¬Å¡Ãƒâ€šÃ‚Â
I was unable to restore the database to recover from the problem. So I thought, I wonder if I can extract what I want from the sql file, no it doesn't seem to be in there.
So the $64,000 question is when you do a database backup,
A) Does it back up articles and menu settings etc?
B) If if does, where does it store them?
C) If it doesn't, what do we need to do to include all of the TP fields and tables in a database backup?
I have been using [unknown]'s create_backup.php and restore_backup.php utilities. SMF database prefix sgr_ , TP prefix (custom) sgrportal_ (I am running 4 test boards on the same database).
This is what I think is the case.
If you only have one board on its own in a database you are OK the backups of the whole database. If you do your backups with a tool that uses a table prefix, like create_backup.php, you will need to run it twice, once with your SMF_ prefix and again with your tportal_ prefix. To back the two up together you need for them to have the same prefix. The easiest way to achieve this ATM appears to be to run the TP install and then run a renaming utility to change the prefix on the TP tables, then manually change the TP files likewise.