* make a backup of a mysql database with:
 mysqldump --opt DBNAME > DBNAME.mysql

 * create a new database with:
 mysql> create database DBNAME;

(user 'ipp' has CREATE permissions) 

 * unpack a backed-up copy into your new database with:

 mysql -u ipp -h alala -p DBNAME < DBNAME.mysql
 (will wipe out the exising DB)