log-slow-queries

Can't get slow querys to log. Does this not work in myisam? *snip* [mysqld] log-slow-queries = /var/log/mysql/mysql-slow.log long_query_time = 1 *snip* restarted mysqld - no log. Created in file in /var/log/mysql/ *snip* -rwxr--r-- 1 mysql mysql 0 May 7 10:33 mysql-slow.log *snip* still

RE: Bogus unsubscribe!

I got this recently and haven't replied to the list in a while. I responded to the list owner. -Original Message- From: Martijn Tonies [mailto:[EMAIL PROTECTED] Sent: Monday, February 25, 2008 12:13 PM To: mysql@lists.mysql.com Subject: Re: Bogus unsubscribe! I just got an email

RE: Backup table structure, not data

This works fine for me: http://www.mysql.com/products/tools/administrator/ -Original Message- From: Esbach, Brandon [mailto:[EMAIL PROTECTED] Sent: Monday, February 18, 2008 12:22 PM To: [EMAIL PROTECTED] Cc: MySQL User Group Subject: RE: Backup table structure, not data I ended up

sequential numbering in Auto_Increment Field across two tables

I have two tables. TableA is current data. TableB (created with 'Create Table A like Table B' ) is an archive where deleted data is inserted from Table A before being deleted from table B with INSERT INTO TableA Select * , Null, NOW (), 'ACTION', 'USER' from TableA. The null column in TableB

secure host and user name for non static ip address

QUESTION: What are the most secure permissions settings for administrator access to connect to my server without using a static IP address? MY ISP changes my DSL ip address almost daily so when I log on to MySQL Administrator with 'myusername'@'currentipaddress' using password 'mypassword' I

Finding empty feilds

I executed an insert...select and some empty fields were inserted into a table. I'm trying to delete these empty fields but a look up for: FIELD = '' FIELD = 'null' FIELD = '0' FIELD = '[SPACE]' Returns nothing. What should I be looking for to delete these empty fields? Thanks. -- MySQL

RE: Finding empty feilds

I was able to delete them using the CreateDate timestamp. For future reference what is the difference between = and is if I may ask. Thanks. -Original Message- From: Gary Josack [mailto:[EMAIL PROTECTED] Sent: Saturday, September 22, 2007 1:20 PM To: Stephen Sunderlin Cc: mysql

RE: Finding empty feilds

Thanks! -Original Message- From: Gary Josack [mailto:[EMAIL PROTECTED] Sent: Saturday, September 22, 2007 2:47 PM To: Stephen Sunderlin Cc: mysql@lists.mysql.com Subject: Re: Finding empty feilds NULL does not equal , , null, 0, 0 or any other variation. Those are all values. NULL

Changing Big Big integer Value

I've recently converted a CRM database with about 20k entries. I exported the data to ACCESS had to tweak the field names and value then Inserted all into mySQL with mySQL Administrator. During the conversion out of the CRM into ACCESS the unique Primary Key for each contact, which is also the

RE: Import file into MySQL Database..

If you can import your excel doc into MS Access I'd suggest: http://www.mysql.com/products/tools/migration-toolkit/ I just started using and love it - easy intutitive GUI tool for importing data into nySQL databases. Good luck. -Original Message- From: Jason Pruim [mailto:[EMAIL