Hello,
I'm using CentOS 4.5 with MySQL 4.1.20. I've got 2G RAM on the system,
and am running an x86_64 kernel (2.6.9-55.0.9.EL). When I try to use
mysqldump, MySQL crashes (then restarts). Here is the output from
mysqldump, and what happens in /var/log/mysql.log.
From mysqldump:
Chris [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, June 04, 2004 8:39 PM
Subject: Re: Backing Up a Database
On Fri, 4 Jun 2004 18:16 , Lou Olsten [EMAIL PROTECTED] sent:
For the time I've been testing, I've used the procedures outlined in the
help to take my backups, which entails
For the time I've been testing, I've used the procedures outlined in the help to take
my backups, which entails doing a FLUSH TABLES WITH READ LOCK in my MySQL monitor,
then going to a shell prompt and executing the mysqldump utility, then issuing the
UNLOCK TABLES from my MySQL monitor.
Now
On Fri, 4 Jun 2004 18:16 , Lou Olsten [EMAIL PROTECTED] sent:
For the time I've been testing, I've used the procedures outlined in the help to take
my backups, which entails doing a FLUSH TABLES WITH
READ LOCK in my MySQL monitor, then going to a shell prompt and executing the
mysqldump
-Original Message-
From: Neil Tompkins [mailto:[EMAIL PROTECTED]]
Can anyone recommend a software app. I could buy to be able
to dump data and
table structures to a text file. Ideally as mentioned before
I need to run
this on a hourly basis.
Backing up the entire database
and
table structures to a text file. Ideally as mentioned before I need to run
this on a hourly basis.
Rgds,
Neil
From: Gerald R. Jensen [EMAIL PROTECTED]
Reply-To: Gerald R. Jensen [EMAIL PROTECTED]
To: Neil Tompkins [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Re: backing up mySQL database
. I'm not being at all facetious when I say that;
most people back up their data once a night or even once a week.
To what do you plan to write your backups? Tape? Another directory on
the same server? Your home hard drive over the 'net? Backing up your
database ten to twenty times per day
Hello,
I'm looking to either development a software application that will allow me
to automatically at scheduled intervals backup my mySQL databases. I would
like to save the table structures and data. I;ve used mySQL Front that
allows you to backup these, but I need it to be automated e.g
, November 30, 2002 10:33 AM
Subject: backing up mySQL database ?
Hello,
I'm looking to either development a software application that will allow
me
to automatically at scheduled intervals backup my mySQL databases. I
would
like to save the table structures and data. I;ve used mySQL Front
]
Sent: Saturday, November 30, 2002 9:33 AM
Subject: backing up mySQL database ?
Hello,
I'm looking to either development a software application that will allow me
to automatically at scheduled intervals backup my mySQL databases. I would
like to save the table structures and data. I;ve used
PROTECTED], [EMAIL PROTECTED]
Subject: Re: backing up mySQL database ?
Date: Sat, 30 Nov 2002 10:23:22 -0600
You don't have to develop or buy anything. You can use mysqldump in
conjunction with a shell script to do what you want, and automate it with
either the Windows Scheduler (on Win32
:
# Make backups of databases at 4am daily
0 4 * * * /usr/local/bin/mydbbak.sh
- Original Message -
From: Neil Tompkins [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Saturday, November 30, 2002 12:11 PM
Subject: Re: backing up mySQL database ?
I rent my mySQL database from
by hand from
the commandline.
Felix
-Ursprüngliche Nachricht-
Von: Alexander Shaw [mailto:[EMAIL PROTECTED]]
Gesendet: Mittwoch, 20. Februar 2002 01:15
An: MySQL List; Felix Richter
Betreff: RE: **Backing Up A Database**
Hi Felix (or anyone),
I'm giving this a go but as a Linux newbie
they are working correctly?
Alex
-Original Message-
From: Felix Richter [mailto:[EMAIL PROTECTED]]
Sent: 18 February 2002 15:26
To: David yahoo; mySQL List
Subject: Re: **Backing Up A Database**
- create a file in /etc/logrotate.d, filename does not matter, take
this as a template, fill
Hi.
What is the easiest way to backup a mySQL v3 database?
Can it be backed up online or do I have to disable it, copy the files and
then enable it again.
Cheers.
Kev.
This e-mail has been scanned for all viruses by Star
Please see
http://www.mysql.com/doc/B/a/Backup.html
I personally issue mysqldumps via cron and maintain the files using logrotate
(Redhat Linux), which automatically zips and rotates them.
-
Before posting, please check:
Kevin,
Monday, February 18, 2002, 3:15:26 PM, you wrote:
KG Hi.
KG What is the easiest way to backup a mySQL v3 database?
KG Can it be backed up online or do I have to disable it, copy the files and
KG then enable it again.
Don't forget to read the manual:
How did u do exactly ?
It's not documented.
Does it take a long.
Do u have to flush and lock tables before, that can be critical for 24/24
server.
what conf for logrotate ?
a+.
I personally issue mysqldumps via cron and maintain the files using
logrotate (Redhat Linux), which automatically
- create a file in /etc/logrotate.d, filename does not matter, take this as a
template, fill in connection parameters in mysqldump call ():
/home/backup/sqlback/mybackup.sql {
daily
nomissingok
nocreate
compress
rotate 14
errors [EMAIL PROTECTED]
prerotate
19 matches
Mail list logo