No,i don't want to do this. My previous variable is "innodb_data_file_path=ibdata1:2G;ibdata2:10M:autoextend".
But ibdata2 had exceed 3G! I changed the variable to "innodb_data_file_path=ibdata1:2G;ibdata2:2G;ibdata3:10M:autoextend". But Server couldn't start. How can i to achieve my idea? ----- Original Message ----- From: "Ow Mun Heng" <[EMAIL PROTECTED]> To: <mysql@lists.mysql.com> Sent: Tuesday, February 07, 2006 4:07 PM Re: split a datafile > On Tue, 2006-02-07 at 15:48 +0800, wangxu wrote: > > I want to split a datafile to two datafiles.How can i do? > Will this do? > > $ split --help > Usage: split [OPTION] [INPUT [PREFIX]] > Output fixed-size pieces of INPUT to PREFIXaa, PREFIXab, ...; default > PREFIX is `x'. With no INPUT, or when INPUT is -, read standard input. > > Mandatory arguments to long options are mandatory for short options too. > -a, --suffix-length=N use suffixes of length N (default 2) > -b, --bytes=SIZE put SIZE bytes per output file > -C, --line-bytes=SIZE put at most SIZE bytes of lines per output > file > -d, --numeric-suffixes use numeric suffixes instead of alphabetic > -l, --lines=NUMBER put NUMBER lines per output file > --verbose print a diagnostic to standard error just > before each output file is opened > --help display this help and exit > --version output version information and exit > > SIZE may have a multiplier suffix: b for 512, k for 1K, m for 1 Meg. > > Report bugs to <bug-coreutils@gnu.org>. > > > -- > Ow Mun Heng > Gentoo/Linux on DELL D600 1.4Ghz 1.5GB RAM > 98% Microsoft(tm) Free!! > Neuromancer 16:06:57 up 1 day, 7:07, 4 users, load average: 1.56, 1.02, > 0.81 > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > >