communication error
The following is an example of an error in our mysql log files: [Warning] Aborted connection 1519045 to db: 'ES_buildings' user: 'esbuildweb' host: 'nrn7.nrcan.gc.ca' (Got an error reading communication packets) Is there some way to determine why/when that happens and to fix our setup so it is corrected? mysql: Ver 14.12 Distrib 5.0.22, for sun-solaris2.8 (sparc) using EditLine wrapper Thanks for any insights. Chris Jones 14 Oneida Avenue Toronto, ON M5J 2E3. Tel. 416-203-7465 Fax. 416-946-1005 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
INSERT into select ... ON DUPLICATE KEY??
I am tying to dupilicate a set of records changing only one field. That field is part of a UNIQUE key. So far I copy the records into themselves and keep the same number of records: insert ignore into user_projects select * from user_projects where user_id=[EMAIL PROTECTED] and fac_id=FAC-0002 ON DUPLICATE KEY UPDATE FAC_ID=FAC-0003 Now in my untrained mind, this should create 4 new, identical records with only the fac_id field changed. Where am I going wrong? Thanks. Chris Jones 14 Oneida Avenue Toronto, ON M5J 2E3. Tel. 416-203-7465 Fax. 416-946-1005 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Is there a way to load non-native Date type with LOAD DATA
Use a command line tool to change the date. I am only familiar with perl and it would be a very short script to change to -MM-DD. At 10:48 PM 9/2/2006, David Perron wrote: I have a pretty large file with a Date column in the format M/D/. Is there a way to either change the Date data type in the table or a method to indicate the date format in the LOAD DATA statement in order to handle this? Thanks in advance for any help! David -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] Chris Jones 14 Oneida Avenue Toronto, ON M5J 2E3. Tel. 416-203-7465 Fax. 416-946-1005 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Table permissions - before the table is created?
Can the mysql administrator grant permissions on a table in an existing database if that table doesn't exist yet? This is part of planning for an upgrade to an existing application. The mysql administrator won't be there when I add the table to the existing database and I don't have grant privileges. Chris Jones, P.Eng. 14 Oneida Avenue Toronto, ON M5J2E3 Tel. 416 203-7465 Fax. 416 946-1005 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Table permissions - before the table is created?
Thanks for that. Will create the two tables ahead of time which won't affect the existing application. At 11:57 30/08/2006, [EMAIL PROTECTED] wrote: Chris Jones wrote: Can the mysql administrator grant permissions on a table in an existing database if that table doesn't exist yet? This is part of planning for an upgrade to an existing application. The mysql administrator won't be there when I add the table to the existing database and I don't have grant privileges. You can't do this using a grant statement because it is bound by existing tables. You may be able to manipulate the mysql db tables directly - I was able to insert a row in mysql.tables_priv for a nonexistent table - but I don't know how this will play out once the table actually is created. Perhaps give it a try on a test db...? David -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] Chris Jones, P.Eng. 14 Oneida Avenue Toronto, ON M5J2E3 Tel. 416 203-7465 Fax. 416 946-1005 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Newbie - Where do I look for answers?
If you are familiar with MS-SQL and SQL in general then reading the manual should be no problem. Likewise, using a command line interface should be second nature. The MySQL manual is very complete. See chapter 4. In particular see 4.3, it very clearly explains how to setup the root password and how to setup new users. I am a complete newbie to mysql and Linux. I completed the installation of the 4.0 version of MySQL/InnoDB, and now I am stuck with permission problems: Logging in with empty username/password lets me look at the initial state of the db, but creating new users or new tables through any front end fails with permission problem messages. SQL (MS-SQL) is second nature to me, but this is not. - Where do I find an EASY, straight forward manual about MySQL administration on Linux - As the root user, how (and where) do I create new MySQL users, set permissions correctly? I would be very greatful for any help Dietrich - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Chris Jones, P. Eng. 14 Oneida Avenue Toronto, ON M5J 2E3 Tel. 416 203-7465 Fax. 416 203-8249 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php