Import larger databases can cause timeouts or errors in phpMyAdmin. For this situations we need to use the command line import.
The file we need is mysql.exe situated in the xampp directory under \xampp\mysql\bin\ . Then 2 steps are required: log in and import the database:
mysql -u [username]
source [path_to_sql_dump] (eventually select required database with “use [db_name]”)
In just one line we can do it the following way, clean and easy:
mysql -u [username] -p [db_name] < [db_dump.sql]