MySQL

Hi,

I had this experience a few days ago which I could definitely spare: my code that runs custom query against a Drupal site's DB failed completely. One day, out of the blue, my code topped working and I got those SQL problems errors. It appeared as if the DB has changed under my feet! C$%p! - DB corruption???
Not really... Had I known a bit more... Embarassed .

Here's the deal:
You work with Drupal, you have your own node types, created with CCK module of course.

I've recently needed to export some MySQL table data into a file.
Sure, there are gazillion ways to do this. I wanted to do this with as simple as possible tools - command line, that will be available always, and in a way which is not too awkward yet still powerful enough while done in a resource-conserving way.