Non - Responding State of Mysql

It has been a few times when I bump into this situation, and I would like to know if anyone has solutions for this: When I "ALTER" a table that contains a lot of data, or enter a long long complex query by mistake, it seems like the query (or action) is taking up all that the server can hand

Re: A Beginner's Query

>query processed . But how to view the structure of the table. I mean I am >not able to do anything even after mysql> prompt appears. I have the >documentation. Can Anyone guide me on this I could write it all, I'm sure many on this list can. It's pretty useless though.. Checkout the manual

Perl script mysqlhotcopy error ... (errno: 24)

Hi, I got this error using mysqlhotcopy: DBD::mysql::db do failed: Can't find file: './Tecnowind/tqgrppia.frm' (errno: 24) at /usr/local/mysql/bin/mysqlhotcopy line 375. Issuing rollback() for database handle being DESTROY'd without explicit disconnect(). and perror 24 says: Error code 24:

Left join together with group by

Hi, I'm curious if I can use "Left Join" together with "group by" as shown below SELECT tbl_data.d1, tbl_customers.c1 FROM tbl_data LEFT JOIN tbl_customers ON tbl_data.d1 = tbl_customers.d1 group by tbl_data.d1, tbl_customers.c1; or is this the way to go? Select DISTINCT(tbl_data.d1), tbl_cust

Platform Requirements

Hi all, I'm a newbie so be gentle. I've looked but unfortunately can't find any information on the minimum hardware specification for MqSQL 3.23. eg minimum recommended amount of RAM, Speed and number of Processors etc. I'd appreciate it if anybody could send any of this information for eit

Re: beggin, commit, and rollback

KB> Doesn't mysql support begin and rollback transactions? I *believe* it went like this -- syntax supported and returned success without doing anything in older versions, then functionality was actually *implemented* more recently -- maybe only most recent stable release? (v3.23)

Re: fastest queries

On 04.04.2001 16:42:28 ?iso-8859-1?Q?Ren=E9_Tegel?= wrote: > not for speed, but i defitively prefer your second query. Reason for this is > simple: you name the field you want to insert. Yes, you are right. But I prefer a third way altogether: INSERT INTO Tbl SET Field=42; The reason fo

Re: Storing pictures in mySQL

On 05.04.2001 04:23:55 Taing Nguon wrote: > I am not sure what you explained. You mean that place PATH/filename.jpg to > picture field. isn't it? If yes, it is just a text. How can we explore that > picture thru web browser such as IE or Netscape? Thanks for the answer Well, he said that he ha

MySQL full-indexing

Hi, all. I'm a newbie so be gentle I have a quastion about new feature of MySQL - Full-text indexing (http://www.mysql.com/doc/M/y/MySQL_full-text_search.html). Cutting: "Since Version 3.23.23, MySQL has support for full-text indexing and searching. Full-text indexes in MySQL are an index of typ

Re: Platform Requirements

I've got MySQL 3.23.21 on a W98 box with a P90 and 32Mb RAM. And it works fine. It's a bit slower than a PIII 600 but it works great ;) Yoann - Original Message - From: "craig moffat" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, April 05, 2001 9:54 AM Subject: Platform Req

huidziekte

Vijf jaar voordat deze foto's werden genomen werd bij mij diagnose reumatische artritis gesteld en als zodanig ook behandeld. Niets hielp. Toen de ziekte zich zo manifesteerde zoals u hieronder kunt zien.. http://www.naardedokter.com/testimonials/sys_lup_eryth.htm --

Re: java.sql.SQLException *SOLVED*

