X-Git-Url: https://disinclined.org/git/?a=blobdiff_plain;f=_posts%2F2011-02-13-mysql-is-my-cms.html;fp=_posts%2F2011-02-13-mysql-is-my-cms.html;h=f22008b6ca6466e50c25de83325e1204be5adedd;hb=4fdb6152f6035dec5d3b46b23cb7f7f15072ef4b;hp=0000000000000000000000000000000000000000;hpb=7d05bc31df7579040af812d878a8553309a94799;p=disinclined.org.git

diff --git a/_posts/2011-02-13-mysql-is-my-cms.html b/_posts/2011-02-13-mysql-is-my-cms.html
new file mode 100644
index 0000000..f22008b
--- /dev/null
+++ b/_posts/2011-02-13-mysql-is-my-cms.html
@@ -0,0 +1,19 @@
+---
+layout: note
+---
+
+<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>
+<pre class="brush: sql">
+mysql&#62; SHOW tables FROM dylanstestserver;
++----------------------------+
+| Tables_in_dylanstestserver |
++----------------------------+
+| notes                      |
+| comments                   |
++----------------------------+
+2 rows in set (0.00 sec)
+</pre>
+<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>
+<pre class="brush: bash">
+mysqldump dylanstestserver -p | mysql -u dylan -h dylanstestserver.com -D dylanstestserver -p
+</pre>