Last week I told a client he could send me a file in excel and I could import that into the mysql database directly. When I got the file I learned that it wasn’t quite that easy. I had planned to just save it as tab delimited text or CSV, but there was a “description” […]
Category Archives: Database
How to add special shipping by product in Zen Cart
originally posted at http://www.goodfeelingplace.com/how-to-add-special-shipping-by-product-in-zen-cart I am in the process of migrating a static site (peacemonger.org) to a database driven site “powered by” zen cart. One of the features requested was the ability to add special shipping charges for odd shaped items, like posters. After doing some research I discovered a page with instructions at http://tutorials.zen-cart.com/index.php?article=190, […]
How to import and export large datasets in mysql
originally posted at http://www.goodfeelingplace.com/how-to-import-and-export-large-datasets-in-mysql I’ve seen many questions around the importing and exporting of large tables and/or databases in mysql, so I’d like to share how I’ve learned to manage those processes. Using phpmyadmin for these tasks is not suitable because web servers are not designed for running large scripts or uploading/downloading large files. You […]
Free MDB file to MySQL Conversion
originally posted at http://www.goodfeelingplace.com/free-mdb-file-to-mysql-conversion This week I created a pretty useful tool I’d like to share. I was given an MS Access file (.mdb) and I needed a way to transfer the structure and the data into a MySQL database. I don’t have MS Access and I have no plans to purchase it, so I […]