Setting up Zen Cart on Windows XP using Xampp - a howto

[kburner]

tar czvf public_html.tgz public_html
If you are on a Linux server it should be fast and you should be able to see the progress.

Finally got this done....thank you.

I am to the next step with database.
Go your local PHPmyadmin, select your local database and click on Import, navigate to the folder where you saved the sql and select it, click go.

I saved database sql to my local file. I went into local PHPmyadmin. I created a new database. I can not find import. It is not below export like on live PHPmyadmin. Page 39 of book said to create database...I went back thru your directions and do not see create database. Not sure what to do next.
Kim

[ckosloff]

I went into local PHPmyadmin. I created a new database. I can not find import.

Of course my instructions don't ask to create database.
They say to delete test installation but NOT database, simply because the name of that database is what the config files use to connect.
Read your config files, therein you will find the name of the database, now create a database with exact same name.
Once created, you select it, it should show import as an option in the top bar.
By the way, what version of XAMPP are you using?
If you installed the latest 1.7.2, then you have PHP 5.3, Zen Cart v1.3.8a and older do not work with that one, read the announcements.
You have to install previous one 1.7.1.

[kburner]

Of course my instructions don't ask to create database.
They say to delete test installation but NOT database, simply because the name of that database is what the config files use to connect.
Read your config files, therein you will find the name of the database, now create a database with exact same name.
Once created, you select it, it should show import as an option in the top bar.
By the way, what version of XAMPP are you using?
If you installed the latest 1.7.2, then you have PHP 5.3, Zen Cart v1.3.8a and older do not work with that one, read the announcements.
You have to install previous one 1.7.1.

I am using XAMPP for Windows Version 1.4.16. Will this one work?

Kim

[kburner]

Of course my instructions don't ask to create database.
They say to delete test installation but NOT database, simply because the name of that database is what the config files use to connect.
Read your config files, therein you will find the name of the database, now create a database with exact same name.
Once created, you select it, it should show import as an option in the top bar.
By the way, what version of XAMPP are you using?
If you installed the latest 1.7.2, then you have PHP 5.3, Zen Cart v1.3.8a and older do not work with that one, read the announcements.
You have to install previous one 1.7.1.

I went to local PHPmyadmin and created database with same name as my live site from config files. Still do not see import as option in top bar....

This is what I see after I select from left side of screen database name. It is on right side.

Server: localhost - Database: mydatabasename_xxxx
StructureStructure SQLSQL SearchSearch QueryQuery ExportExport OperationsOperations DropDrop

No tables found in database.
Create new table on database mydatabasename_xxxx:
Name:
Number of fields:


Kim

[ckosloff]

I went to local PHPmyadmin and created database with same name as my live site from config files.

You are not understanding.
On your local site you create database with same name as your LOCAL files.
You need two sets of files: one for local and one for live.
I recommended 1.7.1.

[kburner]

You are not understanding.
On your local site you create database with same name as your LOCAL files.
You need two sets of files: one for local and one for live.
I recommended 1.7.1.

My local config file does not have a name...
define('DB_DATABASE', '');

Yes, I agree this has been very confusing for me. Kim

[ckosloff]

My local config file does not have a name...
define('DB_DATABASE', '');

This doesn't make sense.
If you installed Zen Cart in your local XAMPP it forced you to create a database (dafault name: zencart).
How would it install otherwise?
Start over.
Uninstall your version of XAMPP, install 1.7.1.
Create DB in phpmyadmin.
Install Zen Cart pointing to that DB you created.
Once it installs correctly, save both your config files.
Then delete the whole folder, but NOT the DB.
Now you have a DB and good config files pointing to it.
Next uncompress your tar.gz into the htdocs folder in XAMPP.
Replace the config files with the ones you saved.
In phpmyadmin import the sql.gz from live into local.

[kburner]

This doesn't make sense.
If you installed Zen Cart in your local XAMPP it forced you to create a database (dafault name: zencart).
How would it install otherwise?
Start over.
Uninstall your version of XAMPP, install 1.7.1.
Create DB in phpmyadmin.
Install Zen Cart pointing to that DB you created.
Once it installs correctly, save both your config files.
Then delete the whole folder, but NOT the DB.
Now you have a DB and good config files pointing to it.
Next uncompress your tar.gz into the htdocs folder in XAMPP.
Replace the config files with the ones you saved.
In phpmyadmin import the sql.gz from live into local.

I started over. Thank you for being patient.

Uninstall your version of XAMPP, install 1.7.1. - DONE
Create DB in phpmyadmin. - Done
Install Zen Cart pointing to that DB you created. - I was able to install copy of live database this time.

I am at this point.
Once it installs correctly, save both your config files. Where do I find these files now? database? This part is confusing because I have not installed uncompress tar.gz into htdocs folder which houses these documents.
Then delete the whole folder, but NOT the DB. - ?

Now you have a DB and good config files pointing to it.
Next uncompress your tar.gz into the htdocs folder in XAMPP.
Replace the config files with the ones you saved.
In phpmyadmin import the sql.gz from live into local.[/QUOTE]

[ckosloff]

Install Zen Cart pointing to that DB you created. - I was able to install copy of live database this time.

Still not understanding.
You have to install a fresh copy of Zen Cart, forget about your live site for the moment.
Create database first, install ZC pointing to that database, all this is in the manual.
Once ZC installs, save /includes/configure.php and /admin/includes/configure.php, anywhere you like.
Then you delete the installation, uncompress tar.gz, replace config files, import sql.gz

[kburner]

Still not understanding.
You have to install a fresh copy of Zen Cart, forget about your live site for the moment.
Create database first, install ZC pointing to that database, all this is in the manual.
Once ZC installs, save /includes/configure.php and /admin/includes/configure.php, anywhere you like.
Then you delete the installation, uncompress tar.gz, replace config files, import sql.gz

Hi ckosloff,

I followed your directions and finally seems to work. I did all you directed above. I went back through book to make sure I was not leaving any open places for potential hackers. I changed curl file like book says on page 40. When I did zc-install (page 46-47) I get error of:

# CURL problems detected: 28 => connect() timed out! more info...
# CURL problems detected: 28 => connect() timed out! more info...
# CURL requires SSL support. Please notify webmaster or hosting company. 28 => connect() timed out!

Since, this is for local do I need to contact my host....I really hope I am still not messing this up. I thought I was finally getting it with last message. Kim