Cannot restore database after moving to Bluehost

  • I switched host providers from Spymac to Bluehost.

    I saved my database.

    and now when i try to restore it, phpMyAdmin doesn’t show any error after it’s uploaded; it just shows the code in the mysql file. After that, it’s as if i didn’t upload anything at all. I’m sorry i find it difficult to explain what’s going on, but basically i’m trying to restore my database and when i do try, nothing happens. I’ve emailed support at bluehost, this is what they said:

    I have imported the databases you have provided, other than that, there isn’t much I can do, we don’t provide support for fantasticio scripts. I believe the problem is the .sql files are invalid so its not really importing anything. I need a valid backup of it.

    Thank you,

    Cody Burdick
    Bluehost.com
    Support Team
    [email protected]

    I REALLY hope it’s not my sql file, because that has about a years worth of data, and i don’t want to start over… again.

    Perhaps i backed up my database improperly, if i need to add tags, is that possible?

    Please be specific when you reply, so i don’t get confused. I really hope i can solve this problem; it’s been about a week that my domain has been inactive due to this problem, and about two weeks because of dns switching.

    THANKS!!
    Daren

Viewing 5 replies - 1 through 5 (of 5 total)

  • How large is your sql file ?
    The only thing I can think of now is trying a local import – which I can do – but I need to know how big the sql file is and whether you can zip it to send to me for me to try.

    Thread Starter deiri87

    (@deiri87)

    my sql file is 1.1mb. i can zip it and send it to you. please contact me for future purposes. [email protected]

    Thank you!
    daren

    The database has been imported without problems.

    Bluehost support ? Oxymoron ?

    Hi Podz,

    Is there any chance you could post the solution here? I am currently having the same problem.

    Cheers,

    Brad.

    Actually, don’t worry about replying — I just realised you did so in another thread, and on your website. The trick, for those who have stumbled here, is splitting your sql file up into parts, until each is small enough to work by itself. I note in passing that when moving to a new server it is essential to re-run your permalink settings in your options.

    Cheers,

    Brad.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Cannot restore database after moving to Bluehost’ is closed to new replies.