Forums

Import database to new host crashes site. (2 posts)

  1. sbrumwel
    Member
    Posted 2 years ago #

    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.

  2. sbrumwel
    Member
    Posted 2 years ago #

    I just did a fresh install. Tried to import posts only. That's really what I don't want to loose. Crashed it again.

Topic Closed

This topic has been closed to new replies.

About this Topic