Max execution time

[dsb]

Max execution time

[Galixte]

@gtbu you have to increase the value “max execution time” of PHP (usually in php.ini file) from XAMPP server.

[gtbu]

I have put the time to 30 minutes and no effect. My provider strato does not allow to download from an online installation of mysqldumper inspite of a green 'database connected' line in mysqldumper (neither remote) .
The ony tool which allowed offline restore of my big database on xampp was mysql maestro which i cannot install online - but maybe it will have the same problem as above. I think i will use sqldumpsplitter 2 and zip the splitted files and the use phpmayadmin to import them one after another into an empty online database.

[DSB]

change of 100-10000 to 5000-20000 has no effect.

You need to lower the number of executed sql commands per page call - not raise it.
Change to 50 - 1000 and retry.

2nd solution is to install MySQLDumper at Strato and create a new backup using the multipart feature which splits the dump automatically into several files.