You can fix network error issue via upgrade to latest phpMyAdmin folder in xampp
If you are facing the network error issue while exporting an existing database in Xampp. You can simply upgrade your phpmyadmin folder with the latest one. I faced this issue with php8.0 and phpmyadmin7.1, so I upgraded my phpmyadmin folder upto: phpMyAdmin 5.3+snapshot. You can also download that upgraded version from here:
https://www.phpmyadmin.net/downloads/
Steps to follow after downloading the upgraded phpmyadmin zip file.
- Extract zip file.
- Rename your old “phpMyAdmin” folder to “phpMyAdmin-old” in Xampp folder. Rename new downloaded phpmyadmin folder to “phpMyAdmin” and move that folder into Xampp.
- Go inside “phpMyAdmin” folder and copy the “config.sample.inc.php” file and rename copied file into “config.inc.php”
- Open config.inc.php file and uncomment all /* Storage database and tables */, /* User used to manipulate with storage */.
- Also make sure username password setting should be like following way:
/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'cookie';
/* Server parameters */
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['AllowNoPassword'] = true;
In my newly downloaded “phpMyAdmin” folder username and password configurations were missing, so I manually added it into config.inc.php file.
Restart the mysql. It will start exporting again your existing databases.
Network issue screenshot:

Updated phpMyadmin confic.inc.php file settings screenshot:

In my case I was scraping 40k posts and my database was increasing day by day. So in the next morning when I again started my script to scrap more posts. It was not working and keep loading the page. I saw that Apache was working fine. But there was an issue with phpmyadmin. So I researched over it and found that php8 has some issue with older phpmyadmin 7.1 . So I decided to upgrade my phpmyadmin folder with the latest one. It is working fine now.