01-20-2004
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
7 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Does anyone know how to get mysql up and running with the installed version that comes with redhat linux?
I've spent hours with no progress.
Thank you (13 Replies)
Discussion started by: gparsons70
13 Replies
2. UNIX for Dummies Questions & Answers
hello,
i'm trying to figure out the size of a mysql database shelling into my server with putty / command line.
is there / are there any commands that will return the size of a database, in MB?
thanks. (4 Replies)
Discussion started by: sbourgeois
4 Replies
3. UNIX for Dummies Questions & Answers
Hi All,
I need to know RedHat linux version installed on a different servers.
I know uname -a or /proc/version
Is any other command to know the Linux version????
When we telnet to any of the Linux server, the version shows very clearly like
Red Hat Enterprise Linux ES release 3 (Taroon... (1 Reply)
Discussion started by: bache_gowda
1 Replies
4. Linux
Hi All,
Is there any command to take complete system backup (image) in Linux like mksysb command in AIX ?
Regards (1 Reply)
Discussion started by: m_raheelahmed
1 Replies
5. Shell Programming and Scripting
Hi All,
Thanks in Advance!!
How to backup a particular Databases..through Bash script!!
For example i have 6 databases;
Anish
linux
Software
Questions
Rhce
Google
these are the databases i have from that i want to take "Anish" and "questions" database backup regularly.... (4 Replies)
Discussion started by: anishkumarv
4 Replies
6. Shell Programming and Scripting
Linux backup command line or live CD?, what do you use? (4 Replies)
Discussion started by: kaja
4 Replies
7. Shell Programming and Scripting
I have a ksh shell script and i need to pass arguments which are generated by data pulled from a database.
When the argument to the shell script is too long (about 4000 charecters) the below is the issue observed.
I copy the command which is 4000 charecters long from the logs and paste it... (7 Replies)
Discussion started by: mohtashims
7 Replies
LEARN ABOUT DEBIAN
bp_genbank2gff
BP_GENBANK2GFF(1p) User Contributed Perl Documentation BP_GENBANK2GFF(1p)
NAME
bp_genbank2gff.pl - Load a Bio::DB::GFF database from GENBANK files.
SYNOPSIS
% bp_genbank2gff.pl -d genbank -f localfile.gb
% bp_genbank2gff.pl -d genbank --accession AP003256
% bp_genbank2gff.pl --accession AP003256 --stdout
DESCRIPTION
This script loads a Bio::DB::GFF database with the features contained in a either a local genbank file or an accession that is fetched from
genbank. Various command-line options allow you to control which database to load and whether to allow an existing database to be
overwritten.
The database must already have been created and the current user must have appropriate INSERT and UPDATE privileges. The --create option
will initialize a new database with the appropriate schema, deleting any tables that were already there.
COMMAND-LINE OPTIONS
Command-line options can be abbreviated to single-letter options. e.g. -d instead of --database.
--create Force creation and initialization of database
--dsn <dsn> Data source (default dbi:mysql:test)
--user <user> Username for mysql authentication
--pass <password> Password for mysql authentication
--proxy <proxy> Proxy server to use for remote access
--stdout direct output to STDOUT
--adaptor <adaptor> adaptor to use (eg dbi::mysql, dbi::pg, dbi::oracle) --viral the genome you are loading is viral (changes tag
choices)
--source <source> source field for features ['genbank']
EITHER --file Arguments that follow are Genbank/EMBL file names
OR --gb_folder What follows is a folder full of gb files to process OR --accession Arguments that follow are genbank accession numbers
(not gi!)
OR --acc_file Accession numbers (not gi!) in a file (one per line, no punc.)
OR --acc_pipe Accession numbers (not gi!) from a STDIN pipe (one
per line)
SEE ALSO
Bio::DB::GFF, bulk_load_gff.pl, load_gff.pl
AUTHOR
Scott Cain, cain@cshl.org
Copyright (c) 2003 Cold Spring Harbor Laboratory
This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself. See DISCLAIMER.txt for
disclaimers of warranty.
perl v5.14.2 2012-03-02 BP_GENBANK2GFF(1p)