table – Decrypt Web

MySQL Ignore tables

Decrypt Web04/14/202212/26/2022PHP/MySQLDatabase, MySQL, mysqldump, tableNo Comments

Commands to export MySQL database schema, database with data, selective tables, ignoring tables

MySQL Table Size

Decrypt Web01/15/202212/26/2022PHP/MySQLDatabase, MySQL, tableNo Comments

Get MySQL table sizes using a query

MySQL table schema details

Decrypt Web04/06/202112/15/2022PHP/MySQLMySQL, schema, tableNo Comments

I am mentioning here a quick way to get the table schema format. Steps 1) Login to your database using mysql -u {username} -p -h {host_name> -D {database_name} 2) Execute query SELECT TABLE_NAME AS `Table`, ROW_FORMAT AS `Format` FROM information_schema.TABLES WHERE TABLE_SCHEMA = “{database_name}” 3) Primarily there are two types of format Dynamic and Compact […]