Help ppl how do I backup a MySql DB running on a desktop on a remote server?

Hello,

I guess what you mean is how to backup MySQL DB on desktop and on Remote Server.

On both system you can use the phpMyAdmin Export utility, it exports both schema and data. You have a variety of option to choose from.

Also, since you would have access to the desktop system, you can easily copy and backup the DB file, it is located in the data folder of the root MySQL installation, there find the folder name that represent your DB.