A while back I had to work on a browser based app for MySQL Database Query, and later I further expanded it and displayed results Google Charts. For this basic query app, I used a simple html template and made it responsive and developed the UI with jQuery and PHP API calls connecting and fetching…
Recently while working on a travel portal, I needed to import huge csv data into MySQL database. Apart from the importing data into its tables, there was another problem. how to upload some 650Mb huge data file of sql dump to server for importing. The trick is that download the csv directly on your server…
While developing a Facebook Dating app recently, I needed to return records for a date range between minimum and maximum age from users table but the data was in the date format (birthday). Following select command will calculate the age from the `birthday` column value for you for each record: SELECT EXTRACT(YEAR FROM (FROM_DAYS(DATEDIFF(NOW(),`birthday`))))+0 AS…
Copying MySQL databases from one server to other remote machine is task every webmaster has to do very often if not daily, and if your databases are huge, following command comes very handy to do this job without first downloading and then uploading the dump file. Also, phpMyAdmin and other MySQL clients fail while importing…
In MySQL date data type, if the date value is not provided while inserting record, ‘0000-00-00’ will be added as If you want to insert empty value for date field and do not want it saved as 0000-00-00, make your date firled NULL as default and do one of the following. Either specify the data…
If you ever have managed some website/portal that has any meaningful traffic, you already know what can it do to your MySQL server performance if you don’t optimise your queries and enable php server side caching. One of the things that you can do at DB level is to enable mysql_query_cache to speed up DB…
If you ever have developed a website which has tasted a bit of success and has reached to serious volume of traffic, welcome to the Big boys club and new headaches! More traffic means high server load which forces you to take number of steps, some of the most important are listed here (in no…
If you get the following error at bash [root@server.com]# service mysqld stop [root@server.com]# service: command not found Then try following command: [root@server.com]# /sbin/service mysqld stop Cheers!
Taking backup databases is a routine for every webmaster. Make your life a little easier by delegating this boring but extremely important chore to the shell script that will do this automatically and silently everyday, or whatever time you choose, for you For automatic MySql database backup, please use following script to take backup using…