Sunday 26 March 2017

How to Import Large size .sql file using WAMP server

From this article i will explain how to upload large size (more then 1 GB) mysql file to our database.

Directly we can upload but we have a limit like max 128 MB.

So very easiest method is to upload large amount of data is cmd.
Open our wamp server mysql > mysql console .

then it will ask your mysql password .

Please enter your password then start your cmds.

1. mysql > use  database_name

It will show databse changed 

2. mysql> source file_path.

successfully uploaded your sql file database.




No comments:

Post a Comment

cURL error 60: SSL certificate problem: unable to get local issuer certificate (see https://curl.haxx.se/libcurl/c/libcurl-errors.html) in Laravel

  WampServer: Download this file:  http://curl.haxx.se/ca/cacert.pem Place this file in the  C:\wamp64\bin\php\php7.1.9  folder Open  php.in...

Popular Articles