At 15:35 30/03/2001 -0800, you wrote: >HI > I am using MySQL 3.23 on Windows 2000 and mm.mysql.jdbc-1.2c but when I > run my servlet it gives me communication link failure error... > please help in solving this error.. > Thanks Update your Driver, This version has a bug (the exception is bad

Re: huidziekte

>Vijf jaar voordat deze foto's werden genomen werd bij mij diagnose >reumatische artritis gesteld en als zodanig ook behandeld. Niets hielp. >Toen de ziekte zich zo manifesteerde zoals u hieronder kunt zien.. THis message is send in Dutch, my native language. I'm not going to translate

Visual Foxpro 6

I wish to use MySQL as a backend to a Visual Foxpro 6 client application, has anyone got any experience of this ? Does it work ? Regards Chris.Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com">http://www.hotmail.com.

Re: Storing pictures in mySQL

> I am not sure what you explained. You mean that place PATH/filename.jpg to > picture field. isn't it? If yes, it is just a text. How can we explore that > picture thru web browser such as IE or Netscape? Thanks for the answer Your image would be in, say /usr/local/apache/htmldoc/images/simpleto

"YourName.BEST321.com" FREE §K¶O°ì¦W !!!!!

Dear Webmaster, Does your homepage address look long and difficult to remember like this: http://www.myhomepage.com/entertainment/w/love/index.html? Wouldn't you like it better if it was like http://YOURNAME.best321.com In that case, Cool168 has the solution for you, and the best thing about it

Re: "YourName.BEST321.com" FREE §K¶O°ì¦W !!!!!

That's it! One more like this and I'm unsubscribing - this is driving me insane!! P On Thu, 5 Apr 2001, Water wrote: > Dear Webmaster, > Does your homepage address look long and difficult to remember like this: >http://www.myhomepage.com/entertainment/w/love/index.html? > Wouldn't you like it

Re: Speed and Hardware

Andy Sharp wrote: > > Hi, > > I'm facing an issue with my primary mySQL server. It powers a web site, > which loads almost 100% dynamic data. At peak times of the day, it > seems to me that the Database is becomming maxxed. (Thus bogging the > site) > > I'm aware that there are simply too ma

Re: [OT] "ourName.BEST321.com" FREE §K¶O°ì¦W !!!!!

Water wrote: > Dear Webmaster, Ok, qhat i think is that son of a bitch is going to subscribe the list to any kind o maling lists. It is going to subscribe and unsubscribe only to joke Soem solutions need to be taken from the owner of the lists: A) DUL,RBL B) new subscriber will be moderate

Re: MySQL full-indexing

Hi! On Apr 05, Dennis S.Davidoff wrote: > Hi, all. > > I'm a newbie so be gentle > > I have a quastion about new feature of MySQL - Full-text indexing > (http://www.mysql.com/doc/M/y/MySQL_full-text_search.html). Cutting: "Since > Version 3.23.23, MySQL has support for full-text indexing and se

Re: Mysql++

Kevin Pratt writes: > I am having a problem installing mysql++ on a freebsd 4.2 install.. I am > wondering if there is anyone who has got it to work? thanks > > > Kevin > > ps if I am in the wrong place please tell me where I should be. :) > Hi! Just download source tarball for ver

Re: Visual Foxpro 6

Hi Christopher, >>I wish to use MySQL as a backend to a Visual Foxpro 6 client application, >>has anyone got any experience of this ? Does it work ? We're using MySQL as backend for our VFP6-Application. It's working with the MyODBC-Driver but you have to take care about memo-fields and boolean f

Install and testing problem?

I have compiled and installed mysql 3.23.33 and now 3.23.36 on a MAC OS X machine.. uanme -a gives.. Rhapsody haarp 5.6 Kernel Release 5.6: Tue Nov 23 15:07:38 PST 1999; root(rcbuilder):Objects/kernel-187.obj~2/RELEASE_PPC Copyright (c) 1988-1995,1997-1999 Apple Computer, Inc. All Rights Reser

Re: MySQL full-indexing

Hi Dennis, Yes, this is the way it works. You can do a match against on whole words only. If you want to search for 'support' match against 'support' is ok, but match against 'supp' will not work. In these cases your only choice is to use where field like '%supp%'. (As far as I know). In MySQ

MySQLGUI strange behavior

It's me again. So I downloaded the statical compiled MysqlGGUI, and i can start it without problem. I can also connect to mysql server and change database. BUT: - When I try to create database the result is NULL :) - After entering the admin panel it usually crashes after another operation

RE: Provider claims 'it's normal that mysql crashes', is that true?

If its a hosting PROVIDER, the table locking issue should really only be a factor for your database. If your design is good, then the rest shouldn't matter. Machine memory and processing power are another issue entirely. Other users could drag the machine down with poor design issues. One i

Problem migrating from 3.23.29 to 3.23.36

Hy! I have this odd problem. I upgraded my MySql from 3.23.29 to 3.23.36. It works fine with some databases I created with 36. But I copied some databases from 29 and I get this mysql> use lumina; Didn't find any fields in table 'absences' Didn't find any fields in table 'admins' Didn't find an

Re: MySQLGUI strange behavior

