mySQL dB Backup How to?

I have a mySQL database on a Site5 server that I use for click activity and other stuff. I want to back it up locally in case the remote server crashes and my data is lost.

How do I do a complete backup in phpMyAdmin? I clicked on my database and then clicked export but wasn't sure if the default options clicked in Cpanel were correct or if I should have highlighted some of the files I saw in an export window (looked like log files).

How would I restore the exported dB if I ever needed to?

Is there a better way to export/import the dB other than phpMyAdmin?

Thanks in advance for any help any might be able to offer.

 

 

 

 

Top