Query from two databases

In each database I have a table with one column I want to compare and then count. So db1.a.odip and db2.aa.newip are the databases, table and coulumns. The data in each column is Ip's, so my result would be a list and count for each by subnet. So the result would be like: db1.a.odip count

Db query help

In each database I have a table with one column I want to compare and then count. So db1.a.odip and db2.aa.newip are the databases, table and coulumns. The data in each column is Ip's, so my result would be a list and count for each by subnet. So the result would be like: db1.a.odip count

Question on Query

If you have a varchar column (late) that holds a timestamp like: 2003-11-01 08:45:12 Can you use this select statement: select * from table where DATE_FORMAT(`late`, '%Y-%m-%d') > '2003-11-01'; Even though the varchar column is not at datetime,timestamp column... Rob -- MySQL General Mailing L

Tune ?

Hello, Is there any RH 9 kernel tuning tips for system running Mysql 4.0 db? Thanks Rob -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MySQL with SSL enabled

Hello, I am in the process of installing Mysql 4.0.17. I need to have Mysql with SSL enabled. Does this feature come enabled with the binary download? Or do I need to download the source and compile it? Any good links ot setting up MySQL with SSL enabled? Thanks Rob -- MySQL General Mail

? about user and db table

Hi, I'm trying to uderstand the difference between these tables (mysql.user, mysql.db) v.4.0. I want user "usera" from "hostname1" to connect to "hostname2" which is where the Mysql db is running and have only select priv on db "db_1". "Hostname1" has mysql clients on it. Host: mysql> select

Help with Update statement

Hello, I have a db that a script failed to run against, and becasue of that a column did not get updated. I have a varchar col that has unixtime timstamp in it. That column gets converted to be readable. My problem is I have many rows that need to be updated, but I dont want to re-convert t

CHECK TABLE results

I'm getting an error when trting to update a table: ERROR 1034: Incorrect key file for table: 'Jan04'. Try to repair it So I ran CHECK TABLE, What does this result mean: mysql> CHECK TABLE Jan04 QUICK; +---+---+--++

Repair Table Hung?

Help. I have a REPAIR table command that has been running since 1/15... I dont know if its hung or what? Should I kill it ? Top shows that it seems to be running? mysql> show processlist; ++--+---+-+-++--+--

2nd Request Repair Table Hung?

Help. I have a REPAIR table command that has been running since 1/15... I dont know if its hung or what? Should I kill it ? Top shows that it seems to be running? mysql> show processlist; ++--+---+-+-++--+--

table design question

I have "ip_address" and "ports" that I want to use in my table. I was just going to make each one a varchar. But was wondering if anyone has a better suggestion? Should I use int for "ports", which will have an index. Not sure how to store "ip_address". This table has the possibility of having

index question

I ran an insert..select from one table to the other ( changed some column types to int from varchar on new table). the insert went fine. mysql> INSERT INTO Feb04_int SELECT * from Feb04; Query O

index question part 2

ssage- From: rmck <[EMAIL PROTECTED]> Sent: Feb 4, 2004 7:33 AM To: [EMAIL PROTECTED] Subject: index question I ran an insert..select from one table to the other ( changed some column types to int from varchar on new table). the insert went fine. mysql> INSERT INTO Feb04_int SELECT

date column question

I have a varchar field "start" on my db that stores dates. The dates are loaded into mysql from a txt file which are like this "2004-02-10 23:35:12" in the txt file. I'm thinking this is not a correct choice of datatype for the column which is called "start". What is the best or recommended dat

Query Help

I have two tables: DB 1: Table A: Userid: Dept: DB 2: Table B: Userid: Dept: Location: How would I query from DB 1 Table A for the Dept if I want to use that value for DB 2’s Dept? Both DB’s and tables have the same Userid. Does not work: Use 2; Select A.Dept from A where B.Userid = ‘sam’;

Select help

Hi, I have a table with ip,port and I want to see the top ten Ip's with the most entries? Ip's can be in db many times... Not the first distinct 10... Im stuck... I have tried: mysql> select DISTINCT ip from iptable limit 10;

