Documentation for Cartweaver 4
Cartweaver 4      

Setting Up Your Local Database

Here we will discuss installing and setting up your local database. We will be using MySQL. Previous versions of Cartweaver ColdFusion supported Microsoft Access, but in today's web environment, for an eCommerce based site Access is simply not a secure, reliable or viable enough database option. All support for Access has been discontinued.

Downloading installing MySQL

MySQL is available in a free open source, community edition and can be downloaded and installed in a number of ways. The method we recommend using one of the "all in one" install utilities that is available as a free download called XAMPP.

XamppXAMPP installs MySQL, Apache, PHP, and PHP MyAdmin... Everything you'll need to use and administer MySQL locally.

If you are using Cartweaver 4 ColdFusion, you may ask, I'm developing in ColdFusion, why should I install PHP, and wont this interfere with my ColdFusion environment? If your system is capable of running ColdFusion and most any of the recent Adobe applications, it should have no problem running the XAMPP applications at the same time. The advantage of doing it this way is the set up is quick, easy, and nearly a one-click operation, and it includes phpMyAdmin which is a reasonably good MySQL administrator, in short it's everything you need and set up is a breeze. The installation and setup for XAMPP is quite straight forward. Refer to the XAMPP documentation for details. So if you are using Cartweaver 4 PHP, install XAMPP and you are ready, if you are using Cartweaver 4 ColdFusion, after installing XAMPP you take about another ten minutes and to install the free ColdFusion developers edition and you are ready to go as well.

NavicatA note about MySQL administration tools. There are many MySQL admin apps, some by MySQL - such as MySQL WorkBench - and others that are open source. For general local development and testing the MySQL admin, installed with XAMPP is more than adequate.

For a standalone administration application that works both with local databases and can connect and administer remote databases We highly recommend Navicat for MySQL - While Navicat is available in a free "Lite" version, we strongly encourage you to go for the commercial version, it is available for around $99 and well worth the investment. The ability to drag-n-drop your MySQL databases between server alone is worth the cost of the application. The installation and setup for Navicat is quite straight forward. Refer to the Navicat documentation for details.

Creating Your Database

Once you have XAMPP installed you will need to create the database that your Cartweaver site will use.

Creating User and Permissions

Once your database is created you'll need to set up a user and permissions for the database so ColdFusion can connect to the database as a data source. With PHPMyAdmin still open to the new database you created you will do the following;

You are now ready to Create your data source connection and set up your Cartweaver database.