Best Way to Restore MySQL DB's in Cpanel

Discussion in 'MySQL' started by Dubz, Mar 6, 2008.

  1. #1
    I have transfered my entire site and plan on making it "live" tomorrow night.

    When I try and restore my new DB's for forum and other live aspects I get a timeout because the file is to large.

    How would one go about restoring most current updated database for a forum, directory etc?

    Much appreciated,
    Rob
     
    Dubz, Mar 6, 2008 IP
  2. jestep

    jestep Prominent Member

    Messages:
    3,659
    Likes Received:
    215
    Best Answers:
    19
    Trophy Points:
    330
    #2
    If you have ssh access to the server, you may need to do it at the command line.

    You could try a 3rd party app like Navicat. You can create a backup of your existing database and restore it to the new one. I've done this with 5Gb+ databases before. Navicat comes with a free 30 day trial, so it may be worth a try.
     
    jestep, Mar 6, 2008 IP
  3. Dubz

    Dubz Peon

    Messages:
    1,859
    Likes Received:
    156
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Right on man. I'm going to try Navicat tonight.
     
    Dubz, Mar 6, 2008 IP