How to make an owncloud mysql db backup? Centos 7


#1

Hi, i dont have any idea to how to make a backup from the owncloud database.
I m just learning how to use linux commands in special ssh for centos 7.
I m only copying data folder but i know that i have to make a backup from the database…
I know the db name, the username and the password.
Can anybody tell me the command to make the backup please?
Thank you.


#2

I think, all the answers can be found within the docs.Please search.


#3

Assuming you have the sql tools installed on your CentOS 7 install its a single command, mysqldump

See here: https://www.linode.com/docs/databases/mysql/use-mysqldump-to-back-up-mysql-or-mariadb/

Hope that helps,
Pat


#4

If you took time to answer, please be polite and help if not please try not to write because you are not helping anybody.
Regards.


#5

Thank you very much pclemins!! i run this command that appears in that website…

Back up a specific database. Replace db1 with the name of the database you want to back up:

mysqldump -u username -p db1 --single-transaction --quick --lock-tables=false > db1-backup-$(date +%F).sql

#6

Hey,

i think this is not fair / true. If i’m following the suggestion by @alfredb to open https://doc.owncloud.org/server/ and put the word “backup” in the search box at the top left i’m able to find the following documentation on how to backup ownCloud and its database with a few seconds effort:

https://doc.owncloud.com/server/10.1/admin_manual/maintenance/backup.html

I think the same could have been done by yourself when following the suggestion by @alfredb so he already helped you a lot :slightly_smiling_face: