Problem bringing over a MySQL database...

beansbaxter

Verified User
Joined
Mar 17, 2004
Messages
218
Location
WA
Under DirectAdmin v1.28.1... under the MySQL backend, I select a database from the drop-down menu, and then browse to find a database to upload it into (a .gz file) and click the Upload button, and then get the following error code:

Unable to restore database scspo2_gallery2 : ERROR 1045 (28000): Access denied for user 'scspo2'@'localhost' (using password: YES) gunzip: stdout: Broken pipe

Not sure why this is happening. Some more info, if it matters...

The MySQL database is being exported from a different server, which is running the following versions:

cPanel Build 10.9.0-RELEASE 118
phpMyAdmin - 2.9.0.2
MySQL 4.0.27-standard

And the server I am trying to upload the database into, the username, database name, and passwords were setup identical to the incoming database I was trying to upload into it.

When looking at the DirectAdmin server info, I noticed it i running

MySQL 4.1.11
phpMyAdmin - 2.8.1

So the MySQL is newer and the phpMyAdmin is older on the current flavor of DirectAdmin...

How can I get a MySQL database from this cPanel to my DirectAdmin????

Thanks in advance?
 
Under DirectAdmin v1.28.1... under the MySQL backend, I select a database from the drop-down menu, and then browse to find a database to upload it into (a .gz file) and click the Upload button, and then get the following error code:

Unable to restore database scspo2_gallery2 : ERROR 1045 (28000): Access denied for user 'scspo2'@'localhost' (using password: YES) gunzip: stdout: Broken pipe

Not sure why this is happening. Some more info, if it matters...

The MySQL database is being exported from a different server, which is running the following versions:

cPanel Build 10.9.0-RELEASE 118
phpMyAdmin - 2.9.0.2
MySQL 4.0.27-standard

And the server I am trying to upload the database into, the username, database name, and passwords were setup identical to the incoming database I was trying to upload into it.

When looking at the DirectAdmin server info, I noticed it i running

MySQL 4.1.11
phpMyAdmin - 2.8.1

So the MySQL is newer and the phpMyAdmin is older on the current flavor of DirectAdmin...

How can I get a MySQL database from this cPanel to my DirectAdmin????

Thanks in advance?

try to export a SQL dump from phpmyadmin (cPanel) and import it directly in phpmyadmin (DA).
 
Back
Top