Backup Suggestion

In this board you can talk about general questions about phpMyFAQ

Moderator: Thorsten

Post Reply
canuck
Posts: 39
Joined: Thu Jul 08, 2004 11:58 am

Backup Suggestion

Post by canuck »

This probably has been adressed earlier, but why don't you have:

Code: Select all

CREATE TABLE IF NOT EXISTS table_name (...) 
in every table that is created by phpMyFAQ? It wouldn't harm if the table already existed, but it would help if something happened to the database, and the db was wiped, for instance.
Thorsten
Posts: 15560
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Post by Thorsten »

Hi,

if the DB was wiped, you need to reinstall phpMyFAQ because you cannot log in to import your backup. I added the "IF TABLE EXISTS" in the installer if not all tables are broken.

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
canuck
Posts: 39
Joined: Thu Jul 08, 2004 11:58 am

Post by canuck »

Why did I asked this? Because I usually have to transfer the FAQ from one place to another, and I wanted to make this a smooth process. Re-installing everything would make me loose all the changes I made on some files. If the tables were created in the script, I could just copy the files, and restore using phpmyadmin for instance. The only thing I do now is use phpmyadmin to save the tables, making the backup feature useless :)
Thorsten
Posts: 15560
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Post by Thorsten »

Hi,

okay, I'll put "a complete backup" on my todo list.

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
Post Reply