mysql

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.

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).

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.

Archive a directory

tar -zcvf .tar.gz /DIR/You/WANT/TO/ARCHIVE 

Extract .tar.gz file

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.