mysql,  phpmyadmin

How to import / upload heavy database on localhost Xampp.

  1. download the sql file you want to upload in the xampp phpmyadmin. eg olddb.sql
  2. create a database in localhost/phpmyadmin. eg mydb
  3. Go to xampp cpanel and click on Shell button on right.
  4. The CMD for sql window will open
  5. 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"

Leave a Reply

Your email address will not be published. Required fields are marked *

5 × one =