topic Re: howto save daily mysql database from cron ? in Operating System - Linux

howto save daily mysql database from cron ?

'chris' — Tue, 06 Jul 2004 14:36:52 GMT

hi

howto save daily mysql database from cron under linux ?

kind regards
chris

Re: howto save daily mysql database from cron ?

Jan Sladky — Tue, 06 Jul 2004 15:31:26 GMT

hi Chris,

#!/bin/bash
59 23 * * * mysqldump db_name >db_name.backup

import into mysql :

mysql db_name < db_name.backup

( db_name.backup is text file with table structure and inserts into table )

hope this will help you

Jan

Re: howto save daily mysql database from cron ?

Stuart Browne — Tue, 06 Jul 2004 17:42:47 GMT

I'd suggest you run it through some kind of compression to save a bit of space:

59 23 * * * mysqldump db_name | bzip2 >db_name.backup.bz2

But *shrug* it's just a suggestion.

Re: howto save daily mysql database from cron ?

Tijl Dullers_4 — Sun, 11 Jul 2004 15:41:24 GMT

Hi,

There is a nice Script/Tool on www.freshmeat.net called mysqlbackup

INstruction on how to schedule this from cron are included in the README files and it is very easy to setup.

Re: howto save daily mysql database from cron ?

'chris' — Sun, 11 Jul 2004 16:27:23 GMT

you mean

http://unix.freshmeat.net/projects/mysqlbackup/

?

but the download link doesn't work.

Re: howto save daily mysql database from cron ?

'chris' — Sat, 17 Jul 2004 04:32:54 GMT

hi

I save from cron with:

59 23 * * * root mysqldump -u root --password=password mysql > /opt/save/mysql >/dev/null 2>&1

but howto restore now ?

Re: howto save daily mysql database from cron ?

Stuart Browne — Sun, 18 Jul 2004 18:48:39 GMT

mysql -u root --password=password mysql < /opt/save/mysql