Jump to content


Photo

big problem


  • Please log in to reply
1 reply to this topic

#1 birdie

birdie
  • Members
  • PipPipPip
  • Advanced Member
  • 65 posts
  • LocationBirmingham UK

Posted 15 April 2006 - 03:49 PM

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

#2 redbullmarky

redbullmarky
  • Staff Alumni
  • Advanced Member
  • 2,863 posts
  • LocationBedfordshire, England

Posted 15 April 2006 - 03:59 PM

[!--quoteo(post=365096:date=Apr 15 2006, 04:49 PM:name=birdie)--][div class=\'quotetop\']QUOTE(birdie @ Apr 15 2006, 04:49 PM) View Post[/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.
"you have to keep pissing in the wind to learn how to keep your shoes dry..."

I say old chap, that is rather amusing!




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users