Want MySQL FullText Search with InnDB Huh?

MySQL FullText indexing is a popular way to search data from table. FullText indexing is only available if database table type is MyISAM. But, MyISAM table type does not support Foreign keys. InnoDB table type support Foreign keys but does not support FullText indexing. So I have to use a trick to implement fulltext search […]

Export/Backup MySQL Database like phpMyAdmin

If you want to backup you mysql database by php script like phpMyadmin do you can use below function, something like for auto backup system or manual backup from admin panel of your webapp. Call the function with database name and a path to save backup( leave blank for current dir)