backup: mysqldump or mysqlhotcopy ?

2010-04-22 Thread Lentes, Bernd
ge often, but i 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 directo

does mysqlhotcopy affect the key buffer?

2009-12-11 Thread Tom Worster
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 to

mysqlhotcopy

2007-11-13 Thread Malka Cymbalista
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'

Re: mysqlhotcopy errors osx

2006-11-17 Thread Mike Kruckenberg
the driver 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 insta

mysqlhotcopy errors osx

2006-11-17 Thread James Tu
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&#

Re: MySQLHotCopy

2006-07-25 Thread Jesse
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. Show

Re: MySQLHotCopy

2006-07-25 Thread Remo Tex
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 ve

MySQLHotCopy

2006-07-24 Thread Jesse
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 thi

RE: Mysqlhotcopy and replication

2006-06-29 Thread Jeff McKeon
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, that is

Re: Mysqlhotcopy and replication

2006-06-29 Thread Dan Buettner
ation 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. While t

Mysqlhotcopy and replication

2006-06-29 Thread Jeff
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

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

2006-06-20 Thread Tim Lucia
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 Xeo

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

2006-06-19 Thread Tim Lucia
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

Re: mysqlhotcopy regexp

2006-05-26 Thread MF
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 do

Re: mysqlhotcopy regexp

2006-05-25 Thread sheeri kritzer
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 w

mysqlhotcopy regexp

2006-05-25 Thread MF
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

2006-02-24 Thread Peter
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/m

Re: mysqlhotcopy

2006-02-24 Thread Imran Chaudhry
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 Lis

Re: mysqlhotcopy

2006-02-23 Thread Peter
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 nam

mysqlhotcopy

2006-02-23 Thread Peter
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

Re: MySQLHotCopy Error

2005-09-11 Thread Josh Chamas
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

MySQLHotCopy Error

2005-09-10 Thread Stephen P. Fracek, Jr.
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/mysqlh

Re: Mysqlhotcopy.

2005-06-17 Thread Gleb Paharenko
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) > >

Mysqlhotcopy.

2005-06-16 Thread Miguel Burgos O.
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 co

Re: mysqlhotcopy

2005-06-03 Thread Keith Ivey
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 Gene

Re: mysqlhotcopy

2005-06-03 Thread Jeremiah Gowdy
Yep. - Original Message - From: "Jeff McKeon" <[EMAIL PROTECTED]> To: "Jeremiah Gowdy" <[EMAIL PROTECTED]>; Sent: Friday, June 03, 2005 12:11 PM Subject: RE: mysqlhotcopy Am I right in assuming that while mysqlhotcopy is running, nobody else can

RE: mysqlhotcopy

2005-06-03 Thread Jeff McKeon
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: R

Re: mysqlhotcopy

2005-06-03 Thread Jeremiah Gowdy
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: "J

mysqlhotcopy

2005-06-03 Thread Jeff McKeon
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

Re: Problem with mysqlhotcopy

2005-02-23 Thread Gleb Paharenko
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

Problem with mysqlhotcopy

2005-02-22 Thread MightyData
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

2005-02-21 Thread MightyData
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

2004-12-07 Thread Greg Whalin
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 the

mysqlhotcopy

2004-08-23 Thread Nuno Dias
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 '

Re: problem restoring backup made from mysqlhotcopy

2004-06-01 Thread venkata ramana
t; >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

Re: problem restoring backup made from mysqlhotcopy

2004-06-01 Thread Abuzar Chaudhary
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 inse

Re: problem restoring backup made from mysqlhotcopy

2004-06-01 Thread gerald_clark
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: I delete the records from tablea and insert records in tableb and observe tableb file size increa

problem restoring backup made from mysqlhotcopy

2004-06-01 Thread Abuzar Chaudhary
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: mysqlhotcopy -- max number of tables

2004-03-31 Thread Dathan Vance Pattishall
D] > Subject: 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 exper

mysqlhotcopy -- max number of tables

2004-03-31 Thread Andrew Loughe
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: use mysqldump and mysqlhotcopy together?

2004-02-10 Thread Kevin Carlson
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.

RE: use mysqldump and mysqlhotcopy together?

2004-02-10 Thread Schwartz, Evelyn
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

use mysqldump and mysqlhotcopy together?

2004-02-10 Thread Bing Du
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 kno

mysqlhotcopy as a replication scheme

2003-12-08 Thread Will Lowe
each datacenter -- 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

MySQLHotCopy - No tables to hot-copy HUH?!

2003-12-05 Thread Lewis Watson
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/ -

Lost Data with delayed insert / mysqlhotcopy

2003-09-24 Thread Martin Friebe
>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 t

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

2003-09-22 Thread Dathan Vance Pattishall
PM -->To: 'Gilmore, 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] --> -->

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

2003-09-22 Thread Dathan Vance Pattishall
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

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

2003-09-22 Thread Egor Egorov
"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 cop

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

2003-09-22 Thread Gilmore, Jason
6 PM To: [EMAIL PROTECTED] Subject: 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

Mysqlhotcopy and incorrect database name error - We must be dense

2003-09-17 Thread Gilmore, Jason
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 dire

mysqlhotcopy fails under linux RH9

2003-09-04 Thread Shawn
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

