Uhhh... I have the same problem.

I need to copy all data from all tables from one database to another.

My problem is I cannot use the EXPORT command because it requires all connections to the database to be ended. And I cannot afford that, not even for one second.

So i was thinking to make a select in all tables, redirect the output to some text files and insert the results in my new database (whose structure I already created).

But I was thinking..... is there any other simpler way to do this?

Thank you.