How to make an owncloud mysql db backup? Centos 7

Server
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

1 Like
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.

1 Like
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 ownCloud Documentation Overview 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:

1 Like