If you directly try to import the sql file in phpMyAdmin you get an error as folows.
Warning: POST Content-Length of 615119678 bytes exceeds the limit of 8388608 bytes in Unknown on line 0
Fatal error: Maximum execution time of 30 seconds exceeded in F:\xampp\phpMyAdmin\libraries\Psr4Autoloader.php on line 91
Solution:
Navigate to the location of mysql.exe inside the xampp folder in the command prompt.
Then type the following command:
mysql -u username -p new_database < data-dump.sql
This is what my command prompt looked like:
F:\xampp\mysql\bin>mysql -u root -p shamsa_db_8_6_2018 < shamsa_db_7_3_2018.sql
Warning: POST Content-Length of 615119678 bytes exceeds the limit of 8388608 bytes in Unknown on line 0
Fatal error: Maximum execution time of 30 seconds exceeded in F:\xampp\phpMyAdmin\libraries\Psr4Autoloader.php on line 91
Solution:
Navigate to the location of mysql.exe inside the xampp folder in the command prompt.
Then type the following command:
mysql -u username -p new_database < data-dump.sql
This is what my command prompt looked like:
F:\xampp\mysql\bin>mysql -u root -p shamsa_db_8_6_2018 < shamsa_db_7_3_2018.sql
I was prompted for a password to which I just pressed enter.
After a while the data was dumped.
No comments:
Post a Comment