Re: Raw partition with InnoDB on Windows 2000
Dyego, I have tested raw partitions in Windows, and others have tested them in Linux. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/fileio/base/createfile.asp " When opening a physical drive, x, the lpFileName string should be of the form \\.\PHYSICALDRIVE. Hard disk numbers start at zero. The following table shows some example physical drive strings. String Meaning \\.\PHYSICALDRIVE0Opens the first physical drive. \\.\PHYSICALDRIVE2Opens the third physical drive. For an example showing how to open a physical drive, see Calling DeviceIoControl. When opening a volume or floppy drive, the lpFileName string should be of the form \\.\:. Do not use a trailing backslash. This would indicate the root directory of the drive. The following table shows some example drive strings. String Meaning \\.\A:Opens drive A (floppy drive). \\.\C:Opens drive C (volume). You can also open a volume by referring to its volume name. For more information, see Naming a Volume. " Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Transactions, foreign keys, and a hot backup tool for MySQL Order MySQL technical support from https://order.mysql.com/ - Original Message - From: "Jackson Miller" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Thursday, August 21, 2003 11:35 AM Subject: Re: Raw partition with InnoDB on Windows 2000 > In linux it says it is untested. I don't think it is even an option for > windows yet. > > -Jackson > > > On Wednesday 20 August 2003 3:00, Dyego Souza do Carmo wrote: > > Hello guys !!! > > > > > > I have MySQL/InnoDB on Windows 2000 and i want to create a RAW > > PARTITION to use InnoDB tablespace... > > > > In Linux the configurarion is: > > > > > > innodb_data_file_path = /dev/hda1:32Gnewraw > > innodb_data_home_dir = > > > > > > and in Windows 2000 ?? > > > > > > Tnks in advance... > > > > > > InnoDB,MySQL,SQL,query,HELLLP !!! > > > > > > - > > ++ Dyego Souza do Carmo ++ Dep. Desenvolvimento > > - > > E S C R I B A I N F O R M A T I C A > > - > > The only stupid question is the unasked one (somewhere in Linux's HowTo) > > Linux registred user : #230601 > > --ICQ : 1647350 > > $ look into "my eyes" Phone : +55 041 296-2311 > > look: cannot open my eyes Fax : +55 041 296-6640 > > - > >Reply: [EMAIL PROTECTED] > > -- > jackson miller > > cold feet creative > 615.321.3300 / 800.595.4401 > [EMAIL PROTECTED] > > > cold feet presents Emma > the world's easiest email marketing > Learn more @ http://www.myemma.com > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Raw partition with InnoDB on Windows 2000
In linux it says it is untested. I don't think it is even an option for windows yet. -Jackson On Wednesday 20 August 2003 3:00, Dyego Souza do Carmo wrote: > Hello guys !!! > > > I have MySQL/InnoDB on Windows 2000 and i want to create a RAW > PARTITION to use InnoDB tablespace... > > In Linux the configurarion is: > > > innodb_data_file_path = /dev/hda1:32Gnewraw > innodb_data_home_dir = > > > and in Windows 2000 ?? > > > Tnks in advance... > > > InnoDB,MySQL,SQL,query,HELLLP !!! > > > - > ++ Dyego Souza do Carmo ++ Dep. Desenvolvimento > - > E S C R I B A I N F O R M A T I C A > - > The only stupid question is the unasked one (somewhere in Linux's HowTo) > Linux registred user : #230601 > --ICQ : 1647350 > $ look into "my eyes" Phone : +55 041 296-2311 > look: cannot open my eyes Fax : +55 041 296-6640 > - >Reply: [EMAIL PROTECTED] -- jackson miller cold feet creative 615.321.3300 / 800.595.4401 [EMAIL PROTECTED] cold feet presents Emma the world's easiest email marketing Learn more @ http://www.myemma.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Raw partition with InnoDB on Windows 2000
At 17:00 -0300 8/20/03, Dyego Souza do Carmo wrote: Hello guys !!! I have MySQL/InnoDB on Windows 2000 and i want to create a RAW PARTITION to use InnoDB tablespace... In Linux the configurarion is: innodb_data_file_path = /dev/hda1:32Gnewraw innodb_data_home_dir = and in Windows 2000 ?? What's the pathname of the partition you want to use? -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Raw partition with InnoDB on Windows 2000
Hello guys !!! I have MySQL/InnoDB on Windows 2000 and i want to create a RAW PARTITION to use InnoDB tablespace... In Linux the configurarion is: innodb_data_file_path = /dev/hda1:32Gnewraw innodb_data_home_dir = and in Windows 2000 ?? Tnks in advance... InnoDB,MySQL,SQL,query,HELLLP !!! - ++ Dyego Souza do Carmo ++ Dep. Desenvolvimento - E S C R I B A I N F O R M A T I C A - The only stupid question is the unasked one (somewhere in Linux's HowTo) Linux registred user : #230601 --ICQ : 1647350 $ look into "my eyes" Phone : +55 041 296-2311 look: cannot open my eyes Fax : +55 041 296-6640 - Reply: [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Raw partition with InnoDB on Windows 2000
Hello guys !!! I have MySQL/InnoDB on Windows 2000 and i want to create a RAW PARTITION to use InnoDB tablespace... In Linux the configurarion is: innodb_data_file_path = /dev/hda1:32Gnewraw innodb_data_home_dir = and in Windows 2000 ?? Tnks in advance... InnoDB,MySQL,SQL,HELLLP !!! - ++ Dyego Souza do Carmo ++ Dep. Desenvolvimento - E S C R I B A I N F O R M A T I C A - The only stupid question is the unasked one (somewhere in Linux's HowTo) Linux registred user : #230601 --ICQ : 1647350 $ look into "my eyes" Phone : +55 041 296-2311 look: cannot open my eyes Fax : +55 041 296-6640 - Reply: [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
