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 .
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.
