At 19:47 -0230 9/28/04, Neil Zanella wrote:
Hello,
I need to backup a mysql database in such a way that the output is
simply a bunch of insert statements. I do not want the database
schema as output as well: just the insert statements. This is
because I already have a script with CREATE statements
Hello,
I need to backup a mysql database in such a way that the output is
simply a bunch of insert statements. I do not want the database
schema as output as well: just the insert statements. This is
because I already have a script with CREATE statements and
would like to rebuild the database fro
take a snapshot in MySQL and use this to back up
data?
Simon
-Original Message-
From: Paco Martinez [mailto:[EMAIL PROTECTED]
Sent: 18 November 2003 10:00
To: Christensen, Dave; 'Richard Reina'; [EMAIL PROTECTED]
Subject: Re: Backup question.
Is there any problem executing "rs
Message -
> From: "Christensen, Dave" <[EMAIL PROTECTED]>
> To: "'Richard Reina'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Wednesday, November 12, 2003 10:20 PM
> Subject: RE: Backup question.
>
> > Yes, you can do
Paco Martinez [mailto:[EMAIL PROTECTED]
> Sent: 18 November 2003 10:00
> To: Christensen, Dave; 'Richard Reina'; [EMAIL PROTECTED]
> Subject: Re: Backup question.
>
>
> Is there any problem executing "rsync /var/lib/mysql/data/" from one host
> to another host and
Just me has access to that machine...
And there's no LVM.
- Original Message -
From: "Simon Green" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, November 18, 2003 11:12 AM
Subject: RE: Backup question.
> Has any one use LVM to take a sna
Has any one use LVM to take a snapshot in MySQL and use this to back up
data?
Simon
-Original Message-
From: Paco Martinez [mailto:[EMAIL PROTECTED]
Sent: 18 November 2003 10:00
To: Christensen, Dave; 'Richard Reina'; [EMAIL PROTECTED]
Subject: Re: Backup question.
Is there a
, Dave" <[EMAIL PROTECTED]>
To: "'Richard Reina'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, November 12, 2003 10:20 PM
Subject: RE: Backup question.
> Yes, you can do it like this:
>
>
> Prompt> mysqldump --add-drop-table -
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Richard --
...and then Richard Reina said...
%
% I would like to backup databases from a linux MySQL server to another
% linux machine on the same private network but I don' see in the docs how
% I can do this with mysqlhotcopy or mysqldump. Is th
n.
Dave
-Original Message-
From: Richard Reina [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 12, 2003 3:54 PM
To: [EMAIL PROTECTED]
Subject: Backup question.
I would like to backup databases from a linux MySQL server to another
linux machine on the same private network but I don
mysqldump -uname -ppassword -BDatabase | mysql -uname -ppasswrod -Ddatabase
-hremotehost
-Original Message-
From: Richard Reina [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 12, 2003 3:54 PM
To: [EMAIL PROTECTED]
Subject: Backup question.
I would like to backup databases from a
I would like to backup databases from a linux MySQL server to another
linux machine on the same private network but I don' see in the docs how
I can do this with mysqlhotcopy or mysqldump. Is there any way to do
this besides using ftp.
Any help would be appreicated.
Richard
--
MySQL General
viewer/Editor
[EMAIL PROTECTED]
http://www.GodsOfMusic.com
-Original Message-
From: KH Chiu [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 17, 2003 9:19 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Database Backup Question
Sorry I am in a bit hurry and just post some hints on
Sorry I am in a bit hurry and just post some hints on your question. It is
more than one way to do your job. One of the trival way is to use php
function 'exec'. This function can execute shell programs. It means that you
can execute mysqldump etc. and create dump file.
>From my experience, you
This is actually more a PHP question but since it refers to a MySQL
database I thought I would ask here.
I may not be looking in the right places but, I can't seem to find a way
to do a database backup through PHP (other than BACKUP TABLE, which I
don't want to use if possible)
What I mean is thi
Richard --
You could do both, I would be a lot quicker to import data than restore
from tape. Say do an incremental dump back to your last level 0. Which
would be helpfull to developers as well as youself. You could also use
a seperate partition for the data directory and back that up.
The subj
I am running mysql on a linux box RH 6.2. I backup all the filesytems
with:
/sbin/dump 0ubf 800 /dev/npt0
to a COLORADO 8gig. travan tape drive. Is this sort of backup regimen a
good one -- compatible with MySQL -- or should I instead be backing up
with FLUSH and (or) mysqldump?
Any h
Young
QML Pathology
Database Administrator
> -Original Message-
> From: Kraa de Simon [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, September 10, 2001 5:47 PM
> To: '[EMAIL PROTECTED]'
> Subject: Backup question
>
> Hi,
>
> I'm running MySQL on a N
Hi,
I'm running MySQL on a NT box and do a nightly backup of the complete file
system to tape.
I know I should use mysqldump and probably stop MySQL but will a file system
copy do as well? The system is inactive at the time.
Met vriendelijke groet / With kind regards,
ICL Nederland B.V.
I'm trying to write a cron job to back up my databases. The manual says:
> Do a full backup of your databases:
>
> shell> mysqldump --tab=/path/to/some/dir --opt --full
>
> You can also simply copy all table files (`*.frm', `*.MYD' and`*.MYI'
> files), as long as the server isn't updating anythin
Look in the MySQL manual for mysqldump
you should find the correct syntax
On Mon, 15 Jan 2001, sanaa wrote:
> hi
> I want to know how to backup and restore databases in mysql.
>
>
> thanks for help
>
> -
> Before posting, pl
hi
i have a problem and i hope somebody can help me.
I use mysql-2.23.25 ( for windows).
I have my database in (c:) and i want to backup it in (d:) .
thanks and regards
-
Before posting, please check:
http://www.mysql.com/
hi
I want to know how to backup and restore databases in mysql.
thanks for help
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To requ
23 matches
Mail list logo