Peter Adamka writes: > It's me again. > So I downloaded the statical compiled MysqlGGUI, and i can start it > without problem. I can also connect to mysql server and change database. > BUT: - When I try to create database the result is NULL :) > - After entering the admin panel it usuall

mysql++-1.7.8 building problem

Hi! I have just read your suggestion for building mysql++. Since I cannot build it successfully I have some more questions for you. I have installed fallowing software on Sun ULTRA 1 under Solaris 2.6: - gcc 2.95.3 - mysql 3.23.5 - fltk-1.0.10 My intention is to install m

3.23.36 on Linux replication problem

After restarting a slave, I got the following error: 010405 11:07:28 Slave: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'xxx-bin.001' at position 289 010405 11:07:28 Error reading packet from server: log event entry exceeded max_allowed_packet - increase max_allo

Re: Problem migrating from 3.23.29 to 3.23.36

MySQL Server wrote: > > Hy! > > I have this odd problem. I upgraded my MySql from 3.23.29 to 3.23.36. > It works fine with some databases I created with 36. > But I copied some databases from 29 and I get this > > mysql> use lumina; > Didn't find any fields in table 'absences' > Didn't find any

Strange problem.

Hello , Few time ago I've started to get the following problems, which several times allready lead to data lost for me. Here is the example: I found the followings in my application error log: Query - #1017 [opal.local] - Can't find file: 'g04stat_languages.MYD' (errno: 2) select visitors,loa

Starting .36 with innobase failed on HPUX-11 / problem with my.cnf

Hi, after succesfully compiling mysql-3.23.36 on my HP-UX11 box (Heikki, thank you for your hints), I can't start start the DB with the start.server script. I created a /etc/my.cnf file with the following values: [mysqld] innobase_data_home_dir = /opt/mysql/var/ innobase_log_group_home_dir =

Replication, problems with binlog-ignore-db

Hi, we use mysql with replication, all works fine. Now we wan't exclude some tables from the replication. I enter in my.cnf the line binlog-ignore-db = news (stop the master and restart the master after the change in my.cnf) After this, the master don't repliacted any databases, only the tab

Re: Starting .36 with innobase failed on HPUX-11 / problem with my.cnf

[EMAIL PROTECTED] writes: > Hi, > > after succesfully compiling mysql-3.23.36 on my HP-UX11 box (Heikki, thank you > for your hints), I can't start start the DB with the start.server script. > > I created a /etc/my.cnf file with the following values: > > [mysqld] > innobase_data_home

Re: Speed and Hardware

We cache all of our output for 1 second. We have larger values for cache timeouts for pages that change less often (hourly / daily), but the 1 second cache allows the proxy web accelerator to serve content without re-requesting the same thing as two milliseconds ago (reducing concurrent MySQL acc

python on windows / mysql on linux

Could someone explain to me *exactly* what I need to do to access a mysql server on my linux box from a python program on my windoz box? The python program works fine on the linux box and I think I should be able to run it on the windoz box simply by changing the connection parameters but I can't

Re: Problem migrating from 3.23.29 to 3.23.36

On Thu, 5 Apr 2001, Gerald Clark wrote: I forgot to mention that the permisions are already set to mysql:mysql 660 > MySQL Server wrote: > > > > Hy! > > > > I have this odd problem. I upgraded my MySql from 3.23.29 to 3.23.36. > > It works fine with some databases I created with 36. > > But I co

query problem with MySQL

hai friends, i am going to provide a query service. for that i am using a Mysql database server for mainting the databse.i will provide my user with a query form that contains several fields.the user is free at his selection of the fields of course atleast one.in case if he selects multiple

RE: SELECT and ORDER OPTIONS

You could use Count(term) and GROUP BY term like SELECT COUNT(term) AS rank, term FROM table GROUP BY term ORDER BY rank or something like that, and that should return something like 4, a 3, z 2, i etc I'm new to MySQL, but that would work in SQL Server and Oracle, depends of mysql supports

Re: SELECT and ORDER OPTIONS

"Ghetalion" <[EMAIL PROTECTED]> wrote: > I figure since there are various ways to sort information in SQL, there must > be some way to sort the most frequent bit of information. Example: > > SELECT term FROM table ORDER BY mostfrequent(term) > > ID TERM > 1 a > 2 a > 3 f > 4 z > 5 a > 6 i > 7 i >

How well does MySQL handle Web Publishing?

Greetings! Quick background: i have extensive RDBMS experience (sybase, progress) but have been "out of the loop" in this field for a few years working as a sys-admin for a linux/unix-based ISP in Canada. We want to host a web-based resource center powered on the backend by an RDBMS. Documents

libncurses.so.5: open failed: No such file

I get the error "ld.so.1: ./mysql: fatal: libncurses.so.5: open failed: No such file or directory" when trying to run MySQL for the first time after installation and on all attempts since. I've install this under SunOS 5.8. There may or may not be related configuration error messages. In eith

Mysql speed :)

