Folks:

We have a web-based app that's _really_ slowing down because multiple
clients are writing their own private data into a single, central
database. I guess the previous programmer did things this way because it
made things easy. Well, I'm the person that has to put up with
the long-term headache.

Anywho, someone at work wants things sped up, so what I'm looking
at doing is this for each client:

* Create a new, separate database for each client.
* Copy/Import their private data over this new database.
* Make necessary changes on the front end so each client
can access this new database.
* Also looking into running MySQL Cluster for failover,
etc. (This is an oil biz app, and we provide services
24, 7, 365...

So, here's the problem: what I want to do is a filtered
import from the central database to the new client database,
filtering out all other data except for the individual client's
data. I guess I could write some SQL code to do this, but I'm
figuring that this is going to take a while. What I'm hoping
for is that there is a program out there that will take care of
this for me. BTW, the data will be going from one MySQL database
to another MySQL database. Any help would be greatly appreciated!

TIA,

Randall