V
V
Viktor2020-06-06 22:59:17
MySQL
Viktor, 2020-06-06 22:59:17

Issues when importing a mysql dump, how to import?

Hello.
I decided to update the personal server on which the site hung. The server was buggy from the intervention of my crooked hands.
Server on ubuntu 18.04 running webmin.
I made a backup of the databases via mysqldump, demolished the OS and installed the same version, but as a control panel, instead of webmin, I installed keyhelp.
webmin installed mysql by default.
keyhelp uses mariadb.
From what I understand, they are compatible.
But when I try to restore data through mysqldump, I get these errors.

/*!40101 SET @[email protected]@CHARACTER_SET_CLIENT */;
/*!40101 SET @[email protected]@CHARACTER_SET_RESULTS */;
/*!40101 SET @[email protected]@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
/*!40103 SET @[email protected]@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @[email protected]@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @[email protected]@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @[email protected]@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @[email protected]@SQL_NOTES, SQL_NOTES=0 */;
/*!40103 SET [email protected]_TIME_ZONE */;

/*!40101 SET [email protected]_SQL_MODE */;
/*!40014 SET [email protected]_FOREIGN_KEY_CHECKS */;
/*!40014 SET [email protected]_UNIQUE_CHECKS */;
/*!40101 SET [email protected]_CHARACTER_SET_CLIENT */;
/*!40101 SET [email protected]_CHARACTER_SET_RESULTS */;
/*!40101 SET [email protected]_COLLATION_CONNECTION */;
/*!40111 SET [email protected]_SQL_NOTES */;
 -- Dump completed on 2020-06-06 23:35:29

No import occurs
Command. sudo mysqldump -u user -p database < /var/lib/mysql-files/database.sql
the script immediately produces the result.
The data is not imported, the database is empty.
Yes, and 22 GB cannot be imported per second. The last import was done a year ago, then it took almost a day.

It is not possible to edit sql backup files due to the size of the files (about 22gb).
Can you tell me how to import data?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
R
Rsa97, 2020-06-06
@VelkinVV

mysqldump dumps the database. You need to import via mysql.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question