mysqlhotcopy fails under linux RH9

2003-09-04 Thread Shawn
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 this

re: mysqlhotcopy

2003-08-01 Thread Seth Redmond
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, `try

Re: mysqlhotcopy problem

2003-07-31 Thread Martin Waite
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 ? >

mysqlhotcopy problem

2003-07-30 Thread Vladimir Shiray
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

Re: mysqlhotcopy on innoDB

2003-07-14 Thread Victoria Reznichenko
"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 s

mysqlhotcopy on innoDB

2003-07-14 Thread Moritz Steiner
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 / bin-log manipulation

2003-06-27 Thread Roman Neuhauser
r). > But the lock used 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 &g

mysqlhotcopy / bin-log manipulation

2003-06-27 Thread Julien Gremillot
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

mysqlhotcopy does not read configuration files.

2003-06-24 Thread lcs
>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: >Originator:Larry

Re: mysqlhotcopy generates a segmentation fault

2003-06-11 Thread Martin Waite
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'

mysqlhotcopy generates a segmentation fault

2003-06-10 Thread Danny Cron
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: D

RE: Question / suggestion re: mysqlhotcopy

2003-06-06 Thread Murray Wells
[EMAIL PROTECTED] Subject: 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 appear

Re: Question / suggestion re: mysqlhotcopy

2003-06-06 Thread Paul DuBois
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

Question / suggestion re: mysqlhotcopy

2003-06-06 Thread Murray Wells
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 plat

Mysqlhotcopy usage problem

2003-06-05 Thread Sagar, Sanjeev
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 contai

Re: mysqlhotcopy usage

2003-05-30 Thread Egor Egorov
"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 w

mysqlhotcopy usage

2003-05-29 Thread Nils Valentin
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

mysqlhotcopy script problem

2003-05-29 Thread stu zimny
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

Problem with mysqlhotcopy version 1.17 when using --record_log_pos

2003-01-29 Thread Søren Thing Andersen
> >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

RE: Mysqlhotcopy and reuilding indexes

2003-01-29 Thread Erlend Hopsø Strømsvik
> -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 PROTEC

mysqldump or mysqlhotcopy?

2003-01-27 Thread Nicole Lallande
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

Mysqlhotcopy and reuilding indexes

2003-01-27 Thread Erlend Hopsø Strømsvik
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

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

2002-12-23 Thread ch
>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 pat

mysqlhotcopy segfaults with perl 5.8

2002-12-19 Thread Matthias Zeichmann
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

RE: mysqlhotcopy

2002-12-10 Thread Grant Cooper
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

Re: mysqlhotcopy??

2002-12-10 Thread Peter T. Abplanalp
es > rely 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

mysqlhotcopy

2002-12-10 Thread ed
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 it is

mysqlhotcopy??

2002-12-10 Thread ed
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 it is

Re: mysqlhotcopy point-in-time recovery

2002-11-13 Thread Heikki Tuuri
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, Micha

Re: mysqlhotcopy point-in-time recovery

2002-11-13 Thread Jeremy Zawodny
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 progra

mysqlhotcopy ignores --host or -h option

2002-11-13 Thread Holger . Manthey
>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: >Originator: >Organization: >MySQL support: none >Synopsis:

RE: mysqlhotcopy point-in-time recovery

2002-11-11 Thread Black, Kelly W [PCS]
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 co

Re: mysqlhotcopy point-in-time recovery

2002-11-11 Thread Michael T. Babcock
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 the

Re: mysqlhotcopy point-in-time recovery

2002-11-11 Thread Heikki Tuuri
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

mysqlhotcopy point-in-time recovery

2002-11-11 Thread Jannie Qu
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 recover

Mysqlhotcopy dyld: perl Undefined symbols:

2002-11-01 Thread Jannie Qu
Hi, all, Greetings. sql, query. I met a error when I use mysqlhotcopy: bash-2.05a$ mysqlhotcopy --user=jqu --password=jqu1234@ test /usr/local/mysql/backups dyld: perl Undefined symbols: _mysql_affected_rows _mysql_close _mysql_create_db

Re: mysqlhotcopy problem - Segmentation fault

2002-08-29 Thread Mihail Manolov
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

Re: mysqlhotcopy problem - Segmentation fault

2002-08-29 Thread Jeremy Zawodny
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

mysqlhotcopy problem - Segmentation fault

2002-08-28 Thread Mihail Manolov
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 problem - Segmentation fault

2002-08-28 Thread Mihail Manolov
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 in the

Mysqlhotcopy error

2002-07-15 Thread Tab Alleman
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 a

mysqlhotcopy / perl problem

2002-07-08 Thread Scott Lahteine
>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

problem with mysqlhotcopy

2002-07-03 Thread Ralf Juengling
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_

problem with mysqlhotcopy

2002-07-03 Thread Ralf Juengling
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_

Re: help with mysqlhotcopy

2002-06-12 Thread Hisseine Dj.
> 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 driv

help with mysqlhotcopy

2002-06-12 Thread Richard Reina
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 ma

help with mysqlhotcopy

2002-06-12 Thread Richard Reina
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 ma

help with mysqlhotcopy

2002-06-12 Thread Richard Reina
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 ma

  1   2   >