Duplicating a MySQL Database


#1

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


#2

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


#3

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

si-blog
Max discount on any plan with promocode SCJESSEYTOTAL