backup: mysqldump or mysqlhotcopy ?

don't like to adapt my script regulary. Which tool do you recommend ? mysqldump or mysqlhotcopy ? Can i backup all databases with mysqlhotcopy using mysqlhotcopy --regexp=[a-zA-Z0-9]\+ ? Can i restore from this backup only some databases just copying the saved directories of the backuped

does mysqlhotcopy affect the key buffer?

i run mysqlhotcopy on each database once every three hours. i happened to be running my cache warmer this afternoon, which logs timing for a bunch of standard randomized queries, that when the backup script ran, the query times increased by a factor of about 20 from a nice quick pace back down

mysqlhotcopy

I am trying to use mysqlhotcopy on 2 different machines and I am having trouble on both of them. On the first machine, which is a Sun Solaris running mysql 4.0.15a, when I give the mysqlhotcopy command, I get the following error: DBD::mysql::db do failed: File './zemed/form_342.MYD' not found

mysqlhotcopy errors osx

The first time I tried to run the mysqlhotcopy script, I got an error that indicated that Perl couldn't find the DBI module. So, I found a site (http://www.quicomm.com/apm_dbddbi.htm) that stepped me through making and installing MySQL DBD and the DBI modules(? don't know if I'm using

Re: mysqlhotcopy errors osx

that mysqlhotcopy is built to use. Mike James Tu wrote: The first time I tried to run the mysqlhotcopy script, I got an error that indicated that Perl couldn't find the DBI module. So, I found a site (http://www.quicomm.com/apm_dbddbi.htm) that stepped me through making and installing MySQL DBD

Re: MySQLHotCopy

Jesse wrote: I read in the manual that MySQLHotCopy would be better than MySQLDump for backing up MyISAM tables. However, I cannot find a .exe in the bin directory by that name. I found a script by that name in a 4.1 installation that I have, but I don't think it's the latest version

Re: MySQLHotCopy

Sorry pal: It runs on Unix and NetWare. What version are you using? I assume Windows at least ( if still looking for an .exe :-) ) Then please read this: http://dev.mysql.com/doc/refman/5.0/en/mysqlhotcopy.html 8.13. mysqlhotcopy — A Database Backup Program Aaah. I missed that. Shows how

MySQLHotCopy

I read in the manual that MySQLHotCopy would be better than MySQLDump for backing up MyISAM tables. However, I cannot find a .exe in the bin directory by that name. I found a script by that name in a 4.1 installation that I have, but I don't think it's the latest version. Is this a script

Mysqlhotcopy and replication

I've got a replication slave db (all MyISAM tables) that I currently back up every night by stopping MySQL, tarballing the table files, then starting MySQL up again. I'd like to use Mysqlhotcopy to do this so that the db can stay up for reads while the backup is being done. Here's my question

Re: Mysqlhotcopy and replication

tables) that I currently back up every night by stopping MySQL, tarballing the table files, then starting MySQL up again. I'd like to use Mysqlhotcopy to do this so that the db can stay up for reads while the backup is being done. Here's my question. While the tables are flushed with read lock, what

RE: Mysqlhotcopy and replication

