Jump to content

Archived

This topic is now archived and is closed to further replies.

birdie

big problem

Recommended Posts

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 :-)

Share this post


Link to post
Share on other sites
[!--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.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.