big problem

[birdie]

hi, i have a mysql database and a very large sql file (backup file). this file is around 226mb and i only need specific tables to be added again. i could edit the file using notepad but that takes far too long as it freezes almost every time i press the enter key.

is there any easier methods and how would i then be able to upload the sql backup file quickly? Ever tryed uploading 220mb through a php upload system? not good.

thanks for any help :-)

[redbullmarky]

[!--quoteo(post=365096:date=Apr 15 2006, 04:49 PM:name=birdie)--][div class=\'quotetop\']QUOTE(birdie @ Apr 15 2006, 04:49 PM) [snapback]365096[/snapback][/div][div class=\'quotemain\'][!--quotec--]
hi, i have a mysql database and a very large sql file (backup file). this file is around 226mb and i only need specific tables to be added again. i could edit the file using notepad but that takes far too long as it freezes almost every time i press the enter key.

is there any easier methods and how would i then be able to upload the sql backup file quickly? Ever tryed uploading 220mb through a php upload system? not good.

thanks for any help :-)
[/quote]

hmm not really had much experience with files so large, but you could probably achieve it by using the fopen, fread, fgets, etc functions to seek out the lines specifically to to with the tables you want and executing the queries one by one.