load data in file with pipe

hello, I was tring to understand the steps to read from pipe and load using LOAD DATA INFILE? I dont understand the "x's" or the cat of tcp, can someone shed some light on this for me?? mkfifo /mysql/db/x/x chmod 666 /mysql/db/x/x cat < /dev/tcp/10.1.1.12/4711 > /mysql/db/x/x mysq

How to import data to diff tables

I have a table with 9 columns, one is an auto_increment for primary key. Data set: 2004-09-21 10:35:50,2004-09-21 10:45:48,tcp,111.111.111.111,80,222.222.222.222,1555,4700 Currently I just dump everyting into one table and query it that way. I was hoping to learn how to place the data into diff

Error 127 = Record-file is crashed

Hello, I have "mysql-standard-4.0.16-pc-linux-i686" installed on a 4gig mem, 2cpu system, RH 9. I have a large table (Data records: 72426930) that is now giving me this error "Error 127" when doing selects... This is my first crash of any kind with Mysql. So I'm a liitle confused on what I s

MYI file

Hello, I have had some Error 127 on my system so I ran myisamchk -rf when mysqld was down. Now I noticed my .MYI file is at 1024K: -rw-rw1 mysqlmysql1024 Nov 11 16:33 table.MYI My .MYD, .frm are still there: -rw-rw1 mysqlmysql8802 Nov 6 07:04 table.frm

LOAD DATA ?

Hello, My Load data command seems not to load data into my db: mysql> load data local infile '/opt/week/ip.0311100440' into table logs.Nov03 ignore 2 lines; Query OK, 1 row affected (0.66 sec) Records: 48273 Deleted: 0 Skipped: 48272 Warnings: 48273 mysql> I have plenty of space where my d

create own auto increment number

I have a request to create an auto increment field that increments like so: 1-112403 2-112403 3-112403 4-112503 etc... Is that possible??? Any variant of that is fine the big issue is they want the Date with the ID number of the record. Thanks, Rob -- MySQL General Mailing List For list arc

mysql openssl Question

Hello, I have a redhat system that is running mysql with openssl for secure connections. There was just a rpm update from redhat for openssl. I applied that and mysql/openssl connections seem fine. But my question is do I need to recomplie mysql to use the latest openssl This was a custom

select from two tables

Hi I have two tables in the same Db : table 1: helpdesk | CREATE TABLE `helpdesk` ( `wcalledname` varchar(50) default NULL, `wcalledphone` varchar(50) default NULL, `wcalledemail` varchar(50) default NULL, `typeof` varchar(50) default NULL, `status` varchar(25) default NULL, `reason

select from two tables #2

Hi I have two tables in the same Db : table 1: helpdesk | CREATE TABLE `helpdesk` ( `wcalledname` varchar(50) default NULL, `wcalledphone` varchar(50) default NULL, `wcalledemail` varchar(50) default NULL, `typeof` varchar(50) default NULL, `status` varchar(25) default NULL, `reason

mysql remote to apache

Is there a good tutorial on installing Mysql on one machine and having Apache on another? I'm thinking on the server with Apache I guess you would just compile Apache with the mysql/php and in your php scripts just point to the hostname of the mysql server? Making sure you can talk to port 330

One Mysql For loads and one for query

I have a Mysql db that is loaded with about 500,000 records a night using LOAD DATA INFILE. This goes on for a month then a new table is created and so on. Then data is then just queryed nothing else. To take some stress off of this server I was wondering if there is a way to have One Mysql ser

Re: One Mysql For loads and one for query

import to a table that does not match the text file it is reading from?? >From manual: mysqlimport strips any extension from the filename and uses the result to determine which table to import the file's contents into. Im sure someone can help me?? Rob -Original Message- Fr

help reading test-select

Hi, I was running the test-select under the /usr/local/mysql/sql-bench dir and was wondering if someone could help break it down for me ( Or at least the "Testing big selects on the table" section ) Thanks : [EMAIL PROTECTED] sql-bench]# perl test-select --password='d'