Need Help with MySQL

Discussion in 'MySQL' started by usf, Jun 2, 2012.

0
  1. #1
    Hello. I need help. My database size is 30.4 GB. And when I download the data base and move it not new place its not loaded. It gives some syntex error. I tried it with MySQL Big Dump. Is there any way to backup and upload it as it is. ??? I have root access to the server and using it with cPanl/WHM.
     
    usf, Jun 2, 2012 IP
  2. Isuru

    Isuru Active Member

    Messages:
    363
    Likes Received:
    6
    Best Answers:
    1
    Trophy Points:
    68
    #2
    Isuru, Jun 2, 2012 IP
  3. aderogbas

    aderogbas Peon

    Messages:
    10
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Instead of backup and restore of the entire database I will recommend you try backup and restore in smaller chunks. If possible try backup and restore of a table first before going for multiple tables.
     
    aderogbas, Jun 2, 2012 IP
  4. WordPressBlogNetwork

    WordPressBlogNetwork Member

    Messages:
    29
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    46
    #4
    If you have root access import by root is much better than bigdump or phpmyadmin

    create your dbname first then use this command
    mysql dbname < 30gb.sql
     
    WordPressBlogNetwork, Jul 19, 2012 IP