server backups

All, I'm new to mysql. I'm interested in writing a cron job to backup mysql that will: - Backup all the global information first (users and groups, typically) - Backup each database independently (not dumpall) For postgres I can dump: - globals pg_dumpall -U $PG_ADMIN -g > $PG_BACK

problem loading data into DB w/ perl script

All, I am having difficulty loading data into a DB using a perl script.Linux RH8 box. DB creation: mysql -uroot -p -e 'create database yeast' mysql -uroot -p -e 'grant all privileges on yeast.* to [EMAIL PROTECTED]' mysql -uroot -p -e 'grant all privileges on yeast.* to [EMAIL PROTECTED]'