mysql replication (Error reading packet from server: Binary log is not open (read_errno 0,server_errno=2000)

021009 12:56:49 mysqld started /usr/sbin/mysqld: ready for connections 021009 12:56:49 Slave: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'FIRST' at position 4 021009 12:56:49 Error reading packet from server: Binary log is not open (read_errno 0,server_errno=2000)

Re: query help

Maybe I'm way out here, but this happens to me (or similar) quite often. My solution; SELECT DISTINCT And a single row will be returned for each. Niclas On Tuesday 08 October 2002 21:48, Michael Knauf/Niles wrote: Here's a query for ya: SELECT products.product_name, products.fg_number,

eroor: when connecting remote system using userid and password on red hat linux

Dear Sir, When Iam trying to connect remote mysql database Using JSP on LINUX Os it is giving an error... Remote system is Windows NT. java.sql.SQLException: Communication link failure: Bad handshake I loaded 1).MySQL-3.23.40-1.i386.rpm 2).MySQL-client-3.23.40-1.i386.rpm

drop constraint in innodb

sql, query Hi Folks ALTER TABLE main_db ADD CONSTRAINT FOREIGN KEY( Code, Kana) REFERENCES Syoyu_db( Code, Kana) ON DELETE CASCADE ; works fine. But how to drop the constraint or modify the constraint ? Simply changing ADD to DROP or MODIFY throws errors regards

Re: mysqld Threads with Innobase

