Q:

Can i transfer one MySQL database without stoping MySQL server?

detailed: I have some MySQL databases,for example:
CREATE DATABASE MyDB1;
CREATE DATABASE MyDB2;
CREATE DATABASE MyDB3;
CREATE DATABASE MyDB4;

each one is databased used by another client. MyDB1 started to use too much resources and needs dedicated server. I need to transfer only one database(its ok if that database will be unavailable(better if it will be available all time) other databases should be available all time. Is free version of MySQL enough?
Each database size is near 5 GB.

A:

MySQL has a tool called myqslhotcopy, which is desigend to dump a running database. It does however use lock_table, but it is supposed to be a faster way than mysqldump.
http://dev.mysql.com/doc/refman/5.0/en/mysqlhotcopy.html
My suggestion would be to dump the database during non peak hours and use scp/rsync to move it to a desired server.
Another approach is to use mysqldump as Bitmap has suggested in his answer.

