February 2012
M T W T F S S
« Dec    
 12345
6789101112
13141516171819
20212223242526
272829  

MySQL Error: Data truncated for column ‘…’ at row 0

If you’ve recently migrated from MySQL 4 to MySQL 5, queries that used to work might cause errors. The thing is that MySQL got much more struct about what data can go where. MySQL 4 used to cast NULL values to 0 INT, DOUBLE, FLOAT etc implicitly. MySQL 5 doesn’t do it so you ether [...]

Backup large MySQL database without SSH access

Moving your databases around is easy when they are small. When they get large it may become a problem especially if you are on a shared hosting… One of my website’s database grew to 5.5Gb in size. When it’s that big phpMyAdmin and standard control panel backup scripts just don’t work. Fortunately there is a [...]

Mysql Connector Set Variable

MySql is a nice database engine, C# is nice programming language. However when you put them together you get something not nice at all. At least from a viewpoint of someone like me who is spoiled by nice, clean and seamless database integration Linq for SQL provides for MSSQL. Unfortunately when you put together MSSQL [...]