HELP: I can't take a mysqldump!!!

B

Blacklazy

Guest
Please tell me why SSH is not supported on jodohost, this is required tool for me to take a dump.

It is impossible to take a dump with jodo host. I cannot use phpmyadmin because it will time out, and it is a HUGE pain in the butt if I have to create a new ticket every day just to have a backup made for my database. I don't have time to make a ticket every single day. I have more things to do.

I cannot believe that jodo host would not support taking a dump. We should be allowed to take a dump if we want. I will have to find another host that will allow it without all this restrictions.

This is a good web host but their database backup options are crap. It is impossible to take a backup from this host. phpmyAdmin and mysqladmin will time out on large databases and they have a limit of 10 mb dump only.

If I take a dump with SSH is the only way to take a dump and have it be accurate backup and you know it. You know that backup via PHP is not a good idea on database if you want a good backup.
 
Re: HELP: I can't take a dump!!!

We already resolve this issue on Live Chat.
Do you have more query?
 
Re: HELP: I can't take a dump!!!

We do not and will not ever allow SSH access.

You can use external MySQL management tools like Navicat or SQLYog to take backups and they work very well.
 
Re: HELP: I can't take a dump!!!

Get a third party tool like sqlyog from webyog dot com -- the free version is a great MySQL management tool, and it will allow you to schedule dumps as jobs remotely. The enterprise ($$$) version will do even more snazzy stuff for you.
 
Re: HELP: I can't take a dump!!!

That pulling the remote host title must be some new feature of this vB version. I wish the core features would work 100% instead :)
 
Re: HELP: I can't take a dump!!!

I have dial up and phpmyadmin times out on making a backup and it only has a limit of 10mb.
 
Re: HELP: I can't take a dump!!!

Blacklazy said:
I have dial up
Click to expand...
Well, there's perhaps the source of all your ills. Even in Wisconsin it's got to be possible to get something more ambitious than that. Up here in my neck of the sticks (central VT) there are creative souls offering WAN WiFi across large swaths of rural countryside.

Sure, it's maybe not as cheap as AOL ("now 4128 minutes free per month!"), but it does get you online at a speed that allows, oh, say, backups of 10Mb+ databases...

If you're really stuck with dial-up maybe you need to think outside the box: mirror your db and run a script that'll copy all the content every so often -- it's not a "real" backup, but it'll give you a second set of uncorrupted data to quickly copy back if things go kablooie.
 
Re: HELP: I can't take a dump!!!

The 10mb limit has nothing to do with dial-up. Its a limit in phpMyAdmin itself. Its a cheap PHP script.

So there is a way to take a backup of my database from the control panel. Is that the same as using SSH? It will be a good backup because its done completely on the server and then I can just download the SQL backup from my domain? Instead of streaming the data to my computer with phpMyAdmin export option.

How exactally does the CP backup program work? Is it as reliable as SSH? How do I know its going to make an accurate backup of my database that I can count on?

Thanks.
 
Re: HELP: I can't take a dump!!!

Black, you can easily use account backups to make a mysql databse backup and download it however you wish.
 
Re: HELP: I can't take a dump!!!

But is it an accurate backup?

OK, Thanks. I have seen onther hosts dont support SSH either. I have to get a deticated server.
 
Re: HELP: I can't take a dump!!!

Yes it is a good backup in gzip or tar.gz format, just extract it and you can have the raw SQL like you would with a mysql dump
 
Re: HELP: I can't take a dump!!!

Most of the time when I run the mysql account backup I get a gzip file with the .sql file which doesnt have the full backup in it. Ive since setup a batch file on my pc at home that does a remote mysqldump. Works 100% for me.
 
Re: HELP: I can't take a dump!!!

Maybe the title of this thread can be changed... I keep wanting to recommend a laxative to solve the problem...

I'm sure the OP knew how he was wording the original post...
 
You must log in or register to reply here.
Back
Top