Tag Filter - (Mysql)

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

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...

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...

(default) 9 queries took 4 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `posts`17171
2DESCRIBE `comments`11110
3DESCRIBE `tags`220
4DESCRIBE `categories`220
5DESCRIBE `posts_tags`220
6DESCRIBE `categories_posts`220
7SELECT 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 DESC331
8SELECT category, COUNT(*) AS cat_cnt FROM categories_posts c2p INNER JOIN categories Cat ON c2p.category_id = Cat.id GROUP BY category15151
9SELECT tag, COUNT(*) AS tag_cnt FROM posts_tags t2p INNER JOIN tags Tag ON t2p.tag_id = Tag.id GROUP BY tag49491