Perhaps everyone is used to importing a database using phpMyAdmin. But this platform has a limit on the weight of the file that can be uploaded. So if the database dump exceeds this quota, you can’t do it through phpMyAdmin.
Today I’m going to show an alternative way to load the database – through the console.
In OpenServer you can use the built-in console (but it is not necessary, you can use any console). You can open it by clicking on the program checkbox and selecting: Advanced -> Console
The first thing to do is to find out the MySQL version in OpenServer. To do this, go to the program settings:
In the settings window go to the Modules tab and in the MySQL / MariaDB section see what version we have.
In the console, navigate to the MySQL folder:
Importing the database:
mysql -uuser -ppassword db_name < C:\OpenServer\data_base.sql- -u — database user
- -p— database user password
- db_name — the name of the database to which you want to import
- C:\OpenServer\data_base.sql – location and name of the database dump file
