Database Startup

George Lemos listreader at lemosnet.com
Thu Mar 25 16:48:42 UTC 2004


> 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.
> 
> --
>    Steve



Elegant or not, good tip -- worked for me, thanks!






More information about the fedora-list mailing list