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.