Search This Blog

Monday, December 7, 2015

How to upload large file size mysql database using Command prompt

Welcome to designer blog

Step1:
 
If you have a Unix/Linux server and have SSH access to it then you can use the `mysql' command line program to import the file like so:

mysql -u myuser -p mydatabase < myfile.sql

This will prompt you for the password for `myuser' and then import the SQL from myfile.sql. Obviously you will need to have uploaded myfile.sql through FTP or similar. Ideally you would compress myfile.sql, upload it, uncompress it and then import using the command above.

Step2:

E:\xampp\mysql\bin>mysql -u root -p wildside < E:\fonts\wlidside.sql



Step3:

Enjoy

No comments:

Post a Comment

Validating to select in sequencial order using angular

    < input type = "checkbox" (change) = "handleSelectTaskItem($event, taskItem)" [checked] = " taskItem . i...