Re: Connect To Foreign Tables

2007-10-06 Thread Werner Van Belle
Hello, On Friday 05 October 2007 01:11:35 James Card wrote: The application I'm working on uses MySQL 5.0.41 and we also need to retrieve some data from a SQL-Server database in another department. SQL-Server has a feature (that I haven't tested) that allows it to make an ODBC connection to

SAN and ibdata files

2007-10-06 Thread Ace
Hi Experts, You all know the size problems with ibdata and log files. We plan to move those files to SAN to have maximum storage possible. We did so with configuration changes in my.cnf files to save log and ibdata files on SAN location. But got following error - InnoDB: Unable to lock

Re: Connect To Foreign Tables

2007-10-06 Thread Rob Wultsch
Have you guys thought about trying to use a Federated table? http://dev.mysql.com/doc/refman/5.0/en/federated-storage-engine.html Probably not exactly the solution you want, but maybe useful. On 10/6/07, Werner Van Belle [EMAIL PROTECTED] wrote: Hello, On Friday 05 October 2007 01:11:35

Re: do I need two tables or one will do just fine?

2007-10-06 Thread John Meyer
Afan Pasalic wrote: hi, I have a employees table (first name, last_name, address, city, state, zip, phone,...). though, I got a requested to add additional info about people, like phone_extension, zip+4, nick, DOB... that will not be used very often. what would be better solution: a) add

Re: SAN and ibdata files

2007-10-06 Thread Dan Nelson
In the last episode (Oct 06), Ace said: Hi Experts, You all know the size problems with ibdata and log files. We plan to move those files to SAN to have maximum storage possible. We did so with configuration changes in my.cnf files to save log and ibdata files on SAN location. But got