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 line 468.
Deleting previous 'old' hotcopy directory ('mydirectory')
Existing hotcopy directory renamed to '/mydirectory/db_name_old'
done.
$ perror 24
Error code 24: Too many open files
Try increasing your open_files_limit?
This is documented here:
http://dev.mysql.com/doc/mysql/en/not-enough-file-handles.html
If this does not help, and you need further support, you could work
this up with MySQL Support at:
https://support.mysql.com
Regards,
Josh
--
Josh Chamas
Director, Professional Services
MySQL Inc., www.mysql.com
Get More with MySQL! www.mysql.com/consulting
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 previous 'old' hotcopy directory ('mydirectory')
Existing hotcopy directory renamed to '/mydirectory/db_name_old'
done.
The frm file it can't find varies with each attempt to use MySQLHotCopy.
The files are there. We've flushed, optimized, and repaired all the tables
in the database without any luck. The db appears to be working fine.
MySQLHotCopy works ok with other databases on this server.
MySQL 4.0.23
Server: Mac OSX Server 10.3.8 dual 1.33 Ghz PPC G4 with 2 GB SDRAM
DB has 274 tables with 1.6 million records. DB size is 400 MB.
Any insights would be greatly appreciated.
TIA
Stephen P. Fracek, Jr.
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 anybody recognize this symptom and know whether I'm missing a perl module or something easy like that? Tab - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
running mysqlhotcopy error
Hello, I'm trying to run mysqlhotcopy for the first time. I get an error that looks like this $ ./mysqlhotcopy X /opt/mysql-3.23.32-sun-solaris2.7-sparc/backup Can't locate DBI.pm in @INC (@INC contains: /usr/local/lib/perl5/5.00503/sun4-solaris /usr/local/lib/perl5/5.00503 /usr/local/lib/perl5/site_perl/5.005/sun4-solaris /usr/local/lib/perl5/site_perl/5.005 .) at ./mysqlhotcopy line 8. BEGIN failed--compilation aborted at ./mysqlhotcopy line 8. What is DBI? I got perl installed at ... $ which perl /usr/local/bin/perl And mysqlhotcopy looks like this... $ head mysqlhotcopy #!/usr/local/bin/perl -w use strict; use Getopt::Long; use Data::Dumper; use File::Basename; use File::Path; use DBI; =head1 NAME Can't really understand what i'm doing wrong here. Anybody have any ideas? Best regards Jari Marikainen - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: running mysqlhotcopy error
mysqlhotcopy uses the DBI to connect to the mysql database, Perl's API for accessing the database. On Mon, 18 Feb 2002 18:44:24 +0100, [EMAIL PROTECTED] wrote: I'm trying to run mysqlhotcopy for the first time. I get an error that looks like this $ ./mysqlhotcopy X /opt/mysql-3.23.32-sun-solaris2.7-sparc/backup Can't locate DBI.pm in @INC (@INC contains: /usr/local/lib/perl5/5.00503/sun4-solaris /usr/local/lib/perl5/5.00503 /usr/local/lib/perl5/site_perl/5.005/sun4-solaris /usr/local/lib/perl5/site_perl/5.005 .) at ./mysqlhotcopy line 8. BEGIN failed--compilation aborted at ./mysqlhotcopy line 8. What is DBI? I got perl installed at ... $ which perl /usr/local/bin/perl Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Perl script mysqlhotcopy error ... (errno: 24)
Hi,
I got this error using mysqlhotcopy:
DBD::mysql::db do failed: Can't find file: './Tecnowind/tqgrppia.frm' (errno:
24) at /usr/local/mysql/bin/mysqlhotcopy line 375.
Issuing rollback() for database handle being DESTROY'd without explicit
disconnect().
and perror 24 says:
Error code 24: Too many open files
Ok, the point is that the database has 865 tables:
# ls -al /home3/Oasi/files/Tecnowind/*.MYI | wc -l
865
The mysqlhotcopy script at line 375 try to lock all tables at once.
$dbh-do("LOCK TABLES $hc_locks");
I got this error with 3.23.34a and 3.23.36 mysql versions.
Could someone give me a solution ?
I think that some parameter should be tuned (open tables limit ???)
Thanks in advance
PS:
Yesterday, I have completed an installation with 120 concurrent users, with
OASI, our ERP based on mysql (OF COURSE) and it runs very very well !
The hardware is a bi-processor XEON 733 MHZ with 2GB of RAM and 60 gb
HD (SCSI).
There are 4 databases that shares some common tables !
marcello
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