Excellent Dan! Thanks! -Original Message- From: Dan Buettner [mailto:[EMAIL PROTECTED] Sent: Thu 6/29/2006 4:35 PM To: Jeff Cc: mysql@lists.mysql.com Subject: Re: Mysqlhotcopy and replication Jeff

RE: Mysqlhotcopy / Perl / DBD::mysql on RHEL 4 x86_64

Solved -- After upgrading to 5.0.22, DBD::mysql builds without any problems. -Original Message- From: Tim Lucia [mailto:[EMAIL PROTECTED] Sent: Monday, June 19, 2006 4:17 PM To: mysql@lists.mysql.com Subject: Mysqlhotcopy / Perl / DBD::mysql on RHEL 4 x86_64 I'm running on a Xeon 3.8

Mysqlhotcopy / Perl / DBD::mysql on RHEL 4 x86_64

I'm running on a Xeon 3.8 under RHEL V.4. I wanted to try out mysqlhotcopy, but it says I need DBD::mysql. Cpan gets it for me, but make DBD::mysql dies with the below error. I am using 5.0.18 standard (MySQL-server-standard-5.0.18-0.rhel4). Attempting to install perl-dbd-mysql off the RPMS

Re: mysqlhotcopy regexp

Thanks, but this not work to (output with --debug) $VAR1 = []; No tables to hot-copy at /usr/local/bin/mysqlhotcopy line 390. /usr/local/bin/mysqlhotcopy Ver 1.22 mysql-4.1.16 perl, v5.8.5 built for i586-linux-thread-multi Linux camel 2.6.8-24.16-default You should just be doing mysqlhotcopy

mysqlhotcopy regexp

Hi, how to write pattern for backup all datases except one? I try this, but not work as expecting. mysqlhotcopy ...connect-options... --regexp /~^db_name$/./.*/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Re: mysqlhotcopy regexp

You should just be doing mysqlhotcopy ...connect-options... --regexp /~^db_name$/ or mysqlhotcopy ...connect-options... --regexp /~^db_name$/ /path/to/new/dir On 5/25/06, MF [EMAIL PROTECTED] wrote: Hi, how to write pattern for backup all datases except one? I try this, but not work

Re: mysqlhotcopy

Good stuff Peter, can you tell us your solution so folks can benefit from your efforts? (I expect the regex has to be POSIX style such as: mydb./'~(expirations|rtt)'/ right?) Imran Chaudhry -- http://www.ImranChaudhry.info MySQL Database Management Design Services -- MySQL General Mailing

Re: mysqlhotcopy

Hi, this is the solution I use: /usr/local/bin/mysqlhotcopy -p mypass --allowold 'mydb./~(expirations|rtt)$/' /var/backups/mysqlbackup/$1 I guess this one is also possible: /usr/local/bin/mysqlhotcopy -p mypass --allowold 'mydb./~^(expirations|rtt)$/' /var/backups/mysqlbackup/$1 Kind

mysqlhotcopy

Hello, I read the manual(http://dev.mysql.com/doc/refman/5.0/en/mysqlhotcopy.html) and especially: Back up tables in the given database that match a regular expression: shell mysqlhotcopy db_name./regex/ The regular expression for the table name can be negated by prefixing it with a tilde

Re: mysqlhotcopy

solved :) Thanks :-) Peter wrote: Hello, I read the manual(http://dev.mysql.com/doc/refman/5.0/en/mysqlhotcopy.html) and especially: Back up tables in the given database that match a regular expression: shell mysqlhotcopy db_name./regex/ The regular expression for the table name can

Re: MySQLHotCopy Error

Stephen P. Fracek, Jr. wrote: We're having a problem with MySQLHotCopy. It has worked flawlessly in the past but now we're getting an error message similar to this: Dumping database... DBD::mysql::db do failed: Can't find file: './file.frm' (errno: 24) at /usr/local/mysql/bin

MySQLHotCopy Error

We're having a problem with MySQLHotCopy. It has worked flawlessly in the past but now we're getting an error message similar to this: Dumping database... DBD::mysql::db do failed: Can't find file: './file.frm' (errno: 24) at /usr/local/mysql/bin/mysqlhotcopy line 468. Deleting

Re: Mysqlhotcopy.

Hello. See: http://dev.mysql.com/doc/mysql/en/problems-with-character-sets.html Miguel Burgos O. wrote: I install the last version of mysql and got this $mysqlhotcopy test File '/usr/share/mysql/charsets/?.conf' not found (Errcode: 2) What happened ? Best regards

Mysqlhotcopy.

I install the last version of mysql and got this $mysqlhotcopy test File '/usr/share/mysql/charsets/?.conf' not found (Errcode: 2) What happened ? Best regards, Miguel --- E-mail: [EMAIL PROTECTED] . ADVERTENCIA: La informacion contenida en

mysqlhotcopy

Hello, Anyone here run mysqlhotcopy? I've read the docs on it but they are basicly just a howto and don't go too in depth. I've got a DB that is the back end to a 24/7 application. I ususally do backups from a replicated db by shutting down the Replicated DB then doing a tar are all the db

Re: mysqlhotcopy

I run 24/7 applications also. Use mysqlhotcopy to do exactly what you're doing by hand now. Run mysqlhotcopy on a slave server. It does exactly what you think. Lock and flush the tables, tarball them, and unlock them. No shutdown required. - Original Message - From: Jeff McKeon

RE: mysqlhotcopy

Am I right in assuming that while mysqlhotcopy is running, nobody else can write to or update the DB? Jeff -Original Message- From: Jeremiah Gowdy [mailto:[EMAIL PROTECTED] Sent: Friday, June 03, 2005 2:24 PM To: Jeff McKeon; mysql@lists.mysql.com Subject: Re: mysqlhotcopy I

Re: mysqlhotcopy

Yep. - Original Message - From: Jeff McKeon [EMAIL PROTECTED] To: Jeremiah Gowdy [EMAIL PROTECTED]; mysql@lists.mysql.com Sent: Friday, June 03, 2005 12:11 PM Subject: RE: mysqlhotcopy Am I right in assuming that while mysqlhotcopy is running, nobody else can write to or update

Re: mysqlhotcopy

Jeff McKeon wrote: Am I right in assuming that while mysqlhotcopy is running, nobody else can write to or update the DB? Yes. That's why it's better to run it on a slave. -- Keith Ivey [EMAIL PROTECTED] Smokefree DC http://www.smokefreedc.org Washington, DC -- MySQL General Mailing List

Re: Problem with mysqlhotcopy

Hello. e:\mysql\scripts\mysqlhotcopy.pl -u root -p password db_name /backup_test I think, the problem is in the missing period in /backup_test, it should be ./backup_test. But generally Windows isn't listed in operating systems list on which mysqlhotcopy works. Maybe cygwin will help

Problem with mysqlhotcopy

I am running MySQL and Perl on Windows 2003. I am trying to use the mysqlhotocpy script for backup. Mysqlhotcopy will execute but returns an error. Command: e:\mysql\scripts\mysqlhotcopy.pl -u root -p password db_name /backup_test Error: The system cannot find the path specified. Executing

Mysqlhotcopy on Windows

Is it possible to use mysqlhotcopy on Windows 2000 Server? If so, how? - Kirk Bowman Phone: 972-390-8600 MightyData, LLC http://www.mightydata.com

mysqlhotcopy in replication setup run from slave

So, ran into a problem with using mysqlhotcopy to build a backup capable of starting a new replicant. The current option (record_log_pos) attempts to get master info from show master status, regardless of whether running on master or slave. It also uses show slave status to see where

mysqlhotcopy

Hi, I'm trying to use mysqlhotcopy to make a backup of some mysql databases. But when i try to run mysqlhotcopy I'm getting this error, [EMAIL PROTECTED] Temp]# mysqlhotcopy -u root dbxpto /root/Temp DBD::mysql::db do failed: You have an error in your SQL syntax near '` READ, `dbxpto

problem restoring backup made from mysqlhotcopy

Hi, Using a sample database, I have tablea and tableb. I populate tablea with some records and I can see the tablea.MYD file size increase on the drive, while tableb.MYD remains at zero bytes. Then I make a backup: mysqlhotcopy -u username -p password sample ./backup Next I modify the database

Re: problem restoring backup made from mysqlhotcopy

see the tablea.MYD file size increase on the drive, while tableb.MYD remains at zero bytes. Then I make a backup: mysqlhotcopy -u username -p password sample ./backup Next I modify the database: I delete the records from tablea and insert records in tableb and observe tableb file size increase

Re: problem restoring backup made from mysqlhotcopy

a backup: mysqlhotcopy -u username -p password sample ./backup Next I modify the database: I delete the records from tablea and insert records in tableb and observe tableb file size increase on the drive, then I remove the sample directory inside /var/lib/mysql which contains the sample database

Re: problem restoring backup made from mysqlhotcopy

a backup: mysqlhotcopy -u username -p password sample ./backup Next I modify the database: I delete the records from tablea and insert records in tableb and observe tableb file size increase on the drive, then I remove the sample directory inside /var/lib/mysql which contains the sample

mysqlhotcopy -- max number of tables

The mysqlhotcopy perl script is failing fail when I try to back up a database containing more than about 600 tables. The script appears to be unable to lock that many tables before making the actual copy. Have others experienced this same problem? Is this a limitation of DBI, or of MySQL 3.23.58

RE: mysqlhotcopy -- max number of tables

Can you send the error message? It might be a timeout problem which is a mySQL configuration issue. (Look at wait_timeout in my.cnf) -Original Message- From: Andrew Loughe [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 31, 2004 10:30 AM To: [EMAIL PROTECTED] Subject: mysqlhotcopy

use mysqldump and mysqlhotcopy together?

Greetings, I've been looking at the backup/recover related discussions in the list archives for a while. Seems to me most people use either mysqldump or mysqlhotcopy. We don't have a good MySQL backup scheme in place yet. Now I have some questions based on my reading. How do I know how each

RE: use mysqldump and mysqlhotcopy together?

Hi, I'm a relative newbie at MySQL (Oracle DBA implementing MySQL in a production environment). There does seem to be a lack of 'Best Practice' documentation for MySQL in a production environment. I opted for using both mysqldump and mysqlhotcopy. Disk is cheap and everything is automated so

Re: use mysqldump and mysqlhotcopy together?

Bing Du wrote: Greetings, I've been looking at the backup/recover related discussions in the list archives for a while. Seems to me most people use either mysqldump or mysqlhotcopy. We don't have a good MySQL backup scheme in place yet. Now I have some questions based on my reading. We use

mysqlhotcopy as a replication scheme

-- this is easy, uses less bandwidth, is easy to control via cron and fits well into the rest of our infrastructure. Then I found mysqlhotcopy. Neato! I've tested, and this seems to work: 1) use mysqlhotcopy to copy the table on the replication master 2) gzip the table/index/data files and ship

MySQLHotCopy - No tables to hot-copy HUH?!

I have a problem using mysqlhotcopy. Everything was fine until I recently moved to a different server. Old one was running mysql 4.0.15 on FreeBSD 4.8, new is mysql 4.0.16 on FreeBSD 4.9. The error returned is No tables to hot-copy at /usr/local/bin/mysqlhotcopy line 379. I ran w/ --debug

Lost Data with delayed insert / mysqlhotcopy

Description: mysqlhotcopy (but possible any other software) can cause delayed handlers to terminate with Delayed insert thread couldn't get requested lock for I havent worked out the exact conditions under wich mysqlhotcopy fails, but it seems that if mysqlhotcopy tries to get a lock

Re: Mysqlhotcopy and incorrect database name error - We must be dense

Gilmore, Jason [EMAIL PROTECTED] wrote: A mysqlhotcopy issue has stumped no less than three of us here today at work, ensuring that the solution is glaringly obvious. We're trying to use mysqlhotcopy to copy a few databases. We want to make a local copy, nothing exotic, just want to move

RE: Mysqlhotcopy and incorrect database name error - We must be dense

Your not using mysqlhotcopy correctly. /usr/bin/mysqlhotcopy db_name[./table_regex/] [new_db_name | directory] The problem is this mysqlhotcopy -u root --suffix=091703 staff /backups look at -u here is a format from inside mysqlhotcopy mysqlhotcopy --method='scp -Bq -i /usr/home/foo/.ssh

RE: Mysqlhotcopy and incorrect database name error - We must be dense

, Jason'; [EMAIL PROTECTED] --Subject: RE: Mysqlhotcopy and incorrect database name error - We must be --dense -- --Your not using mysqlhotcopy correctly. -- --/usr/bin/mysqlhotcopy db_name[./table_regex/] [new_db_name | directory] -- -- --The problem is this --mysqlhotcopy -u root --suffix=091703

Mysqlhotcopy and incorrect database name error - We must be dense

Hi there, A mysqlhotcopy issue has stumped no less than three of us here today at work, ensuring that the solution is glaringly obvious. We're trying to use mysqlhotcopy to copy a few databases. We want to make a local copy, nothing exotic, just want to move the database backups to the directory

mysqlhotcopy fails under linux RH9

Hello, I tried to use mysqlhotcopy which previously worked under RH8 but now fails under RH9. I have the following packages installed: perl-DBD-MySQL-2.1021-3 MySQL-devel-4.0.12-0 MySQL-server-4.0.12-0 MySQL-client-4.0.12-0 MySQL-shared-4.0.12-0 qt-MySQL-3.1.1-6 but get

mysqlhotcopy fails under linux RH9

Is mysqlhotcopy not available for 4.0.12? The error message I got asked for libmysqlclient.so.10 which seems to be a MySQL-client-3.23.xx feature. 4.0.12 appears not to support it (correct)? /usr/bin/msql2mysql /usr/bin/mysql /usr/bin/mysql_find_rows /usr/bin/mysql_waitpid /usr/bin

re: mysqlhotcopy

I'm running mySql 3.23 on OS X 10.2 and I've reached a bit of an impassse with mysqlhotcopy, after having to re=install dbd and dbi, I keep getting the error: DBD::mysql::db do failed: You have an error in your SQL syntax near '` READ, `trypanofan`.``construct`` READ, `trypanofan`.``dapi

Re: mysqlhotcopy problem

On Wed, 2003-07-30 at 17:40, Vladimir Shiray wrote: How can I make hotcopy of my database if it have many tables (more than 1000) ??? mysqlhotcopy failed when it try to lock all tables ... How many tables can I lock at one time ? Can I increase this limit ? Hi, You probably ran out

mysqlhotcopy problem

How can I make hotcopy of my database if it have many tables (more than 1000) ??? mysqlhotcopy failed when it try to lock all tables ... How many tables can I lock at one time ? Can I increase this limit ? Working system: RedHat 7.3 MySQL 3.23.56 (compiled manualy) Perl 5.6.1

mysqlhotcopy on innoDB

Does mysqlhotcopy work with innoDB? I only get it to work with MyISAM tables... For innoDB only the structure is saved but not the data Thanks for some answers, Moritz

Re: mysqlhotcopy on innoDB

Moritz Steiner [EMAIL PROTECTED] wrote: Does mysqlhotcopy work with innoDB? I only get it to work with MyISAM tables... For innoDB only the structure is saved but not the data mysqlhotcopy works only with ISAM/MyISAM tables. -- For technical support contracts, goto https://order.mysql.com

mysqlhotcopy / bin-log manipulation

I have a question regarding mysqlhotcopy's use. I'd like to use the --flushlog option in order to have a nice backup synchronized log for my replication slave in case of recover need (without stopping the master). But the lock used by mysqlhotcopy made me split the backups into something like

Re: mysqlhotcopy / bin-log manipulation

by mysqlhotcopy made me split the backups into something like: mysqlhotcopy db_name_1 db_name_2 mysqlhotcopy db_name_3 db_name_4 db_name 5 mysqlhotcopy db_name_6 (that way because the backup of db_name_1 and db_name_2 is fast and I don't want these table to be locked a long time (a few sec. max

mysqlhotcopy does not read configuration files.

Description: mysqlhotcopy does not read defaults from my.cnf and .my.cnf files. How-To-Repeat: Run mysqlhotcopy and observe it doesn't read client defaults. Fix: See below for patch, shown as a context diff Submitter-Id: submitter ID Originator:Larry Stone

Re: mysqlhotcopy generates a segmentation fault

On Wed, 2003-06-11 at 01:55, Danny Cron wrote: I have three boxes. Mysqlhotcopy works on box1, but it generates a segmentation fault on box2 and box3. I want it to work on all boxes. I am prepared to upgrade them all to the level of box3 (but mysqlhotcopy doesn't work

mysqlhotcopy generates a segmentation fault

I have three boxes. Mysqlhotcopy works on box1, but it generates a segmentation fault on box2 and box3. I want it to work on all boxes. I am prepared to upgrade them all to the level of box3 (but mysqlhotcopy doesn't work with that configuration). Does anyone know of a solution? Box 1: Debian

Question / suggestion re: mysqlhotcopy

Hi All, Apologies if this has been done to death previously, but would it be sensible to indicate in the MySQL documentation that the Perl mysqlhotcopy script only appears to work on the Linux platform? (Or, more accurately, doesn't work on the WinXP platform, I have no idea about other platforms

Re: Question / suggestion re: mysqlhotcopy

At 10:34 +1000 6/7/03, Murray Wells wrote: Hi All, Apologies if this has been done to death previously, but would it be sensible to indicate in the MySQL documentation that the Perl mysqlhotcopy script only appears to work on the Linux platform? (Or, more accurately, doesn't work on the WinXP

RE: Question / suggestion re: mysqlhotcopy

re: mysqlhotcopy At 10:34 +1000 6/7/03, Murray Wells wrote: Hi All, Apologies if this has been done to death previously, but would it be sensible to indicate in the MySQL documentation that the Perl mysqlhotcopy script only appears to work on the Linux platform? (Or, more accurately, doesn't

Mysqlhotcopy usage problem

Hello All, I am facing following error while I am trying to use mysqlhotcopy utility for hot backups. I am not sure that how can I check the perl correct installation. Please see below [EMAIL PROTECTED]:/usr/local/mysql/bin mysqlhotcopy --help Can't locate DBI.pm in @INC (@INC contains: /opt

Re: mysqlhotcopy usage

Nils Valentin [EMAIL PROTECTED] wrote: Does anybody know detailed how mysqlhotcopy works ? Does it put a lock on the table or only on a row in case of transaction safe tables ? It uses LOCK TABLES statement, so it locks the whole table. Does it work with any table type (Innodb,BDB, Merge

mysqlhotcopy script problem

Greetings: Attempting to run mysqlhotcopy on my RH 7.3 server/ MySQL 4.012 generates the following: install_driver(mysql) failed: Can't load '/usr/lib/perl5/site_perl/5.6.1/i386-linux/auto/DBD/mysql/mysql.so' for module DBD::mysql: libmysqlclient.so.10: cannot open shared object file

mysqlhotcopy usage

Hello mysql fans ;-), Does anybody know detailed how mysqlhotcopy works ? Does it put a lock on the table or only on a row in case of transaction safe tables ? Does it work with any table type (Innodb,BDB, Merge, MyISAM) ? Any comments much appreciated. --- To general list Moderator: Please

RE: Mysqlhotcopy and reuilding indexes

-Original Message- From: Harald Fuchs [mailto:[EMAIL PROTECTED]] Sent: 28. januar 2003 10:46 To: [EMAIL PROTECTED] Subject: Re: Mysqlhotcopy and reuilding indexes In article [EMAIL PROTECTED], Erlend Hopsø Strømsvik [EMAIL PROTECTED] writes: Hi Sorry if I'm just being

Problem with mysqlhotcopy version 1.17 when using --record_log_pos

Description: With mysqlhotcopy version 1.15 (from MySQL-3.23.49-1) I used to do like this: mysqlhotcopy --user=root --password=foo -q --allowold --record_log_pos backup.log_pos db1 db2 backup $TMPDIR After upgrading to MySQL-3.23.55-1 and thus mysqlhotcopy

Mysqlhotcopy and reuilding indexes

Hi Sorry if I'm just being feeble minded here but I can't get this to work. First I take a copy of my database using: mysqlhotcopy --allowold --noindices db_name /path/path using the '--noindices' since it says --noindices Don't include full index files in copy to make the backup smaller

mysqldump or mysqlhotcopy?

Greetings, I would like to set up cron jobs on my servers to make backups of my databases: 1. The reference manual recommends mysqlhotcopy over mysqldump. Any opinions? 2. What format does mysqlhotcopy save in? sql files? csv? 3. Anyone else doing this with cron? I'd like to see

mysqlhotcopy should suggest ~/.my.cnf instead of --password

Description: The mysqlhotcopy manpage suggests giving the password via the command line option '--password'. This is higly insecure as every system user is able to read it. How-To-Repeat: RTFM ;-) Fix: Please apply the following patch: --- mysql-dfsg

mysqlhotcopy segfaults with perl 5.8

mysqlhotcopy always worked fine with perl 5.6.1 (debian woody), but i had to upgrade to perl 5.8 and now it croaks and dies with a segfault. the problem exists only with mysqlhotcopy; other db-connections with perl 5.8 and DBI/DBD::mysql are no problem. at http://volltext.net/mysql/strace.txt

mysqlhotcopy??

I am trying to find the best way to backup my 4.7GB database and have unfortunately found out the hard way that mysqldump is grossly inefficient. Since 4 web sites rely on the data, shutting it down to copy it is not a good option either. Has anyone used mysqlhotcopy? The perl doc says

mysqlhotcopy

I am trying to find the best way to backup my 4.7GB database and have unfortunately found out the hard way that mysqldump is grossly inefficient. Since 4 web sites rely on the data, shutting it down to copy it is not a good option either. Has anyone used mysqlhotcopy? The perl doc says

Re: mysqlhotcopy??

on the data, shutting it down to copy it is not a good option either. Has anyone used mysqlhotcopy? The perl doc says it is still in beta, which makes me a little nervous. have you thought about lvm? http://tldp.org/HOWTO/LVM-HOWTO/snapshots_backup.html - -- Peter Abplanalp -BEGIN PGP SIGNATURE

RE: mysqlhotcopy

PROTECTED]] Sent: Tuesday, December 10, 2002 9:14 AM To: [EMAIL PROTECTED] Subject: mysqlhotcopy I am trying to find the best way to backup my 4.7GB database and have unfortunately found out the hard way that mysqldump is grossly inefficient. Since 4 web sites rely on the data, shutting it down to copy

mysqlhotcopy ignores --host or -h option

Description: mysqlhotcopy ignores --host -h option How-To-Repeat: call mysqlhotcopy with a host differs from localhost Fix: Add host|h=s to GetOptions Submitter-Id: submitter ID Originator: Organization: organization of PR author (multiple lines) MySQL support: none

Re: mysqlhotcopy point-in-time recovery

On Wed, Nov 13, 2002 at 01:18:18PM -0500, Michael T. Babcock wrote: Jeremy Zawodny wrote: Well, it handles ISAM, MyISAM, and BDB (last I checked). So what should it be called? mysql_isam_myisam_bdb_hotcopy? Heheh, point taken. It seems simply unfortunate that the program in

Re: mysqlhotcopy point-in-time recovery

Michael, Jeremy, - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Wednesday, November 13, 2002 9:21 PM Subject: Re: mysqlhotcopy point-in-time recovery On Wed, Nov 13, 2002 at 01:18:18PM -0500, Michael T. Babcock wrote: Jeremy

mysqlhotcopy point-in-time recovery

Hi, all, sql, query. I use mysqlhotcopy to backup innodb tables and I tried to find how to recovery database point-in-time with the help of binary log. I had tried mysqlbinlog --user-jqu --password=1234 Host-bin.[0-9]* | mysql without success. Anyone of you know how to recovery database

Re: mysqlhotcopy point-in-time recovery

Jing, - Original Message - From: Jannie Qu [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Monday, November 11, 2002 8:03 PM Subject: mysqlhotcopy point-in-time recovery Hi, all, sql, query. I use mysqlhotcopy to backup innodb tables and I tried to find how to recovery

Re: mysqlhotcopy point-in-time recovery

Heikki Tuuri wrote: you cannot use mysqlhotcopy to back up InnoDB type tables. Only the .frm files are in the database directory, while the data is in ibdata files. mysqlhotcopy does not copy ibdata files or ib_logfiles, and if it would do that, the copies could be corrupt because of writes

RE: mysqlhotcopy point-in-time recovery

PM To: Heikki Tuuri Cc: [EMAIL PROTECTED] Subject: Re: mysqlhotcopy point-in-time recovery Heikki Tuuri wrote: you cannot use mysqlhotcopy to back up InnoDB type tables. Only the .frm files are in the database directory, while the data is in ibdata files. mysqlhotcopy does not copy ibdata files

Re: mysqlhotcopy problem - Segmentation fault

On Wed, Aug 28, 2002 at 04:50:22PM -0400, Mihail Manolov wrote: I have strange problem - I get Segmentation fault error when I am trying to execute mysqlhotcopy. When I remove the [mysqlhotcopy] section in my /etc/my.cnf configuration it works. Meanwhile, on another server it works just

Re: mysqlhotcopy problem - Segmentation fault

Yes, both run 3.23.49a - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] To: Mihail Manolov [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, August 29, 2002 3:24 AM Subject: Re: mysqlhotcopy problem - Segmentation fault On Wed, Aug 28, 2002 at 04:50:22PM -0400, Mihail

mysqlhotcopy problem - Segmentation fault

I have strange problem - I get Segmentation fault error when I am trying to execute mysqlhotcopy. When I remove the [mysqlhotcopy] section in my /etc/my.cnf configuration it works. Meanwhile, on another server it works just fine with the same configuration file. There is nothing fancy

mysqlhotcopy problem - Segmentation fault

I have strange problem - I get Segmentation fault error when I am trying to execute mysqlhotcopy. When I remove the [mysqlhotcopy] and [client] sections in my /etc/my.cnf configuration it works. Meanwhile, on another server it works just fine with the same configuration file. There is nothing

Mysqlhotcopy error

I am looking into using the mysqlhotcopy.pl script to back-up my databases. When I try to run it, I get the following error: The getpwuid function is unimplemented at C:\mysql\scripts\mysqlhotcopy.pl line 79. I'm not familiar enough with perl to even begin debugging the script myself.. Does

mysqlhotcopy / perl problem

Description: The mysqlhotcopy script fails with recent versions of perl. How-To-Repeat: Invoke mysqlhotcopy with perl 5.6.1. (I'm on a NetBSD box.) The script fails, complaining it can't create the target directory. Fix: In the section of the script that creates

problem with mysqlhotcopy

Hi mysql wizards, I've a problem with mysqlhotcopy, i.e. the 'copy step' fails. I've no idea why (for I don't understand perl), could anyone help? Here is how mysqlhotcopy is invoked (intentionaly using option '-n' here): mysqlhotcopy webimages /swpr_ss02-2/frisbee/dbbackups --allowold

problem with mysqlhotcopy

Hi mysql wizards, I've a problem with mysqlhotcopy, i.e. the 'copy step' fails. I've no idea why (for I don't understand perl), could anyone help? Here is how mysqlhotcopy is invoked (intentionaly using option '-n' here): mysqlhotcopy webimages /swpr_ss02-2/frisbee/dbbackups --allowold

help with mysqlhotcopy

I was wondering if someone could help me out with the syntax to use mysqlhotcopy to backup a database to a tape drive ( /dev/nst0 ). I've tried a few variations of the command but with no luck so far. The mysql server is running on RH 7.2 and the DAT tape drive is on that same machine

help with mysqlhotcopy

I was wondering if someone could help me out with the syntax to use mysqlhotcopy to backup a database to a tape drive ( /dev/nst0 ). I've tried a few variations of the command but with no luck so far. The mysql server is running on RH 7.2 and the DAT tape drive is on that same machine

help with mysqlhotcopy

I was wondering if someone could help me out with the syntax to use mysqlhotcopy to backup a database to a tape drive ( /dev/nst0 ). I've tried a few variations of the command but with no luck so far. The mysql server is running on RH 7.2 and the DAT tape drive is on that same machine

Re: help with mysqlhotcopy

I was wondering if someone could help me out with the syntax to use mysqlhotcopy to backup a database to a tape drive ( /dev/nst0 ). I've tried a few variations of the command but with no luck so far. The mysql server is running on RH 7.2 and the DAT tape drive is on that same machine

mysqlhotcopy broken ???

It appears the v4.0.1 mysqlhotcopy perl script has been modified and broken. When using cp for the backup it's passing a null value for the file(s) to be copied. Below is a session clipping of an execution with --debug turned

mysqlhotcopy regexp problem with 640 and more Databases

Description: When using mysqlhotcopy 1.15 for database backups with --regexp='.*' and having 640 or more Databases produces the following error: DBD::mysql::db do failed: File '/lvol1/mysql/data/mydatabase/mytable640.MYD' not found (Errcode: 24) at ./bin/mysqlhotcopy line 432. The file

  1   2   >