Kaos Posted July 15, 2003 Posted July 15, 2003 I have a couple really large db's I need to import into MYSQL and PHPMyadmin doesn't seem up to the job...any ideas? Quote
Wilexa Posted July 15, 2003 Posted July 15, 2003 Some questions: 1. How large is "really large"? 2. What error does PHPMyAdmin give you when you try to upload the file from your computer? 3. Are they text-only DBs or are you using blobs? The more we know, the better help the TCH family can give. Thumbs Up ...Dave Quote
Kaos Posted July 15, 2003 Author Posted July 15, 2003 one of my queries is 100,000+lines.... Errors: Just times out when trying to add it, via textfile or adding it piece by piece, have to add like 100 lines at a time....that would take forever.... Text DB's Quote
Wilexa Posted July 15, 2003 Posted July 15, 2003 If you have enough disk space in your account to handle both the fully-loaded DB and the text source file at the same time, you might want to FTP the source file up to your account, then just use plain mysql commands (if you are comfortable using them) from the shell to load it in. Then there shouldn't be any timeout problems. I am assuming that your text file looks like: >CREATE TABLE mytable blah blah blah; INSERT into mytable values(x,y,z); INSERT into mytable values(a,b,c); If you don't have shell access, then submit a help ticket. The support folks may be able to set you up with jailshell. It sounds like you have a pretty good case to me. Here's the policy: http://www.totalchoicehosting.com/help/sshpage.htm Hope this helps, Dave Rock Sign Quote
surefire Posted July 15, 2003 Posted July 15, 2003 I'm assuming you've tried both running the query on the dump file. Have you tried uploading a text file? The only other thing I can think of would be to write a script that pulls the info line by line from site a and puts in on TCH site B. Quote
Kaos Posted July 17, 2003 Author Posted July 17, 2003 Thx for the info, however I"m not much of a coder, I've submitted a ticket for SSH access, hoping to hear back soon. 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.