Category: mySQL

We had deployed a Zen Cart website and we came up with the following error in the Zen Cart admin panel when clicking on the Tools -> Send Email link. Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation ‘locate’ …

How to resolve the Zen Cart Illegal mix of collations error Read More »

Tagged with: , ,

mySQL has full text indexing and searching support from version 5.0 onwards however there are some limitations. If you need to implement full text indexing then please review points given below: 1. mySQL allows full text indexing on MyISAM tables …

Steps to implement mySQL FULLTEXT Read More »

Tagged with: ,

After Oracle announced in mid 2009 to acquire Sun there has been much apprehension in the open source community over the future of mySQL. Sun had acquired MySQL AB (the company) and kept it open source however once Oracle acquires …

Sign the petition to save mySQL Read More »

Tagged with:

A client of mine developed his website in Zencart and after careful scrutiny approved the website for deployment to his production machine. He provided the FTP and mySQL information for us to deploy the website. As is the practice, I …

What is the minimum mySQL version requirement for Zencart? Read More »

Tagged with: ,

A client was running a membership driven website for some time now. He had been offering free membership and no membership expiry up till now. However, some where along the way he was bit by the commercial bug 🙂 and …

How to add number of days in a date in mySQL? Read More »

Tagged with:

I had logged into PhPMyAdmin and was trying to add some fields into a table when I got the error “Got error 28 from storage engine”. I tried to refresh the page but it kept coming. I closed the browser …

What to do if you got the “Got error 28 from storage engine” in mySQL? Read More »

Tagged with: ,

mySQL is one of the most widely used open source databases around the world. Today this is the database engine driving up to 90% of PHP driven websites on the web. PHP has been the first love of mySQL and …

How to connect .NET with mySQL? Read More »

Tagged with: ,

If you want to modify the auto increment column to start inserting records from a specific value then you will need to run the following statement. ALTER TABLE <table_name> AUTO_INCREMENT = 12345; After running the above statement the insertion will …

Modify the auto increment value in mySQL Read More »

Tagged with: ,

If you have developed a website in mySQL 5.x and your client somehow manages to purchase a hosting which supports mySQL 4.x (don’t know how this could happen but it happened to me once) then you can do the following …

Generate mySQL dump for mySQL 4.x and below Read More »

Tagged with:

We have all moved databases from one hosting machine to another by creating SQL dumps with PhpMyAdmin or any other mySQL desktop client on the source machine and then running those SQL scripts on the destination machine. This is fine …

How to move large sized mySQL database Read More »

Tagged with: