Hot answers tagged

3

This should work: [mysqld] character-set-server=utf8mb4 collation-server=utf8mb4_unicode_ci init-connect='SET NAMES utf8mb4' May be you need to define these options as well: [client] default-character-set=utf8mb4 [mysql] default-character-set=utf8mb4 Hope it helps. Cheers Update: Changed to utf8mb4


2

Typically if a MyISAM table has free space in the middle of the datafile after DELETE operations, it will insert the rows in that free space. However, due the way MyISAM implements concurrency, it depends on the workload what happens. From MySQL manual For a table with a hole, new rows are inserted at the end of the table if it is in use by another ...


1

If you get an error from zcat, in which the error message contains the file name with an extra suffix .Z, then try using gzcat instead, as described at http://stackoverflow.com/questions/296717/zcat-wont-unzip-files-properly



Only top voted, non community-wiki answers of a minimum length are eligible