ARP Posted August 30, 2023 Share Posted August 30, 2023 Hello. I have a 2019 Server running IIS, PHP 7.4, MySQL, phpMyAdmin. The user is trying to import a DB into MySQL via phpMyAdmin but after about 2 minutes or so, he gets an error that says the sever has reset. He has the DB file on the same server so it shouldn't be a network issue. max_execution_time is 0 Max_input_time is -1 post_max_size is larger than the DB file upload_max_filesize is larger than the DB file I'm fairly new at PHP so I don't know what else to check. Any help is greate appreciated!!! AP Quote Link to comment Share on other sites More sharing options...
Solution kicken Posted August 30, 2023 Solution Share Posted August 30, 2023 IIS has various timeout settings. If this is a large import, you shouldn't be doing it through a web interface like phpMyAdmin, long running requests don't usually work out well. You'd be better off using the command line tools to do the import or a tool like MySQL Workbench that can connect directly to the database and run the import. Quote Link to comment Share on other sites More sharing options...
ARP Posted August 30, 2023 Author Share Posted August 30, 2023 Thanks. I just spoke to the user and he's going to do it directly to Mysql and skip phpmyadmin. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.