Answer the question
In order to leave comments, you need to log in
How to export mysql db data in csv format?
[email protected]:/home/fapchat/Рабочий стол/papka/backups of mysql# mysqldump -u fapchat -ppassword --no-create-info --tab=/home/fapchat/'Рабочий стол'/papka/'backups of mysql' --fields-terminated-by=',' publications
mysqldump: Got error: 1: "Can't create/write to file '/home/fapchat/Рабочий стол/papka/backups of mysql/accounts.txt' (Errcode: 13 "Permission denied")" when executing 'SELECT INTO OUTFILE'
MariaDB [(none)]> GRANT ALL ON *.* TO 'fapchat'@'localhost' IDENTIFIED BY 'password';
Query OK, 0 rows affected (0.14 sec)
MariaDB [publications]> LOCK TABLES
-> classics Read, customers read;
Query OK, 0 rows affected (0.00 sec)
(even if not all, it should still work)MariaDB [publications]> show tables;
+------------------------+
| Tables_in_publications |
+------------------------+
| accounts |
| classics |
| customers |
+------------------------+
3 rows in set (0.00 sec)
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question