Getting Errors When Trying to transfer MySQL database

CathyAnn · 04-10-2008, 07:08 AM

Help please. I had to give up on StartLogic and am switching my vbulletin forum to a different server, but it isn't accepting the MySQL database transfer.

If I try to install the unzipped files I receive this message:

Error in zip archive: CRC32 Checksum is not equal with the value in header information.

If I try to upload the unzipped files I receive this message:
Error #1044 Access denied for user 'XXXXX@'local host' to database 'XXXXXXX'

Skie · 04-10-2008, 08:13 AM

What exactly are you doing when you get these errors? The second error means that there's a username/password required to access the database and you're not supplying the proper username/password.

CathyAnn · 04-12-2008, 10:11 AM

Thank you so much for your prompt response. I'm sorry I was late in getting back to you.

Through the cpanel, I am going to phpMyAdmin. I was told by a tech at BlueHost that it shouldn't matter if I transferred the zipped or unzipped files. So I clicked on the database I created and then clicked on Import. I tried both the zipped files of the database and then the unzipped.

The tech support at vBulletin told me to check the information in the config file, which I did, but I still am not having any luck.

They also gave me something to try that is way over my head . . .
4. Or you are running MySQL 4.1.x. As of MySQL 4.1.X there is a new password hashing system. PHP4 does not have builtin support for it as of yet, however PHP5 and the MySQLi library do. In order for your old PHP4 MySQL clients to be able to connect to the MySQL 4.1.X database you need to rehash the password using the old method. You should be able to run the following query to make it possible for PHP4 to access the MySQL 4.1.X database.

SET PASSWORD FOR 'username'@'localhost' = OLD_PASSWORD('password');

...with 'username' and 'password' being the new 'username' and 'password' settings in your config.php file. This needs to be run as the MySQL 'root' user from the MySQL prompt, so if you do not have root access to this server you will need to ask your host to do this for you.

More info is here:
http://dev.mysql.com/doc/mysql/en/password-hashing.html
http://dev.mysql.com/doc/mysql/en/up...-from-4-0.html

I really don't think that should apply to my situation, anyway. I just feel like I have missed a step somewhere in transferring my site, and that maybe the vbulletin instructions were not complete enough for a novice like me.

04-10-2008, 07:08 AM	#1 (permalink)
CathyAnn Registered User Join Date: Sep 2006 Posts: 13 OS: XP	Getting Errors When Trying to transfer MySQL database Help please. I had to give up on StartLogic and am switching my vbulletin forum to a different server, but it isn't accepting the MySQL database transfer. If I try to install the unzipped files I receive this message: Error in zip archive: CRC32 Checksum is not equal with the value in header information. If I try to upload the unzipped files I receive this message: Error #1044 Access denied for user 'XXXXX@'local host' to database 'XXXXXXX'

04-10-2008, 08:13 AM	#2 (permalink)
Skie Manager, Alternative Comp Join Date: Mar 2003 Location: Downers Grove, IL Posts: 1,821 OS: Gentoo Linux, Redhat Enterprise Linux, CentOS My System	Re: Getting Errors When Trying to transfer MySQL database What exactly are you doing when you get these errors? The second error means that there's a username/password required to access the database and you're not supplying the proper username/password. __________________

04-12-2008, 10:11 AM	#3 (permalink)
CathyAnn Registered User Join Date: Sep 2006 Posts: 13 OS: XP	Re: Getting Errors When Trying to transfer MySQL database Thank you so much for your prompt response. I'm sorry I was late in getting back to you. Through the cpanel, I am going to phpMyAdmin. I was told by a tech at BlueHost that it shouldn't matter if I transferred the zipped or unzipped files. So I clicked on the database I created and then clicked on Import. I tried both the zipped files of the database and then the unzipped. The tech support at vBulletin told me to check the information in the config file, which I did, but I still am not having any luck. They also gave me something to try that is way over my head . . . 4. Or you are running MySQL 4.1.x. As of MySQL 4.1.X there is a new password hashing system. PHP4 does not have builtin support for it as of yet, however PHP5 and the MySQLi library do. In order for your old PHP4 MySQL clients to be able to connect to the MySQL 4.1.X database you need to rehash the password using the old method. You should be able to run the following query to make it possible for PHP4 to access the MySQL 4.1.X database. SET PASSWORD FOR 'username'@'localhost' = OLD_PASSWORD('password'); ...with 'username' and 'password' being the new 'username' and 'password' settings in your config.php file. This needs to be run as the MySQL 'root' user from the MySQL prompt, so if you do not have root access to this server you will need to ask your host to do this for you. More info is here: http://dev.mysql.com/doc/mysql/en/password-hashing.html http://dev.mysql.com/doc/mysql/en/up...-from-4-0.html I really don't think that should apply to my situation, anyway. I just feel like I have missed a step somewhere in transferring my site, and that maybe the vbulletin instructions were not complete enough for a novice like me.