* make a backup of a mysql database called DBNAME with:

mysqldump -uUSERID -hDBHOST -pPASSWD --opt DBNAME > DBNAME.mysql

  • create a new database with: mysql> create database NEWDB;

(user USERID must have CREATE permissions)

  • unpack the backed-up copy of DBNAME into your new database NEWDB with:

mysql -uUSERID -hDBHOST -pPASSWD NEWDB < DBNAME.mysql

(will wipe out the exising DB)