Category Archives: Code Snippets

Subversion security issues – .svn directory has your source code in it

Stop Publishing Your Source! Well, unless you’re working on an Open Source project that is. Many of the developers I have worked with on web based apps use a working copy for development purposes or even for staging servers (as … Continue reading

Posted in Code Snippets, Command Line, Server Administration, Source Control, Subversion, Web Servers Tagged , , , , , , , , , , ,

Case Sensitive Comparisons in MySQL Where Clause

How can I make MySQL treat my query as case sensitive? As with all good tools there’s more than one way to get the job done. Assuming you have access to change the structure of the table you have to … Continue reading

Posted in Code Snippets, Database, MySQL, SQL Tagged , ,

Database error fix… mysqldump: Couldn’t execute show create table view

Today I found that my automated MySQL backups have been choking for the last few days with “mysqldump: Couldn’t execute show create table view” because I recently added a view to one of the databases. Apparently the backup user needs … Continue reading

Posted in Code Snippets, Database, MySQL, Server Administration Tagged , , , , ,