MySQL restore tool - 10% at a time.

Discussion in 'PHP' started by West, Jan 18, 2007.

  1. #1
    Hello,

    I am interesting in developing a tool for people to use that will allow them to select a .sql file from their hard drive to restore to their mysql. I am fairly certain that it IS possible to split a .sql file up into parts, and restore a certain percentage at a time. Infact, Mark Wraith wrote a tool that was strictly for IPB a while back (1.3 ish) - I just cannot locate it anywhere to see how he did such a thing.

    If anyone has any idea on how one might split the files to restore, please let me know. :) I dont need an example, etc as this is my battle but a little discussion on it would help.

    Thanks,
    West
     
    West, Jan 18, 2007 IP
  2. krakjoe

    krakjoe Well-Known Member

    Messages:
    1,795
    Likes Received:
    141
    Best Answers:
    0
    Trophy Points:
    135
    #2
    splitting would be pretty ez, I'd split into create table and insert into table commands, and just make sure I keep lines complete, if you wanted to be more complicted you could split into row by preg'ing INSERT INTO `table` and matching table, for pretty output and stuff.... it seems a pretty ez thing to do though ....
     
    krakjoe, Jan 18, 2007 IP