Hi,
I've searched google and the forum but didn't find anything relevant (except a bug for Plesk migration).
I have a CPanel server (11.34.0 b9) into which I've migrated ~100 sites from Ensim servers (v. 10.3.6). In the last few days a problem occurs to sites migrated: Databases are not migrated automatically.
Moreover, on these new sites after migration, new databases created in CPanel by the account owners do not appear in their "Mysql Databases" CPanel frontend and creation of new DB users from CPanel fails. (But DBs still exist, work and are administered through PhpMyAdmin).
The Databases on remote servers are read fine, mysql user grants are read fine too ("enXim Grabbing mysql grants...Done"). Everything else seems fine in migrating, however, when trying to restore DBs:
--- Log Detail ---
Restoring MySQL databases....
Restoring database domain_com_data......
ERROR 1045 (28000): Access denied for user 'domainuser'@'localhost' (using password: YES) Restoration of MySQL database (domain_com_data) failed with error: Execution of /usr/bin/mysql --defaults-file=/home/domainuser/._.work.B7JRsZ2m_lP7nWC3 -B -A --force domain_com_data exited with value: 1
Saved to /home/domainuser/domain_com_data.1353978676
Done
Done
Restoring MySQL privs
Done
Reloading MySQL
Done
--- Log Detail End---
After that the import continues and finishes successfully.
("Transfer Complete - Account Copy Process Complete")
Now, I've read somewhere for db users not to exceed 16 characters and they do not.
There's lot of free disk space
There are no problems creating new DBs or DB users on the other accounts (previously imported).
MySQL general log only shows an entry "connect Access denied for user 'domainuser'@'localhost' (using password: YES)", after a few root@localhost successful connections.
On the last accounts (having this issue) sometimes the databases appear in CPanel, but there is an extra DB named "ERROR 1045 (28000): Access denied for user 'domainuser'@'localhost' (using password: YES)", as in
.
However, some other times no DB appears. If the account owner tries to delete the DB, all DBs disappear from his CPanel.
Some 100 sites were migrated fine in the last few months and continue to operate fine. But the last 12 sites appear to have this consistent issue.
Any thoughts?
I've searched google and the forum but didn't find anything relevant (except a bug for Plesk migration).
I have a CPanel server (11.34.0 b9) into which I've migrated ~100 sites from Ensim servers (v. 10.3.6). In the last few days a problem occurs to sites migrated: Databases are not migrated automatically.
Moreover, on these new sites after migration, new databases created in CPanel by the account owners do not appear in their "Mysql Databases" CPanel frontend and creation of new DB users from CPanel fails. (But DBs still exist, work and are administered through PhpMyAdmin).
The Databases on remote servers are read fine, mysql user grants are read fine too ("enXim Grabbing mysql grants...Done"). Everything else seems fine in migrating, however, when trying to restore DBs:
--- Log Detail ---
Restoring MySQL databases....
Restoring database domain_com_data......
ERROR 1045 (28000): Access denied for user 'domainuser'@'localhost' (using password: YES) Restoration of MySQL database (domain_com_data) failed with error: Execution of /usr/bin/mysql --defaults-file=/home/domainuser/._.work.B7JRsZ2m_lP7nWC3 -B -A --force domain_com_data exited with value: 1
Saved to /home/domainuser/domain_com_data.1353978676
Done
Done
Restoring MySQL privs
Done
Reloading MySQL
Done
--- Log Detail End---
After that the import continues and finishes successfully.
("Transfer Complete - Account Copy Process Complete")
Now, I've read somewhere for db users not to exceed 16 characters and they do not.
There's lot of free disk space
There are no problems creating new DBs or DB users on the other accounts (previously imported).
MySQL general log only shows an entry "connect Access denied for user 'domainuser'@'localhost' (using password: YES)", after a few root@localhost successful connections.
On the last accounts (having this issue) sometimes the databases appear in CPanel, but there is an extra DB named "ERROR 1045 (28000): Access denied for user 'domainuser'@'localhost' (using password: YES)", as in

However, some other times no DB appears. If the account owner tries to delete the DB, all DBs disappear from his CPanel.
Some 100 sites were migrated fine in the last few months and continue to operate fine. But the last 12 sites appear to have this consistent issue.
Any thoughts?