> 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!
