Problems backing up 4.1.20 database
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: --- [symbiot (06:35:45) ~]# mysqldump -u root -p UniversalTimeline Enter password: -- MySQL dump 10.9 -- -- Host: localhostDatabase: UniversalTimeline -- -- -- Server version 4.1.20 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; mysqldump: Got error: 2013: Lost connection to MySQL server during query when using LOCK TABLES From /var/log/mysql.log: mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=8388600 read_buffer_size=131072 max_used_connections=1 max_connections=100 threads_connected=1 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 225791 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Number of processes running now: 0 071113 06:36:06 mysqld restarted 071113 6:36:07 InnoDB: Started; log sequence number 0 43644 /usr/libexec/mysqld: ready for connections. Version: '4.1.20' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution Any hints as to what's going on here? I don't remember having this problem with MySQL 3.x (but that was many moons ago). Cheers, Arpotu. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Backing Up a Database
Thanks, but I have innodb tables as well. I don't see any caveats in the docs for mysqldump, so I'm *assuming* it'll work correctly, but I'd like to hear from someone who is counting on it in a production environment, just to be sure. Thanks, Lou - Original Message - From: McKeever 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 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 I'm trying to schedule all this and I have a question about using just mysqldump. If I use the --lock-tables parm, am I getting the same functionality? The reason I'm concerned is because the help says: The FLUSH TABLES statement is needed to ensure that the all active index pages are written to disk before you start the backup. I cant answer your question directly, but I suggest looking at mysqlhotcopy Can I make sure that happens without moving back and forth between the MySQL monitor and the mysqldump utility? Thanks, Lou --- Chris McKeever If you want to reply directly to me, please use cgmckeever--at--prupref---dot---com A href=http://www.prupref.com;www.prupref.com/A Prudential Preferred Properties A href=http://www.prupref.com;Chicago and Illinois NorthShore Real Estate Experts/A Prudential Preferred Properties www.prupref.com Success Driven By Results Results Driven By Commitment Commitment Driven By Integrity We Are Prudential Preferred Properties -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Backing Up a Database
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 I'm trying to schedule all this and I have a question about using just mysqldump. If I use the --lock-tables parm, am I getting the same functionality? The reason I'm concerned is because the help says: The FLUSH TABLES statement is needed to ensure that the all active index pages are written to disk before you start the backup. Can I make sure that happens without moving back and forth between the MySQL monitor and the mysqldump utility? Thanks, Lou
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 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 I'm trying to schedule all this and I have a question about using just mysqldump. If I use the --lock-tables parm, am I getting the same functionality? The reason I'm concerned is because the help says: The FLUSH TABLES statement is needed to ensure that the all active index pages are written to disk before you start the backup. I cant answer your question directly, but I suggest looking at mysqlhotcopy Can I make sure that happens without moving back and forth between the MySQL monitor and the mysqldump utility? Thanks, Lou --- Chris McKeever If you want to reply directly to me, please use cgmckeever--at--prupref---dot---com A href=http://www.prupref.com;www.prupref.com/A Prudential Preferred Properties A href=http://www.prupref.com;Chicago and Illinois NorthShore Real Estate Experts/A Prudential Preferred Properties www.prupref.com Success Driven By Results Results Driven By Commitment Commitment Driven By Integrity We Are Prudential Preferred Properties -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: backing up mySQL database ?
-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 on an hourly basis could be time- and processor-intensive, if the database gets large. I'd recommend backing up the full database at longer intervals (say, nightly) with mysqldump and then using the update log to fill in any gaps. If getting the backups onto a different machine is important you can always just copy the log. A backup plus all the update log entries since the backup was taken is sufficient to recover the database. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: backing up mySQL database ?
Hi Thanks for that information. But I think I want to purchase a software application, due to my lack of knowledge for mySQL. In addition to this, my ISP doesn't allow that much control over the operating system. 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. 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 ? Date: Sat, 30 Nov 2002 14:17:52 -0600 OK ... but you newed to work this out with you ISP. Create a shell script, and place it in the server's path: # #!/bin/sh # Create /dbbakup directory # $1 = Unix/MySQL Username # $2 = Unix/MySQL Password if [ ! -e /dbbakup ] then mkdir /dbbakup chmod 777 /dbbakup -R fi # The following is a single line: mysqldump -u$1 -p$2 -c --add-drop-table --add-locks --flush-logs --databases databasename/dbbakup/databasename.sql # Add the following to your crontab: # 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 my ISP would this be a problem ? Maybe you provide me with a simple example ? Since I'm very new to mySQL and have no knowledge of unix. Thanks 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 ? 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) or a cronjob (Linux, *nix). - Original Message - From: Neil Tompkins [EMAIL PROTECTED] To: [EMAIL PROTECTED] 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 mySQL Front that allows you to backup these, but I need it to be automated e.g every 2 hours... Can someone point me in the right direction. I will look to develop the software is Delphi 6 or C++ Builder 5. The other option I have is to purchase some software that will allow me to do this. Any suggestions or recommendations ? Thanks for any help and advice. Neil _ The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. http://join.msn.com/?page=features/virus - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: backing up mySQL database ?
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Neil, et al -- ...and then Neil Tompkins said... % % Hi Hi! % % Thanks for that information. But I think I want to purchase a software % application, due to my lack of knowledge for mySQL. In addition to this, % my ISP doesn't allow that much control over the operating system. Sure, I can recommend some. It's called, um, David's Fabulous Backup Software, and for the monthly license fee of, uh, let's say $1000 you get a custom installation and configuration. It's very closely modeled after mysqldump and uses only open-source software (primarily mysqldump). OK, all kidding aside, that's what mysqldump is for and it does its job well. I'm no mysql greybeard but other than a system backup tool (Veritas NetBackup, Legato Networker, tar, BRU, whatever) I don't know of anything that fits your bill (does not involve mysql as I understand it). % % 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. You must be doing something very important to have to back up your data multiple times per day. 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 will chew up a lot of space even if the instance is small, and if it's not separate from your server then you've gained nothing if the disk head crashes (same disk) or the server gets hacked or goes wacko (different disk or RAID or whatnot) or the place burns down. You say your ISP doesn't allow that much control over the operating system. Do they not offer backups as part of your package, or as a part that you could buy? I don't know what you're doing or where you're hosting or how much data is involved, but if you really have something important enough that you have to back it up hourly then I would 1) look into other ISPs/ASPs and 2) check out having one or more slave servers, which can replicate the data in real time and then go offline to allow backups. Oh, yeah; let me know which tape company you'll use so that I can buy some stock! Usually I'd recommend myself to someone who needs individual services such as the ability to back up his database, but I won't touch this one; anything that really needs to be backed up that frequently needs serious, industrial-strength work. I can design and implement it, though, at my usual consulting rates; you might want to sit down with me (or anyone else, but *someone*) and see what you really need and what it's going to cost you. % % Rgds, % Neil HTH HAND mysql query, :-D - -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health http://www.justpickone.org/davidtg/Shpx gur Pbzzhavpngvbaf Qrprapl Npg! -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (FreeBSD) iD8DBQE96pOCGb7uCXufRwARAhQtAKDkE9P8ZNUV1E6aISM/X2f7274J0ACgonbn H+Ws5zJmRHs1h0TKjd4vyPo= =Kixn -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 that allows you to backup these, but I need it to be automated e.g every 2 hours... Can someone point me in the right direction. I will look to develop the software is Delphi 6 or C++ Builder 5. The other option I have is to purchase some software that will allow me to do this. Any suggestions or recommendations ? Thanks for any help and advice. Neil _ The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: backing up mySQL database ?
I might be totally off track here, but a simple shell script works fine for me. /bin/sh, tar, and cron are a powerful team. --Joe -- Joe Stump Affordable Computers, Inc. 800-864-2345 x113 - Original Message - From: Neil Tompkins [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, 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 that allows you to backup these, but I need it to be automated e.g every 2 hours... Can someone point me in the right direction. I will look to develop the software is Delphi 6 or C++ Builder 5. The other option I have is to purchase some software that will allow me to do this. Any suggestions or recommendations ? Thanks for any help and advice. Neil _ The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: backing up mySQL database ?
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) or a cronjob (Linux, *nix). - Original Message - From: Neil Tompkins [EMAIL PROTECTED] To: [EMAIL PROTECTED] 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 mySQL Front that allows you to backup these, but I need it to be automated e.g every 2 hours... Can someone point me in the right direction. I will look to develop the software is Delphi 6 or C++ Builder 5. The other option I have is to purchase some software that will allow me to do this. Any suggestions or recommendations ? Thanks for any help and advice. Neil _ The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: backing up mySQL database ?
I rent my mySQL database from my ISP would this be a problem ? Maybe you provide me with a simple example ? Since I'm very new to mySQL and have no knowledge of unix. Thanks 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 ? 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) or a cronjob (Linux, *nix). - Original Message - From: Neil Tompkins [EMAIL PROTECTED] To: [EMAIL PROTECTED] 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 mySQL Front that allows you to backup these, but I need it to be automated e.g every 2 hours... Can someone point me in the right direction. I will look to develop the software is Delphi 6 or C++ Builder 5. The other option I have is to purchase some software that will allow me to do this. Any suggestions or recommendations ? Thanks for any help and advice. Neil _ The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: backing up mySQL database ?
OK ... but you newed to work this out with you ISP. Create a shell script, and place it in the server's path: # #!/bin/sh # Create /dbbakup directory # $1 = Unix/MySQL Username # $2 = Unix/MySQL Password if [ ! -e /dbbakup ] then mkdir /dbbakup chmod 777 /dbbakup -R fi # The following is a single line: mysqldump -u$1 -p$2 -c --add-drop-table --add-locks --flush-logs --databases databasename/dbbakup/databasename.sql # Add the following to your crontab: # 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 my ISP would this be a problem ? Maybe you provide me with a simple example ? Since I'm very new to mySQL and have no knowledge of unix. Thanks 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 ? 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) or a cronjob (Linux, *nix). - Original Message - From: Neil Tompkins [EMAIL PROTECTED] To: [EMAIL PROTECTED] 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 mySQL Front that allows you to backup these, but I need it to be automated e.g every 2 hours... Can someone point me in the right direction. I will look to develop the software is Delphi 6 or C++ Builder 5. The other option I have is to purchase some software that will allow me to do this. Any suggestions or recommendations ? Thanks for any help and advice. Neil _ The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: **Backing Up A Database**
You may simply copy or move logrotate from /etc/cron.daily in /etc/cron.hourly. Logrotate will then be executed hourly, have a look into /etc/logrotate.conf, /etc/logrotate.d and determine which files are due to be rotated. But as you cannot set other delays but daily,weekly,monthly (see man logrotate), I suggest some tricking: add size 10k in the /etc/logrotate.d/-file you created, so that logrotate will find it due every day or when its size grew bigger than 10k (i.e. very soon, more often than daily...). For testing purposes, you may also just call /etc/cron.daily/logrotate 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 running Red hat 7.2 I have a question to ask Do I need to alter anything in Cron for it to run the logrotate script? What would I need to put into the hourly cron folder to make things happen more often to check they are working correctly? Alex - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: **Backing Up A Database**
Hi Felix (or anyone),
I'm giving this a go but as a Linux newbie running Red hat 7.2 I have a
question to ask
Do I need to alter anything in Cron for it to run the logrotate script?
What would I need to put into the hourly cron folder to make things happen
more often to check 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 in connection parameters in mysqldump call
():
/home/backup/sqlback/mybackup.sql {
daily
nomissingok
nocreate
compress
rotate 14
errors [EMAIL PROTECTED]
prerotate
mysqldump --opt --full
/home/backup/sqlback/mybackup.sql
endscript
}
- check syntax and options of this file: man logrotate
- you're set: cron will call logrotate each night. logrotate
processes each file in the dir, executes the prerotate script and
then compresses the logfile (i.e. SQL-Dump), renames older ones
and keeps at max 14 of them (rotate 14). nomissingok will let
you know if the mysqldump failed
Felix
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.324 / Virus Database: 181 - Release Date: 14/02/2002
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.324 / Virus Database: 181 - Release Date: 14/02/2002
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
**Backing Up A Database**
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 Internet. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: **Backing Up A Database**
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: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
**Backing Up A Database**
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: http://www.mysql.com/doc/B/a/Backup.html KG Cheers. KG Kev. -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: **Backing Up A Database**
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 zips and rotates them. _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: **Backing Up A Database**
- 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
mysqldump --opt --full /home/backup/sqlback/mybackup.sql
endscript
}
- check syntax and options of this file: man logrotate
- you're set: cron will call logrotate each night. logrotate processes each file in
the dir, executes the prerotate script and then compresses the logfile (i.e.
SQL-Dump), renames older ones and keeps at max 14 of them (rotate 14). nomissingok
will let you know if the mysqldump failed
Felix
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
