Sql
27 Jul 2016 22:27
SQL syntax or access violation error while running joomla xmlImport.php file
Error: SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BL OB prefix of 768 bytes is stored inline.
27 Jul 2016 22:29
Steps to restore an innodb database
Set up a temporary mysql “sandbox” instance using the innodb files and the fil ebased backups of the database and create a mysql dump of the database.
27 Jul 2016 22:29
Optimize database using phpMyAdmin
Over a time as your website add contents to it’s database, the files/tables will become fragmented resulting in slower performance. Optimizing the database will essentially defragment the files, and is something you should perform regularily if you do have a busy website.