Uploading Mysql files

[ripper7777777]

Well I'm trying to upload an sql backup from my other host, it's a Gzip file that's 15 megs, but the cpanel always times out and so does the phpmyadmin and the continue doesn't seem to work. I want to be able to restore my own databases and not rely on tech for this.

So what's the best way to restore a Mysql backup?

[cjnoyes]

Originally Posted by ripper7777777

Well I'm trying to upload an sql backup from my other host, it's a Gzip file that's 15 megs, but the cpanel always times out and so does the phpmyadmin and the continue doesn't seem to work. I want to be able to restore my own databases and not rely on tech for this.

So what's the best way to restore a Mysql backup?

My hunch is you will have to ungzip break up the script into several parts and gzip each one and run each separately. 15 megs is definitely beyond the file upload size max

[ripper7777777]

Great....

I hope this isn't the case, I did ask in another thread before I hosted here and it seemed like I wouldn't have a problem but now I am having a problem and this is one of the main reasons I'm leaving my last host.

[slapshotw]

I agree- split the file up into 2 less than 10mb mysql files. This isn't a hostgator issue; i suspect it's not going to be easy to upload a 15mb file all in one shot in any cPanel/phpmyadmin environment anywhere.

You could also try using a desktop-based program to access it, you may have more luck with the file.

And, finally, have you contacted support and asked them to do it? I have a feeling they won't charge you just to restore a 15mb backup you made because it's so big (relatively speaking). I think the charge comes in when they actually have to go get their backup and restore it.

-Matt

[cjnoyes]

Originally Posted by ripper7777777

Great....

I hope this isn't the case, I did ask in another thread before I hosted here and it seemed like I wouldn't have a problem but now I am having a problem and this is one of the main reasons I'm leaving my last host.

Two issues are happening here

our maximum upload size is 2M
the other that could happen is there is a max run time with each php that if the inser was too big you would have a problem there even if the upload size was larger. See if you can work around the limitation by breaking up the file

[cjnoyes]

Try Matt's suggestion, I think that is the way to go

[Roaddog]

Upload the gzip and ask tech support to install it for you...........

[m7csat]

While going with tech support is the way to go, there are two programs that come to mind should you have to split it yourself . . . Hjsplit (for splitting the file) http://www.freebyte.com/hjsplit/#win32 and ConText (http://www.context.cx/) for minor editing of the split files. Reason that I'm suggesting Hjsplit is that it will sequentially number your files automatically and ConText is a tabbed editor. You'll need to edit the files in context after HJsplit splits them because the last line of each file will in most cases be an incomplete SQL command, so you'll have to look for the remaining part in the next file.

[Serra]

Originally Posted by ripper7777777

Well I'm trying to upload an sql backup from my other host, it's a Gzip file that's 15 megs, but the cpanel always times out and so does the phpmyadmin and the continue doesn't seem to work. I want to be able to restore my own databases and not rely on tech for this.

So what's the best way to restore a Mysql backup?

Support is the best way. An ftp program will allow you to upload it whole. There is no limit on file size from ftp. Keep in mind that HG doesn't offer shell access, so support takes on the role of shell access.

[ripper7777777]

Well I'm going to try a couple different methods before I hit up tech, I still have the old host running so I'll export in smaller files instead of cutting up the current sql. I'm also testing using Mysql Query Browser, if that fails I'll hit up tech. Oh and I'm not leaving my current host because tech has to restore it, I'm leaving because tech is horrible and for almost 2 years I have been able to do it myself and than all of sudden a 2 meg limit is put in place and I have been trying to get tech to do it for 3 weeks on 3 different tickets and all I get is auto replys to my emails. I won't trash the host but I will say the name begins with "I" and ends with "web" and their lack of "power" is showing....LOL

I have no doubt that tech here will be there for me, but forums seem to attract script kitties so it's nice to be able to restore on your own should you mis an update on security.


Thanks for all the help

[Serra]

I'm not sure why you would be running into a 2 meg limit unless you are using a PHP script to upload it. If that is the case, the 2 meg limit is kinda standard. Just about everyone uses the 2 meg limit for PHP uploads or close to it.

Where did you run into the limit at the old host?

[ripper7777777]

Well at the old host I ran into it in the phpmyadmin and their version of cpanel stopped working, see I don't mind limits, but when they are all of sudden added after 2 years without any warning and you spend 3 weeks with 3 different tickets for the same problem and recieve nothing but auto reply emails it gets old.

So far Hostgator has been great, I was able to re-export my archive forum sql into 4 parts and upload it myself and I sent hostgator my working forums sql last night around 10:30 and recieved an email this morning the task was complete. With hostgator I was running into the time limit, but seperating out the larger tables worked great.

So far I am very pleased with Hostgator.

Thanks again everyone.

[Serra]

You might want to look into an external management program for your mySQL like mySQLcc or some other program. They allow you to do a lot that is difficult in mysqladmin.

[ripper7777777]

Thanks, yea I'm looking into other sql control options.