Hello mysql, I've resenty tried to becnhmark mysql in really simple case. I need to select indexes really fast so I did "select * from pages where hash=11" there was a key on hash and the query returned only one row. The query was constant and server ad no other load. I've run this on

Re: Mysql speed :)

Peter Zaitsev writes: > Hello mysql, > > I've resenty tried to becnhmark mysql in really simple case. > I need to select indexes really fast so I did "select * from pages > where hash=11" there was a key on hash and the query returned only > one row. The query was constant and serv

Re: Mysql speed :)

Are the Mysql supplied statically linked binaries built using these optimised glibc 2.2 libraries, or are they just the stock standard 2.1.3 libraries? -- Richard Ellerbrock [EMAIL PROTECTED] >>> Sinisa Milivojevic <[EMAIL PROTECTED]> 2001/04/05 05:06:45 >>> Peter Zaitsev writes: > Hello mysql

SCRIPTS IN DIFFERENTS DATABASES

Hi,... We've got a MySQL server running with a lot of different databases that have the same table-structure. Does anybody knows how to make an SCRIPT that performs an administrative task (like ALTER TABLE 'table_name') in all the databases? Do I have to use a script like this ? US

FW: .36 memory fault with innobase on HP-UX11

Hi, I use the following my.cnf: [mysqld] innobase_data_home_dir = /opt/mysql/var/ innobase_data_file_path = ib_data1:10M innobase_log_group_home_dir = /opt/mysql/var/ innobase_log_arch_dir = /opt/mysql/mysql/var/ set-variable = innobase_mirrored_log_groups=1 set-variable = innobase_log_files_in_

Client running pSOS

Hi, I'd like to run a mysqlclient on a homemade communication hardware running pSOS operating system. Has somebody already ported the mysqlclient to pSOS ? If not, what should I begin with, and how difficult would it be ? Thanks Christophe

Re:FW: .36 memory fault with innobase on HP-UX11

Andre, innobase_log_arch_dir should be the same as innobase_log_group_home_dir. Now there is an extra 'mysql' in the path. You probably do not have that directory existing, and Innobase asserts a failure. I am sorry, I will change the assert to an error message in the next release, but have bee

[mysql] cant start mysqld process

Hello, I just finished moving my database to another machine. It was running fine and after I rebooted I now get an error when I try to run safe_mysqld &. When I look in mysql/data/comproom.err file, I get a message about '... cant find file: './mysql/host.ISM' (errno: 13) thanks for any help

Using Full-Text Query in the HAVING clause

>Description: Pretty simple, just try to do a "match(column) against ('text') in the HAVING clause of a SELECT statement. Restarts my database server every time. >How-To-Repeat: Above >Fix: Restructure the query. The reason I want to do this is to run the

Re: [mysql] cant start mysqld process

In my mysql/data/mysq directory all the permissions are set to 660. Any ideas on what host.ISM file that it is looking for. I never seen it before and when I check the old server I can't find it. thanks kevin -- >From: "Brian Warn" <[EMAIL PROTECTED]> >To: "Kevin J. MacDonald" <[EMAIL

Moving MySQL database(s)

Hi, I've developed my mysql databases/tables on a local intranet server. What's involved in correctly copying them to an online linux machine please? regards, Graham Nichols

SQL query question?

Hi there, So a question I have two tables. And i want to... (i just show you) Table 1. OwnerChar(30)Uniqe FileChar(80) OIDint(not in use yet) Table 2. IDintuniqe and so on OwnerChar NameChar adress etc

Hey MySQL

How do I add a user? P.S. ALL YOUR MySQL DATABASE ARE BELONG TO US!! --- Clinton Ecker http://www.phaedo.cx http://www.picabomb.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://li

Re: [mysql] cant start mysqld process

