Getting the following error while import sql file in phpmyadmin.

By | March 1, 2018

Fatal error: Out of memory (allocated 998506496) (tried to allocate 496760462 bytes)phpMyAdmin\libraries\import.lib.php on line 373

Step1:Copy the .sql file into the xammp folder in the below path
xampp/mysql/bin
Step2:create a database called testdatabase in phpmyadmin

step3:
Execute the below command through command prompt

C:\xampp\mysql\bin>mysql -u root -D testdatabase < db_dump_db.sql