Author Archives: admin

Vim colorschemes

If you want to customize the colors you get in  VIM Here is a gallery:   http://vimcolorschemetest.googlecode.com/svn/html/index-html.html To try out different schemes you can type :colorscheme XXXXX in vi  where XXX is the scheme name  (without the .vim extension ) Once … Continue reading

Posted in Uncategorized | Leave a comment

Separating storage of mysql database files

We often have very large databases we want to create in mysql. If we don’t have enough space in the /var/lib/mysql partition it is handy to be able to specify that a specific database be stored on another drive. This … Continue reading

Posted in Uncategorized | Leave a comment

Loading compressed file into mysql without uncompressing

If you have a compressed file from a mysqldump backup of your mysql database, and you don’t have space to uncompress it to load it on another machine.  You can load it directly from the compress file using this command: … Continue reading

Posted in Uncategorized | Leave a comment

Fixing VIM to allow smart match finding using the percent key

Edited the file /usr/share/vim/vim70/syntax/smarty.vim Added the following code: ” HTML:  thanks to Johannes Zellner and Benji Fisher. if exists(“loaded_matchit”) let b:match_ignorecase = 1 let b:match_skip = ‘s:Comment’ let b:match_words = ‘,’ . \ ‘]*\%(>\|$\):\|$\):\|$\):

Posted in Uncategorized | 1 Comment

Background Gradient Image Creation Tool

If you need to create a gradient image for a background you might try this tool. It is pretty slick. http://www.ogim.4u2ges.com/gradient-image-maker.asp

Posted in Uncategorized | 1 Comment

Faster MYSQL Index creation

Creating indexes in mysql on large tables can take a long time. Because it makes a temporary copy of the entire DB file first then creates the indexes. So be sure you have enough free space for the complete DB … Continue reading

Posted in Uncategorized | Tagged | Leave a comment

Generate SQL to create indexes in mysql

If you have a mysql database table with indexes and you want to get the alter table  commands to “create” the same indexes on another db You can run this sql — replacing the tablename with your table. Just add … Continue reading

Posted in Uncategorized | Tagged | Leave a comment

Meek Consulting is online!

The home of Fairwayfiles is now back online

Posted in Uncategorized | Leave a comment