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 [SIZE=“7”]HUGE[/SIZE] 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.
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.
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.
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?
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.
