The database is not imported, what should I do?

Question

PHP

I have LAMP installed, (if it matters), when I try to import the database via phpmyadmin (the database weighs 20mb), the page just loads endlessly, and nothing happens, help me decide.

Answer 1

Alternative option

mysql -u root -h localhost -p database < database.sql

• root is your user
  
• localhost - server host
  
• database - database name
  
• database.sql - dump file
  

Answer 2

; Maximum allowed size for uploaded files.
upload_max_filesize = 40M
; Must be greater than or equal to upload_max_filesize
post_max_size = 40M
in php.ini find upload_max_filesize and post_max_size and edit them like this.

Answer 3

check php settings for limiting the size of the post
database can hang for a long time if some implicit calls or index rebuilds occur for each line. and in general, you should look at the log.
And a million more reasons. Without what is written in the log, now poking a finger in the sky