Tag Filter - (Mysql)

Sep 09, 2012
09:09

Quick command line MYSQL backup or copy your mysql database

Just a quick note on how to backup or copy your database through the command line...

Filed under: Notes  Tags: Mysql

Oct 06, 2011
05:10

embarcadero dbexpress SQLConnection DriverName access violation DbxCommon150.bpl

I struck a problem trying to use the dbExpress TSQLConnection components on an upgraded BDS2006 application where the program would compile and link fine but when you ran the application it would fail with the following access violation error...

Filed under: Code Snip  Tags: Embarcadero, Borland, C, Cpp, Xe, Xe2, Delphi, Rad Studio, Mysql

Oct 05, 2011
05:10

Getting embarcadero dbexpress mysql working - DBX Error: Driver not initialized

Sometimes the simple things are harder than you expected and dbexpress probably comes under that category, it was less express than I had expected but once you figure things out it does work. Some of the problems were my fault while others took time due to the obscur nature of the errors returned by XE and XE2...

Filed under: Code Snip  Tags: Embarcadero, Borland, C, Cpp, Xe, Xe2, Delphi, Mysql
(default) 3 queries took 4 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT Post.* FROM posts Post, posts_tags pt, tags t WHERE t.tag = ('Mysql') AND t.id = pt.tag_id AND pt.post_id = Post.id AND Post.status = 1 ORDER BY Post.created DESC332
2SELECT category, COUNT(*) AS cat_cnt FROM categories_posts c2p INNER JOIN categories Cat ON c2p.category_id = Cat.id GROUP BY category15151
3SELECT tag, COUNT(*) AS tag_cnt FROM posts_tags t2p INNER JOIN tags Tag ON t2p.tag_id = Tag.id GROUP BY tag49491