I have FC6 and use the following script to backup a mysql database from the command line: mysqldump -h localhost -u db_user -p database1 > database1.sql I have a few questions: 1. Using this I have to enter the db_user password. Is there a way to have the password in the script so it will run automatically? 2. What would the script look like to be able to load the database from the command line to restore? 3. Is there a way to have "Drop Database..." added to the backup script? Thanks.