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
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
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'
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
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&#
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
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
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
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
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
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
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
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
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
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
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
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
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 nam
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
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
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)
>
>
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
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
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: "J
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
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
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
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
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
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 '
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
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
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
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
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
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
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.
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
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
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
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/ -
>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
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
"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
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
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
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
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
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
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 ?
>
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
"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
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
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
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
>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
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'
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
[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
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
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
"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
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
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
> >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
> -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
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
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
>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 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
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
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
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
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
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
>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:
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
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
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
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
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
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
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
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
>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
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_
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_
> 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
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
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
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 - 100 of 144 matches
Mail list logo
