Moving MySQL database to another domain

[Roadsie]

I'm trying to make a copy of a MySQL site onto another domain, for testing, backup and demo purposes. The problem that I have is in creating the copy of the database, I've tried creating a new empty MySQL database and importing the file dump from the original using phpMyAdmin but it fails. Dumping the SQL into a text file and then executing it in the new database also fails.

Can anyone help please?

[RFH Reseller: Rappie]

Thats odd. I succesfully copyed MySQL databases a couple of time from one domain to another. Just like you described. Exporting to whole database and inporting it again to a empty database.

What errors do you run too?

[Roadsie]

When importing I get;

SQL query:

--
-- Database: `dbbackup`
--
CREATE DATABASE `dbbackup` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;

MySQL said: Documentation
#1044 - Access denied for user 'newuser'@'%' to database 'dbbackup'


where dbbackup is the old database being imported and 'newuser' is the user name for the newly created db

[Roadsie]

The problem is that the MySQL dump includes an instruction to create a database, maybe there's a way of having it not do this but my solution was to dump the database to a text file and then remove the create database code.

This can then be pasted into the SQL box and executed.