mysql prob.

Hi, Platform is red hat linux-9.. my hardware is 2.8GHz pentium-4 with 512 GB ram.. softwares are Bugzilla 2.18 ,mysql-standard-4.0.15-pc-linu­x-i686, httpd-2.0.40-21 now problem is when i m trying to take back up of mysql by passing the command.. /usr/local/mysql/bin/mysqldump

Re: mysql prob.

Manish wrote: Hi, Platform is red hat linux-9.. my hardware is 2.8GHz pentium-4 with 512 GB ram.. softwares are Bugzilla 2.18 ,mysql-standard-4.0.15-pc-linu­x-i686, httpd-2.0.40-21 now problem is when i m trying to take back up of mysql by passing the command..

RE: mysql prob.

Hi Manish, How you r connecting to mysql. Just try the same way. What bugs keyword stand in the command. Perhaps you have to use mysqldump -S /tmp/mysql.sock2 -uroot Regards, Anurag -Original Message- From: Manish [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 20, 2005 12:14 PM To:

mysql server does not close tables

Hi all, We have a Mysql 4.0.24 running on FreeBSD 4.11 Yesterday server started to refuse new connections, while the established connections did function properly. I discovered that the problems start when the number of open tables reaches 20, the table_cache size is 64. I also discovered that

database problems.

Hi all, The moral of the story, is don't run out of disk space, but it's a bit to late for that now. A quick scenario One master server, two backups replicating from the master. Our data and bin logs are on two different partitions, and the partition holding the bin logs, ran out of disk

Socket Problem

Hi, i try to use mysql with stunnel (http://stunnel.org) in order to encrypt my mysql connections. I know that mysql-4.x supports SSL but i can't compile it on my windows box. When i try to use stunnel on my windows box, it works, i just have to use this command : mysql -u user

Re: Socket Problem

[EMAIL PROTECTED] wrote: Hi, i try to use mysql with stunnel (http://stunnel.org) in order to encrypt my mysql connections. I know that mysql-4.x supports SSL but i can't compile it on my windows box. When i try to use stunnel on my windows box, it works, i just have to use this command :

Re-2: Socket Problem

mysql is trying to connect to localhost by default. Yes, i know that, but with stunnel, when i connect to localhost, it is suppose to connect to the remote server. LinuxBox - 3306 - stunnel - 3307 3307 - stunnel - 3306 - Server On my linux box, i try to connect to local port 3306 and

RE: MySQLDump - Command line password

Hi, For confirming that password is shown or not in ps -ef, just try to connect to your server using your password ,then in a new window just do ps -ef --width 400 |grep mysql You will find the output like below which doesn't show the password -uroot -px xxx Atleast it is not showing in

Re: mysql server does not close tables

Hello. table_cache size is 64. I also discovered that the server does not close the tables automatically, e.g. if you open two windows and start MySQL usually closes tables only in some cases. See: http://dev.mysql.com/doc/mysql/en/table-cache.html What error do you obtain when

Re: mysql prob.

Hello. See: http://dev.mysql.com/doc/mysql/en/can-not-connect-to-server.html Manish [EMAIL PROTECTED] wrote: Hi, Platform is red hat linux-9.. my hardware is 2.8GHz pentium-4 with 512 GB ram.. softwares are Bugzilla 2.18 ,mysql-standard-4.0.15-pc-linu­x-i686,

Conditional insert or update.

Hi, I have a table that looks something like this: ip | mac_current | mac_change now if I have an entry that looks like this 10.0.0.1 | 11:11:11:11:11:11:11 | NULL If the next time the script runs and the mac has changed, how can I catch this and put the new MAC into mac_change? Ultimately,

Re: Socket Problem

Hello. First check if you are able to establish TCP connection to port which is linked by stunnel. Telnet or netcat could be helpful in this case. Use --host=xxx --protocol=tcp --port=xxx to explicitly specify connection parameters. See:

Re: MySQLDump - Command line password

Cabbar Duzayak wrote: ... I have setup cronjobs to take daily backups of my db using mysqldump. But the problem is, mysqldump requires the password to be passed via command line, which means anyone on the same machine can take a peek at my password using top, ps -ef, etc. Is there a way of

Re: Fw: table export problem

Hi all, Juan Pedro Reyes Molina wrote: I have been able to create your table in my mysql 4.1.12 I think your remote server is in mysql 4.0 series I had the same problem some days ago. I can almost garantee that the local server is running MySQL 4.1.x, and I can garantee (99.99%

Re-2: Socket Problem

When i try mysql -h server --port=3306 --protocol=TCP -u user --password=xxx it works! The real problem is when using stunnel, i have to do as if i will connect to a local server... On windows it works but not on linux... :( Original Message Subject: Re: Socket Problem

Re: Conditional insert or update.

Hello. Please, provide more information on your's application logic. To catch events which occurs for the table use triggers. See: http://dev.mysql.com/doc/mysql/en/triggers.html Unfortunately they're available only in MySQL 5.0.x, which is still beta. Paul Halliday [EMAIL

Re: Re-2: Socket Problem

[EMAIL PROTECTED] wrote: When i try mysql -h server --port=3306 --protocol=TCP -u user --password=xxx it works! The real problem is when using stunnel, i have to do as if i will connect to a local server... On windows it works but not on linux... :( Original Message

random rows selection

Hello, How to select 5 random rows from big table with WHERE clause? This query very slow on 1 mln rows: SELECT col1, col2 FROM table WHERE col3=123 ORDER BY RAND() LIMIT 5 Have you a faster one? Sincerely, Michael, http://xoib.com/ http://3d2f.com/ http://qaix.com/ http://ryxi.com/

How to know if a migration might have problems

Hi all, I have a MySQL server version 4.1.10a, for pc-linux-gnu (i686) installed (from official binary RPMs) and running. My question is if there are problems from updating the server to the most current version of the 4.1.x series, specially things that fail to work, or database

Re: random rows selection

Hello. Similar questions have been asked before. For example: http://lists.mysql.com/mysql/184088 Search in archives at: http://lists.mysql.com/mysql Michael Monashev [EMAIL PROTECTED] wrote: Hello, How to select 5 random rows from big table with WHERE clause?

Re: Re-2: Socket Problem

Hello. Are you able to connect to 3306 port on your localhost using telnet or netcat? You should check if stunnel works properly on Linux. Bastian Balthazar Bux [EMAIL PROTECTED] wrote: [EMAIL PROTECTED] wrote: When i try mysql -h server --port=3306 --protocol=TCP -u user

Re: random rows selection

Put a index on col3 and it will be faster. That's the only way as far as I know. -- Chris. - Original Message - From: Michael Monashev [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Wednesday, July 20, 2005 3:04 PM Subject: random rows selection Hello, How to select 5 random

Re-4: Socket Problem

I have already test and it doesn't work, my stunnel doesn't work properly. I have asked my question on stunnel-users mailing list but i d'ont have answer for the moment... Thanks for your help! Original Message Subject: Re: Re-2: Socket Problem (20-juil.-2005 16:11) From:

Re: How to know if a migration might have problems

Nuno Pereira wrote: Hi all, I have a MySQL server version 4.1.10a, for pc-linux-gnu (i686) installed (from official binary RPMs) and running. My question is if there are problems from updating the server to the most current version of the 4.1.x series, specially things that fail to work,

copying rows from one MySQL server to another

I am working on a MySQL application where laptops will be collecting data into local MySQL tables, and then once a week they will be network-connected to a central server where they will check in their new data and check out new assignments for data collection. given a set of rows in a set of

Re: random rows selection

Hello GP Similar questions have been asked before. For example: GP http://lists.mysql.com/mysql/184088 Thank you. I found something interesting: SELECT @rand_id:= CAST( 1 + MAX(id)*RAND() AS UNSIGNED) FROM history; SELECT * FROM history WHERE id = @rand_id LIMIT 1; But this query can return

Re: Conditional insert or update.

Ok, The entire table looks like this: ip | hostname | mac_current | mac_change | port_current | port_change The IP addresses are harvested via netflow (a different table) and or arpwatch (an event). This new table is to augment the current information that is within the netflow tables but

Remove Unique Key

I have a field that was set as a unique key when created via: UNIQUE KEY `username` (`username`) I no longer want it unique, but can't see a way with ALTER TABLE to remove it. It isn't the Primary Key or an index. The describe looks like this:

Re: Remove Unique Key

www.mysql.com/doc search drop index Eric Jensen wrote: I have a field that was set as a unique key when created via: UNIQUE KEY `username` (`username`) I no longer want it unique, but can't see a way with ALTER TABLE to remove it. It isn't the Primary Key or an index. The describe looks

Re: Remove Unique Key

Eric Jensen [EMAIL PROTECTED] wrote on 07/20/2005 02:00:26 PM: I have a field that was set as a unique key when created via: UNIQUE KEY `username` (`username`) I no longer want it unique, but can't see a way with ALTER TABLE to remove it. It isn't the Primary Key or an index. The describe

Group by Month

I have query that pulls data between to dates. How to group the data by month? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Group by Month

[snip] I have query that pulls data between to dates. How to group the data by month? [/snip] It would be better if you showed use the query, but heh...our mind reading skills are getting pretty good. At the end of your query put the line; GROUP BY month -- MySQL General Mailing List For list

Re: mysql server does not close tables

Hello. | | open_files_limit | 50 You have a very low value for open_files_limit. Increase it to several thousands. See: http://dev.mysql.com/doc/mysql/en/not-enough-file-handles.html Please next time send you answers to the list. On 7/20/05, Gleb Paharenko [EMAIL

Re: copying rows from one MySQL server to another

Les Schaffer [EMAIL PROTECTED] wrote on 07/20/2005 12:06:46 PM: I am working on a MySQL application where laptops will be collecting data into local MySQL tables, and then once a week they will be network-connected to a central server where they will check in their new data and check out

Re: SQLyog Enterprise

Hello, I find SQLyog Enterprise an indispensable tool. Your $49 will be saved within the first 3 days of use because of improved productivity with MySQL. Karam --- Scott Hamm [EMAIL PROTECTED] wrote: I'm contemplating buying SQLyog Enterprise for $49 dollars (non-commerical) for personal

Re: SQLyog Enterprise

Love it - use it all the time. Saw it at the Mysql conference, bought it that night. Use it every day. Well worth $50. I'm contemplating buying SQLyog Enterprise for $49 dollars (non-commerical) for personal use. Do anyone use it and how does it fare in your opinion? -- Power to people, Linux

SELECT by date plus get both next and last dates with data in it

Hello, Having some problems trying to get the correct data from MySQL. I need to grab a bunch of information based on a date the user selects (no problem there). However, this is an events type situation, where I want to give people an easy option to move forward or backwards through the

Re: SELECT by date plus get both next and last dates with data in it

me you [EMAIL PROTECTED] wrote on 07/20/2005 03:05:30 PM: Hello, Having some problems trying to get the correct data from MySQL. I need to grab a bunch of information based on a date the user selects (no problem there). However, this is an events type situation, where I want to give

Re: database problems.

Hi Chris, I have run into this myself before as well, where the partition housing the bin log filled up. In our case, there weren't failed queries on the master; the integrity of data on the master was fine, and the slave was simply out of date, but not error-full. However, even in that case

RE: Group by Month

group by date_format(field_type_date,'%Y/%m' ) -Original Message- From: Jerry Swanson [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 20, 2005 1:08 PM To: mysql@lists.mysql.com Subject: Group by Month I have query that pulls data between to dates. How to group the data by month?

Insert decimals with rounding

Hi all. I am trying to figure out if there is a way to configure MySQL so that when inserts occur on decimal fields where the value being inserted has more precision than the field specification, then the value inserted is rounded instead of truncated. For example, if i have a column: Acres

Make a report like this...

+--+---+++-+ | G_ID | TOTAL | G2 | NR | ASSEMBLY_LISTING| +--+---+++-+ | 1132 |34 | 1 | 1 | 1bf3-1,1bgj-1,1bgn-1,1bkw-1,1cc4-1, | | | |||

Re: Insert decimals with rounding

on 7/20/05 2:23 PM, sean c peters at [EMAIL PROTECTED] wrote: Hi all. I am trying to figure out if there is a way to configure MySQL so that when inserts occur on decimal fields where the value being inserted has more precision than the field specification, then the value inserted is rounded

Re: Make a report like this...

Dan Hello, I made the above report by hand after using a GROUP_CONCAT query. Is there any way to make this kind of format automatically in MySQL? How about HTML output (mysql ... -H)? PB -- Dan Bolser wrote: +--+---+++-+ | G_ID |

Bit keeper download problem ?

Hello, When I am trying to download mysql from the repository, I am running into some problem. Earlier about a month back, it was working fine, but its only recently I am facing this problem. Anyone can please shed some light on it? Thanks. This is the command which I am using bk clone

Re: table export problem

Which version of mysql are you exporting from and inserting into? [EMAIL PROTECTED] wrote: Hi all, I am trying to create a table on the remote server from a table I created on my local sever but it never seems to work CREATE TABLE `sheet1` ( `id` int(10) NOT NULL auto_increment, `title`

Re: Make a report like this...

On Wed, 20 Jul 2005, Peter Brawley wrote: Dan /Hello, I made the above report by hand after using a GROUP_CONCAT query. Is there any way to make this kind of format automatically in MySQL?/ How about HTML output (mysql ... -H)? Yeah, I found that works, for example also with 'GROUP_CONCAT(

Re: Make a report like this...

You might try --xml or --html with a different separator. Greg -- Greg Fortune Enterprise Systems Eastern Washington University Phone: 509-359-6690 Email: [EMAIL PROTECTED] On Wednesday 20 July 2005 03:28 pm, Dan Bolser wrote: +--+---+++-+

Mac OS PrefPane

Greetings! I have begun using the preferences pane that came in the official binary [4.1.12] instead of always manually starting stopping the server. This is a nice improvement as Mac OS X client edition doesn't come with this, and i've only recently seen it in the package. However, it

Re: SQLyog Enterprise

Hi Karam, I have seen you recommending SQLyog on the list for quite some time by now. May I ask, are you just a REALLY happy customer or otherwise somehow involved in the company which is producing it posting from your private e-mail ;-) ? Best regards Nils Valentin Tokyo / Japan

Re: SQLyog Enterprise

It's a bit weak on foreign keys, no support for procedures and views (if you're looking at MySQL 5) from a gui perspective (from what I have found). Other plus points are it has a http tunnel feature if you host your mysql database with someone (requires php on the hosted server), so you can

Re: SQLyog Enterprise

Also check out EMS MySQL Manager. I looked at every MySQL tool I could get my hands on, and ended up buying a license of this. Main site is here: http://sqlmanager.net/products/mysql/manager/ Feature list is here: http://sqlmanager.net/en/products/mysql/manager/features It also has access

temp table cannot be created?

any ideas on this? google has not helped. can temp tables be innodb? can they have fk? mysql mysql create temporary table bvolsetparents - ( - volset int not null, - ancestor int not null, - primary key (volset,ancestor), - foreign key (volset) REFERENCES bvolset(id),

Re: copying rows from one MySQL server to another

On Wednesday 20 July 2005 10:06am, Les Schaffer wrote: I am working on a MySQL application where laptops will be collecting data into local MySQL tables, and then once a week they will be network-connected to a central server where they will check in their new data and check out new

Re: Insert decimals with rounding

sean c peters wrote: Hi all. I am trying to figure out if there is a way to configure MySQL so that when inserts occur on decimal fields where the value being inserted has more precision than the field specification, then the value inserted is rounded instead of truncated. Rounding is what

Report tools

Any report tools that can be use with Mysql that you guys can recommend? Any free mysql report generators? Thanks, Nestor :-) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]