Tag: mysql

Adeel Sarfraz does freelance website design/development/marketing along with mobile applications

An alternative way to check mySQL version in the Magento check script

Magento, like most other open source softwares, provides a list of requirements which need to be fulfilled before it can be installed on your machine. If you are installing Magento for the first time then I would recommend that you read the server requirments. on the other hand there may be some who would like…
Read more

January 19, 2012 0

Sign the petition to save mySQL

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 it things may not remain the same as mySQL is a competitor to Oracle. Save…
Read more

January 27, 2010 0

What is the minimum mySQL version requirement for Zencart?

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 check for any version conflicts that may conflict with our system before I give the…
Read more

July 31, 2009 0

How to add number of days in a date in mySQL?

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 he decided on ending free membership for all members. He wanted his members to pay…
Read more

July 26, 2009 0

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

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 and then tried to run my website and found that the same error message was…
Read more

July 23, 2009 0

How to connect .NET with mySQL?

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 it will always have a special place. However, with other technologies coming to the fore…
Read more

July 14, 2009 0

Modify the auto increment value in mySQL

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 start from that value. However if there are any records which have a value greater…
Read more

April 4, 2009 0

Generate mySQL dump for mySQL 4.x and below

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 to generate SQL script in the right version by using mySQLDump Go to the command…
Read more

February 18, 2009 0

How to move large sized mySQL database

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 when the size of the database is a few MBs. However when the size is…
Read more

January 11, 2009 0