Remote mysql server

Hello,
I'm looking for help, because I've found informations really old about that feature.
I've setup a remote mysql server, and it works.
Now it's time to move databases from local to remote server. Can someone tell me how to do that?
Maybe something more painless than "stop mysql and copy with scp the /var/lib/mysql/ folder"?
In cpanel documentation everything is explained for a "first setup" server, but what I do if my server is already up with 50 clients?
Because in that situation is better to setup a new cPanel server with remote mysql server enabled and move old accounts without remote db to this new server.

I've asked for a better integration and clustering with a "MySQL only" version of cPanel/WHM; I hope this help.
MySQL Only version of cPanel & WHM | cPanel Feature Requests

Thank you for the help

 

Thank you, I've tried with a test server, and it works.
But an old account still load the database from localhost, instead load the db from remote server: how can I tell cPanel to use remote server for account's database, and not local db?
Thank you
For reference, i've found that useful post:
http://forums.cpanel.net/f354/cpanel-remote-database-server-mysql-server-setup-cpanel-integration-existing-db-migration-357001.html#post1440991

 

Yes, I've setup the remote DB, in fact I don't see localhost anymore, but I see the mysql server's IP.
Now the situation is:
- I've about 100 sites and accounts on localhost db and server
- I've moved one site DB with scp to remote server
- I've stopped mysql on remote server, the site work.
- I've renamed the /var/lib/mysql folder with account name on localhost. The site not work anymore.

It's nice if I can select which account to move, and move the accounts between server like zones with DNS Only.

 

Thank you, I've done everything, in fact I see the cPanel services using the remote db.
What I've learned is that I don't need to edit my customers script and change server to remote ip.
Can you confirm that?

Thank you

 

Yes, they are working perfectly with localhost. But they use local db.
I have see that because if I have an account called "test", and I move /var/lib/mysql/test from local server to remote server, the site stop works.
In a normal situation, and if remote server concept is to use a remote server, if I move the db for the account from local server to remote server, it use remote db.
I can't change configuration files for over 100 accounts, maybe I start with a brand new server.