|
|
Download MySQL database from website to local - Mysql
|
Views : 617
|
|
Tagged in : Mysql
|
|
|
Report This Scrap as Inappropriate
We request you to choose the appropriate categroy and subcategory that suits your
objectionable concern about the scrap, So that our team can review and find out whether it violates our Guidelines or the
scrap is not suitable for all viewers.
|
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.
|
|
By - Nirmala, On - 2009-08-05 |
|
|
|
