Compressing MyISAM Tables

Aug 26, 2010 Author: Developer
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

Jun 16, 2009 Author: City Hall
The creation of a new database is relatively simple:

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

Dec 11, 2008 Author: City Hall
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…