Hendrik,
Monday, March 18, 2002, 10:04:44 AM, you wrote:
HN> We have problem with moving data to new server. We dumped
HN> database with mysqldump on old server and used
HN> "mysql dbname < db.sql" syntax for database import.
HN> When mysql imports one of our biggest table, then the import fails and
HN> after some minutes gives an error message:
HN> "ERROR 1030 at line 244654: Got error 28 from table handler"
[greta@esther greta]$ perror 28
Error code 28: No space left on device
HN> What might be the problem?
HN> MySQL version on new server is 3.23.49a-log. Server have RedHat
HN> 7.2 installed, RAID disks, 512MB RAM, CPU is Intel PIII.
HN> If the problem is caused with RAID, then, how to set the "have_raid"
HN> variable to "ON" (I hasn't find this operation from manual).
MySQL RAID support has no relation to Linux's RAID support and Linux's RAID support
has no connections to hardware RAIDs.
So which RAID do you mean? If MySQL one, you can read about it at:
http://www.mysql.com/doc/C/R/CREATE_TABLE.html
have_raid is not a variable you can set. It's a variable that is used to check if
MySQL is compiled with a various options like InnoDB, BDB, RAID and so on.
HN> Hendrik
--
For technical support contracts, goto https://order.mysql.com/
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
---------------------------------------------------------------------
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
