Table

PHP script to Change MySQL Table Prefix

Tags: MySQLphpTable

Published on : April 4, 2016 by

PHP script to Change MySQL Table Prefix

When installing applications like Magento, WordPress, etc, there will be an option to specify a MySQL table prefix which is to be used with the application’s MySQL database. This prefix will be added to all the tables in the application’s database. Adding such a prefix increases the security of the application as it is a […]

Continue Reading...


MySQL & phpMyAdmin – Truncate didnt free the innoDB space

Tags: innodbMySQLphpmyadminTableTruncate

Published on : April 7, 2012 by

MySQL & phpMyAdmin – Truncate didnt free the innoDB space

Situation :In cPanel database management we have come across the issue that the truncate didn’t free the innoDB space. The issue is that we have Configured the MySQL server with innodb per table. There was a table comments having approximate 600+ MB size all because of comment spamming. I went to the table field in […]

Continue Reading...


Let's Connect

Get new updates

Categories

$0.000 items