I am currently hosting my site at a cloud hosting but the database has a limit of 50 max user connection so I purchased a vps plan . I am planning to migrate my database on vps how can i do this ? Thank you so much.
Thank you so much but I just want to migrate only the database
Is it possible to use remote database ?
Just read the bit about migrating the database 
It's possible if you have the permissions to do so and a good connection. It won't work well enough over the public internet.
You can use remote database to migrate your database if you have large database.
But for that it is must to have root access over both server.
If you don't have root access then you can migrate your database by importing and exporting your database.
But for that it is must to have root access over both server.
If you don't have root access then you can migrate your database by importing and exporting your database.