Topic: Moving Hosting. Fine at first, after several hour some columns gone.

Right now, i'm moving my hosting. Nothing wrong with the old one, but I need to move to new hosting since i need Dedicated IP. the old one doesnot provide it.

What I did :
1. Install fresh FrontAccounting, and make sure everything works fine.
2. Copy database from the old to the new.
3. DONE. everything works perfectly.
4. After several hour, the errors come up. Such as some column on the table is missing. How come the column suddenly dissapeared?

I tried several time, the result is the same.

Can you anybody help me?

2 (edited by apmuthu 02/12/2014 05:31:21 am)

Re: Moving Hosting. Fine at first, after several hour some columns gone.

It is possible you did not install some extensions in the new one that was in in the old one that may possess an extra column/table.

Copying the files from one server to another may need to have the file users and groups and permissions set correctly and some apache and php directives set that may be peculiar for the new server like file paths in the config.php, etc.

State what column was missing and check the old sql backup as well.