I have musql 4.1.7 on Solaris 9, 64 bits and I want to mysqldump a +-4
gigas db.
The dump I want to do is from a myISAM tables databank. I used to do
that dump wihtout any problem until recently while the size of the Db
double (+-2 to +-4)
The full directory that contains the *.frm, *.MYD,*.MYI files has the
following size:
>du -ks /seqdata/mysql/autres_bds/regen
3702719 /seqdata/mysql/autres_bds/regen
In my.conf, tmpdir is /seqdata/mysql/tmp.
The dmp file itself is created also on /seqdata/mysql.
Space available:
mercure{root}142: df -k
Filesystem kbytes used avail capacity Mounted on
/dev/dsk/c0t0d0s0 7156569 6771681 313323 96% /
/dev/dsk/c0t0d0s3 2056211 515444 1479081 26% /var
/dev/dsk/c2t5d0s0 2033839 1235855 736969 63% /seqweb
/dev/dsk/c0t0d0s4 6120070 4997223 1061647 83% /opt
/dev/dsk/c1t5d0s2 121640139 67202782 53220956 56% /seqdata
/dev/dsk/c2t5d0s5 34077781 20618437 13459344 61% /oracle
/dev/dsk/c2t5d0s6 102749585 1677327 100044763 2% /dbs
Running the following, I eventually get an error message
mercure{mysql}53: /seqweb/mysql/bin/mysqldump --opt --flush-logs regen >
/seqdata/mysql/myregendump
/seqweb/mysql/bin/mysqldump: Got errno 27 on write
and I get the output du -k: 2098184 myregendump
this error supposed to be:
bin/perror 27
Error code 27: File too large
As you can see I have plenty of space.
In the error file I have multiple times the line:
InnoDB: Error: unable to create temporary file; errno: 2
mercure{mysql}66: bin/perror 2
Error code 2: No such file or directory
But the directory exist.
Then I tried a verbose mysqldump.
mercure{mysql}73: /seqweb/mysql/bin/mysqldump --opt --verbose regen >
/seqdata/mysql/myregendump
-- Connecting to localhost...
-- Retrieving table structure for table cpgisland_Human_May2004...
-- Sending SELECT query...
-- Retrieving rows...
...
21 tables
-- Retrieving table structure for table unit_occurence_Human_May2004...
-- Sending SELECT query...
-- Retrieving rows...
/seqweb/mysql/bin/mysqldump: Got errno 27 on write
This table is 1 giga data and 500mb index.
Then I tried a mysqldump of this table only:
/seqweb/mysql/bin/mysqldump --opt --verbose regen
unit_occurence_Human_May2004
and it works fine.
How can I solve this problem?
I have looked at the previous message in the forum but could not find
anything answering my problem.
Thank you in advance for any help.
Johanne Duhaime
[EMAIL PROTECTED]
tel 5556
local 1565.4, Centre de documentation
