Duplicating a MySQL Database

I am trying to duplicate a MySQL database in phpMyAdmin and get permissions problems. It I create an empty DBS 1st I get the following error:

[code]Error
SQL query:

CREATE TABLE `playboardphpbb3`.`phpbb3_acl_groups` (
`group_id` mediumint( 8 ) unsigned NOT NULL default '0',
`forum_id` mediumint( 8 ) unsigned NOT NULL default '0',
`auth_option_id` mediumint( 8 ) unsigned NOT NULL default '0',
`auth_role_id` mediumint( 8 ) unsigned NOT NULL default '0',
`auth_setting` tinyint( 2 ) NOT NULL default '0',
KEY `group_id` ( `group_id` ) ,
KEY `auth_opt_id` ( `auth_option_id` ) ,
KEY `auth_role_id` ( `auth_role_id` )
) ENGINE = MYISAM DEFAULT CHARSET = utf8 COLLATE = utf8_bin

MySQL said:

#1142 - CREATE command denied to user 'kernos'@'unusedvps1.dreamhost.com' for table 'phpbb3_acl_groups' [/code]

Had DH turned off the CREATE command? I do have permissions for both databases. The only other thing that may make a difference is the the old database is on ""dogbert:eubank" MySQL Server" and the new database (and all new databases) is on "toto:ljungquist" MySQL Server.

So, How do I duplicate a MySQL database on DH?

TIA,

Bill

At DH, create is disabled. You will need to create the database in the panel, then import your data. Please see this thread for a more complete explanation.

Regards,
Rudy

CREATE DATABASE is not allowed, but CREATE TABLE should work just fine.


-- si-blog --