DBD::mysqlPP is the pure Perl driver for DBI. Is there a reason you are
using that instead of DBD::mysql? I haven't done Perl/MySQL on OS X
before but on other platforms (and from the error you're getting here)
DBD::mysql is the typical driver for using DBI with MySQL. It also is
the driver tha
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
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. Is
th
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
Jeff, that is indeed the case - the replication thread will "freeze"
just like any other thread, and pick up where it left off.
In fact, the statements are still replicated to the slave by the
replication thread, stored in the slave's relay-bin file I think.
Therefore even though the slave data i
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
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
>
> mysqlhotcop
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 as exp
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 reg
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
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 be n
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/mysqlh
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 r
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
F
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
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
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"
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: mysqlhotc
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]
-->
-->
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/ide
"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
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`` READ
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 ou
"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.my
# [EMAIL PROTECTED] / 2003-06-27 14:44:55 +0200:
> 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 m
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 with that configura
[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
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 plat
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)
"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
> -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
Why is mysqldump grossly inefficient. I thought this was the standard to
backing up a mysql database. I use dump / restore to back up my hard drive.
Would this be a better option to do a separate dump on the mysql database?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTE
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
* On Tue, Dec 10, 2002 at 11:04:01AM -0500, [EMAIL PROTECTED] wrote:
>
> 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
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
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
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
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 d
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
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 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
In the last episode (Jun 05), Pabst Simon said:
> 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 (
On Tue, 2002-03-26 at 07:24, Hans Kind wrote:
> Dear Martin,
>
> I tried that option, but it returns a errono 24:
>
> ../bin/mysqlhotcopy -u username -p password --flushlog --allowold
> --regexp='.*' /d1/terminal-a/mysql/
> 'mail' is an empty database
> 'opt' is an empty database
> 'oveas' is a
Dear Martin,
I tried that option, but it returns a errono 24:
../bin/mysqlhotcopy -u username -p password --flushlog --allowold
--regexp='.*' /d1/terminal-a/mysql/
'mail' is an empty database
'opt' is an empty database
'oveas' is an empty database
DBD::mysql::db do failed: Can't find file:
'./
On Sat, 2002-03-23 at 15:19, Hans Kind wrote:
> Hi,
>
> What is the correct syntax to use to backup all databases in the
> /usr/local/mysql/var directory.
>
> We tried a number of different options, but at best we get only 1 database,
> backup completely. Using a wildcard, *, only creates the
Check ownership and permissions of MyDatabase_copy directory (and maybe
the files).
On Wed, 2002-03-20 at 02:01, Ashwin Kotian wrote:
> I'm using the following syntax to backup one of my Mysql databses using
> mysqlhotcopy:
>
> #/usr/bin/mysqlhotcopy --allowold MyDatabase MyDatabase_copy
>
> T
On Mon, 2002-02-11 at 02:04, Jeremy Zawodny wrote:
> On Mon, Feb 11, 2002 at 03:04:47PM +1300, Ian Collins wrote:
> > In mysqlhotcopy, function copy_files, there is a line,
> >
> > my @non_raid = grep { $_ !~ m:\d\d/: } @$files;
> >
> > (dont you just love perl?).
> >
> > If the database name i
OK.
By the way - why is it trying to strip 2 digits in a row? I'm sure there was
a reason.
Cheers,
Ian Collins.
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 11, 2002 3:05 PM
To: Ian Collins
Cc: Mysql (E-mail)
Subject: Re: mysqlhotco
On Mon, Feb 11, 2002 at 03:04:47PM +1300, Ian Collins wrote:
> In mysqlhotcopy, function copy_files, there is a line,
>
> my @non_raid = grep { $_ !~ m:\d\d/: } @$files;
>
> (dont you just love perl?).
>
> If the database name in question is, for example, testone_750, a
> perfectly legal databa
OK.
By the way - why is it trying to strip 2 digits in a row? I'm sure there was
a reason.
Cheers,
Ian Collins.
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 11, 2002 3:05 PM
To: Ian Collins
Cc: Mysql (E-mail)
Subject: Re: mysqlhotco
On Mon, Feb 11, 2002 at 03:04:47PM +1300, Ian Collins wrote:
> In mysqlhotcopy, function copy_files, there is a line,
>
> my @non_raid = grep { $_ !~ m:\d\d/: } @$files;
>
> (dont you just love perl?).
>
> If the database name in question is, for example, testone_750, a
> perfectly legal databa
On Fri, Jul 20, 2001 at 01:25:22AM -0700, Jeremy Zawodny wrote:
> >
> > If I specify just one database, I still get the "deprecated"
> > warning, but the hotcopy works...
>
> There are two bugs.
>
> (1) The "depricated" message. I'm submitting a patch for that.
>
> (2) The fact that if yo
On Wed, Jul 18, 2001 at 09:57:00AM -0800, Chris Lott wrote:
>
> Using the mysqhotcopy that came with the most recent MySQL (3.23.39)
> on a RedHat 7.1 box with perl 5.6.0, I am getting the following
> errors when trying to back up all databases:
>
> mysqlhotcopy --password="foo" --allowold --reg
On Fri, Jun 01, 2001 at 03:35:57PM +0800, Alice wrote:
> i have no idea on how to run mysqlhotcopy in the query tool or it is
> not suppose to run in query tool. is this correct ? mysqlhotcopy
> db_name '/downloads/backupDB/'
It's a stand-alone tool. If you run it without any command-line
argu
53 matches
Mail list logo
