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

Discussion in 'H-Sphere Shared Hosting' started by Blacklazy, Jan 8, 2007.

  1. Blacklazy

    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.
  2. yogesh

    yogesh Perch

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

    We already resolve this issue on Live Chat.
    Do you have more query?
  3. Stephen

    Stephen US Operations Staff Member

    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.
  4. thingwarbler

    thingwarbler Perch

    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.
  5. Stephen

    Stephen US Operations Staff Member

    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 :)
  6. Blacklazy

    Blacklazy Guest

    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.
  7. timruns

    timruns Perch

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

    dial-up? wow, I didn't know that still existed! :D
  8. thingwarbler

    thingwarbler Perch

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

    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.
  9. Blacklazy

    Blacklazy Guest

    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.
  10. Stephen

    Stephen US Operations Staff Member

    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.
  11. Blacklazy

    Blacklazy Guest

    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.
  12. Stephen

    Stephen US Operations Staff Member

    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
  13. twoolums

    twoolums Perch

    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.
  14. Wheemer

    Wheemer Perch

    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...

Share This Page

JodoHost - 26,000 hosting end-users in 100 countries
Plesk Web Hosting
VPS Hosting
H-Sphere Web Hosting
Other Services