Well I will be downloading the 1.5.7 version real soon. I still have products & customers in MySQL Database on my server. What I need to know is I don't have the actual Zen-Cart on my server. Is there a why to connect to that without starting from scratch? So I won't lose any my current products and my customers.
Results 1 to 5 of 5
-
30 Jun 2020, 05:37 AM #1
Totally Zenned
- Join Date
- Aug 2007
- Location
- Amarillo, Tx
- Posts
- 1,517
- Plugin Contributions
- 0
Products & Customers are still in MySQL database on my server.
-
30 Jun 2020, 11:19 AM #2
Administrator
- Join Date
- Feb 2006
- Location
- Tampa Bay, Florida
- Posts
- 9,672
- Plugin Contributions
- 123
Re: Products & Customers are still in MySQL database on my server.
If you have an old database that you want to use, just specify it in your includes/configure.php and admin/includes/configure.php after you install the files for Zen Cart 1.5.7.
You'll be updating the block at the bottom of these files that says:
define('DB_TYPE', 'mysql'); // always 'mysql'
define('DB_PREFIX', ''); // prefix for database table names -- preferred to be left empty
define('DB_CHARSET', 'utf8'); // 'utf8' or 'latin1' are most common
define('DB_SERVER', 'localhost'); // address of your db server
define('DB_SERVER_USERNAME', '');
define('DB_SERVER_PASSWORD', '');
define('DB_DATABASE', '');
Create these files from the dist-configure.php files included in the build in the two folders.That Software Guy. My Store: Zen Cart Modifications
Available for hire - See my ad in Services
Plugin Moderator, Documentation Curator, Chief Cook and Bottle-Washer.
Do you benefit from Zen Cart? Then please support the project.
-
30 Jun 2020, 01:39 PM #3
Zen Follower
- Join Date
- Jul 2007
- Posts
- 342
- Plugin Contributions
- 7
Re: Products & Customers are still in MySQL database on my server.
Why not just do a clean install of Zen cart 1..5.7 plus any plugins you require and once you are pleased with the result import your customers and products into the new database.
Originally Posted by wmorris
-
30 Jun 2020, 02:06 PM #4
Administrator
- Join Date
- Sep 2009
- Location
- Stuart, FL
- Posts
- 12,472
- Plugin Contributions
- 88
Re: Products & Customers are still in MySQL database on my server.
Not a good idea, especially if the various database tables have been changed (which is quite likely) in the transition to zc157. Originally Posted by ianhg
-
30 Jun 2020, 04:53 PM #5
Sensei
- Join Date
- Jan 2004
- Posts
- 66,373
- Blog Entries
- 7
- Plugin Contributions
- 274
Re: Products & Customers are still in MySQL database on my server.
The procedure for setting up a new 1.5.7 site for testing and eventually making it use your "actual" data is all spelled out here:
https://docs.zen-cart.com/user/upgra...led_upgrading/.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole
Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.
Reply With Quote
Similar Threads
-
SecurityMetrics are still finding vulnerabilities within PHP scripts on my server
By Dunk in forum General QuestionsReplies: 6Last Post: 12 May 2011, 12:11 PM -
Server upgraded mysql and there are problems - upgrading questions on 1.3.6 to 1.3.7
By kinget in forum Upgrading from 1.3.x to 1.3.9Replies: 3Last Post: 10 Aug 2007, 11:49 PM
Bookmarks