How to import / upload heavy database on localhost Xampp.
- download the sql file you want to upload in the xampp phpmyadmin. eg olddb.sql
- create a database in localhost/phpmyadmin. eg mydb
- Go to xampp cpanel and click on Shell button on right.
- The CMD for sql window will open
- write the command over there and done. command is mysql -u username -p database_name < “/path/file.sql”
# mysql -u root -p mydb < "C:\olddb.sql"
