MySQL Issue...

Martyn Day

Verified User
Joined
Jul 15, 2009
Messages
83
trying to import my forums database since i used cpanel, it states
Code:
Unable to restore database afk_database : ERROR 1045 (28000): Access denied for user 'afk'@'localhost' (using password: YES)  gunzip: stdout: Broken pipe
all the permissions are correct....

=-/ any idea?
 
You might have to import the raw sql with phpmyadmin.
 
What forum is it, vb phbb etc?

How did you backup the forum to start with?

What version of mysql was the old server running compared to the new one?

The best way to do this is with mysqldump
 
vb, and backed up via the control panel of cPanel, and also backed it up via vbulletin it self..
 
Here is the best way to ensure it works

mysqldump --opt -Q -uUSERNAME -p DATABASENAME > /PATH/TO/DUMP.SQL

then move it to the new server

then restore with this

mysql -uUSERNAME -p NEWDBNAME < /PATH/TO/NEW/DUMP.SQL

all from the command line
 
Back
Top