Announcement

Collapse
No announcement yet.

Best Database Backup Option

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Best Database Backup Option

    My site, www.fogpog.com, is currently hosted by powweb.com. My forum has recently grown to a size where backing up using phpMyAdmin and saving a backup like vbulletin.sql to my computer is now timing out and not completing. The problem I have is I can't backup my database with SSH or Telnet because it is not supported by my host. Other than the obvious solution of changing hosts, are there any other options you guys can provide that would allow me to make successful backups?

  • #2
    If phpMyAdmin doesn't work for you, and you don't have SSH/Telnet, I can't really think of anything else. My suggestion would be to do what you already mentioned and change hosts.

    Or - check with your host to see if they'll do a backup of the database for you since they don't give you SSH/Telnet access.

    Comment


    • #3
      go to vbulletin.org there is a hack that allow you to backup db automatically via cronjob, it's will save locally.

      Comment


      • #4
        If you don't have telnet or SSH access, some people have reported success with these scripts:

        MySQLDumper:
        http://www.mysqldumper.de/en/index.php

        MySQLHotxcopy:
        http://www.vbulletin.com/forum/showt...t=mysqlhotcopy

        Bigdump:
        http://www.ozerov.de/bigdump.php

        Note: If you have cronjobs available through your host, you can use this crontab script to automate your backups:

        http://www.vbulletin.com/forum/showp...90&postcount=5
        Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
        Change CKEditor Colors to Match Style (for 4.1.4 and above)

        Steve Machol Photography


        Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


        Comment

        widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
        Working...
        X