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
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.