Backup software

[BBK]

Anyone got a recommendation for backup software? I'm running Vista and just got a new external 1Tb drive that I would like to have running on a nightly schedule to backup up my work folders. Ideally I'd like something that could automatically backup mysql databases even if they are open, and for it to be able to backup files from a small home network. Networking really isn't my cup of tea, so it has to be a piece of piss to setup!

[willp2003]

Tombott says have a look here:

http://www.vista4beginners.com/How-to-backup-your-data

[BBK]

Does that backup open mysql databases? I know I can get to the files on the drive but I thought there was an issue with databases actually being in use?

[willp2003]

take tombott off your ignore list, and he may help you out

I have no idea LOL

[BBK]

OK, well to prove that I'm not an arsehole who holds grudges (and will whore himself for favours) 'tis done. Very willing to here your advice tom, this is one area where I really am a dunce.

[tombott]

The software won't work with Vista Home Basic or Windows Vista Home Premium, so if your using those then you'll need something else.

With regards to your mysql DB's I would use batch file to stop the service, copy the data then restart the service.
This could be run via Scheduled task

What OS is MySQL running on?

[BBK]

Many thanks Tom

MySQL is just running on my Vista laptop. I swap between 4 & 5, but I know the locations of the physical files, but more through luck than judgement.

I started running through the tutorial, so discovered I do have the correct version of Vista, so thanks for that tutorial.

As for batch files - christ, I haven't written a batch file for 20 years, and I only know my way around mysql via phpmyadmin.

[liveseytowers]

Tombott says have a look here:

http://www.vista4beginners.com/How-to-backup-your-data

I thought that was a taking the piss url!

[BBK]

I thought that was a taking the piss url!

Its a bloody good one for me! I've been working for a large corporate for the past 8 years, and all this shit was done for me - now I'm out on my own this is exactly the kind of link I need

[tombott]

There are a number of pay for products out there that will do this for you.

http://recipe-database-mysql.qarchive.org/

I'm not 100% up to speed with Mysql under Windows (I use Linux for MySql) but I presume its controlled via a service.

If you can find out the service name then doing a batch file would be fairly straight forward.

[BBK]

I have a service called wampsqld, looks favourite. I'll have to look more into the mysql ones, but I do think stopping the service and just grabbing the files is all I need right now, as I have them all online anyway for clients (this is just my development setup).

Thanks for the link btw, backing up all my other crap now.

[tombott]

No worries, I think your right as well just stopping the services copying data and starting the services should do the trick.

Let us know if you need and help writing the batch file.

[BBK]

No worries, I think your right as well just stopping the services copying data and starting the services should do the trick.

Let us know if you need and help writing the batch file.

I may take you up on that, but I'm going to have a stab first I think, have to learn somehow. Thanks.

[tombott]

Check out Robocopy, free download from MS.

Like xcopy but with load more options, you can get it to write out to a log file, watch directories for changes etc and ll from the CLI

[unclex]

http://www.2brightsparks.com/

Great bit of kit and they do a free version

[Mr.James]

Tombott says have a look here:

http://www.vista4beginners.com/How-to-backup-your-data

Good post.

That link will backup all your data without the need to start/stop your sql databases.