Daily backup of one table

[expired user #5088]'s profile image [expired user #5088] posted 14 years ago in General Permalink
I am a SQL dummy but at least Heidi makes me look smart LOL
I am running MySql on an XP 23 bit machine. I want to do a daily backup of a few critical tables .The total size is about 80 meg
How is the easiest way to do this ?
I do it manually now :(

Also does it hurt to run "repair" daily on the DB if not how do I script this to be done daily ??

TIA
oz

PS great app
[expired user #5088]'s profile image [expired user #5088] posted 14 years ago Permalink
um 32 bit
ansgar's profile image ansgar posted 14 years ago Permalink
HeidiSQL cannot be scheduled for export stuff, sorry. But you can use your Windows task scheduler to run e.g.:
mysqldump.exe -hlocalhost -uroot -p123 mydb >c:\backup.sql
kalvaro's profile image kalvaro posted 14 years ago Permalink
HeidiSQL is a cool piece of software but it's not really designed as a backup tool.

You can get MySQL Administrator from the MySQL GUI Tools Bundle and try its scheduled backup feature. The software is supposedly deprecated in favour of MySQL Workbench but Workbench seems to lack this feature.

Please login to leave a reply, or register at first.