5 <p>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.
</p>
6 <pre class=
"brush: sql">
7 mysql
> SHOW tables FROM dylanstestserver;
8 +----------------------------+
9 | Tables_in_dylanstestserver |
10 +----------------------------+
13 +----------------------------+
14 2 rows in set (
0.00 sec)
16 <p>Once everything was running the way I wanted on my development stack, it was a one line command to copy over the database.
</p>
17 <pre class=
"brush: bash">
18 mysqldump dylanstestserver -p | mysql -u dylan -h dylanstestserver.com -D dylanstestserver -p