The new forums will be named Coin Return (based on the most recent vote)! You can check on the status and timeline of the transition to the new forums here.
The Guiding Principles and New Rules document is now in effect.

Best / cheapest way to automatically back up a Windows PC?

LoneIgadzraLoneIgadzra Registered User regular
edited September 2009 in Help / Advice Forum
I have this computer running XP that really needs an automated back up. Like bad. The ideal solution would be something like Apple's Time Machine which finds all the changed files and only copies those to the backup, but we can't replace it with a Mac.

The other thing I need it do is run some scripts every backup. Specifically, this computer has a critically important MySQL database on it, and I want to run a mysqldump of it every so often (some of the tables are InnoDB and just backing up the data folder doesn't seem to work). Easy on Unix with a bash script, but what do I have to do in Windows? A batch file or something?

LoneIgadzra on

Posts

  • PeregrineFalconPeregrineFalcon Registered User regular
    edited September 2009
    Since you're using InnoDB, use ibbackup.

    You can even do this hot to avoid downing the database.

    Entirely too much information available in reference form here.

    PeregrineFalcon on
    Looking for a DX:HR OnLive code for my kid brother.
    Can trade TF2 items or whatever else you're interested in. PM me.
  • LoneIgadzraLoneIgadzra Registered User regular
    edited September 2009
    This database is only used sporadically by a single application running on the server machine (honestly I could use any backend with an ADO.NET connector, but I need to mirror to a web server every so often so MySQL is the overall easiest). mysqldump is sufficient for my purposes, since it gets both InnoDB and MyISAM tables in one go. Unless there is some reason I really need to setup and use this additional third party program.

    LoneIgadzra on
  • LoneIgadzraLoneIgadzra Registered User regular
    edited September 2009
    *bump*

    LoneIgadzra on
Sign In or Register to comment.