upgrading from mysql 4.0 to 4.1 : TIMESTAMP OTHER FEATURES
Hi! I would like to upgrade the database of my organisation from mysql4.0.22 from 4.1. We use Debian. I've read info in the manual, but i don't have things clear. We process data of DB with scripts, and I'm annoyed because the change of format of timestamp, is there any command in 4.1 to obtain this info in the previous format (4.0) ??? I want that out in 4.1 as MMDDHHMMSS Furthermore, my databases are in latin1, i've read that 4.1 take data in utf8, but i don't understand reading manual how this affect to my info. And to finish, do i have to keep more features in mind Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
howto query DELETE all records having invalid table refs
Hi all, there is a live before foreign keys, but now I'm using mysql 5.0 ;) how where I'm about to convert my db schema to make use of foreign keys (via innodb) I am enforced to delete all invalid entries before. however, I can do this using a huch select loop with a test within to delete all whose referencing record in a parent table doesn't exist anylonger. but I'd like to do this cleanup within a single DELETE query (to speedup the schema upgrade phase), but what kind of WHERE clause shall I use here? TABLE Accounts ( ID INTEGER NOT NULL auto_increment, -- ... ); TABLE GbEntries ( ID INTEGER NOT NULL auto_increment Sender INTEGER NOT NULL, -- references an account (the sender) -- ... FOREIGN KEY (Sender) REFERENCES Accounts(ID); ); I can add the foreign key to GbEntries only when all invalid records (pointing to not anylonger existing `Accounts` records) have been wiped out of GbEntries table. DELETE GbEntries Accounts WHERE Sender NOT IN Accounts.ID; but how's the proper SQL syntax for this? Thanks in advance, Christian Parpart. pgp2l9v1LOnci.pgp Description: PGP signature
howto query DELETE all records having invalid table refs
Hi all, there is a live before foreign keys, but now I'm using mysql 5.0 ;) how where I'm about to convert my db schema to make use of foreign keys (via innodb) I am enforced to delete all invalid entries before. however, I can do this using a huch select loop with a test within to delete all whose referencing record in a parent table doesn't exist anylonger. but I'd like to do this cleanup within a single DELETE query (to speedup the schema upgrade phase), but what kind of WHERE clause shall I use here? TABLE Accounts ( ID INTEGER NOT NULL auto_increment, -- ... ); TABLE GbEntries ( ID INTEGER NOT NULL auto_increment Sender INTEGER NOT NULL, -- references an account (the sender) -- ... FOREIGN KEY (Sender) REFERENCES Accounts(ID); ); I can add the foreign key to GbEntries only when all invalid records (pointing to not anylonger existing `Accounts` records) have been wiped out of GbEntries table. DELETE GbEntries Accounts WHERE Sender NOT IN Accounts.ID; but how's the proper SQL syntax for this? Thanks in advance, Christian Parpart. pgpRXubTioFGf.pgp Description: PGP signature
Re: howto query DELETE all records having invalid table refs
The following statement should do the trick: delete from GBEntries t1 where (select count(*) from Accounts nt1 where nt1.ID=t1.Sender)=0 Performance of this query will be significantly improved if there is an index on Accounts.ID. HTH, Panos. On 12/20/06, Christian Parpart [EMAIL PROTECTED] wrote: Hi all, there is a live before foreign keys, but now I'm using mysql 5.0 ;) how where I'm about to convert my db schema to make use of foreign keys (via innodb) I am enforced to delete all invalid entries before. however, I can do this using a huch select loop with a test within to delete all whose referencing record in a parent table doesn't exist anylonger. but I'd like to do this cleanup within a single DELETE query (to speedup the schema upgrade phase), but what kind of WHERE clause shall I use here? TABLE Accounts ( ID INTEGER NOT NULL auto_increment, -- ... ); TABLE GbEntries ( ID INTEGER NOT NULL auto_increment Sender INTEGER NOT NULL, -- references an account (the sender) -- ... FOREIGN KEY (Sender) REFERENCES Accounts(ID); ); I can add the foreign key to GbEntries only when all invalid records (pointing to not anylonger existing `Accounts` records) have been wiped out of GbEntries table. DELETE GbEntries Accounts WHERE Sender NOT IN Accounts.ID; but how's the proper SQL syntax for this? Thanks in advance, Christian Parpart. -- Panos Tsapralis, Senior Software / Systems Engineer, +306948076902, Athens, GREECE.
Re: no log generated?
On 12/19/06, Bing Du [EMAIL PROTECTED] wrote: Hi, We use /usr/libexec/mysqld Ver 4.1.20 for redhat-linux-gnu on i386 (Source distribution). /etc/my.cnf has the following configurations. == [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). old_passwords=1 [mysql.server] user=mysql basedir=/var/lib [mysqld_safe] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid == But /var/log/mysqld.log doesn't have anything more recent than October 2006. Yesterday, the mysqld experienced too many connections problem. But I didn't find anything got logged in mysqld.log. Why is that? I'm sure that's the config file mysqld reads because the pid-file has the pid of the running mysqld. I'd appreciate any insight. Could it be that the problems you mentioned generate warnings and not errors? If so, then you won't see anything in the error log, only if you use the log-warnings variable. Check the manual... Thanks Daniel. The message I got wasn't clear for me to tell if it's a warning or error. I figured there must be some option to set up log level or something. Anyway, I'll check the manual. Bing -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ERROR 1114
[EMAIL PROTECTED] wrote: In my configuration file there was a line that said: innodb_data_file_path = ibdata1:10M:autoextend:max:1900M This refers to the data file that contains all of my databases. The number 1900M is close to the 2G filesize limit on my linux server. With all of the chatter about other causes of Error 1114, I'd missed that this file had grown to it's limit. A small suggestion that you may find useful. You could have used 'optimize table' to free up some space. To make it easier to run optimize table, you can put in the 'innodb_file_per_table' into your my.cnf. This will create each table in its own file/tablespace, thus making it easier for optimize to run faster. However, this option only affects new tables. Old tables would still live in the shared ibdata file. -- raj shekhar facts: http://rajshekhar.net | opinions: http://rajshekhar.net/blog I dare do all that may become a man; Who dares do more is none. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ERROR 1114
Optimize table does not reclaim space for InnoDB tables in the shared tablespace, FYI - only for those that live independently when using the 'innodb_file_per_table' option. On 12/20/06, Raj Shekhar [EMAIL PROTECTED] wrote: [EMAIL PROTECTED] wrote: In my configuration file there was a line that said: innodb_data_file_path = ibdata1:10M:autoextend:max:1900M This refers to the data file that contains all of my databases. The number 1900M is close to the 2G filesize limit on my linux server. With all of the chatter about other causes of Error 1114, I'd missed that this file had grown to it's limit. A small suggestion that you may find useful. You could have used 'optimize table' to free up some space. To make it easier to run optimize table, you can put in the 'innodb_file_per_table' into your my.cnf. This will create each table in its own file/tablespace, thus making it easier for optimize to run faster. However, this option only affects new tables. Old tables would still live in the shared ibdata file. -- raj shekhar facts: http://rajshekhar.net | opinions: http://rajshekhar.net/blog I dare do all that may become a man; Who dares do more is none. -- 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: ERROR 1114
Raj, Normally, if you have problem with your configurations, I suggest recreate your databases : 1) backup all your database using mysqldump *$ mysqldump --opt --user=root --password= --databases db1 db2 db3 db4 /your/directory/of backups/backup.databases.dmp* ** ** 2) delete your databases 3) modify your configurations using 3 or 4 ibdata1:1900;ibdata2:1900;ibdata3:1900 ( my.cnf). $service mysql stop $service mysql start 4) load your initial backup into mysql Option 1: mysql set foreign_key_checks=0 mysql set autocommit=0 mysql source backup.mysql.dmp ( your possition must be of the file of backup) option 2 : *$ mysql --user=root --password= backup.mysql.dmp* Comments : You can use innodb_file_per_table , but if you say that your files can grow only 2G could be dangerous. On 12/20/06, Raj Shekhar [EMAIL PROTECTED] wrote: [EMAIL PROTECTED] wrote: In my configuration file there was a line that said: innodb_data_file_path = ibdata1:10M:autoextend:max:1900M This refers to the data file that contains all of my databases. The number 1900M is close to the 2G filesize limit on my linux server. With all of the chatter about other causes of Error 1114, I'd missed that this file had grown to it's limit. A small suggestion that you may find useful. You could have used 'optimize table' to free up some space. To make it easier to run optimize table, you can put in the 'innodb_file_per_table' into your my.cnf. This will create each table in its own file/tablespace, thus making it easier for optimize to run faster. However, this option only affects new tables. Old tables would still live in the shared ibdata file. -- raj shekhar facts: http://rajshekhar.net | opinions: http://rajshekhar.net/blog I dare do all that may become a man; Who dares do more is none. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
ERROR 2013 (HY000): Lost connection to MySQL server during query, 061220 14:48:44 mysqld restarted
I have MySQL 4.1.22 source installation on a 1.66 Intel Core Duo Mac Mini running OS X Server 10.4.8. It is a slave replicating to a master over ssl. Replication works fine, however I get this error always if I execute the STOP SLAVE statement ([EMAIL PROTECTED]) (none) stop slave; ERROR 2013 (HY000): Lost connection to MySQL server during query ([EMAIL PROTECTED]) (none) 061220 14:48:44 mysqld restarted Also, if I execute mysqladmin shutdown, it restarts also slmini:/usr/local admin$ mysqladmin -u root -p shutdown Enter password: slmini:/usr/local admin$ 061220 14:59:19 mysqld restarted The source has been compiled with SSL feature. I have exact same installation on a single CPU powerpc G4 XServe with no problems. My installation procedure/flags are here: Any ideas what the problem might be? Should I just rebuild the OS from scratch? Could it be corrupt data that needs to be recopied form the master? I'm baffled at this point. Regards, Kieran -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: upgrading from mysql 4.0 to 4.1 : TIMESTAMP OTHER FEATURES
Regarding the format of TIMESTAMP columns, one of the user comments on http://dev.mysql.com/doc/refman/4.1/en/timestamp-4-1.html offers the solution below: Posted by Kjell Arne Rekaa on April 14 2005 11:11pm If you want the same view of a timestamp field in 4.1.x as it was in in earlier mysql versions, without the delimiter characters in date and time, simply add a +0 to the column name: mysql create table date (remember timestamp); Query OK, 0 rows affected (0.03 sec) mysql insert date values ('2005051712'); Query OK, 1 row affected (0.00 sec) mysql select remember from date; +-+ | remember| +-+ | 2005-05-17 12:00:00 | +-+ 1 row in set (0.00 sec) mysql select remember+0 from date; ++ | remember+0 | ++ | 2005051712 | ++ 1 row in set (0.00 sec) As far as your character set, I believe that is stored by table, so your data should remain OK. Another major consideration with 4.1 is that passwords changed considerably from 4.0 to 4.1: http://dev.mysql.com/doc/refman/4.1/en/password-hashing.html HTH, Dan On 12/20/06, tere [EMAIL PROTECTED] wrote: Hi! I would like to upgrade the database of my organisation from mysql4.0.22 from 4.1. We use Debian. I've read info in the manual, but i don't have things clear. We process data of DB with scripts, and I'm annoyed because the change of format of timestamp, is there any command in 4.1 to obtain this info in the previous format (4.0) ??? I want that out in 4.1 as MMDDHHMMSS Furthermore, my databases are in latin1, i've read that 4.1 take data in utf8, but i don't understand reading manual how this affect to my info. And to finish, do i have to keep more features in mind Thanks -- 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: ERROR 2013 (HY000): Lost connection to MySQL server during query, 061220 14:48:44 mysqld restarted
I left out URL to source compilation procedure and flags in original message. Here it is: http://homepage.mac.com/kelleherk/iblog/C711669388/E20061121141451/ index.html ANy advice would be really appreciated. Regards, Kieran On Dec 20, 2006, at 3:08 PM, Kieran Kelleher wrote: I have MySQL 4.1.22 source installation on a 1.66 Intel Core Duo Mac Mini running OS X Server 10.4.8. It is a slave replicating to a master over ssl. Replication works fine, however I get this error always if I execute the STOP SLAVE statement ([EMAIL PROTECTED]) (none) stop slave; ERROR 2013 (HY000): Lost connection to MySQL server during query ([EMAIL PROTECTED]) (none) 061220 14:48:44 mysqld restarted Also, if I execute mysqladmin shutdown, it restarts also slmini:/usr/local admin$ mysqladmin -u root -p shutdown Enter password: slmini:/usr/local admin$ 061220 14:59:19 mysqld restarted The source has been compiled with SSL feature. I have exact same installation on a single CPU powerpc G4 XServe with no problems. My installation procedure/flags are here: Any ideas what the problem might be? Should I just rebuild the OS from scratch? Could it be corrupt data that needs to be recopied form the master? I'm baffled at this point. Regards, Kieran -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql? [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ERROR 2013 (HY000): Lost connection to MySQL server during query, 061220 14:48:44 mysqld restarted
Replying to myself again... OK, some more light on the subject. I did a complete dump of the master and reloaded the slave thinking maybe I had corrupt tables or something. Having started the slave with skip-start-slave, I found that I could stop mysqld on command line using mysqladmin without problems. As soon as I started the slave and tried to issue a stop slave, then the crash happened again. So basically the crash only happens if we try and stop the slave threads. This wouls explain why mysaadmin shutdown crashed when slave IO was on, but not when slave IO was stopped. Here is error I got this time for stop slave: stop slave; ERROR 2013 (HY000): Lost connection to MySQL server during query ([EMAIL PROTECTED]) (none) /usr/local/mysql/bin/mysqld_safe: line 1: 401 Illegal instruction nohup /usr/local/mysql/libexec/ mysqld --defaults-extra-file=/usr/local/mysql/data/my.cnf --basedir=/ usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql --pid- file=/usr/local/mysql/data/slmini.local.pid --socket=/tmp/mysql.sock --skip-slave-start /usr/local/mysql/data/slmini.local.err 21 061220 16:02:05 mysqld restarted Any ideas what could be wrong here or is this possibly a bug? Regards, Kieran On Dec 20, 2006, at 3:08 PM, Kieran Kelleher wrote: I have MySQL 4.1.22 source installation on a 1.66 Intel Core Duo Mac Mini running OS X Server 10.4.8. It is a slave replicating to a master over ssl. Replication works fine, however I get this error always if I execute the STOP SLAVE statement ([EMAIL PROTECTED]) (none) stop slave; ERROR 2013 (HY000): Lost connection to MySQL server during query ([EMAIL PROTECTED]) (none) 061220 14:48:44 mysqld restarted Also, if I execute mysqladmin shutdown, it restarts also slmini:/usr/local admin$ mysqladmin -u root -p shutdown Enter password: slmini:/usr/local admin$ 061220 14:59:19 mysqld restarted The source has been compiled with SSL feature. I have exact same installation on a single CPU powerpc G4 XServe with no problems. My installation procedure/flags are here: Any ideas what the problem might be? Should I just rebuild the OS from scratch? Could it be corrupt data that needs to be recopied form the master? I'm baffled at this point. Regards, Kieran -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql? [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
socket error
hi I have this error on mysql engine Could not connect: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13) is there any suggestion my version is 3.23.58 BR
oracle transfer question
There is a oracle SQL: SELECT employee_id, salary, hire_date, STDDEV(salary) OVER (ORDER BY hire_date) Std Deviation of Salary FROM employees WHERE job_id = 'ST_CLERK'; The result is: EMPLOYEE_ID SALARY HIRE_DATE Std Deviation of Salary --- -- -- --- 137 3600 14-7月 -95 0 141 3500 17-10月-95 70.7106781 133 3300 14-6月 -96 152.752523 142 3100 29-1月 -97 221.735578 131 2500 16-2月 -97 435.889894 125 3200 16-7月 -97 389.871774 129 3300 20-8月 -97 357.903951 138 3200 26-10月-97 331.393163 130 2800 30-10月-97 339.116499 139 2700 12-2月 -98 352.136337 143 2600 15-3月 -98 369.028208 EMPLOYEE_ID SALARY HIRE_DATE Std Deviation of Salary --- -- -- --- 140 2500 06-4月 -98 388.762606 144 2500 09-7月 -98 399.679359 134 2900 26-8月 -98 384.664832 126 2700 28-9月 -98 377.586319 127 2400 14-1月 -99 390.72582 132 2100 10-4月 -99 427.974023 135 2400 12-12月-99 430.116263 136 2200 06-2月 -00 443.800703 128 2200 08-3月 -00 453.379126 I transfer the oracle sql to mysql sql: SELECT employee_id, salary, hire_date, STDDEV_pop(salary)Std Deviation of Salary FROM employees WHERE job_id = 'ST_CLERK' Group by employee_id, salary, hire_date ORDER BY hire_date; But the result are: +-+++-+ | employee_id | salary | hire_date | Std Deviation of Salary | +-+++-+ | 137 | 3600 | 1995-07-14 | 0. | | 141 | 3500 | 1995-10-17 | 0. | | 133 | 3300 | 1996-06-14 | 0. | | 142 | 3100 | 1997-01-29 | 0. | | 131 | 2500 | 1997-02-16 | 0. | | 125 | 3200 | 1997-07-16 | 0. | | 129 | 3300 | 1997-08-20 | 0. | | 138 | 3200 | 1997-10-26 | 0. | | 130 | 2800 | 1997-10-30 | 0. | | 139 | 2700 | 1998-02-12 | 0. | | 143 | 2600 | 1998-03-15 | 0. | | 140 | 2500 | 1998-04-06 | 0. | | 144 | 2500 | 1998-07-09 | 0. | | 134 | 2900 | 1998-08-26 | 0. | | 126 | 2700 | 1998-09-28 | 0. | | 127 | 2400 | 1999-01-14 | 0. | | 132 | 2100 | 1999-04-10 | 0. | | 135 | 2400 | 1999-12-12 | 0. | | 136 | 2200 | 2000-02-06 | 0. | | 128 | 2200 | 2000-03-08 | 0. | +-+++-+ Why all the compute column values are 0?What is the correct sql? thanks!
How to transfer the oracle function PERCENT_RANK to mysql
How to transfer the oracle function PERCENT_RANK to mysql? oracle example: SELECT PERCENT_RANK(11000) WITHIN GROUP (ORDER BY salary DESC) Rank of $11,000 among managers FROM employees WHERE job_id LIKE '%MAN' OR job_id LIKE '%MGR';
How to transfer the oracle function PERCENT_RANK to mysql
How to transfer the oracle function PERCENT_RANK to mysql? oracle example: SELECT PERCENT_RANK(11000) WITHIN GROUP (ORDER BY salary DESC) Rank of $11,000 among managers FROM employees WHERE job_id LIKE '%MAN' OR job_id LIKE '%MGR';
oracle transfer question
There is a oracle SQL: SELECT employee_id, salary, hire_date, STDDEV(salary) OVER (ORDER BY hire_date) Std Deviation of Salary FROM employees WHERE job_id = 'ST_CLERK'; The result is: EMPLOYEE_ID SALARY HIRE_DATE Std Deviation of Salary --- -- -- --- 137 3600 14-7月 -95 0 141 3500 17-10月-95 70.7106781 133 3300 14-6月 -96 152.752523 142 3100 29-1月 -97 221.735578 131 2500 16-2月 -97 435.889894 125 3200 16-7月 -97 389.871774 129 3300 20-8月 -97 357.903951 138 3200 26-10月-97 331.393163 130 2800 30-10月-97 339.116499 139 2700 12-2月 -98 352.136337 143 2600 15-3月 -98 369.028208 EMPLOYEE_ID SALARY HIRE_DATE Std Deviation of Salary --- -- -- --- 140 2500 06-4月 -98 388.762606 144 2500 09-7月 -98 399.679359 134 2900 26-8月 -98 384.664832 126 2700 28-9月 -98 377.586319 127 2400 14-1月 -99 390.72582 132 2100 10-4月 -99 427.974023 135 2400 12-12月-99 430.116263 136 2200 06-2月 -00 443.800703 128 2200 08-3月 -00 453.379126 I transfer the oracle sql to mysql sql: SELECT employee_id, salary, hire_date, STDDEV_pop(salary)Std Deviation of Salary FROM employees WHERE job_id = 'ST_CLERK' Group by employee_id, salary, hire_date ORDER BY hire_date; But the result are: +-+++-+ | employee_id | salary | hire_date | Std Deviation of Salary | +-+++-+ | 137 | 3600 | 1995-07-14 | 0. | | 141 | 3500 | 1995-10-17 | 0. | | 133 | 3300 | 1996-06-14 | 0. | | 142 | 3100 | 1997-01-29 | 0. | | 131 | 2500 | 1997-02-16 | 0. | | 125 | 3200 | 1997-07-16 | 0. | | 129 | 3300 | 1997-08-20 | 0. | | 138 | 3200 | 1997-10-26 | 0. | | 130 | 2800 | 1997-10-30 | 0. | | 139 | 2700 | 1998-02-12 | 0. | | 143 | 2600 | 1998-03-15 | 0. | | 140 | 2500 | 1998-04-06 | 0. | | 144 | 2500 | 1998-07-09 | 0. | | 134 | 2900 | 1998-08-26 | 0. | | 126 | 2700 | 1998-09-28 | 0. | | 127 | 2400 | 1999-01-14 | 0. | | 132 | 2100 | 1999-04-10 | 0. | | 135 | 2400 | 1999-12-12 | 0. | | 136 | 2200 | 2000-02-06 | 0. | | 128 | 2200 | 2000-03-08 | 0. | +-+++-+ Why all the compute column values are 0?What is the correct sql? thanks!
Re: howto query DELETE all records having invalid table refs
Hi, Try, mysql delete from GbEntries where sender not in (select * from Accounts); Thanks ViSolve DB Team. - Original Message - From: Christian Parpart [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Wednesday, December 20, 2006 3:11 PM Subject: howto query DELETE all records having invalid table refs -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: leading the technological bandwagon
You should send that one to The Daily WTF... http://thedailywtf.com/ Jay Blanchard wrote: [snip] I recently last week Had and experience with an Very small Company, where as they had around 15 Machines all hooked Star topology and a central iis ASP Web server that only showed the date, and a few small utilities when addressed To it, now there entire Operation was based upon Excel, everything not joking I mean everything, was a file share to an Folder (around 90 Folders) in which they had probably 200 + excel sheets in each one u name something u need to do in business I guarantee there was a excel sheet for it, repetitive sheets for Different Operations, all Sheets linked to one another thru references in excel, excel97 Mind u, I was there on a Consulting call, to inform them of a better way to update / Operate there business They ended up saying they liked there Current way better it makes more sence to them and Only wanted me to link 10 more sheets to what they already had and add a few more file shares, of Course I refused this Project and walked out Laughing my ass off in the car [/snip] Seriously? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]