Posted January 29, 200718 yr Is there any way to split a .sql backup into several parts that is located on my computer? This thing is just way too big to do by hand. I've already googled. Please help. Edit: nvm got it.
January 29, 200718 yr As long as the INSERTS are seperate you can do it by hand, just copy paste. Or if you're on a *nix machine: split -l 3000 omghaxoration.sql splitfile will split omghaxoration.sql into individual files starting with splitfile of 3000 lines. Of course you should go in a check to make sure it didn't split any multi-line statements.
January 29, 200718 yr Author OverlordQ;438440']As long as the INSERTS are seperate you can do it by hand, just copy paste. Or if you're on a *nix machine: split -l 3000 omghaxoration.sql splitfile will split omghaxoration.sql into individual files starting with splitfile of 3000 lines. Of course you should go in a check to make sure it didn't split any multi-line statements. Well the problem was it was shared hosting. And it was too big to do it by hand, it was a 168mb database. I used a simple file splitter and patched up the little bits by hand. Wasn't so bad. The worst part was the 50k max_questions limit so I had to upload it as 20 diff users ;-(
