Search by tag: backup

2 articles

MariaDB / MySQL: export or backup data to a CSV file

Apr 9, 2014 by dixDel

mariadb mysql backup export csv +2

It seems there are several ways to do this. Here is one, using the mysql prompt. I used mysql root account because my usual user has not enough permissions to write files (ERROR 1045 (28000): Access denied for user 'username'@'localhost' (using password: YES)), even after a chmod 777: UPDATE: We…

MariaDB / MySQL: backup and restore a specific table

Apr 7, 2014 by dixDel

mariadb mysql backup mysqldump +1

We just have to specify the name of the table we want to backup in the usual mysqldump command: $ mysqldump -h hostname -u username -p database_name table_name > backup_table_name.sql Then, to restore it: Source