Another thought. These are isam tables, not myisam tables. Unless the two machines are the same hardware type and operating system, you can't just copy the files over. Use msqldump. "Kevin J. MacDonald" wrote: > > In my mysql/data/mysq directory all the permissions are set to 660. > Any ideas

Avoiding roundtrips

Hi. I guess we all are waiting for subselects in Mysql...but can you do many sql-commands in a single execution, with a nice finally-result-select at the end? Many roundtrips feels bad... kind regards Tomas

mySQL - maker

Hi, I have problems with mySQL-maker, I can't connect to my mySQL database. I have a account at http://www.cihost.com At home we have a local network, and my friend have a mySQL database on his computer.. and that database I can connect to very easy. So why can't I connect to my mySQL database

Re: Moving MySQL database(s)

$ mysqladmin -u -p create and then $ mysqldump -h -u -p | mysql -h -u -p or $ mysqldump -h -u -p > dbdump.sql $ mysql -u -p < dbdump.sql cheers, roel On Thu, Apr 05, 2001 at 05:06:24PM +0100, Graham Nichols wrote: > I've developed my mysql databases/tables on a local intranet ser

turning logging on/off while server is running

Hi all, Is there a way to turn the query logging on and off while the database server is running? Right now I have a script that stops and restarts the database with loggin on or off depending on the parameters, but this is not so great; I was wondering if there is another way. Also, is there a w

Re: [mysql] cant start mysqld process

thanks, I'm going to give that a try kevin -- >From: Gerald Clark <[EMAIL PROTECTED]> >To: [EMAIL PROTECTED] >Subject: Re: [mysql] cant start mysqld process >Date: Thu, Apr 5, 2001, 1:21 PM > > Another thought. > These are isam tables, not myisam tables. > Unless the two machines are

Re: mySQL - maker

On Thu, Apr 05, 2001 at 06:42:25PM +0200, Leif Sundin wrote: > I have problems with mySQL-maker, I can't connect to my mySQL > database. I have a account at http://www.cihost.com At home we have a > local network, and my friend have a mySQL database on his computer.. > and that database I can conn

Re: Mysql speed :)

Hi! I tried a test similar to Peter. There is a table with 3 integer columns. There is a primary key on the first column and a non-unique key on the second column. I wrote a Perl program which inserts rows one at a time, and also selects rows one at a time. I ran the tests on a Linux 2-CPU Xeon

Re: Moving MySQL database(s)

"Graham Nichols" <[EMAIL PROTECTED]> wrote: > I've developed my mysql databases/tables on a local intranet server. > What's involved in correctly copying them to an online linux machine Stop the mysql server on the intranet and FTP the files in the MySQL data directory to the MySQL data directory

Re: query problem with MySQL

>one.in case if he selects multiple fields, how could i >provide my user with all set of records which contains >what all data he placed in query form. I think you want to study a bit more on MySQL and PHP. If you take the time to go to sites like www.devshed.com you might get an idea of how My

Re: SQL query question?

It's not possible to do in one step in MySQL. -- Steve Werby President, Befriend Internet Services LLC http://www.befriend.com/ "roger westin" <[EMAIL PROTECTED]> wrote: So a question I have two tables. And i want to... (i just show you) Table 1. OwnerChar(30)Uniqe FileChar

Running crash-me against remote M$ SQL Server

Dear Y'all - I've developed a diff-based testing framework in perl. It's used to qualify modifications we want to make to systems (i.e. applying patches, installing applications...) for deployment to a thousand some odd machines. The testing framework runs on linux and tests target machines th

How to run two mysql servers on one machine(NT4.0 or Solaris 5.8)

Hi, guys, This is Jing. I need a favor. I am trying to run two mysql servers on one machine. But I do not know how to do it correctly. I created a database using mysql, the database is a part of our product. And meantime, we have another mysql with the third party s

Re: Running crash-me against remote M$ SQL Server

Perl/DBI, or any mysql client on Linux should connect to mysql on NT with no problem. Why would you need ODBC? William Goedicke wrote: > > Dear Y'all - > > I've developed a diff-based testing framework in perl. It's used to > qualify modifications we want to make to systems (i.e. applying >

Re: Running crash-me against remote M$ SQL Server

I think William mentioned MS-SQL - as opposed to mysql - on the NT box... P On Thu, 5 Apr 2001, Gerald Clark wrote: > Perl/DBI, or any mysql client on Linux should connect to mysql on NT > with no problem. Why would you need ODBC? > > > > William Goedicke wrote: > > > > Dear Y'all - > >

