How to backup a particular Database in MYSQL? Post: 302534293

6 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

MYSQL command to take a backup of the database in Redhat linux 7.2

I am new to mysql database , we have a mysql database running on linux , and we use mysql database for bugzilla, so we wanted to take a backup . what is the command for taking the entire database backup from the command prompt with all options. Thanks in advance Bache Gowda

2. UNIX for Dummies Questions & Answers

Connect MySQL database from Unix

How to connect a MySQL database from unix using unix shell scripting ( people are using perl scrpt to connect the same database). I want to access a MySQL database through a shell script

3. Web Development

Updating Records in Mysql Database

so when i issue a command like the below: # mysql --pager=/usr/bin/less -u cactiman -p -e 'select * from data_input' cacti Enter password: ...

4. Programming

Help with mySQL database by perl script

Hello; I was trying to set up a mysql database using following script, but never went through. The code seems fine without any syntax error as I tested it: perl -c Brapa0101-db.pl Brapa0101-db.pl syntax OKHowever, whenever I run it, an error message was tossed out: DBD::mysql::st execute...

5. UNIX for Dummies Questions & Answers

SSH import mysql database

Hi all, I am trying to import a database in putty with the syntax: mysql –u database_username –p database_name < filename.mysql As you can see in the screenshot it asks me for the database password - which suggests that the syntax is correct - but then after I enter the password it gives...

6. Shell Programming and Scripting

File fetching from mysql database

I have a configuration file namely: abcd, that will be use for some service (like gammu) Inside that configuration file: number1 = 66673527 number1 = 8373272 How can I make the file to search the number1 and number2 from a mysql database? Any help will be very appreciated. Thanks

LEARN ABOUT DEBIAN

ctl_cyrusdb

CTL_CYRUSDB(8)						      System Manager's Manual						    CTL_CYRUSDB(8)

 *

NAME

       ctl_cyrusdb - perform operations common to all Cyrus databases

SYNOPSIS

       ctl_cyrusdb [ -C config-file ] -r [ -x ]
       ctl_cyrusdb [ -C config-file ] -c

DESCRIPTION

       Ctl_cyrusdb is used to perform various administrative operations on the Cyrus databases.

       Ctl_cyrusdb  reads its configuration options out of the imapd.conf(5) file unless specified otherwise by -C.  The configdirectory option is
       used to determine the default location of the Cyrus databases.

OPTIONS

       -C config-file
	      Read configuration options from config-file.

       -r     Recover the databases after an application or system failure.  Also performs database cleanup  like  removing  mailbox  reservations
	      (and any associated mailbox files).

	      All  mailbox  files  are	also checked to make sure the file format matches the configured database type in imapd.conf.  If not, the
	      file is automatically converted using the same logic as cvt_cyrusdb.

       -x     Used with -r to recover the database only.  (Prevents database cleanup).

       -c     Checkpoint and archive the databases.  Changes to the database which are part of committed transactions are written to disk.   Also,
	      a hot backup of the databases is made and inactive log files are removed.

FILES

       /etc/imapd.conf

SEE ALSO

       imapd.conf(5), cyrmaster(8)

CMU
								   Project Cyrus						    CTL_CYRUSDB(8)