Backing up with phpMyAdmin question

  • Anonymous

    22 years ago

    Every month or so I’d like to backup my blog and save it onto my hard drive using phpMyAdmin. I was wondering exactly how to do that. I have no experience with databases. I got into my wordpress data base and chose “select all” which highlighted :
    ae_data wp_categories wp_comments wp_linkcategories wp_links wp_optiongroup_options wp_optiongroups wp_options wp_optiontypes wp_optionvalues wp_photos wp_post2cat wp_posts wp_users
    My questions are:
    1. Do I need to select structure only, structure and data, data only, export to xml format, or LaTeX?
    2. Do I need to select add drop table, complete inserts, extended inserts, and/or enclose field names with backquotes ?
    3. I’d like to use the option of saving as a zip file. Would this be ok?
    My host backs up once a week but I’d still like to have a copy saved each month on my own hard drive just to be on the safe side. I want to backup in a way that everything I need is saved so that uploading in the event that my blog is lost will be as simple as possible. Thank you in advance for your help.

Viewing 4 replies - 1 through 4 (of 4 total)
  • Beel

    (@beel)

    22 years ago

    You could get the backup/restore hack for WP.

    ottofilm

    (@ottofilm)

    22 years ago

    Structure and data are both needed to recreate the database if it’s gone. SQL would most easily allow an import back in to recreate everything; with both structure and data in SQL format it will rebuild everything for you before you can even blink. I think extended inserts are overkill but someone else might know better; I think it’s just it labels every insert but the data will already be orderly and I don’t think that’s needed. Zip would be fine; it can read it back I believe on re-install.
    If you post a lot, do it more often than once a month; remember there are no physical files to try and salvage as backup if the database is gone.

    Thread Starter Anonymous

    22 years ago

    Thanks for the info. And you’re right, I should do it more often. Once a week would be much better. Thanks again.

    Sushubh

    (@sushubh)

    22 years ago

    damn u are scaring me now 🙁

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Backing up with phpMyAdmin question’ is closed to new replies.