Jump to content

Recommended Posts

Posted

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

Posted

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

Posted

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

Posted

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.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...