mysql Archives - Conroyp.com

Schrödinger’s Mysql table – does it exist?

WP Upload Directory not writable! Check file and directory permissions

Feb

2014

Recently I ran in to a particularly odd database problem – a mysql table that both existed and didn’t at the same time. Queries were failing, reporting that the table didn’t exist. Yet when I tried to recreate this Schrödinger’s table, mysql insisted that it already existed, and wouldn’t recreate it. So what gives? The ...

Mysqldump syntax error fixed

WP Upload Directory not writable! Check file and directory permissions

Dec

2013

Recently I needed to move a database I had running in RDS to a machine on a new digitalocean account. A simple enough process, the first step of which was to export the database from RDS, but I pretty quickly ran in to a mysqldump syntax error. 1234mysqldump: Couldn't execute 'SET OPTION SQL_QUOTE_SHOW_CREATE=1': You have ...