[racktables-users] Re: how to properly back up racktables
- From: "Luis F. Lacayo" <llacayo@xxxxxxxx>
- To: racktables-users@xxxxxxxxxxxxx
- Date: Tue, 02 Apr 2013 17:54:56 -0500
I just do a mysqldump and backup everything. it take less than 30 seconds.
mysqldump -u<user> -p<password> racktables > racktables.dump
why complicate your life.
Luis
On 4/2/13 3:37 PM, Daniel Kasen wrote:
You could just use mysqldump for the whole DB. I've found it to be
the simplest method. Then rsync the racktables dir if you use any
custom plugins.
-djtecha
On Tue, Apr 2, 2013 at 12:52 PM, Chubby Wl <chubbypama@xxxxxxxxx
<mailto:chubbypama@xxxxxxxxx>> wrote:
Hi there. I'm trying to use the mysqldump command to create a
complete back up of racktables.
The command we are looking to use is the following:
mysqldump --no-create-info=FALSE --order-by-primary=FALSE
--force=FALSE --no-data=FALSE --tz-utc=TRUE \
--flush-privileges=FALSE --compress=FALSE --replace=FALSE
--insert-ignore=FALSE --extended-insert=TRUE \
--user=root --password=nagios --quote-names=TRUE --hex-blob=FALSE
--complete-insert=FALSE --add-locks=TRUE \
--port=3306 --disable-keys=TRUE --delayed-insert=FALSE
--create-options=TRUE --delete-master-logs=FALSE \
--comments=TRUE --default-character-set=utf8
--max_allowed_packet=1G --flush-logs=FALSE --dump-date=TRUE \
--lock-tables=TRUE --allow-keywords=FALSE --events=FALSE
--databases --routines "racktables" > /racktables-`hostname`.sql
I wanted to double check to see if there was any recommended way
of doing this. I've been looking through the docs and I've also
googled but haven't found anything specific to racktables.
Does anyone have any comments / can you share what you are doing
to back up your database?
Thanks
Other related posts:
