View Single Post
Old
  (#5 (permalink))
mikem
Senior Member
 
Status: Offline
Posts: 2,905
Join Date: Sep 2002
12-29-2002, 05:44 PM

Do as Anor says.

Take the sql file you backed up. Open it in Notepad or Wordpad..whichever doesn't screw up the Format.

Then go through and break it up into little pieces, copying and pasting a few tables at a time into a New notpad document. THen save the new document as 1.sql, then do the next few table, copy and paste them into a new Notepad doc. and save it as 2.sql Go on and on until you have gone through the whole file..This will take you quite some time to do. I had to do it once and it's no fun, but with large DB's like yours, you have to break up the sql file in order for PHPADMIN not to time out on uploading it.

Then once you are done, go to your phpadmin, and upload the first sql file 1.sql then the next 2.sql then the next 3.sql and so on. With the sql file broken down into smaller sql files, phpadmin shouldn't time out on you then.

Make sure as you copy and paste that your are beggining the copy at the start of a tabel and ending at the end of a table..don't cut the tabels in half in other words.

mikem
   
Reply With Quote