Clever software solutions to everyday challenges
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 …
Continue reading “How to import and export large datasets in mysql”
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 …
originally posted at http://www.goodfeelingplace.com/how-to-enable-soap-on-a-lamp-server I wanted to use the MSN search API on a VPS (Virtual Private Server) I have setup for a client, but the existing CentOS 5 operating system only had PHP5.1.6 and I needed PHP5.2.1 (at least) with SOAP enabled for the search API to work. So I downloaded all my code …
originally posted at http://www.goodfeelingplace.com/how-to-allow-up-and-down-arrows-to-navigate-your-form-fields I learned something pretty cool last week. I fielded a request from a client who wanted to be able to use the up and down arrows on his keyboard to navigate a rather large form on the site I created for him. I believed it was possible but I had never …
Continue reading “How to allow up and down arrows to navigate your form fields”
originally posted at http://www.goodfeelingplace.com/source-control-feels-good Today I want to sing praises for source control. I was working on an inventory application this morning, putting a few final touches on the display of the data to make it more crisp and clean looking. In this application I used the extjs grid view library (see www.extjs.com for more …