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