You are trying to copy your live site to the offline Xampp server environment but when trying to import the database, you get a filesize error – local xampp phpmyadmin only allows you to import up to 2MB size files. This can however be changed.

Increase the limit in the php.ini file. If you are using windows, you will the find the php.ini file in the C:\xampp\php directory.

Now change the following lines & set your new limits:

post_max_size = 128M
upload_max_filesize = 128M 
max_execution_time = 2000
max_input_time = 3000
memory_limit = 256M

You will then need to close down the Xampp Control Panel and restart everything.

You will now be able to import a larger database via localhost/phpmyadmin