Author: Stasyuk Eugene 33 08.03.2024

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

Other articles

How to Translate a WordPress Theme to Another Language перевод

How to Translate a WordPress Theme to Another Language

How to Translate a WordPress Theme to Another Language

While working on creating a WordPress theme, we often come across such inscriptions as “upload more, author, tags”, etc. For example, as in my blog: It’s good when the site is in one language. Then you don’t really need to do anything with them. But what to do when the site is multilingual. If the […]

Position sticky doesn’t work position: sticky

Position sticky doesn’t work

Position sticky doesn’t work

Position sticky doesn’t work – to my surprise this is a fairly common request that I myself have encountered in my time. Sticky is a pretty simple and versatile solution for placing sticky blocks on a page. At the very least, it doesn’t require you to do a decent amount of javascript code, which did […]