Site maintenance: Tuesday 17 Nov, from 10:00 UTC, about 4–6 hours. Details

This cutover relies on some testing that is still incomplete so may be cancelled at short notice

Forums / Upgrading from 1.2 to 1.3.x / Upgrading from 1.2.4 to 1.3.7, changing hosts

Upgrading from 1.2.4 to 1.3.7, changing hosts

Locked

Started by rayw1679 on 10 Jul 2007, 7:43 PM · Views: 2,997

Results 1 to 8 of 8
This thread is locked. New replies are disabled.
10 Jul 2007, 7:43 PM
#1
rayw1679 avatar

rayw1679

Zen Follower

Join Date:
Mar 2005
Location:
Waxahachie, Texas
Posts:
172
Plugin Contributions:
0

Upgrading from 1.2.4 to 1.3.7, changing hosts

I am experiencing an access error while trying to import my database.

I am moving from Powweb (1.2.4) to Bluehost, and want to upgrade to 1.3.7 while doing so.

I did an export on my old database via phpMyAdmin. I then Installed 1.3.7 on Bluehost. I went to phpMyAdmin on Bluehost, selected the database, dropped the tables, and did the "import" from the .sql file I had backed up. I'm getting the following message:

SQL query:

-- phpMyAdmin SQL Dump
-- version 2.8.0.1
-- http://www.phpmyadmin.net

-- Host: custsql-pow05
-- Generation Time: Jul 09, 2007 at 08:39 PM
-- Server version: 4.1.18
-- PHP Version: 4.4.4

-- Database: rgkzen

CREATE DATABASE rgkzen DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;

MySQL said:

#1044 - Access denied for user 'reliabm4'@'localhost' to database 'rgkzen'

I previously established a username of 'reliabm4_rgkzen' and assigned it to the 'rgkzen' database.

I contacted BlueHost support about the error, and they referred me to their "help" section to read through it.

I assume if I get through this error I can use the installation php to upgrade the database to the new version.

Any suggestions would be greatly appreciated; I have been fighting this for several days, and obviously don't know what I'm doing.

Thanks,
Ray

10 Jul 2007, 8:15 PM
#2
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: Upgrading from 1.2.4 to 1.3.7, changing hosts

If you can edit the sql file, remove the section on CREATE DATABASE....

as you already have the DB created this is not necessary just the populate/insert tables stuff

Zen-Venom Get Bitten

10 Jul 2007, 8:29 PM
#3
rayw1679 avatar

rayw1679

Zen Follower

Join Date:
Mar 2005
Location:
Waxahachie, Texas
Posts:
172
Plugin Contributions:
0

Re: Upgrading from 1.2.4 to 1.3.7, changing hosts

Thank you for your response.

Can I edit the file with Notepad? Sorry, I'm in unfamiliar territory here.

Thanks,
Ray

10 Jul 2007, 8:35 PM
#4
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: Upgrading from 1.2.4 to 1.3.7, changing hosts

Notepad is fine as long as the file size is not too large...

There are free text editors that can handle larger files like notepad2, notepad+ etc.

You do want a plain text editor and not one like MS Word

Or have your Host restore this to the DB

Zen-Venom Get Bitten

10 Jul 2007, 8:45 PM
#5
rayw1679 avatar

rayw1679

Zen Follower

Join Date:
Mar 2005
Location:
Waxahachie, Texas
Posts:
172
Plugin Contributions:
0

Re: Upgrading from 1.2.4 to 1.3.7, changing hosts

Thank you, again. I finally got someone at Bluehost that would talk to me, and they had me send them the file. There were some garbage characters that were messing it up, so you were correct. They had to remove the "drop table" command and they said it worked. I'm getting ready to try it now.

Thank you again for your help.

Thanks,
Ray

21 Jul 2007, 4:16 PM
#6
nedbenj avatar

nedbenj

New Zenner

Join Date:
Jul 2007
Location:
Spain
Posts:
12
Plugin Contributions:
0

Re: Upgrading from 1.2.4 to 1.3.7, changing hosts

Hi there,

Did you manage to resolve this problem. I'm just transferring to Bluehost as well and have the same issue. I've commented out the CREATE DATABASE line in my exported sql file, but it still gives me the same 'access denied' error.

Thanks

14 Sep 2007, 8:10 PM
#7
rayw1679 avatar

rayw1679

Zen Follower

Join Date:
Mar 2005
Location:
Waxahachie, Texas
Posts:
172
Plugin Contributions:
0

Re: Upgrading from 1.2.4 to 1.3.7, changing hosts

Sorry for the delay.

There were some "square" characters in the first of the file; I deleted them and inserted a carriage return where those had been. Not only did it look very structured, but it worked!

Thanks,
Ray

14 Sep 2007, 8:14 PM
#8
rayw1679 avatar

rayw1679

Zen Follower

Join Date:
Mar 2005
Location:
Waxahachie, Texas
Posts:
172
Plugin Contributions:
0

Re: Upgrading from 1.2.4 to 1.3.7, changing hosts

I had a single string of data with the "squares" ... after I converted it, it looked like this:

-- phpMyAdmin SQL Dump
-- version 2.10.0.2
-- http://www.phpmyadmin.net

-- Host: localhost
-- Generation Time: Aug 03, 2007 at 12:33 PM
-- Server version: 5.0.27
-- PHP Version: 4.4.4

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: username_zencart

Thanks,
Ray