Re: Audit - Log

You will need to create my.cnf and turn ON the loggin option. Bhavin. - Original Message - From: "Jorge Ceballos" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, July 04, 2002 12:30 PM Subject: Audit - Log > Hi, > > After reading about the audit log > (http://lists.mysql.com

Audit - Log

Hi, After reading about the audit log (http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:95588), which I need; I looked for the my.cnf and mysql.log file but didn't find any nor any other related file. Are these created by default or should I create them ? Please advise. TIA. Jorge Ceballos Mexi

innodb database schema dump

I had the same problem, and while I don't think there's a way around it, you can load the schema with the force option so that it will eventually make it to the table the must be created first, (even if a previous table creation gives an error). Running the script many times over and over will ev

Re: help me please with mysqlgui

You might have your socket files in /var/lib/mysql/. Search for the socket file and create a symlink in the /tmp directory as such: ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock Regards, Bhavin. - Original Message - From: "Bas Mooyman" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: T

help me please with mysqlgui

When I start mysqlgui on my mandrake 8.2 machine the program starts, but I get an error message: Can't connect to local MySQL server through socket'/tmp/mysql.sock'(2) I don't know what to do and I cannot acces the help file or find documentation on MySQLserver. Please tell me how I can solve

Re: How best to store queries

Tim: >From the DB side, it is pretty easy to do ... a table with 3 columns will suffice: CREATE TABLE queries ( q_id int(11) NOT NULL auto_increment, q_name varchar(30) default NULL, q_text text, PRIMARY KEY (q_id) ); Your app needs to be able to select/load/exec

Re: resizing images in blobs

:Lets say the image is 400 x 300 px and I would like tor resize the image to :40 x 30. :Is there a way without php or similar? Go with ImageMagick. It has a imaging resizing and cropping functions : :Maybe someone has done this already and can give me a hint on that. : :Thanx in advance,

How best to store queries

Hello All: I believe that MySQL does not have the ability to directly store procedures, but I need to develop a process for clients to have an option to store queries that they have just made. The most obvious solution (to me) would be to store the entire query as a string of

resizing images in blobs

Hi there, I am wondering if it is anyhow possible to resize an image stored in a blob field. Lets say the image is 400 x 300 px and I would like tor resize the image to 40 x 30. Is there a way without php or similar? Maybe someone has done this already and can give me a hint on that. Thanx in

RE: AUTO_INCREMENT with Replication

We use a strategy of giving each node a unique ID and using the combination of the NodeId and the AUTO_INCREMENT value as the key for the objects. The AUTO_INCREMENT field ensures uniqueness between records in a single node. The NodeID ensures uniqueness between nodes. This way nodes that are wid

Problem with SQL Statement

Hello, i have tryed a lot but don´t find a way for the following problem with my SQL Statement. I have 3 tabels and will make a fulltext search on this 3 tables. My fulltext indexes are propper set. On a hit i will see the datas from table1 with the main informations (the other 2 tables have onl

Re: AUTO_INCREMENT with Replication

Eric Frazier wrote: > > Hi, > > That kind of bothers me. But I can see how it might be better in some way > than using a time function. My idea was to use the perl Time::HiRes to make > a unique key adjusted by timezone. As long as the clocks of the two > machines are fairly in since, it should

BigINT inserts

"You can always store an exact integer value in a BIGINT column by storing it as a string. In this case, MySQL will perform a string-to-number conversion that involves no intermediate double representation." I don't understand this, does this mean that the fastest way to insert bigint values

RE: What are the hardware requirements

I wouldn't try it on anything less than a Pentium class machine with at least 64 MB of RAM. It could probably be compiled on a 486 but, well, I'm not into that kind of pain. :) If you want decent performance I would suggest no less than a PIII500 with 1GB of RAM. (THe more RAM the merrier) It r

RE: Row level locking

What tests have you done to satisfy to yourself that it is turned off? =C= * * Cal Evans * The Virtual CIO * http://www.calevans.com * -Original Message- From: Tom Robinson [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 04, 2002 6:10 AM To: [EMAIL PROTECTED] Subject: Row level locking

Problem with SQL Statement

Hello, i have tryed a lot but don´t find a way for the following problem with my SQL Statement. I have 3 tabels and will make a fulltext search on this 3 tables. My fulltext indexes are propper set. On a hit i will see the datas from table1 with the main informations (the other 2 tables have onl

select tuning / simple

Hi! I got a very simple SQL query which takes 0.2sec to execute (far too long) and it seems I can't do nothing about it. I use : "SELECT id FROM news WHERE state=1 and main_page=1 order by timestamp desc LIMIT 10" I got indexes too : +---+++--+-

Re: Porting my gweMysql JDBC Driver(Type4) to C# Driver!!

Sorry, URL is wrong Please check it out http://www.t3-jpn.com/jdbc/jdbcmysql.html "TAKAHASHI, Tomohiro" wrote: > > Hi, All > > I ported my gweMysql JDBC Driver(Type4) to C# Driver. :-) > If you are interested in C# Driver, please check it out!! -- I love Borland. TAKAHASHI, KEN,

Porting my gweMysql JDBC Driver(Type4) to C# Driver!!

Hi, All I ported my gweMysql JDBC Driver(Type4) to C# Driver. :-) If you are interested in C# Driver, please check it out!! http://www.t3-jpn.com/work/jdbc/jdbcmysql.html -- I love Borland. TAKAHASHI, KEN, Tomohiro -

Re: AUTO_INCREMENT with Replication

Hi, That kind of bothers me. But I can see how it might be better in some way than using a time function. My idea was to use the perl Time::HiRes to make a unique key adjusted by timezone. As long as the clocks of the two machines are fairly in since, it should work :) I guess I could also add

Re: temporary table query

* Wilbert Enserink > I'm using this query: > > CREATE temporary TABLE temptable SELECT * FROM gallery INNER JOIN > designers > ON (designers.designersID=gallery.designersID) WHERE > (LOWER(gallery.omschrijving) LIKE '%$search%' OR > LOWER(gallery.productnaam) > LIKE '%$search%' OR LOWER(voornaam)

Re: temporary table query

Selecting each column (instead of *) and then assigning an alias to designerID from one of the tables (select designerID as GDID..) might work. Regards, Bhavin. - Original Message - From: "Wilbert Enserink" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, July 04, 2002 7:38

temporary table query

hi all I'm using this query: CREATE temporary TABLE temptable SELECT * FROM gallery INNER JOIN designers ON (designers.designersID=gallery.designersID) WHERE (LOWER(gallery.omschrijving) LIKE '%$search%' OR LOWER(gallery.productnaam) LIKE '%$search%' OR LOWER(voornaam) LIKE '%$search%' OR LOWE

Re: Error on rename

Hi Mark, I do have rights! I'm logged in as administrator and as root in MySQL and the problem still happens If I flush the tables, then everything is ok...and I can figure out why... The problematic areas are: rename tables alter tables types, e.g., from varchar to text. creating ind

MySQL compiling errors

Hello! i have some trouble to compile MySQL (from source not from pkgsrc) on my NetBSD/i386 Notebook. After configure i type gmake and get this: gmake[2]: *** [my_gethostbyname. lo] Error 1 gmake[2]: Leaving directory '/mysql-3.23.51/libmysql' gmake[1]: *** [all-recursive] Error 1 gmake[1]: Lea

Row level locking

Hi, Ive just downloaded MySQL and am trying to switch on row level locking. Ive changed the tables to InnoDB but it still seems to be switched off - are there other things which need to be done? Thanks, Tom Robinson Workforce Systems ---

Re: How to On DELETE CASCADE

multivac, Thursday, July 04, 2002, 12:22:42 AM, you wrote: m> I'm quite new in MySQL and PHP, so I guess my question is stupide. Sorry m> for that but I really need the solution... m> I have 2 tables [skip] m> The primary Keys are ClientID on table Client and CommandID on table m> Command. m>

Re: login root problem

Ivan, Thursday, July 04, 2002, 8:33:31 AM, you wrote: IP> I can't login using root to mysql server from my pc-client... IP> I have tried to use this command but still have a problem... IP> > mysql -u root -p -h 192.168.x.xxx IP> i already created one user which have all privileges IP> so, if

Re: MYSQ current value!!!

Rahadul, Wednesday, July 03, 2002, 10:32:19 PM, you wrote: RK> This are the few variables for mysql. Does anyone know how can I set the RK> "current value" to some other value. because whats happing now is when I RK> try to startup mysql, it starts and right after a second it ends. and I RK> thin

Re: exclude columns in query

W., Thursday, July 04, 2002, 12:34:12 PM, you wrote: WE> is it possible to exclude columns in a query? WE> something like WE> select * from table except columnname ?? You should specify all needed columns, i.e. if your table contains 3 columns: column1, column2, column3, but you want to get d

Re: unexpected results using LEFT JOIN with more than one

Harald, Wednesday, July 03, 2002, 11:06:36 PM, you wrote: HK> >Description: HK> I use LEFT JOIN to join together two tables. And (for some 'complex' HK> reason) I want to add additional conditions into the join_condition-part HK> (and not in the WHERE part where it would belong to). But these

What are the hardware requirements

To run mysql Thanks Kevin Kevin Passey KDP Software Limited Tel: 01273 712830 Fax: 08700 510103 mailto:[EMAIL PROTECTED] http://www.kdpsoftware.co.uk - Before posting, please check: http://www.mysql.com/manual.php (the ma

FW: Regarding cast functions

> -Original Message- > From: Harish Varandani-Software-Bangalore > Sent: Wednesday, July 03, 2002 12:26 PM > To: '[EMAIL PROTECTED]' > Subject: FW: Regarding cast functions > > > > > > I would like to know regarding the cast and convert functions in > MySql4.0.1;.

AUTO_INCREMENT in master-master mode...?

Hi all! In MySQL, is replication of auto_increment (primary keys) in a master-master mode working? or is it only working with master-slave? -Jon - Before posting, please check: http://www.mysql.com/manual.php (the manual)

RE: MySQL access denied problem

Hello, > -Original Message- > From: Dicky Wahyu Purnomo [mailto:[EMAIL PROTECTED]] > Sent: Thursday, July 04, 2002 12:44 PM > To: Simas Cepaitis > Cc: [EMAIL PROTECTED] > Subject: Re: MySQL access denied problem > > > What was the error message appear when you try to log in with > norm

innodb database schema dump

how can i dump innodb tables schema with foreign key references so that the tables are created in the right order ? thanks, Pierre -- sql,query - Before posting, please check: http://www.mysql.com/manual.php (the manua

Re: exclude columns in query

Pada Thu, 4 Jul 2002 11:34:12 +0200 "W. Enserink" <[EMAIL PROTECTED]> menulis : > Hi all, > > is it possible to exclude columns in a query? > > something like > > select * from table except columnname ?? Nope, I don't think it's possible ... You have to give columns list, like this ... "sel

Re: MySQL access denied problem

Pada Thu, 4 Jul 2002 10:40:36 +0200 Simas Cepaitis <[EMAIL PROTECTED]> menulis : > Hello, > > > I have a problem that happens periodically on my FreeBSD 4.6 box. > Somehow MySQL (3.23.49) stops responding after some period. It > doesn't allow to connect any user except root ( and it's not

Demande d'inscription à mysql-france

Bonjour, Vous avez récemment demandé à vous inscrire au groupe mysql-france. Comme vous êtes déjà membre de ce groupe, votre demande ne sera pas prise en compte. Pour toute question sur l'envoi de messages à ce groupe, veuillez envoyer un e-mail à [EMAIL PROTECTED] Cordialement, L'équipe

exclude columns in query

Hi all, is it possible to exclude columns in a query? something like select * from table except columnname ?? regards WIlbert mysql. - Pas de Deux Van Mierisstraat 25 2526 NM Den Haag tel 070 4450855 fax 070 4450852 http://www.pdd.nl [EMAIL PROTECTED] -

Re: mysql query: left join with same column names

* Wilbert Enserink > I have to tables A and B. > They boyh have a column with the same name. > > Now, I wrote this MySQL statement performing a left join. > This results in a data set with rows consisting of 2 columns of the same > name, in which the date is stored when the record was last alter

mysql query: left join with same column names

Hi all, I have to tables A and B. They boyh have a column with the same name. Now, I wrote this MySQL statement performing a left join. This results in a data set with rows consisting of 2 columns of the same name, in which the date is stored when the record was last altered. This column is cal

Re: Replication Question

On Thu, Jul 04, 2002 at 09:33:54AM +0100, David Shields wrote: > The MySQL manual for 3.23.38, Section 11.4 states that you can have a > replication chain A -> B -> C -> A. > I guess this means > A Master B Slave > B Master C Slave > C Master A Slave > > Can this loop be reduced to the most triv

Replication Question

The MySQL manual for 3.23.38, Section 11.4 states that you can have a replication chain A -> B -> C -> A. I guess this means A Master B Slave B Master C Slave C Master A Slave Can this loop be reduced to the most trivial case A -> B -> A ? If so, it would help me with a roving laptop issue I ha

MySQL access denied problem

Hello, I have a problem that happens periodically on my FreeBSD 4.6 box. Somehow MySQL (3.23.49) stops responding after some period. It doesn't allow to connect any user except root ( and it's not because max_connections, there aren't active connections at the time). The only thing that h

RE: selected records retrieve

Hi, you can use mysqldump command line utility with the '--where=' switch. See the man page for more details. Regards, Sebastien sql query > -Message d'origine- > De : Nixarlidis Aris [mailto:[EMAIL PROTECTED]] > Envoye : jeudi 4 juillet 2002 09:46 > A : [EMAIL PROTECTED] > Objet : sele

Re: selected records retrieve

* Nixarlidis Aris > Hi to all. > I'm new in the list and in mysql as well, so excuse me for anything that > sounds novice or in wrong place.I'm facing the following situation: > > For some reason, i had to use a backup of the database.Because of the > difference in time between my backup and the i

Re: Load Data Problem

* [EMAIL PROTECTED] > Hie there, > I'm having a potential problem with Load Data Infile function > where i'm unable to get the right no. of records to appear in the table. I > have a table created in MySQL with 2 fields region (char 1)-pkey and > regionname (char 30). The table name is c

Performance : create table into database

Hi all, I want to add huge amount of data to the mysql database in chunks. Lets call it as data1, data2 , data3. Now there are 2 solutions to the problem: 1. Create the different table for each of data1, data2, data3 etc. 2. Create a single table and add different rows into the table, each fo

selected records retrieve

Hi to all. I'm new in the list and in mysql as well, so excuse me for anything that sounds novice or in wrong place.I'm facing the following situation: For some reason, i had to use a backup of the database.Because of the difference in time between my backup and the instance i had to use it,i

Re: Re: Transparent Encryption [was: encrypt myisam?]

Am Donnerstag, 4. Juli 2002 09:03 schrieben Sie: > Your message cannot be posted because it appears to be either > spam or simply off topic to our filter. To bypass the filter > you must include one of the following words in your message: > > sql,query > > If you just reply to this message, and in

Re: TCP & TIME_WAIT strange problem ( LINUX & mysql 3.23.49 )

Hi, "TIME_WAIT" said to you that are still packet in the network which are unhandled after socket it's closed. The question is: ... why happend this? IFCONFIG show you information about network interfaces which is mounted in your computer and not about entire network. Regards, Gelu _