Announcement Announcement Module
Collapse
No announcement yet.
How to back up a wordpress blog Page Title Module
Move Remove Collapse
Search Search Module
Collapse

Advertisement Advertisement Module
Collapse

Latest Topics Latest Topics Module
Collapse

  • J4v3rt
    Logo for coaching business
    J4v3rt
    Hello,

    Logo for my life-coaching company.
    Any help is greatly appreciated.
    Honest and constructive critique is also very important for me.

    Why butterflies?
    ...
    Today, 06:01 PM
  • Mr.Mag00
    Missing fonts...
    Mr.Mag00
    I'm running Windows 8.1 on a high-end computer. Suddenly the drop-down list of fonts in Illustrator CC has changed! Many or all of the fonts I need, are missing, and there are lots of other fonts in...
    Today, 05:17 PM
  • Mr.Mag00
    Reply to Gaussian blur changing with image size!
    Mr.Mag00
    There are holes in my knowledge. I am quite disorganized. I'm severely dyslexic... so when I run into a roadblock, I just do whatever I can to get around it... even if it means using something like...
    Today, 04:49 PM
  • BOXED
    Would appreciate some feedback on logo
    BOXED
    Starting a new project website for print designers!

    I want to share the latest news on design trends, tips, tutorials, free print design templates. I want to focus purely on the print design...
    Today, 03:41 PM
  • alansmms
    Finding good music theme for website developing even if have to buy rights….
    alansmms
    I’m trying to get hold of good music theme/themes for my site. But I having a hard time finding music that fit even paid stuff. Hope someone here can help with leads to place that have it.
    ...
    Today, 03:10 PM

X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • How to back up a wordpress blog

    How do you do a full backup for a wordpress blog - e.g. db and whatever else

    Thanks
    ehsan.

  • #2
    google: wordpress backup plugin...then install
    Monarchs Rule!

    Comment


    • #3
      I use my database tools on the server, but if I recall correctly there is a wordpress plugin that will allow you to download the DB.


      yep, a quick search pulls this up.
      http://wordpress.org/extend/plugins/wp-db-backup/

      Comment


      • #4
        JINX! (flutterby)

        Comment


        • #5
          :d
          Monarchs Rule!

          Comment


          • #6
            Is that plugin trustworthy? I'm about to install my first wordpress site for a client...however it will be the second one I am working on. Since I had a my first site go down on accident due ftp file moving error type thing, I want to back up as I work on the site, and once we go live. My host does daily backups, but I still would like to retain a copy for my client. I'm so nervous about something breaking in the process of backing up, and even more so, moving the wp site from the test sub domain to the root. I'm obviously a WP newbie, and pretty novice with php and mySQL (going to change that). If there's any advice, such as what tools to use, and best FTP program or settings I'd greatly appreciate the insight. (sorry to hi-jack!)
            | Valerie |
            "Make sure the fortune that you seek is the fortune that you need"
            -Ben Harper

            Comment


            • #7
              You probably need to get to know PHPMyAdmin which will let you access the database 'directly'. Use the 'export' tab and add 'drop-table' when you need to overwrite an existing database. Then if you are moving between domains you will need to run some SQL queries to correct some of the settings (mainly in wp_options).

              There is also some info on the WordPress website.

              One piece of advice is: always make complete back-ups of both database and file structure and keep them somewhere safe. As you say, it's easy to accidentally mess things up: you want to always make sure you can get back to your starting point if necessary.
              Business website: Jackfruit Design
              Personal blog: theSheep.co.uk

              Comment


              • #8
                Thanks great info to know. I did go into the phpmyadmin area because I screwed up something after the install and had to dump the tables. All over my head so reading up on this is definitely a good idea! I'm going to have to move this thing from a sub-domain to the root to go live so I will need to be doing a lot of maintenance like that beforehand.
                | Valerie |
                "Make sure the fortune that you seek is the fortune that you need"
                -Ben Harper

                Comment


                • #9
                  Originally posted by Benjamin
                  Always make complete back-ups of both database and file structure and keep them somewhere safe.
                  Good advice – keep the table structures separate from the data that goes in them. You would then import the structures then the data rather than having a single file.

                  Comment


                  • #10
                    I guess I have to read more on this because I have no idea how to do that or what it means to keep them separate. Then again, I don't know how to backup the db yet...but I am sure some reading will help me understand that.

                    I did get into the back end to dump tables but haven't a clue even what that is. I'm so afraid i'm going to F this up anyways. But I'm going to have to make a backup sometime in the next few days because I'm going to be adding some plugin's and widgets and who knows what is supported in this new 2.8 version.
                    | Valerie |
                    "Make sure the fortune that you seek is the fortune that you need"
                    -Ben Harper

                    Comment


                    • #11
                      For example, a typical blog table may have the following fields id, user_id, title, subtitle, entry, created and updated. The structure of the table is represented by those fields and its name. Each row of that table can be considered data. The Data can't exist without the table, but the table can exist without the data. The table exists without the data when its empty no blog entries have been added to it yet. At that point only the structure exists, but no row data.

                      Comment


                      • #12
                        I'm not positive how you accomplish it in PHP MySQLAdmin but it looks as if all you need to do is uncheck data for the first export then for the second uncheck structure and check data.

                        Comment


                        • #13
                          Thanks tZ that makes perfect sense...
                          | Valerie |
                          "Make sure the fortune that you seek is the fortune that you need"
                          -Ben Harper

                          Comment


                          • #14
                            when you do a fresh wordpress install and create the database, you have an empty table structure already...so wouldn't you just need to backup your populated tables and import them?
                            Monarchs Rule!

                            Comment

                            Mediabistro A division of Prometheus Global Media home | site map | advertising/sponsorships | careers | contact us | help courses | browse jobs | freelancers | content | member benefits | reprints & permissions terms of use | privacy policy Copyright © 2015 Mediabistro Inc.
                            Working...
                            X