So you have been lured into storing attribute data as JSON in your MySQL to avoid defining a proper schema from the beginning. Well, now for some report you need a certain attribute as column. Here is how to solve this task. We have following simplified schema: With data as in following example: We may …
Schlagwort-Archive: mysql
Magento and timezones
Today i had the issue that after dumping and importing a Magento Database from one instance of MySQL into another one the order dates got transported 2 hours into the future. How come?!? Investigation and testing showed that the source database was running with timezone „GMT“ aka „UTC“ aka +00. The target database was running …
Today i corrupted MySQL…here’s how
If you want to change MySQL setting innodb_log_file_size to improve performance the top answer on stack overflow says you have to delete the redo log in /var/lib/mysql/ib_logfile* so that MySQL creates it with the new size. Before deleting you obviously shutdown mysql. But a normal shutdown of MySQL is a fast shutdown which might leave …