WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] PhpMyAdmin - how to backup (7 posts)

  1. utnalove
    Member
    Posted 3 years ago #

    Hello, my PhpMyAdmin is slightly different than the one in http://codex.wordpress.org/Backing_Up_Your_Database

    In my PhpMyAdmin I am asked if I want to:
    "Save output to a file" - and give a "File name template:" = @DATABASE@

    The description is:
    This value is interpreted using strftime, so you can use time formatting strings. Additionally the following transformations will happen: @SERVER@ will become the server name , @DATABASE@ will become the database name. Other text will be kept as is. See the FAQ for details.

    What should I do here?

    I have also some Format-specific options:
    -Display comments (includes info such as export timestamp, PHP version, and server version)
    -Include a timestamp of when databases were created, last updated, and last checked
    -Enclose export in a transaction
    -Disable foreign key checks

    What should I choose above?
    Thank you

  2. heathenjimmy
    Member
    Posted 3 years ago #

    There are some plugins that may help you with your questions.
    http://wordpress.org/extend/plugins/wp-dbmanager/
    http://wordpress.org/extend/plugins/wp-db-backup/
    These two are the most popular among the many listed at WordPress.

  3. utnalove
    Member
    Posted 3 years ago #

    Yes, thanks I used wp-db-backup, but I would like to be able to make a backup using phpmyadmin as well...

    Do you know what I should choose?

  4. heathenjimmy
    Member
    Posted 3 years ago #

    If you have cPanel access to your web site then you can change the values and add fields to your database structure via PHPadmin. Displaying new additions in your theme will also require editing the theme files or via a child theme.
    Backing up your files is easier than changing them.
    http://www.co.cc will provide you with a free domain name which you can use as a test site for code experiments. You can make a backup copy and see it working before making big changes to what you've already got on your functional web site.
    Upgrading to WordPress 3.2 is causing a few problems, a test site will avoid errors in your plugins configuration.

  5. utnalove
    Member
    Posted 3 years ago #

    Hello, thank you for your message.
    I just would like what must be and must not be selected here to have a successfully working backup that can be easily restored:

    http://img713.imageshack.us/img713/3014/screenjl.png

  6. heathenjimmy
    Member
    Posted 3 years ago #

    There are many options to choose from on that page you copied. I'm not smart enough to help you with it, but there's bound to be a help page somewhere that can. Good luck.

  7. utnalove
    Member
    Posted 3 years ago #

    Thank you heathenjimmy, you have been very helpful.

    Please somebody help to choose what I have to select here: http://img713.imageshack.us/img713/3014/screenjl.png

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags

No tags yet.