Announcement

Collapse
No announcement yet.

backin up database!!

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

  • backin up database!!

    Hi guys,
    I am backing up my database for the first time and I really need some help. I am uploading the image of what I see. Can someone PLEEEEEZE check and lemme know which options i need to check and select to do a GOOD backup.
    I tried running mysqldump so many times .. but it sez invalid syntax even though i checked and double checked syntax.

    I have read through the backup article on VBulletin.com and documentation online but the options given there do not match what I see online.

    My host does not allow SSH and telnet access and they are really not helping on how to do the backup.

    Also,

    how will i ever restore the database?? i dont see any option indcating restore?

    I will REALLY appreciate ur help.

    pls help.

    Vik
    Attached Files

  • #2
    I'm curious, how could you have tried the mysqldump option if you don't have telnet or ssh access?

    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. However here are the instructions for using phpMyAdmin:

    Backup with phpMyAdmin:
    http://www.vbulletin.com/docs/html/m...myadmin_backup

    Restore with phpMyAdmin:
    http://www.vbulletin.com/docs/html/m...yadmin_restore
    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,
      thanks for superfast reply...

      as per the inst. of backup using phpMyAdmin ===
      =================================================
      In the right-hand frame, you will see a row of links. Click [Export]

      Now in the right-hand frame you will see three (3) areas. In the first area, called Export you select the table(s) you wish to back up by selecting them from the list. To select multiple tables, hold the Ctrl key and lick the table names. To select all table, click the [Select All] link.

      In the second area, called SQL Options, make sure you have the follwing boxes checked:

      Structure
      Add 'drop table'
      Add AUTO_INCREMENT value
      Enclose table and field names with backquotes
      Data
      -------------

      I do not have any export option and Add AUTO_INCREMENT value option.

      Comment


      • #4
        It sounds like you have an older version of phpMyAdmin. I have never made a db backup with phpMyAdmin so I really can't offer much guidance. Hopefully someone else will be able to help.
        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