vendlus Posted January 14, 2004 Posted January 14, 2004 I'm attempting to move an invision board from another server to my current one. I have a copy of the tables that I dumped with phpMyAdmin and am now trying to upload them again. Just the posts table by itself is a 30MB sql file and phpMyAdmin times out when trying to transfer it into the database (using the SQL portion of phpMyAdmin to run the sql file). Is there anyway to export the table easily in several sections so that I can upload smaller portions at a time so that it doesn't time out? Or is there a better way to upload the files? *edit* found a link to mysql_tool over on Invision's board that people claim works. I'm trying it now. Quote
DarqFlare Posted January 14, 2004 Posted January 14, 2004 Make sure to let us know what happens... Are you just pasting all of the information into the text box, or did you save it locally as a text file to upload? Something else you might want to do is break up the file into smaller parts, then use the parts one-by-one. This may take some time, but at least it will get done. Break them up to say, 5MB or 10MB each. If you know MySQL at all then you'll know where you can break it up. Otherwise, break it up at a point where there are a few multiple line breaks with no actual coding... Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.