How do I make backups ?

  • I finally got everything working correctly and am ready to start blogging after I clean up the template and CSS file a bit.
    Once I get some posts entered how do I make a backup in case the server craps out?

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

  • This is what I do:
    Keep a backup of the folder on the FTP.
    Take the backup of the database from the backend.
    These 2 are good enough.

    Thread Starter Anonymous

    Thanks.
    I will check with my hosting company since I have never had to backup a database before.

    if u made the database urself, u will find the option there somewhere.
    what backend ur host provide? DirectAdmin or CPanelx?

    Thread Starter Anonymous

    I just told them I needed a SQL database and wordpress did the rest ??

    If you have shell access, I’ve got a shell script that I’m willing to share that does the trick. I run it as a cronjob every night.

    well then test if they are polite enough to back the database for u every week :).
    Most probably, they would have a front end for you. Play with it and you will find loads of stuff you would have never imagined you were payin for! ??

    I have a php file that you can run on either your local box or the remote box, and will copy named/listed tables between two databases. People should let me know if this is useful (I adapted it from somewhere around the net), and I can probably make it a bit more WP-ready… ?? I’ll have to find a place on my site for downloads… hmmm… haven’t done a downloads page yet.
    =d

    That sounds like it’d be very useful, David.

    I’ll try to remember to package it up, maybe over the weekend. It’s a hack, but maybe that’s enough for everyone to start with. Eventually, it’d be nice to actually promote my ‘localhost support’ code into CVS for all to use, and then add a ‘backup now’ button into the admin interface. Well, now I’m just dreaming… ??
    =d

    Okay, I just posted an article on https://www.chait.net (“WordPress backup”) referencing a sample backup file. People can feel free to grab from there and leave me any comments, suggestions, improvements, etc.
    =d

    …And I removed the direct link last night, after Mark’s noting how dangerous it is in the hands of the averager user… and I dropped myself to being an average user yesterday after doing the backup the wrong direction! The file is still up there, but you should know PHP, understand the risks of copying between databases (and double check the code).
    I’ll be working in the weeks ahead on better backup utilities, both to file and between databases, with more ‘protection’ so you can screw up like I did. ??
    =d

Viewing 11 replies - 1 through 11 (of 11 total)
  • The topic ‘How do I make backups ?’ is closed to new replies.