Convert a MySQL database to UTF8
This is a “script” to convert your latin1 myisam database to utf8 innodb Dump the database mysqldump -u root -p database_to_convert > db.latin1.sql Make a copy of the dump cp…
A bunch of ramblings about PHP programming, JQuery, MySQL and other 'stuff'
This is a “script” to convert your latin1 myisam database to utf8 innodb Dump the database mysqldump -u root -p database_to_convert > db.latin1.sql Make a copy of the dump cp…
Quite often I have to convert datasets from one source to another target. Sometimes I can only export them as CSV to investigate the field order/column structure Then, once I…
There is a very useful command in Linux, called grep. It is a utility for searching plain text files using regular expressions. You can either search files and folders as…