Perform a database backup

Collapse
X
Collapse
 
  • Page of 1
Previous template Next
  • admin
    started a blog post Perform a database backup

    Perform a database backup

    1. Switch Vbulletin off in Admin Control Panel - Settings - Options - Switch Vbulletin On/Off.

    2. Make an SSH connection to your web server with PuTTY.

    3. At the command prompt enter
    Code:
    mysqldump -u yourMySQLusername -pyourMySQLpassword yourdbname > yourdbname.sql
    (note the intentional lack of a space between -p and yourMSQLpassword)

    4. At the command prompt enter
    Code:
    gzip yourdbname.sql
    to compress the file.

    5. Store the resulting yourdbname.sql.gz file away for safe keeping.

    6. Switch Vbulletin back on in Admin Control Panel - Settings - Options - Switch Vbulletin On/Off.


    The backup is complete.
    Tags: backup, database, mysql, mysqldump, vbulletin
        Previous template Next
        Posting comments is disabled.

      Related Topics

      Collapse
      Working...