I've used a fresh install to get my site up and running on a new host - justhost. WordPress installs fine, but when I try to import the database from my old host, the site crashes and gives me this message
- SQL query:
/*!40103 set time_zone=@old_time_zone*/;
MySQL said: #1100 Table "time_zone_name' was not locked with lock tables.
On my most recent attempt, I tried to import table by table with the same result. When I try to access my site after the import error, the page is blank, including the source code.
The mysql version is the same at both hosts.
When I export from netfirms, I check "Structure and data", "Add drop table", and "Complete inserts"
My site is currently at mrbrumwell.com
The page is blank, although I intend to do yet another fresh install and try to figure this out. Any help or suggestions are appreciated. Thanks.