https://images.app.goo.gl/f1kaWn4YCgWHKnCH7

How you can import a large SQL database on your PHPmyAdmin?

Hello, guys in this article I am going to explain how you can import a large SQL database on your PHPmyAdmin which is running on your webserver.

I have a database which is test.sql and it is around 250MB and I want to import this database in this PHPMyAdmin MySQL database using this webserver.

When import database it says you probably tried to upload a file that is too large please refer to the documentation.

Image by Author

Now your file size is not enough for uploading SQL file.

Image by author

As a solution for too long file size, you need to change the php.ini file and change limits of MySQL database upload max filesize in php.ini

Steps:

1. Start your WampServer.
2. Right-click on WampServer.
3. Go to PHP >php.ini and open the file.

Image by author

4. Search for upload_max_filesize.

Image by author

5. You will find upload_max_filesize=2M

Image by author

6. Change it to 100M or more according to your requirements. Save file and close.

Image by author

7. Right-click on WampServer and click on “Restart All Services”

Image by author

Finally, you can see your upload file size is now changed and it is larger what you previously had.

I hope this article will help you.

See you again, bye!