Compressing MyISAM Tables

Although tables become static or dynamic without your specific request (but in response to your design decisions), tables are not automatically compressed. To compress a table, you need to use the command-line…

Creating Databases and Tables

The creation of a new database is relatively simple:

MYSQL Change Collation On All Tables And Columns In MySQL with Phoca Changing Collation Utility

I was working with lot of databases collated in latin1_swedish_ci lately. I needed to convert the structure to utf8 collation, but it was very time-consuming to convert all the tables and all the columns…