Download MySQL database from website to local

Hi....
If you want to download database from website to local follow the below steps.
(*) Login Cpanel
(*) Select Mysql Databases. End of this page phpMyAdmin is there. Click on that.
(*) Databases are listed in left top corner.
(*) Select which database you want to download.
(*) Click Export option.
(*) Change SQL compatibility mode to MYSQL4.0.
(*) Check Save as file.
(*) Click Go button. Now file will be downloaded.


Extract downloaded file in local use the below command:
(*) Create database.
(*) In linux machine open terminal and type the below line.
mysql -u root databasename < downloadfile.sql (eg./home/hiox/Desktop/downloads/myscript_stats.sql)
(*) In windows machine type the above line in command prompt.