+- ZenphotoCMS Forum (https://forum.zenphoto.org)
+-- Forum: Support (https://forum.zenphoto.org/forum-1.html)
+--- Forum: General support (https://forum.zenphoto.org/forum-4.html)
+--- Thread: Error when restoring database from a backup. (/thread-10044.html)
Error when restoring database from a backup. - rreimche - 2012-06-03
After the installation I copied all the files from the test server including database backups. And when I try to restore, I get the following:
Zenphoto encountered an error
MySQL Query ( SHOW FULL COLUMNS FROM [prefix]admintoobject ) failed. MySQL returned the error Table 'tricky_zen._admintoobject' doesn't exist
Error when restoring database from a backup. - sbillard - 2012-06-03
Here is the list of possible problems:
-
You have not restored the database on the new install. It is not enough to copy the backups, they have to be restored on the new database.
-
The "prefix" for the tables has changed. Be sure that you have told setup to use the same prefix as from the test server.
-
You have not run setup on the new server. You must always run setup if you move an installaton.
Error when restoring database from a backup. - rreimche - 2012-06-04
Seems that the problem is table prefixes. How can I edit that?
Error when restoring database from a backup. - rreimche - 2012-06-04
I mean, perhaps, there is a file where this settings is written down?
Error when restoring database from a backup. - acrylian - 2012-06-04
zp-data/zenphoto.cfg. You also have been asked for it when running setup the first time.