Nicholas, - Original Message - From: Nicholas Gaugler [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Wednesday, October 09, 2002 8:22 AM Subject: mysqld Threads with Innobase I know it's not very important in normal day to day operations, but does anyone know what each

mytop - DBD::mysql failed to load

Hi, I try to install mytop in order to get some information about my MySQL database, after I installed : - DBI-1.18.tar.gz - Msql-Mysql-modules-1.2216.tar.gz - Data-Dumper-2.101.tar.gz - Data-ShowTable-3.3.tar.gz ...and 'perl Makefile.PL' I get this warning: Warning: prerequisite DBD::mysql

Re: AUTO_INCREMENT max value...

Bill Hess wrote: Hello all... What is the maximum value of an AUTO_INCREMENT field? I am currently running into a maximum value of 296,995,724 on Solaris 8 using MySQL 3.23.42 - the field has been defined as an INT(11), which should be able to handle a value bigger than what I am seeing -

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

How to get the lists of DB from MySQL system tables?

Hi Guys, I'm using MySQL for Windoze (latest version of Server ODBC). Is it possible to get the lists of DB in the Windows using the system tables of MySQL? or any workaround you can suggest. Many thanks in advance. Regards, Jojo

connect failed from external

Hi, I failed to connect mysql from external network (it works by connected . In the error log, I found the following message. Number of processes running now: 1 mysqld process hanging, pid 13523 - killed 021009 12:35:28 mysqld restarted /usr/libexec/mysqld: ready for connections As you

How to use comma instead dot in numeric values?

Is there a simple solution to define MySQL to use comma instead of dot in numeric fields? Sincerely, Putte koivisto - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

CPU Load

sql spam filter Hi I'm running MySQL-3.23.37 on a cobalt raq. I have a table with approx 40,000 records and a dozen users running simple queries and updates - names, addresses that kinda thing, but every time a query is run mysql takes everything it can get and the box freezes: 10:33am up

optimizer bug in selecting fields that don´t belong to the index used by mysql/Innodb

Description: Hello, We reported a problem about selecting fields that some of them didn´t belong to the used index on September. We have already installed MySql 4.0.4 and we have a similar problem (and also we are still having the original problem) when we select fields which some

mysql.server Mods for Multiple Instances/Users

What are the issues if I were to remove the following snippets from mysql.server on a RH 7.2 system running multiple instances of MySQL under multiple users?: # Make lock for RedHat / SuSE if test -w /var/lock/subsys then touch /var/lock/subsys/mysql fi

How to rebuild indexes..

It says in the manual .. recompile MySQL, and rebuild your FULLTEXT indexes First time I downloaded the source code and compiled it, I just deleted the old indexes and created new ones. But now I have a lot of tables with fulltext indexes. So I'm looking for an easy way to do it. Searched

Re: AUTO_INCREMENT max value...

But did you check if the file size is at 4Gig? This will cause strange things to happen, mysql does not gice a nice error for this condition. If the table was not created with MAX_ROWS option = to some real large number like 5000, then you could be running into a problem with the size

Re: drop constraint in innodb

Last week, I posted a message related to this. Heikki (InnoDB Developer) said sorry, DROP CONSTRAINT is not implemented yet. - Original Message - From: kayamboo [EMAIL PROTECTED] To: list mysql [EMAIL PROTECTED] Sent: Wednesday, October 09, 2002 2:45 PM Subject: drop constraint in

RE: storing PDF files in mysql ?????

Hi, The thing I was wondering is whether there is any advantage in saving IMAGES in a database? I have had a little play around with a 50k jpeg file and it appears that if I save it in Blob format, then the filesize of the database increases by 50K as well, and surely converting it from/to a

re: drop constraint in innodb

kayamboo, Wednesday, October 09, 2002, 8:45:39 AM, you wrote: k ALTER TABLE main_db ADD CONSTRAINT FOREIGN KEY( Code, Kana) REFERENCES k Syoyu_db( Code, Kana) ON DELETE CASCADE ; k works fine. k But how to drop the constraint or modify the constraint ? k Simply changing ADD to DROP or MODIFY

re: RESET MASTER during daily backups

Russell, Wednesday, October 09, 2002, 1:44:14 AM, you wrote: RU we use the binary log as a crash recovery tool. RU therefore, once we have backed up the db (we use the excellent mysql_backup for this) we can happily discard yesterday's binlog. RU the only correct way i've found to get rid of

re: MySQL install Problem?

Daniel, Tuesday, October 08, 2002, 11:14:06 PM, you wrote: DM I have am having problems getting the MySQL server to start running, please help me, here are my problems, I have also displayed my error logs below, at least I hope they are the error logs; DM I have been trying to install the

re: How to use comma instead dot in numeric values?

Putte, Wednesday, October 09, 2002, 12:04:25 PM, you wrote: PK Is there a simple solution to define MySQL to use comma instead of dot in PK numeric fields? You can't use ',' in numeric values. If you want to use ',', you can store as a string. -- For technical support contracts, goto

re: Query content question

ir000387, Tuesday, October 08, 2002, 11:22:51 PM, you wrote: iamdc I am trying to find a way to store the body of a binary NNTP message into iamdc MySQL. However, due to the way lines are encoded, MySQL will not accept the iamdc SQL statement. Does anyone have any ideas on how I should approch

re: table damaged?

speters, Wednesday, October 09, 2002, 2:09:30 AM, you wrote: samdc I think i have a damaged table in one of my databases. samdc I can do a SELECT count(*) from table samdc on every table in the db with no problem, except for 1 samdc of them, the query just sits for a while. samdc So i assume

re: How to get the lists of DB from MySQL system tables?

Jojo, Wednesday, October 09, 2002, 12:00:07 PM, you wrote: JM I'm using MySQL for Windoze (latest version of Server ODBC). JM Is it possible to get the lists of DB in the Windows using the system JM tables of MySQL? If you what to get a list of databases just use SHOW

re: MySQL

Jeremy, Tuesday, October 08, 2002, 8:55:35 PM, you wrote: JOn I am currently try to set up mysql on my computer and I'm running into a JOn few bugs. I'm using the book PHP fast easy web development. I've JOn run into a problem when I type the command mysqld --standalone into the JOn prompt.

re: MySQLGUI 1.7.5-1 problem

Martín, Tuesday, October 08, 2002, 8:29:21 PM, you wrote: MF I have downloades the last version of your software, but when I try to MF connecto to the mysql server remotly, the server crash, and safe_mysqld MF restar it. Your software reports lost connection to MySQL dureing query MF And the

Re: PHP/mySQL - displaying length of time used by query

Shaun Bramley [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Hello all, I am using mySQL and PHP, how can I use PHP to display the length of time used by a query? Shaun, ? // grab the start time $start = time(); // db query goes here $res =

RE: storing PDF files in mysql ?????

thnx guyz 1) i m tryin to put the pdf file into a blob field but i cant insert it like normal text how shall i go about inserting it 2) i m in the process of converting the word doccuments to pdf got this acrobat disteller n m havin a million probz with that alone like the security

Re: storing PDF files in mysql ?????

Alexis Antonakis wrote: The thing I was wondering is whether there is any advantage in saving IMAGES in a database? None whatsoever unless you can't do remote file access any other way. # SQL: SELECT name FROM images LEFT JOIN table1 ON table1.imageid = images.id; # Program: open(name) off

crossover replication

If my mysql master is under Linux and my slave under Windows, if the master crashes, can I make the slave a master once I recover the Linux machine even if data is replicated 100%? Does replication only involves data? Would there be issues that would make my Windows slave incompatible as a master

information about the tables in the database

Hi all, There is a way to know if I have table x in my db? Let's say some catalog tables that hold information about the db like tables name etc. and i can do query like select tables from catalogName and get all the tables in the db thanks :) Inbal

RE: Query Spans Multiple Pages

-Original Message- From: William Martell [mailto:[EMAIL PROTECTED]] I am trying to query MySQL using PHP and I would like the results to display on multiple pages. I would like to display only 20 results per page and allow the user access to the other pages by clicking next

indexing column type SET

Hi, I have a question about indexing a column of type SET. It seems that generally the index is not too useful, since it always requires some sort of expression to get what you want out of the set, and therefore the index won't be used. Example: create table FOO (BAR

Re: mysql replication (Error reading packet from server: Binary logis not open (read_errno 0,server_errno=2000)

Looks like you don't have binary logging turned on on the master. louie miranda wrote: 021009 12:56:49 mysqld started /usr/sbin/mysqld: ready for connections 021009 12:56:49 Slave: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'FIRST' at position 4 021009 12:56:49

AW: storing PDF files in mysql ?????

Hi, I do not recommend saving the image data in the DB: 1. The size of each DB Row increases dramatically. Depending on the structure of your tables, query speed drops as the rows are located further away on the disk (disk seek times) 2. For each image request, you have to involve some

Re: crossover replication

On Wed, Oct 09, 2002 at 09:29:34AM -0400, Kevan Louou wrote: If my mysql master is under Linux and my slave under Windows, if the master crashes, can I make the slave a master once I recover the Linux machine even if data is replicated 100%? Yes. Does replication only involves data? I'm

Re: mysqld Threads with Innobase

[ start stupid question ] Does setting innodb_thread_concurrency to 1 imply that only one innodb thread will be working at any given time? So using this on SMP servers that you would like to be answering simultaneous queries is probably not what you would really like to be doing, no? [ end

Re: information about the tables in the database

On Wed, Oct 09, 2002 at 03:43:15PM +0200, Inbal Ovadia wrote: Hi all, There is a way to know if I have table x in my db? Let's say some catalog tables that hold information about the db like tables name etc. and i can do query like select tables from catalogName and get all the tables in

Autocommit in MySql/Innodb

How can i take AUTOCOMMIT default in my MYSQL Configuration with Innodb tablespace? Every time i login at MySQL i have to type SET AUTOCOMMIT = 0. I want this parameter be always 0. I don´t use AUTOCOMMIT. Thanks Jacob --- UOL Eleições 2002 - Todos os lances da disputa política

Re: information about the tables in the database

On Wed, 9 Oct 2002, Inbal Ovadia wrote: Hi all, There is a way to know if I have table x in my db? Let's say some catalog tables that hold information about the db like tables name etc. and i can do query like select tables from catalogName and get all the tables in the db Hi, I guess

Re: information about the tables in the database

show tables; On Wednesday, Oct 9, 2002, at 05:43 America/Anchorage, Inbal Ovadia wrote: Hi all, There is a way to know if I have table x in my db? Let's say some catalog tables that hold information about the db like tables name etc. and i can do query like select tables from

Re: eroor: when connecting remote system using userid and passwordon red hat linux

kusuma guntupalli wrote: Dear Sir, When Iam trying to connect remote mysql database Using JSP on LINUX Os it is giving an error... Remote system is Windows NT. java.sql.SQLException: Communication link failure: Bad handshake I loaded 1).MySQL-3.23.40-1.i386.rpm

Question about solving a query !

Hello, I have a problem to treat a query with MySQL because MySQL does not permit nested SELECT clauses. The schema of the table is : Hospital num | name | city| numbeds 10 | Clairval| Marseille | 70 20 | Notre-Dame |

Re: AUTO_INCREMENT max value...

Nope - nothing close to 4GB or even 1GB... My greatest data file size is 80MB. The largest table is 1.7 million rows. I have databases with more and bigger files. I think my problem is that the table having the problem with auto increment is refreshed everyday (or even multiple times a

using php to connect to a 2nd mySQL server

Hello all, I am new to this list ... and hope to find an answer to a question which has come up. On the server for my websites at my ISP, a mySQL server is installed to handle different customers' databases (1 database setup for each customer) Now, as I have a need for a mySQL server where

Calculating Recurring Dates

Hi all, Can anyone tell me how to do this? What I want to do is run a query that calculates the next [n]th [Sun - Sat] of [Jan - Dec] in MySQL? ie (Return the next occurance of the 2nd Tuesday in April). In my table I store the day of the week I want the event to occur on, which occurance in

Replication issues

Hello List, I'm using MySQL 4.0.3-beta on 2 RedHat 7.3 Boxes belonging to a 2 node HA Cluster. To allow the takeover of the database node I formed a replication ring. So node1 replicates to node2 and the other way round. Read/Write operations are only done on Node 2. The nodes are connected

Re: information about the tables in the database

On Wed, 9 Oct 2002, Brian Reichert wrote: On Wed, Oct 09, 2002 at 03:43:15PM +0200, Inbal Ovadia wrote: Hi all, There is a way to know if I have table x in my db? Let's say some catalog tables that hold information about the db like tables name etc. and i can do query like select

Re: optimizer bug in selecting fields that don´t belong to the index used by mysql/Innodb

Rafa, I fixed the optimization of the ORDER BY ... LIMIT 50 query on the generated 'clientes' table you sent in September. The fix is in 3.23.53. It will favor index range scans even more over full index scans. But the underlying problem is in the MySQL optimizer. It does not realize that it

Re: mysqld Threads with Innobase

Owen, - Original Message - From: Owen Scott Medd [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED] Cc: Nicholas Gaugler [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, October 09, 2002 5:44 PM Subject: Re: mysqld Threads with Innobase [ start stupid question ] Does setting

RE: information about the tables in the database

show tables; show tables from catalogName; show tables from catalogName like 'order%'; -J -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Iikka Meriläinen Sent: Wednesday, October 09, 2002 10:09 AM To: Inbal Ovadia Cc: '[EMAIL PROTECTED]' Subject: Re:

Re: Kylux

Hi Silmara, You can use the dbExpress that comes with kylix. Silmara wrote: need use MySql to Linux ( Connectiva 7 )and Kylux. What version of the MySQL? Do I need MyODBC? -- -- \|/ __\|/ `@ / o . \ @' Microsoft? Por acaso

Displaying Default Values

I am useing mysql Ver 11.18 Distrib 3.23.52, for pc-linux-gnu (i686). I have set up a table in which one of the fields have a default value (i.e. New York). When I INSERT a record, that field is empty so that the default value is inserted into the field automatically (at least that's what I

InnoDb data file path

I am trying to set up two data files in case the first one fills up. I tried to use the following in my.cnf but it says there is an error. If I take out the reference to the second data file everything works AIX 4.3.3 MySQL 4.0.4

Re: Question about solving a query !

Myoung-Ah KANG wrote: The query is: For each city, what is the name of the hospital having the highest number of beds ? ' . Select name From Hospital Where (city, numbeds) In (Select city, MAX(numbeds) From Hospital Group By city); select name, city, max(numbeds) from hospital

Re: information about the tables in the database

Sure you can. show tables like 's%' from mydatabase; Iikka Meriläinen wrote: On Wed, 9 Oct 2002, Inbal Ovadia wrote: Hi all, There is a way to know if I have table x in my db? Let's say some catalog tables that hold information about the db like tables name etc. and i can do query like

Re: AUTO_INCREMENT max value...

On 9 Oct 2002, at 11:55, Bill Hess wrote: One would think that the value would not top out until 2^31 since I have it defined as a normal INT. I guess I can make it a BIGINT, but I think I will run into a problem eventually regardless how big I make the field... Since the limit you're

RE: using php to connect to a 2nd mySQL server

the port is part of the server parameter in the connection eg port 3307 mysql_connect ( localhost:3307 , username , password ) http://www.php.net/manual/en/function.mysql-connect.php has the details HTH Peter --- Excellence in internet and open

RE: Question about solving a query !

Is this what you're looking for? mysql select city,name,max(numbeds) from hospitals group by city; +---+--+--+ | city | name | max(numbeds) | +---+--+--+ | Lyon | Tonkin | 300 | | Marseille | Clairval | 150

RE: using php to connect to a 2nd mySQL server

Hello Wolfgang, [..] My question now is this: How can I tell a php script to not use the standard mySQL server that exists on this server computer, but to use the 2nd mySQL server that runs on the different port number ? Currently I use info set up in variables like this: # MySQL database

fetching specific date from datetime field

Hi All My mysql database is set up having a field cdate - cdate datetime has the format -00-00 00:00:00 If I want to fetch rows for say the date 2000-12-19, I do it using perl (it's a tediuos code) Is there a way to do it using sql queries Also how can I get betwee two specific date that

Re: CHAR vs. VARCHAR

From: christophe barbe [EMAIL PROTECTED] Is it then correct that VARCHAR(255) and TINYTEXT are strictly equivalent? I believe they work almost the same, but there may be performance implications because they are stored differently. My understanding is that TINYTEXT is simply a sort of BLOB

RE: storing PDF files in mysql ?????

From: Sqlcoders.com Programming Dept [EMAIL PROTECTED] You should look into (via google.com) some doc to pdf converters. An example is this com object: http://www.convertzone.com/doc2pdfcom/help.htm#HowtoBuy, it costs $219 and converts .doc to .pdf. That's $219 saved if you're on MacOS X, since

Re: InnoDb data file path

Scott Pippin wrote: I am trying to set up two data files in case the first one fills up. I tried to use the following in my.cnf but it says there is an error. If I take out the reference to the second data file everything works AIX 4.3.3 MySQL 4.0.4

Re: Displaying Default Values

On 9 Oct 2002, at 13:14, Lawrence S. Stephens III wrote: When I INSERT a record, that field is empty so that the default value is inserted into the field automatically (at least that's what I think). If your query is setting the column to the empty string, then you're setting it to the

Re: optimizer bug in selecting fields that dont belong to the index used by mysql/Innodb

Rafa, it looks like the tuning I did to 3.23.53 fixes the optimization also in the 'albaranes' case below. Lenz starts building of 3.23.53 this week. With good luck 3.23.53 is available around Oct 17, 2002. Best regards, Heikki Innobase Oy heikki@hundin:~/mysql/client mysql test Welcome to

Re: fetching specific date from datetime field

select * from table where substring(timestampField,1,8) = 'MMDD' from Perl, execute this statement and then process each returned row - hcir My mysql database is set up having a field cdate - cdate datetime has the format -00-00 00:00:00 If I want to fetch rows for say the

RE: Question about solving a query !

Here is a correct one to solve your problem: select b.city, b.name, b.numbeds, count(distinct a.numbeds) c from hospitals a, hospitals b where a.city = b.city and a.numbeds=b.numbeds group by b.name, b.city, b.numbeds having c=1; -Original Message- From: Myoung-Ah KANG [mailto:[EMAIL

NULL sometimes joins to NULL

Description: After adding a key to a nullable column, null values will successfully join through to null values in other tables. This only seems to happen when the index is added after the row contains null values. This affects both MyISAM and InnoDB table types and both binary versions 3.23.42

Re: drop constraint in innodb

Is there any other way to do this in a table with thousands of records. - Original Message - From: "Heo, Jungsu" [EMAIL PROTECTED] To: "kayamboo" [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, October 09, 2002 8:50 PM Subject: Re: drop constraint in innodb Last week, I

Re: storing PDF files in mysql ?????

Hello There are lots of discussions in this regard and the suggestions are always to save your blob somewhere in your hard disk and just store the path. In my case, each of my image is around 1MB but you know, I find it difficult to map the images stored in a particular machine, through a

Re: storing PDF files in mysql ?????

Hi toby Just replace the .gif with your .pdf. I hope this will work for you. INSERT INTO photo(name , pic, picname) values( 'raman', load_file('e:/mysql/images/Click.gif'),'Click.gif') ; SELECT length(pic) FROM photo WHERE picname = 'Click.gif' ; UPDATE photo SET pic =

Re: drop constraint in innodb

HI If suppose my table has thousands of records, is it possible to create a new table without a foreign key constraint, and then copy the existing data with the foreign key constraint to the new one ? regards - Original Message - From: "Egor Egorov" [EMAIL PROTECTED] To: [EMAIL

password / last record

sql, query Hello Folks 1. Is there anyway to know the string value of the password using the encrypted value , from the mysql.user table ? 2. How can I know the most recently entered record, that does not have an AUTOINCREMENT column ? Thanks for the tips.

mysql@lists.mysql.com

mysqlÄúºÃ! Ìì½òÊб±´óҽԺǿֱ¿Æ¼Ì³ÐÖйú´«Í³Ò½Ñ§µÄ¾«Ë裬·¢¾ò³öÁËÇ峯Ãñ¼äÌØЧ ÖÎÁÆÇ¿Ö±ÐÔ¼¹ÖùÑ×µÄÎâÊÏÖÐÒ½ÁÆ·¨£¬ÓÐЧÖÎÁÆÇ¿Ö±¼¹ÖùÑס£ ¸ÃÁÆ·¨²ÉÓöÀÌصĽ«Ö²¡Òò×ӰγöÌåÍâµÄ·½·¨,Ó¦ÓÃÏÊÖвÝÒ©Íâ·óÖÎÁÆ£¬ÎÞ Ðè¿Ú·þ£¬ÎÞ¶¾¸¶×÷ÓÃ, ¸ü²»»áÉ˼°³¦Î¸, Ò»°ãÇé¿öÖ»ÐèÁ½¸öÁƳÌ15Ìì×óÓÒ¼´¿É ʹ»¼Õß½â³ý²¡Í´¡£

Help with Sum(), newbie

OK. Maybe I'm expecting too much of myself, but I can't figure out what I am doing wrong here: mysql select * from example; +---++ | first | second | +---++ | 1 | 2 | | 2 | 3 | +---++ 2 rows in set (0.00 sec) mysql select first, second,

Re: information about the tables in the database

On Wednesday 09 October 2002 21:43, Inbal Ovadia wrote: Hi all, There is a way to know if I have table x in my db? Let's say some catalog tables that hold information about the db like tables name etc. and i can do query like select tables from catalogName and get all the tables in the db

By mistake I removed root server of localhost thru webmin

Dear List, I have removed root user of localhost thru webmin and now i am not able to login into MySQL Interface of webmin as it says Incorrect user name and password when I try to enter as any user [root or any XYZ user], please tell me how to create this user for MySQL so that I can access

Re: Help with Sum(), newbie

well the result is correct. the sum of first is 1 for the first record. the sum of first AND second would be 3. select first, second, sum(first + second) from example; is that what you want? Rgds Terence - Original Message - From: Kevin [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent:

RE: Help with Sum(), newbie

snip mysql select first, second, SUM(first) from example group by first; +---+++ | first | second | SUM(first) | +---+++ | 1 | 2 | 1 | | 2 | 3 | 2 | +---+++ 2 rows in set (0.00

Re: password / last record

Hi, On Thu, 2002-10-10 at 10:57, kayamboo wrote: 1. Is there anyway to know the string value of the password using the encrypted value , from the mysql.user table ? No. It's scrambled with a one-way (lossy) algorithm. 2. How can I know the most recently entered record, that does not

Re: InnoDb data file path

Hi Scott, On Thu, 2002-10-10 at 03:28, Scott Pippin wrote: I am trying to set up two data files in case the first one fills up. I tried to use the following in my.cnf but it says there is an error. If I take out the reference to the second data file everything works AIX 4.3.3 MySQL

Maximize Performance by Improving Search Program Logic - Help?

Hi, I need to improve the performance of a 1-word search engine which I've created. Currently the RAM is 1 GIG and the key_buffer is set at 512 MB which has improved the search results but I think perhaps I can improve my method of search with your help perhaps. The program is coded to run in

resetting mysql server gently

Hi, I have a mysql + php + apache server that is under heavy load. I have a script that runs every minute to deterimine if the load is above a certain value (or if swap is high) and if so, it kills all the httpd processes, does /etc/rc.d/init.d/mysql stop The script then starts everything

./configure --withorwithout-mit-pthreads

I switched my server from linux debian to NetBSD 1.6. All when fine until I tried to do ./configure for the mysql-3.23.52 from the source tar.gz. Problem is, it keeps looping saying can't cd to mit-pthreads. I did my homework and seeked a solution on mailing list, google etc and got nothing