Announcement

Collapse
No announcement yet.

Restoring Database

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

  • Restoring Database

    Hi .. I have read the data

    The only reliable method of backing up and restoring a database is with shell access via telnet or ssh. Please see the instructions here:

    Backup:
    http://www.vbulletin.com/docs/html/m...nce_ssh_backup

    Restore:
    http://www.vbulletin.com/docs/html/m...ce_ssh_restore

    This is because backing up with a PHP script like that in the Admin CP or phpMyAdmin can result in PHP timeouts errors and an incomplete backup file.


    #################

    I have SSH ... but where does one run this command

    run: mysqldump --opt -u user -p dbname > {path}/backup.sql


    OK .. I understand username dbname and path to /backup.sql

    But where does one put that data ... please it seems like the simplest instructions but not knowing where to place this is a bain

    I have the backup on the server in the same area as the forums ... but what and how to

    Thank you

    GB
    Travel Information

  • #2
    Once you login with SSH you will be at the server command line. You enter the command there.
    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


    • #3
      Hi Steve

      I have been looking in

      SSH Secure File Transfer Client

      and now realise it is

      SSH Secure Shell Client

      it is as though a light went on, will work thru it slowly

      Thanks

      GB
      Travel Information

      Comment


      • #4
        Steve

        I succeeded

        you cannot understand how incredible this is

        with SSH .. you must use the SHELL ... newbies don't know this automatically when refering to the SSH

        I am most grateful

        Thank you

        GB
        Travel Information

        Comment

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