How do i use BigDump to restore Database

Discussion in 'MySQL' started by richu, Jan 26, 2008.

  1. #1
    What all information should i provide in that bigdump.php file ?
    My restore back-up file is something that should restore a whole database .
    So in that file should i again give the name of a database or should i leave that field as blank ?
    Please help me . Also please explain in detail the steps that i should take to restore my database .
     
    richu, Jan 26, 2008 IP
  2. Boulder

    Boulder Well-Known Member

    Messages:
    806
    Likes Received:
    46
    Best Answers:
    0
    Trophy Points:
    118
    #2
    Yes, in that file you must put in the name of the database where the new data is going.. and you need to put the database user name and database password and the name of the restore file.

    Boulder
     
    Boulder, Jan 26, 2008 IP
  3. richu

    richu Peon

    Messages:
    460
    Likes Received:
    9
    Best Answers:
    0
    Trophy Points:
    0
    #3
    but the restore itslef creates a new database then why should i again provide a database name ? OK if so then can i use any database name ? or should i use the name of the database that the back up file is gonna create ?
     
    richu, Jan 26, 2008 IP
  4. NDUHosts

    NDUHosts Peon

    Messages:
    178
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #4
    NDUHosts, Oct 26, 2008 IP
  5. Jackie_W

    Jackie_W Well-Known Member

    Messages:
    1,964
    Likes Received:
    55
    Best Answers:
    0
    Trophy Points:
    115
    #5
    I;m trying to use bigdump to move data from one mysql database to another but i keep getting this error

    "Stopped at the line 1356.

    At this place the current query includes more than 300 dump lines. "

    any idea what i need to do?
     
    Jackie_W, Oct 30, 2008 IP