Forums / General Questions / Mysql database

Mysql database

Locked

Started by craigfer on 31 Oct 2007, 4:26 PM · Views: 1,279

Results 1 to 7 of 7
This thread is locked. New replies are disabled.
31 Oct 2007, 4:26 PM
#1
craigfer avatar

craigfer

New Zenner

Join Date:
Sep 2007
Posts:
10
Plugin Contributions:
0

Mysql database

Here's the quick story

My hosting company deleted my site - Yeah I know!!

I have a backup of the database on mysql

I want to import it to a new zencart installation

How do i do it?

31 Oct 2007, 4:41 PM
#2
afo avatar

afo

Totally Zenned

Join Date:
Aug 2004
Location:
New York City
Posts:
6,800
Plugin Contributions:
0

Re: Mysql database

You should be able to do it using phpMyAdmin from your webmaster panel.

I take it you've created the database and installed Zen Cart already using zc_install.

Mary Ellen
I came; I saw; I Zenned
Taking over the world... one website at a time
Make sure brain is engaged before putting mouth in gear... or fingers to keyboard.

Holzheimer
Fan Odyssey

31 Oct 2007, 7:15 PM
#3
craigfer avatar

craigfer

New Zenner

Join Date:
Sep 2007
Posts:
10
Plugin Contributions:
0

Re: Mysql database

Yes the database has been uploaded to myphp

but zen cart doesnt seem to be able to see it

31 Oct 2007, 7:19 PM
#4
afo avatar

afo

Totally Zenned

Join Date:
Aug 2004
Location:
New York City
Posts:
6,800
Plugin Contributions:
0

Re: Mysql database

Check that the information in your config files matches the database information. Especially that the passwords match.

Mary Ellen
I came; I saw; I Zenned
Taking over the world... one website at a time
Make sure brain is engaged before putting mouth in gear... or fingers to keyboard.

Holzheimer
Fan Odyssey

31 Oct 2007, 7:40 PM
#5
craigfer avatar

craigfer

New Zenner

Join Date:
Sep 2007
Posts:
10
Plugin Contributions:
0

Re: Mysql database

Yes they look the same - have just changed the password to something else and it didnt site load. Changed the password back and now it loads

But still nothing!

31 Oct 2007, 7:51 PM
#6
afo avatar

afo

Totally Zenned

Join Date:
Aug 2004
Location:
New York City
Posts:
6,800
Plugin Contributions:
0

Re: Mysql database

First, make sure that the OLD user and password are assigned to the current database and that the OLD user and password are what's in the config files.

Second, check this thread and see if it helps. I kinda doubt it, but it's worth a try.

Mary Ellen
I came; I saw; I Zenned
Taking over the world... one website at a time
Make sure brain is engaged before putting mouth in gear... or fingers to keyboard.

Holzheimer
Fan Odyssey

31 Oct 2007, 8:28 PM
#7
poolprorich avatar

poolprorich

Zen Follower

Join Date:
Aug 2007
Location:
Tampa FL.
Posts:
143
Plugin Contributions:
0

Re: Mysql database

Hello,

AFO is correct, just to add check to see if your database prefix is correct if using one as some hosts install setups use a zen_ or zc_ for database prefix

Rich