Re: Create Foreign Key Issue

2007-05-18 Thread Baron Schwartz
Hi Jesse, Jesse wrote: Currently using MySQL version 5.0.22-community-nt on a Windows XP Pro box (my development machine). When I attempt to add a Foreign Key to one of my tables, I get the error, "Can't create table '.\woodturners\#sql-2dc_8.frm' (errno: 150). I have checked through all o

Create Foreign Key Issue

2007-05-18 Thread Jesse
Currently using MySQL version 5.0.22-community-nt on a Windows XP Pro box (my development machine). When I attempt to add a Foreign Key to one of my tables, I get the error, "Can't create table '.\woodturners\#sql-2dc_8.frm' (errno: 150). I have checked through all of the standard issues:

Re: Broken Tables, was:Memory Problems

2007-05-18 Thread mos
At 09:42 AM 5/18/2007, you wrote: Hi, It seems to be the Hardware somehow. I tested on another Machine with same OS, and everything seems to run now. I am using the same Memory so this is not the problem. Both Machines have hardware raid. The only thing left is the mainboard. Vey ugly.

Re: Broken Tables, was:Memory Problems

2007-05-18 Thread Christoph Klünter
Hi, It seems to be the Hardware somehow. I tested on another Machine with same OS, and everything seems to run now. I am using the same Memory so this is not the problem. Both Machines have hardware raid. The only thing left is the mainboard. Vey ugly. Cheers, Christoph On Friday 18

Re: Broken Tables, was:Memory Problems

2007-05-18 Thread mos
Christoph, I don't know if this helps or not, but I had a similar problem a few years back on a Windows machine. Memory kept getting corrupted and I traced the problem to Intel Accelerator that I had running. Intel only admitted to the problem with their software months later. My ad

Re: Broken Tables, was:Memory Problems

2007-05-18 Thread Christoph Klünter
Hi everybody, On Friday 18 May 2007 14:50:55 Brent Baisley wrote: > You may be running into file system file size "limits". You would need to > make sure the file system you are using is set to handle files larger than > 4GB, in addition, you need to check that the account mysqld us running > unde

Re: Broken Tables, was:Memory Problems

2007-05-18 Thread Brent Baisley
You may be running into file system file size "limits". You would need to make sure the file system you are using is set to handle files larger than 4GB, in addition, you need to check that the account mysqld us running under is allowed to create files larger than 4GB. Just because the OS and fil

Corrupted Tables, was:Memory Problems

2007-05-18 Thread Christoph Klünter
On Tuesday 15 May 2007 14:36:45 Mathieu Bruneau wrote: > Hi, yeah, apparenlty you're running into the 32 bits memory liimt. Note > thta some memory is allocated for the OS so you don't even have the full > 4GB of ram you can technically adressesed. > > The 64 bits os would increase this limit to 64

Broken Tables, was:Memory Problems

2007-05-18 Thread Christoph Klünter
On Tuesday 15 May 2007 14:36:45 Mathieu Bruneau wrote: > Hi, yeah, apparenlty you're running into the 32 bits memory liimt. Note > thta some memory is allocated for the OS so you don't even have the full > 4GB of ram you can technically adressesed. > > The 64 bits os would increase this limit to 64