root bin

# # The MySQL database server configuration file. # [client] port = 3306 socket = /var/run/mysqld/mysqld.sock [mysqld_safe] socket ...

for t in $ ( mysql -- user = root -- password = admin -- database = DBNAME - e "show tables" ;); do echo "...

CREATE TABLE wpdb.wp_posts_deduped like wpdb.wp_posts; INSERT wpdb.wp_posts_deduped SELECT * FROM wpdb.wp_posts GROUP BY post_content, post...

These queries are very useful to find bloated databases/tables: Show size of all databases (in MB) SELECT s.schema_name,     SUM(t.data_...

A very nice MySQL log analyzer tool from  Percona #!/usr/bin/perl # # Nathanial Hendler # http://retards.org/ # # 2001-06-26 v1.0 # # ...

mysql> show status like 'qc%'; +-------------------------+----------+ | Variable_name | Value | +-------------------------+----...

Many suggested solutions did not work. But this one does the job First You have to  Stop mysql server:   service mysqld stop Now Star...