How to Import very large MySQL database .sql file to phpmyadmin using wamp server

preview_player
Показать описание
Importing very large MySQL database .sql files in phpmyadmin is not a very easy process. When we go to the local host and login to And go to import our database It shows the file limit of 120 MIb. By this process we cannot import very large database in this MySQL phpmyadmin.

To import a large database just go to the icon in the Wamp server And click on the MySQL. Then just click on the MYSQL console. Then just enter your username and hit on the enter Then just type your password and hit enter. than MySQL command line is open. just type “Use database name” click on the enter button. Then it's a Select your database. Then just type “source” and the path of your .sql file. in path just remove ‘/ ‘ and replace with “\” Then also type your .sql file name. and just click on the enter and your database is imported to your MySQL phpmyadmin. Thanks friends
Рекомендации по теме
Комментарии
Автор

Thank you sir! This was a big help. Have a 14GB sql file, and this worked like a charm.

MikeEnos
Автор

i can't believe this work... before i found this video, many article and video recomended tools or app, , thx man you like man from future ..

vakn_official
Автор

I don't see the console on the xampp server

englishguru