Below are the steps to import large Database in MySQL:

Step 1: Stop MySQL server from your control panel.

Step 2:  Open the file C:\xampp\mysql\bin\my configuration
Search and Change the below lines (setting):
innodb_buffer_pool_size=4G
innodb_log_file_size=2GB
innodb_log_buffer_size=256M
innodb_flush_log_at_trx_commit=0
innodb_lock_wait_timeout=500
innodb_strict_mode=0
 
Step 3: Start the MySQL server from your control panel.

Step 4: Open command prompt and run import command
mysql -h localhost -u root -p your_local_db < e:/db/backupdb.sql