Forums / General Questions / Don't know how to import MySQL DB....PLS HELP!

Don't know how to import MySQL DB....PLS HELP!

Locked

Views: 1,062

Results 1 to 4 of 4
This thread is locked. New replies are disabled.
22 May 2007, 9:03 AM
#1
mrnewbie avatar

mrnewbie

New Zenner

Join Date:
May 2007
Posts:
3
Plugin Contributions:
0

Don't know how to import MySQL DB....PLS HELP!

...Many questions from a Ground Zero Rookie....
.......These should be my "last" customization concerns:

  1. How do I import/connect ZCart to MySQL DB? My host gave me this PHP connection string: *

$dbh=mysql_connect ("localhost", "sicoinsc_zc2", "<PASSWORD HERE>") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("sicoinsc_zc2");

(Where "sicoinsc_zc2" is my DB name)

What do I do with that??????...(looks like Martian-Lingo to me..!)
*
2) What is the fields format I should define for my DB (I assume there must be a specific format) ? (I found something at Wiki, but not very specific)

Many thanks !
Wade

22 May 2007, 9:47 AM
#2
rodg avatar

rodg

Deceased

Join Date:
Jan 2007
Location:
Australia
Posts:
6,263
Plugin Contributions:
4

Re: Don't know how to import MySQL DB....PLS HELP!

Step1 - unzip the zencart files and install them on your webhost.
Step2 - point your browser to your store. Since this is a first time install (by the sounds of it), you'll be greeted with the zencart setup/configuration pages.

When you come to the database connection settings, enter 'localhost' for the servername, sicoinsc_zc2 for the username, your password in the password field, and sicoinsc_zc2 for the database name.
The zencart install script will then create all the required tables for you.

NOTE: We are sorry that Rod is no longer with us.
We are grateful for all his contributions to the Zen Cart community.

Ozpost - The Ultimate Shipping module for Australian Merchants. Click these links for its Homepage, or Download from Zen-Cart.com.

23 May 2007, 6:58 AM
#3
mrnewbie avatar

mrnewbie

New Zenner

Join Date:
May 2007
Posts:
3
Plugin Contributions:
0

Re: Don't know how to import MySQL DB....PLS HELP!

**Thanks for the answer..

I already had my store up and running, and the installation/unzipping was done directly through my host's cpanel, so it never prompted me for any connection settings (as far as I remember)

Do you know any way to do that with the store already installed (eg through ....store/admin)?**

23 May 2007, 7:02 AM
#4
rodg avatar

rodg

Deceased

Join Date:
Jan 2007
Location:
Australia
Posts:
6,263
Plugin Contributions:
4

Re: Don't know how to import MySQL DB....PLS HELP!

If its "up and running" I don't see what your problem is????

Rod

NOTE: We are sorry that Rod is no longer with us.
We are grateful for all his contributions to the Zen Cart community.

Ozpost - The Ultimate Shipping module for Australian Merchants. Click these links for its Homepage, or Download from Zen-Cart.com.