Database Startup
Jeff Vian
jvian10 at charter.net
Thu Mar 25 22:32:06 UTC 2004
George Lemos wrote:
>>There are probably more elegant solutions, but I lost the
>>root passwords when I was first learning MySQL. Since I had
>>no real data there, renamed the mysql directory holding the
>>tables to mysql.old and restarted mysql. I then started over
>>with a fresh DB.
>>
>>Backup is a good thing! I have a cron job that runs every
>>night and backs up all my dbs:
>>
>> 0 0 * * * export test2;declare test2=`date|cut -c
>>1-3`;mysqldump --all-databases -prootpasswordhere |gzip >
>>/root/sql-backup/all_databases_$test2.sql.gz
>>
>>The files contain everything needed to recreate the databases.
>>
>>
Why not put this into cron.daily?
>>--
>> Steve
>>
>>
>
>
>
>Elegant or not, good tip -- worked for me, thanks!
>
>
>
>
>
More information about the fedora-list
mailing list