2011-02-13 / Mysql Is My Cms

I've searched for a CMS to use. I want something small, to edit my notes in Vim and sort them easily in code. I finally decided to write a pagination script for the site, and use the MySQL shell to keep track of things. Python scripts take care of the most repetitive tasks.

mysql> SHOW tables FROM dylanstestserver;
+----------------------------+
| Tables_in_dylanstestserver |
+----------------------------+
| notes                      |
| comments                   |
+----------------------------+
2 rows in set (0.00 sec)

Once everything was running the way I wanted on my development stack, it was a one line command to copy over the database.

mysqldump dylanstestserver -p | mysql -u dylan -h dylanstestserver.com -D dylanstestserver -p