The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Problem restoring big backup file

Discussion in 'General Discussion' started by hotice007, Jun 20, 2002.

  1. hotice007

    hotice007 Well-Known Member
    PartnerNOC

    Joined:
    Jun 20, 2002
    Messages:
    64
    Likes Received:
    0
    Trophy Points:
    6
    I have a SQL DB Backup file which is about 130mb in size, I keep having problem using the restore feature in Cpanel since my browser keep timing out while uploading the file. Can someone please help me find a solution of how to restore my database? Thanks!
     
  2. netlook

    netlook Well-Known Member
    PartnerNOC

    Joined:
    Mar 25, 2004
    Messages:
    335
    Likes Received:
    0
    Trophy Points:
    16
  3. anand

    anand Well-Known Member

    Joined:
    Nov 11, 2002
    Messages:
    1,435
    Likes Received:
    1
    Trophy Points:
    38
    Location:
    India
    cPanel Access Level:
    DataCenter Provider
    Use shell to restore it.

    mysql dbname < sqlfile.sql

    This is the recommended way to restore huge dbs.
     
Loading...

Share This Page