R
R
Roman Zadorozhny2018-11-28 20:52:52
MySQL
Roman Zadorozhny, 2018-11-28 20:52:52

Why can't I dump the database?

So far, I'm just learning mysql, I got to the backup and stuck ... In general, even just displaying all the information on the command line does not work. First I enter: mysqldump -u пользователь -pпароль БАЗА ДАННЫХ nothing happens, then I try a semicolon - it writes the wrong syntax. I read something that maybe the default path is not set, I was looking for solutions, but still to no avail. Worth MariaDB. Thank you very much in advance.

Answer the question

In order to leave comments, you need to log in

2 answer(s)
H
hOtRush, 2018-11-28
@hOtRush

mysqldump -u пользователь -pпароль БАЗА ДАННЫХ > dump.sql

https://dev.mysql.com/doc/refman/8.0/en/mysqldump.html

V
vreitech, 2018-11-28
@fzfx

mysqldump is a system program, not a sql command. enter it in bash in the terminal, not in the mysql session.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question