Re: Running crash-me against remote M$ SQL Server

William Goedicke wrote: > > Finally we get to my question. Can anyone give me pointers on how to > setup the linux box so that I can run crash-me against the remote NT > box's SQL Servers. Crash-me is running fine on the linux test server > and I've been experimenting with unixODBC and other ut

MyAccess by Hubertus Hiden, [Slighlty OT]

Hi, Does anyone have any experience with MyAccess (http://www.accessmysql.com) by Hubertus Hiden? (This is an Access Addin which queries MySQL via ODBC for importing and exporting data and tables.) We have a client who uses Access and I'm determining if we should develop in

Need offsite Web developer

We are looking for an offsite Web Developer to work on an upcoming project that will include MySQL programming. Please respond to [EMAIL PROTECTED] and we will give you the project details. Thank you, Maroa Gikuuri - Before

subqueries

Howdy, all. I note that subqueries are in the "to be done real soon" list. Is anyone working on this for 4.0 or 4.1? I note that it did not seem to be in the 4.0 todo, but sometimes things make someone's hot project list without being reflected in the todo. Scott Scott Ellsworth [EMAIL PROTE

Visual Foxpro 6 (again)

Thanks for all the advice about using Visual Foxpro 6 with MySQL. I have started to create my application and have come across a strange problem. In MySQL i have a field in a table called Address1, it is VARCHAR(40) ... when i create my view i can run the sql and see the results no problem.

import - date format

Hi there, I have many files need import into mysql database. Unfortunately, the date format in my csv file is mm/dd/, so is there a wordaround that I don't need write another script to convert all my files? Thanks. Kevin

Re: Running crash-me against remote M$ SQL Server

> "GC" == Gerald Clark <[EMAIL PROTECTED]> writes: GC> Perl/DBI, or any mysql client on Linux should connect to mysql on NT GC> with no problem. Why would you need ODBC? Except that perl/DBI requires an underlying C library for the DBMS in question. I understand that the sybase libs might

RE: import - date format

Hi, If you use DBTools (http://dbtools.vila.bol.com.br), using the import text wizard you have a lot of parameters to set, including date format and separators. Unfortunatelly, runs only on windows platforms. []'s Crercio -Original Message- From: Kevin Xin Lin [mailto:[EMAIL PROTECTED]

RAID stripping for MySQL

It was mentioned to me today that there are various RAID policies necessary for optimal performance for diffferent programs such as SQL, Oracle, etc. Are there any special or recommended policies (like stripe size, etc) for MySQL running under Solaris 8/i86 with a PERC2/DC configured for RAID 5 on

RE: Perl - DBD:DBI Errors

Gerald, I grabbed the correct rpm for zlib under RedHat/RPMS - but I still get the error message: >rpm -ivh zlib-1.1.3-6.rpm Unable to open /usr/lib/rpm/rpmrc for reading: No such file or directory. I'm logged in as root. Any ideas? Thanks, Chris B -Original Message- From: [EMAIL PR

free admin/client gui for win32

Can any one share with me a good free admin/client GUI for win32? Thanks. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request thi

Firewall logged probes on mysql port

My firewall has denied and logged several of the following messages: Packet log: input DENY eth0 PROTO=6 192.168.0.1:37656 66.31.176.185:3306 L=40 S=0x00 I=26581 F=0x T=39 (#2) As you can see, it is a spoofed IP trying to connect to the mysql port. I've looked around at basic security sites

Foreign Keys

Are people using Mysql using foreign keys and how are they using them? It seems that the way to use them is with the scripting language used to access the database. - Before posting, please check: http://www.mysql.com/manual.p

Re: Firewall logged probes on mysql port

Gary Huntress wrote: > > My firewall has denied and logged several of the following messages: > > Packet log: input DENY eth0 PROTO=6 192.168.0.1:37656 66.31.176.185:3306 > L=40 S=0x00 I=26581 F=0x T=39 (#2) > > As you can see, it is a spoofed IP trying to connect to the mysql port. > I've

Re: Firewall logged probes on mysql port

It's late.. I want to catch some sleep.. but I found a few on the incidents list.. http://www.securityfocus.com/bid/926 http://www.securityfocus.com/bid/975 According to some people on the incidents lists there seems to be one or two probes going on for MySQL servers.. dunno what they're look

Re: Firewall logged probes on mysql port

Maybe they just seeing if MySQL is 'as open' as Interbase... http://www.securityfocus.com/frames/?content=/templates/advisory.html%3Fid%3D3152 There are a lot of 'robotic probes' going on out there (most commonly looking for FTP access). Just 'batten down the hatches' and keep monitoring...

Re: Firewall logged probes on mysql port

One thing you should do to protect your MySQL 'instance' , is have it running on a system 'behind' your 'front line' defenses (i.e. Firewall) and not 'on it'. Setup MySQL to listen only on the interface that your webserver or other 'client' is communicating on (we have a 'private' network conne

Re: Visual Foxpro 6

Hi, it works very well via MyODBC with either SQLCONNECT(), SQLEXEC() into local cursors or Remote Views stored in a local VP database. >From: "Christopher Davis" <[EMAIL PROTECTED]> >To: "mysqllist" <[EMAIL PROTECTED]> >Subject: Visual Foxpro 6 >Date: Thu, 5 Apr 2001 10:01:57 +0100 >I wish to

date select question

Hi, I'm trying to figure out how to select records from an events database which (from today) will take place on next weekend. The table has a from_date and a to_date fields, among other. I've found a way mixing PHP with SQL, but I'm curious to know if is there a neat and pure SQL version usi

Errant (Replication) error: "ERROR 1200: The server is not configured as slave"

Hi All, Sorry if I'm missing something totally daft here... I've got my master and slave hosts (both runng MySQL 3.23.36) configured roughly as-per the HOWTO, ( as follows ) to replicate the "test" database, but not the "mysql" database [btw. it's not clear from the docs that if you omit both bi

Strange problem.

Hi! > "Peter" == Peter Zaitsev <[EMAIL PROTECTED]> writes: Peter> Hello , Peter> Few time ago I've started to get the following problems, which several Peter> times allready lead to data lost for me. Peter> Here is the example: Peter> I found the followings in my application error log:

Signal to Noise Ratio...

Hi! > "Eric" == Eric Fitzgerald <[EMAIL PROTECTED]> writes: Eric> This is an open plea to the MySQL team. The amount of spam and other noise Eric> on the list has been growing more and more every day. I would like to make Eric> a couple basic plea's. The first, is that you require a post

Re: date functions crash

On Wednesday 04 April 2001 04:03, Max Hammond wrote: > I'll just add that if anyone wants a dump of the data causing this, drop > me a note at [EMAIL PROTECTED] and I'll mail it to you, it's about 2500 > rows, and only that one field necessary to crash it. > > Cheers, > > Max Fix: --- 1.11/sql

DSN

To whom it may concern, How can I set a datasource name (DSN) for a database in MySQL? Thank you, Ha - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the li

Re: REPOST: SELECT syntax

On Wed, 4 Apr 2001, Ashley M. Kirchner wrote: > > Db -> table1, table2 and table3 > > SELECT table1.task, table2.comment, table2.remarks, table3.history > FROM table1 LEFT JOIN table2 ON table1.id=table2.todoid > LEFT JOIN table3 ON table1.id=table3.todoid WHERE table1.id=10; > > Resul

Re: date select question

"Llorenc Sole" <[EMAIL PROTECTED]> wrote: > I'm trying to figure out how to select records from an events > database which (from today) will take place on next weekend. The > table has a from_date and a to_date fields, among other. I've found a > way mixing PHP with SQL, but I'm curious to know if

Re: REPOST: SELECT syntax

"Thalis A. Kalfigopoulos" wrote: > > +--++--+-+ > > | task | comment |remarks | history | > > +--++--+-+ > > | task_1 | cmt_1| rmk_1| | > > | task_1 | cmt_2

RE: MyAccess by Hubertus Hiden, [Slightly OT]

I installed it and got it up and running very quickly and easily. It is really a great product. Access2sql utility works great, as does the ODBC linking and the table create/modify utility. If you find out anything about how to get BLOBS to work with it, let me know. -

Re: Signal to Noise Ratio...

"Michael Widenius" <[EMAIL PROTECTED]> wrote: > This thing has been up a couple of times over the years. The problem > is that requiring people to be subscribers to the mailing list before > posting will only confuse the poor people that don't expect to get 100 > emails per day after subscribing.

  1   2   >