OT: Experiences with SATA, Intel ICH5, Kernel 2.6

n the future). Has someone experiences with this one. I often heard that Promise is crap and a performance hog compared to other raid solutions. I would use it just to have another 2 SATA-Ports. Best regards, Henrik -- Henrik Heil, zweipol Coy & Heil GbR http://www.zweipol.net/ -- To UNSUBSCRIBE, e

Re: q re transferring mysql db from redhat to debian

is what phpmayadmin does with checked "Add AUTO_INCREMENT value" CREATE TABLE `testtab` ( `id` int(11) NOT NULL auto_increment, PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=8 ; I don't know how get this with mysqldump. Best regards, Henrik -- Henri

Re: q re transferring mysql db from redhat to debian

cked the manpage and it seems that you cannot tell mysqldump to add AUTO_INCREMENT=... to the CREATE TABLE statement (please correct me if you know a way). phpmyadmin creates dumps with AUTO_INCREMENT information -- i thought mysqldump would do the same -- but it does not. Best regards, Henr

Re: q re transferring mysql db from redhat to debian

annot have a downtime or disable write access while migrating you could set up replication to keep the databases in sync until you switch to the new server (only with mysql version >= 3.23.15). Best regards, Henrik -- Henrik Heil, zweipol Coy & Heil GbR http://www.zweipol.net/ -- To UNSUBSCRI

Re: hardware/optimizations for a download-webserver

100Mbit (non-realtek) NIC ? Thanks, Henrik -- Henrik Heil, zweipol Coy & Heil GbR http://www.zweipol.net/ -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]

hardware/optimizations for a download-webserver

alltogether) - replacing apache with fnord (http://www.fefe.de/fnord/) or cthulhu (http://cthulhu.fnord.at/). Can anyone share experiences with these? - (as a last resort) using 2 loadbalancing servers with lvs (http://www.linuxvirtualserver.org/). Thanks, Henrik -- Henrik Heil, zweipol Coy & Heil