We had to install a new WordPress site onto an old MySQL server and received the following error on import:
In order to fix, we needed to change the collation of the sql file. To do this easily, we found the following snippet:
Today I had the need to dump a certain amount of rows from an existing database and insert them into a new table with the same structure. This application required me to not include the table structure nor the primary key (id). To get the database dump, I used the following command.
I find myself searching for these commands more often than I should. So, until my mush brain remembers these I'll write them down here.
Today I was working with an ExpressionEngine website (which I know nothing about) and I needed to get a modification date on the user profile fields. After searching the ExpressionEngines documentation, I realized that adding my own submit function wasn't going to be as easy as Drupal's hook_form_alter(). My next thought was to try MySQL. After searching a little, I found a post that showed me how to add a timestamp field that updates automatically (http://richard-quinn.net/?p=114).