Published by: admin, date of publication: December 11, 2020
In this post I will take a note to myself and possibly others. Sometimes you have to import or export large databases. But doing it through third-party programs or scripts, it comes down to the limitations of POST data, the size of uploaded files to the server, or, ultimately, the speed of the Internet. Here I will describe the way to import / export Mysql database via ssh (console, terminal).
In principle, you can use the command:
mysql -uroot -proot_pass db_name <db_name.sql
but it contains pitfalls in the form of the fact that if, for example, the database has already been created, then the import may fail.
The best way out of the situation is to import directly via the MySQL cli:
We go into MySQL:
mysql -uLogin -pPassword
(instead of Login and Password, enter data for authorizing the database user)
Select the database:
(instead of db_name, enter the name of the database)
We import the file into the selected database :
(instead of db_name.sql, enter the name of the database dump file or the path to the file if you find it in the wrong folder where the file is located)
We export using the convenient mysqldump:Tags: sites
Other materials from our site:
Let's set up a wireless connection for the currently most popular Windows 7 operating system. For this, the system must have drivers installed on the Wi-Fi network card. In addition, in laptops, it is disabled by default, so you should look for a button to enable it. For ASUS, you can try pressing the FN + F2 key combination. For some models, a special button with a drawn antenna is used next to which Wireless may be written. Well, the Wi-Fi access point, I hope you have it configured correctly.
In order for the system to be as safe as possible, it must be regularly updated. Software cannot be perfect and new security problems, vulnerabilities and ways of circumventing defenses are constantly found in it. Developers are quick to release fixes for their systems. But for these fixes to apply, you need to upgrade.
Today, let's take a look at the past and plunge into the days of Windows XP. The old woman delighted us from 2001 to April 2019, when the last of her versions were no longer updated . But even earlier, most programs for Windows XP stopped updating.
I would like to tell you a little about HDD diagnostics on my own, I will clearly try to outline typical types of malfunctions in the material, and tell you when to try to do something yourself, and when you cannot do without the help of a specialist. This article is aimed at a target audience with no experience in either repair or data recovery ... We will not touch on highly intelligent concepts and the physics of the problem.
With WordPress 5.5.3, your site gets much better in three areas: speed, search, and security.