Re: Replication with INNODB

Hi! Replication between MyISAM and and InnoDB tables should work, and actually many people use it. The only essential limitation in replication with InnoDB is that LOAD TABLE FROM MASTER does not work. The workaround is to ALTER the table to MyISAM, do LOAD TABLE..., and ALTER back. Best regard

MySQL/InnoDB-3.23.52 is released

Hi! InnoDB is a table type in MySQL which supports transactions, row level locking, foreign keys, and a non-free hot online backup tool. InnoDB is included in MySQL-Max-3.23 and MySQL-4.0 distributions. >From now on, the feature set of InnoDB in the 3.23 branch will be frozen. New features are

Query slowing down, need advice

Hi, I am the lead developer of Phorum . We are starting to see some users with 1 Million messages in their forums, including me at dealmac.com. I am trying to optimize the tables and I am having good luck analyzing the keys and building better ones. However, I am having a pr

Îȶ¨Ñ¹µ¹Ò»ÇÐ---ÖÐСÆóÒµÉÏÍøµÄ¾ø¼Ñ·½°¸!

Ç×°®µÄÅóÓÑ£º ÄúºÃ£¡ ÕâÊÇÀ´×ÔÏÃÃÅÍòά¿Æ¼¼·¢Õ¹ÓÐÏÞ¹«Ë¾µÄÎʺò£¬¸ÐлÄúÊÕ¿´Õâ·âÓʼþ¡£Èç¹ûÄúÒÑÓС¢»òÕý×¼±¸½¨ÉèÍøÕ¾£¬ ÄÇôÇëÄú²Î¹ÛÒ»ÏÂÎÒÃǵÄÍøÕ¾http://www.onway.net£¬ÏàÐÅÄܶÔÄúÓÐËù°ïÖú¡£ ÎÒÃÇΪÄúÌṩµÄÒÔÏÂÍøÕ¾¿Õ¼ä¶¼¿ÉÖ§³ÖÊý¾Ý¿â£¨CGI¡¢PHP¡¢MYSQL¡¢SQL¡¢ACCESS¡¢ASP¡¢JSP£©£¬È«Ãæ Âú×ãÄúµÄÐèÇó¡£Õ

Re: replication

- Original Message - From: <[EMAIL PROTECTED]> To: "Serge Paquin" <[EMAIL PROTECTED]> Sent: Friday, August 16, 2002 3:41 AM Subject: Re: replication > 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 i

Re: email marketing software

I apologized to Mark in private for my blast that was also private. Sorry to take up the bandwidth. Curtis - Original Message - From: "Mark Stringham" <[EMAIL PROTECTED]> To: "Curtis Maurand" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, August 15, 2002 11:46 PM Subject: Re

Re: Replication with INNODB

Hello, I'm not sure I am still using 3.23. Serge. - Original Message - From: "Eric Frazier" <[EMAIL PROTECTED]> To: "Serge Paquin" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, August 15, 2002 10:05 PM Subject: Re: Replication with INNODB > Hi, > > I am confused. I just

Re: Replication with INNODB

Hi, I am confused. I just tried replication with 4.0.2 on master and slave, and it appeared to work with the InnoDB tables on the Master.. What is the expected issue, or error that happens that causes the manual to say that Replication doesn't work yet with InnoDB at least not when you use LOAD

Replication with INNODB

Hello, I am trying to setup replication to be used basicaly as a hot backup. My production database uses INNODB tables. I would like my Replication database to just my MyISAM since I do not need transactions on that one. Just a copy of the data. I followed the process to create the slave b

Re: email marketing software

MailLoop works for opt-in mailings. Uses a text database however. You would have to do some sort of export. It is very configurable though. http://www.MarketingTips.com/noc.cgi/648957/mailloop.html At 22:46 8/15/2002, Mark Stringham wrote: >Hey Curtis - > >Calm down - I never said anythin

Re: email marketing software

Hey Curtis - Calm down - I never said anything about spamming. I'm working on a CRM project that sends target opt-in mailings. I am a regular user of this list and MySQL and was asking a LEGITIMATE question. You must be waiting to blast people when you think they're asking something other than

Re: MySQL vs. Oracle (not speed)

Price. MySQL == Free Oracle == On Thu, 2002-08-15 at 20:25, Elizabeth Bogner wrote: > > A company I work with is in the process of upgrading its databases from > some > motheaten system to something current. My impression is that they > want to go with Oracle, and I'm not sure if this

RE: MySQL vs. Oracle (not speed)

A few things I can say from experience, Oracle support is quite expensive as is their software and it is as much bloatware at M$ if not more. Art -Original Message- From: Elizabeth Bogner [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 7:25 PM To: [EMAIL PROTECTED] Subject: M

RE: email marketing software

There is an ODBC driver for MySQL for both Windows and Linux. Art -Original Message- From: Mark Stringham [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 6:02 PM To: [EMAIL PROTECTED] Subject: email marketing software My bad about the subject line . MS - Original Me

Re: Still trying to build libmysqld.a on Tru64

In the last episode (Aug 15), Randall Severy said: > To anyone who can help, > > I'm still struggling to build a working 4.0.2 libmysqld.a library on > the Compaq Tru64 (formerly Dec OSF) platform. I now have access to the > Compaq C++ compiler, but any libraries that I build still crash

Multi-Column Index with AutoIncrement

A month or two back I posted a question asking if an AutoIncrement column in a multicolumn index was supposed to work. At the time, I had accidently produced the intended effect, and couldn't duplicate it. Today, while browsing the MySQL docs, I discovered how to do it properly, and thought those

Re: email marketing software

That is CRM software. Its quite similar to saleslogix, though I did not see anything about storing attachments for a customer. It otherwise looks very, very cool. Curtis - Original Message - From: "Wee Keat" <[EMAIL PROTECTED]> To: "Mark Stringham" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED

MySQL vs. Oracle (not speed)

A company I work with is in the process of upgrading its databases from some motheaten system to something current. My impression is that they want to go with Oracle, and I'm not sure if this is based on anything other than being impressed with the size and presumed quality support of Oracle. I'

Re: email marketing software

I'm not too sure what u want exactly... but I found this a few days ago... check it out... http://www.relata.org/articles.php?Entry_ID2=12 - Original Message - From: "Mark Stringham" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: 16 August, 2002 11:02 AM Subject: email marketing sof

Re: what dir is mysql.sock in?

At 15:59 -0700 8/15/02, Dave Reinhardt wrote: >what dir is mysql.sock in? /tmp/mysql.sock is a likely location, but it depends on your configuration. Why? - Before posting, please check: http://www.mysql.com/manual.php (th

Re: startup automatic

At 20:54 -0300 8/15/02, Paulo Azevedo IEG wrote: >Hi all > >I have Mysql Version: 3.23.49a at RadHat 7.2 > >I read the documentation about automatic startup/shutdown >but when I start the script it wait for a ENTER >then it doesn't work at boot >I always need do manual startup > >anybody have any

Re: Zombie slave process on my master

Thanks, Victoria. Yes, there is a master.info, and it looks like the culprit. Can I just delete it? Any idea where it came from? To the best of my knowledge, the server was never started as a slave. > Date: Thu, 15 Aug 2002 16:42:01 +0300 > From: Victoria Reznichenko <[EMAIL PROTECTED]> > Sub

email marketing software

My bad about the subject line . MS - Original Message - From: "Mark Stringham" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, August 15, 2002 6:57 PM Subject: Re: Transactions not supported by database - Perl > Anyone know of an email marketing software suite that works

Re: Transactions not supported by database - Perl

Anyone know of an email marketing software suite that works well with MySQL on the backend? I've seen stuff that works with ODBC db connectivity but I'm not interested in moving to MS SQL or Access. Any feedback is appreciated Thanks Mark -

RE: Transactions not supported by database - Perl

I have expereience the same behaviour when using the ppm from activestate. Try using the one below, seem to work for me... ppm install http://theoryx5.uwinnipeg.ca/ppmpackages/DBD-mysql.ppd -Original Message- From: Gerald Clark [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 14, 2002

Fax to MySQL

Does anyone know of a solution that would allow me to setup faxing into a MySQL database, preferably GNU? Thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

startup automatic

Hi all I have Mysql Version: 3.23.49a at RadHat 7.2 I read the documentation about automatic startup/shutdown but when I start the script it wait for a ENTER then it doesn't work at boot I always need do manual startup anybody have any hint ?? ats Paulo ---

Still trying to build libmysqld.a on Tru64

To anyone who can help, I'm still struggling to build a working 4.0.2 libmysqld.a library on the Compaq Tru64 (formerly Dec OSF) platform. I now have access to the Compaq C++ compiler, but any libraries that I build still crash in the thread functions, as follows: Program terminated w

Getting users next slot

I'm working on building an online scheduling system. I want to be able to select all the users who don't have any scheduled commitments on the next weekend and then sort based on when the users next scheduled spot is. I have a few problems however. First of all I have a set of users who don't have

MySQL ERROR 1133 MEANING?

Hi friends: I try to grant privileges to a user named 'glen' but not succeed. Here is the script: -# mysql> update user set Password=password('tidbs1') where User='glen'; Query OK, 0 rows affected (0.00 sec) Rows matched: 1 Cha

MySQL ERROR 1133 MEANING?

Hi friends: I try to grant privileges to a user named 'glen' but not succeed. Here is the script: -# mysql> update user set Password=password('tidbs1') where User='glen'; Query OK, 0 rows affected (0.00 sec) Rows matched: 1 Cha

Re: LIMITing result sets - Spoiled by MySQL

Michael, I do not believe there is a real equivalent. SQL Server supports the 'TOP' statement. It is like using the one-argument variation of MySQL's LIMIT clause. It looks like: SELECT TOP 20 foo FROM BAR The obvious problem is that this is pretty much useless for pagination, sin

what dir is mysql.sock in?

what dir is mysql.sock in? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubsc

RE: Is this a known issue?

I'm using MYSQL Ver 3.23.49a. Thanks. Jay Song -Original Message- From: Jocelyn Fournier [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 6:20 PM To: Song, Jay; [EMAIL PROTECTED] Subject: Re: Is this a known issue? Hi, What version of MySQL are you using ? Regards, Jocel

Re: Is this a known issue?

Hi, What version of MySQL are you using ? Regards, Jocelyn - Original Message - From: "Song, Jay" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, August 15, 2002 11:57 PM Subject: Is this a known issue? > Well, I am not sure if anyone has experienced the same problem, or

Date comparison assistance please

I have a column defined in a table as type date. I desire to include a date comparison in the WHERE clause of the following statement. The following statement is not working correctly, I suspect that there is a formatting issue. The statement returns true even if USER.elig_date has an earlier date

Query problem

Hey all, I've been given the task of adding a few hundred, and later a few thousand, new records to my database that currently exist in (ugh...) an excel spreadsheet. I was able to very quickly and efficiently deal with the initial insertion of the main data to the main table, but am having diffi

Re: Supplied argument is not a valid MySQL result resource!!

At 8/16/2002, you wrote: >Hi, >in the piece of code given below >--- >$qid = mysql_query(" > SELECT * > FROM 1_nodedata > WHERE id = $edit_id > "); > $frm = mysql_fetch_array($qid); >--- >i get the follownig error: > >Warning: Supplied argument is not a valid MySQL result reso

Is this a known issue?

Well, I am not sure if anyone has experienced the same problem, or if this problem has been documented, but this is what I have noticed: After one of my data table was full, I started to delete old records from the table to allow new data to be inserted. Since then, the LIMIT function stop workin

Re: Table locking questions

At 8/15/2002, you wrote: >Hi everyone! > >I'm fairly familiar with the table locking methods in MySQL but I have a >problem I can't solve. > >I have two main tables which are read simultaneously by many clients. The >clients only do reads, but they do it very extensively and for 30 secs each. > >T

Re: Losing data

Jacob, - Original Message - From: "Devore, Jacob" <[EMAIL PROTECTED]> To: "'Heikki Tuuri'" <[EMAIL PROTECTED]> Sent: Friday, August 16, 2002 12:20 AM Subject: RE: Losing data > can one change a table from MyISAM tables into something else on the fly? ALTER TABLE tablename TYPE = somety

Re: Supplied argument is not a valid MySQL result resource!!

can u plz tell me how can i check that? regards anil - Original Message - From: "Dan Nelson" <[EMAIL PROTECTED]> To: "Anil Garg" <[EMAIL PROTECTED]> Cc: "SteveH" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, August 15, 2002 5:41 PM Subject: Re: Supplied argument is not a valid M

Re: Supplied argument is not a valid MySQL result resource!!

Let's try this : $qid = mysql_query("SELECT * FROM 1_nodedata WHERE id='$edit_id'") or die(mysql_error()); - Original Message - From: "Anil Garg" <[EMAIL PROTECTED]> To: "Jocelyn Fournier" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, August 15, 2002 11:42 PM Subject: Re: Supp

Re: Supplied argument is not a valid MySQL result resource!!

yes..it echos $edit_id fine. i am also feeling strange why its not working! regards anil - Original Message - From: "Jocelyn Fournier" <[EMAIL PROTECTED]> To: "Anil Garg" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, August 15, 2002 5:40 PM Subject: Re: Supplied argument is no

Re: Supplied argument is not a valid MySQL result resource!!

In the last episode (Aug 15), Anil Garg said: > > Thursday, August 15, 2002, 1:12:21 PM, you wrote: > > > > > Hi, > > > in the piece of code given below > > > --- > > > $qid = mysql_query(" > > > SELECT * > > > FROM 1_nodedata > > > WHERE id = $edit_id > > > "); > > > $frm = mysql_fet

Re: Supplied argument is not a valid MySQL result resource!!

Hi, try : > $qid = mysql_query(" > SELECT * > FROM 1_nodedata > WHERE id = '$edit_id' > "); > $frm = mysql_fetch_array($qid); (what does echo "edit_id : $edit_id"; display ?) Regards, Jocelyn - Original Message - From: "Anil Garg" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent

problem connecting to mysql with gui

please how can i set Sql command on connect to be able to connect to mysql.i am a novice.i tried to enter /var/lib/mysql/mysql.sock but still couldn't connect.help please. i have tried with both static and semi-static files. thanks.

Losing data more info

create table EAP (eapID int auto_increment primary key, Name varchar(60), Addr1 varchar(50), Addr2 varchar(50), City varchar(30), State varchar(2), index state_ind(state),

Re: Supplied argument is not a valid MySQL result resource!!

hi, m sorry i dint mention that its just a part of code. i am able to delete entries from the database .so i think mysql_connect is not the reason. please tell if u have some more ideas regards anil - Original Message - From: "SteveH" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thur

Re: Supplied argument is not a valid MySQL result resource!!

Anil, You never created a connection. mysql_connect() Regards. Thursday, August 15, 2002, 1:12:21 PM, you wrote: > Hi, > in the piece of code given below > --- > $qid = mysql_query(" > SELECT * > FROM 1_nodedata > WHERE id = $edit_id > "); > $frm = mysql_fetch_array($qid); >

RE: creating a database without being an administrator

is there a way to give certain users rights to create and drop mysql databases without being administrators? I'd like to create a new database every time a user runs my code on a new set of data. thanks Josh - Before po

Re: Losing data

Anna, please check with SHOW VARIABLES if InnoDB is enabled in mysqld. Also check with SHOW CREATE TABLE tablename that your tables really are of the InnoDB type. Error 127 means the 'table is crashed', and I think only MyISAM type tables can return that error number. An upgrade to 4.0.2 is

Supplied argument is not a valid MySQL result resource!!

Hi, in the piece of code given below --- $qid = mysql_query(" SELECT * FROM 1_nodedata WHERE id = $edit_id "); $frm = mysql_fetch_array($qid); --- i get the follownig error: Warning: Supplied argument is not a valid MySQL result resource in /z/mercury/www/niksun/admin/add_doc

RE: LIMITing result sets - Spoiled by MySQL

Well, I am not sure about MS, but in Oracle you have to use the rownum pseudocolumn and a pseudocolumn, an example: SELECT * FROM (SELECT * FROM mytable ORDER BY somedatefield) WHERE rownum > 20 AND rownum < 30; or something like that. It may be similar for MSsql, I am not sure. Mike P.S. my e

Re: LIMITing result sets - Spoiled by MySQL

Hi, I don't know MSSQL well, but what about TOP ? Regards, Jocelyn - Original Message - From: "Michael Marano" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, August 15, 2002 10:37 PM Subject: LIMITing result sets - Spoiled by MySQL I am used to working in MySQL, and am n

LIMITing result sets - Spoiled by MySQL

I am used to working in MySQL, and am now working with MS SQLServer :( I'm hoping someone else has been in this unfortunate situation before and can help me out. I'm looking to do pagination of some resultset in JSP. in MySQL I would have used something like: SELECT * FROM mytable ORDER

Table locking questions

Hi everyone! I'm fairly familiar with the table locking methods in MySQL but I have a problem I can't solve. I have two main tables which are read simultaneously by many clients. The clients only do reads, but they do it very extensively and for 30 secs each. The two main tables needs updates e

Losing data

Hej I have several databases with several tables in them and all works fine except for one database that loses data. I'm running mySQL 4.0.1-alpha-nt and the tables are all INNODB. The problem is as follows: Table B references table A by a foreign key. I've filled table A with all the data I

Can't locate loadable object DBD::mysql in @INC

Hello Everyone, We are attempting to use a Perl script to access MySQL on Red Hat Linux release 7.2 (Enigma) Kernel 2.4.7-10 on an i686 Unfortunately, the below error keeps appearing: - install_driver(mysql) failed: Can't locate loadable object for module DBD::mysql in

Problem with joining multiple tables

I am having some problems getting multiple joins to work. I have the following code: mysql> select customers.customer_id, last, first, company, count(work_order.work_order_number) as WO -> from customers left join work_order -> on (customers.customer_id=work_order.customer_id) -> whe

Re: joining to tables

> 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 include the entire text of it in the > reply, you

Query help

filter fodder: sql, query Hi all, I feel like I am probly being amazingly stupid, but here goes nothing. I have 3 tables: "students" "undergrads" "postgrads" "students" holds all common info. eg dt_matric, dob, religion, etc. undergrads hold eg. degree, subject postgrads holds eg. transfer_dat

MySQL 3.23 problems on BSDI 4.1

I downloaded and built mysql-3.23.49 on my BSDI 4.1 system. It configured and built fine, but it hangs whenever I do more than the most trivial operations. It is my dim recollection that there have been problems with the thread libraries in the past. Does this ring a bell? (I can't use the pre

Re: Load Data Warnings

On 15 Aug 2002, at 10:45, Brian Fahey wrote: > How do I find out what the warnings are? I haven't been able to find > anything about what they are. Paul DuBois has a Perl script, load_diag.pl, that could answer your question: http://www.kitebird.com/mysql-cookbook/ Or you could export the d

"test" and "test\_%"

I have a database called test in the mysql database db table it is listed as "test" and "test\_%" what is the significance of two record that have all the Y/N entries the same? . - Before posting, please check: http://ww

Load Data Warnings

I have been using the following code and have been getting warnings: LOAD DATA INFILE 'myfile' INTO TABLE mytable FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n' (myfields); Query OK, 206 rows affected (0.13 sec) Records: 206 Deleted: 0 Skipped: 0 Warnings: 14 How do I find out what the

Load Data Warnings

I have been using the following code and have been getting warnings: LOAD DATA INFILE 'myfile' INTO TABLE mytable FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n' (myfields); Query OK, 206 rows affected (0.13 sec) Records: 206 Deleted: 0 Skipped: 0 Warnings: 14 How do I find out what the

Re: RES: Aggregate + left outer join (Solution)

Hi Eduardo, I found the solution the left outer join + aggregate problem I had earlier faced. the query should be SELECT p.nm_project, sum( dl.hours) FROM PROJECT p LEFT OUTER JOIN DAYLOG dl ON (p.id_project = dl.id_project

RE: Mysql Table Case

Well, I guess that ISN'T really the case. http://www.mysql.com/doc/en/Name_case_sensitivity.html Sorry that I asked the question at all, but thanks for the replies. -James -Original Message- From: Nilesh Shah [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 10:20 AM To: James

Re: Mysql Table Case

At 9:59 -0700 8/15/02, James Kelty wrote: >Hello, > >Is there a compile option or startup option to make mysql ignore table name >case? So that the tables security and Security would be seen as the same >table? --set-variable=lower_case_table_names=1 But you should rename your tables to lowercas

RE: Mysql Table Case

Answer is No. Case-sensitivity of table names depends on operating system you are running mysql on.MySQL stores table definitions in TABLENAME.* files. So it will always be case-sensitive on *nix and case-insensitive on windows. Nilesh -Original Message- From: James Kelty [mailto:[EMAIL

Primary key info in C API

Typically when using the C API, when you do a Select, MySQL hands back a virtual table where the fields (columns) are marked with various kinds of info - their name and source table, as you might expect, but also stuff like whether this field is the primary key for its table. So for example i

Mysql Table Case

Hello, Is there a compile option or startup option to make mysql ignore table name case? So that the tables security and Security would be seen as the same table? -James James Kelty Director of Operations Everbase Systems, LLC 624 A Street Ashland, OR 97520 [EMAIL PROTECTED] 541.488.0801

warnings in 4.x

Does anyone know if version 4.x has/will have warnings if data being inserted is too large for a column? sql,query -- Walter Anthony System Administrator National Electronic Attachment Atlanta, Georgia 1-800-782-5150 ext. 1608 "If it's not broketweak it"

Re: Slow Log

Did you check your error logs? Does mysql have write permissions to /home/admin ? John Wards wrote: >I am having problems with mysql loggin slow queries. I have set up mysql.sh >like this > >log_dir=/home/admin/slow_slog.log > >$bindir/safe_mysqld --datadir=$datadir --pid-file=$pid_file --log-sl

RE: View current connections

Is the MySQL serving a web site? If yes, wrap show processlist in perl or php and have it generate an auto refreshing page. On Thu, 15 Aug 2002, Tab Alleman wrote: > Date: Thu, 15 Aug 2002 11:01:44 -0400 > From: Tab Alleman <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Subject: RE: View curren

Fwd: Cannot run any I configure

-- Forwarded Message -- Subject: Cannot run any I configure Date: Thu, 15 Aug 2002 11:08:26 +0100 From: Barry Schofield <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: [I have tried rpm's and 4.0 version and your 3.23.51-pc-lin

I cannot get mysql to run.

-- Forwarded Message -- Subject: I cannot get mysql to run. Date: Thu, 15 Aug 2002 11:02:08 +0100 From: Barry Schofield <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] SEND-PR: -*- send-pr -*- SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as SEND-PR: will al

Re: View current connections

> ...I'm really hoping to > find is a GUI that updates itself on the fly, kind of like the Win2k > Task Manager processes tab. Anybody got anything like this? I am really happy with this one http://www.anse.de/mysqlfront/ It can do that and a lot of other nice features. Best regards, Mikhail.

myisampack/myisamchk question

I got an error while executing myisamchk -rq on compressed table. Here's the output: [root@db prod_rel5_1_0]# myisampack buyer Compressing buyer.MYD: (3687550 records) - Calculating statistics - Compressing file 62.69% Remember to run myisamchk -rq on compressed tables [root@db prod_rel5_1_0]# m

RE: View current connections

Thanks for the reply Egor.. This helps, but what I'm really hoping to find is a GUI that updates itself on the fly, kind of like the Win2k Task Manager processes tab. Anybody got anything like this? -Original Message- From: Egor Egorov [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 1

Re: problem starting mysqld on Solaris 2.8 (source distribution)

The mysql user needs write permission on the directory /usr/local/mysql-3.23.51/var Mark Gillett wrote: >Having done some further work (I re-built using 3.23.51) I have managed to >have the server startup and run, however I am still experiencing the : > >020814 15:25:48 /usr/local/mysql-3.23.5

Re: CDSISIS

Hi people, I ´ve converted from an ISIS database to Mysql. The opposite also is possible. As you know an ISIS tech database could not be relational. Perhaps you want to make some normalization first. I have done this using ISIS_DLL from VB, firs created an Access Database, exported to text an

temporary files

HI, MySQL keep the temporary files until it's closed down. Is there somme possibility to remove them as soon as they are no longer needed?? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

FW: temporary files

-Original Message- From: DRISSI,SAMIA (Non-A-hsgGermany,ex1) Sent: Thursday, August 15, 2002 4:06 PM To: [EMAIL PROTECTED] Subject: Hi, Bei running one application on MySQL, the server generates a giant temporary file. At the same time i call the application again, and keep all old p

Re: Zombie slave process on my master

Bill, Thursday, August 15, 2002, 3:43:03 PM, you wrote: BE> Our server seems to think it is a slave. It has a slave thread rnning, BE> whose only action is to complain once a minute about not being able to BE> connect to master "". This just started one day, when we took the server BE> down and

Re: Problems connecting

Elna, Thursday, August 15, 2002, 4:16:59 PM, you wrote: EM> I have the mysqlgui installed on my machine which has Win NT. The db is on EM> another machine, which I connect to using Telnet, and then the mysql command EM> to connect to the db. That works fine. I want to however connect with the

RE: Setting root password in mysql for windows

Still could not get it to work so I uninstealled and reinstalled. Will use the anonymous login etc util I figure out this security system. Is there a document that explains the password system in laymans terms? Art -Original Message- From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]]

Re: temporary files,

samia, Thursday, August 15, 2002, 3:45:27 PM, you wrote: s> It's my first time for using MySQL. s> I would know, why does it generate such giant temporary files. And what should i do to save my disk from getting s> filled by these files. MySQL uses temporary tables in some queries. So, if you i

Re: MySQL 4.0.2, 4.0.3 replication circle broken.

Artem, Thursday, August 15, 2002, 12:06:07 PM, you wrote: AVR> In case of repliacation circle (A->B->A) query 'flush log' on any of AVR> this servers create endless loop, with creating new binary log file AVR> on each iteration. (about 30 new files every second in my case) Thanks for bug r

Slow Log

I am having problems with mysql loggin slow queries. I have set up mysql.sh like this log_dir=/home/admin/slow_slog.log $bindir/safe_mysqld --datadir=$datadir --pid-file=$pid_file --log-slow-queri es=$log_dir & That is all I have changed and re started mysql. but no slow_slog.log file has been

Problems connecting

I have the mysqlgui installed on my machine which has Win NT. The db is on another machine, which I connect to using Telnet, and then the mysql command to connect to the db. That works fine. I want to however connect with the gui to the db on the other machine which I connect to using Telnet wi

Re: Newbie With a Question

* Jones Tyler > My problem is that I am unable to change data in an > existing table. I use the UPDATE function and it > continues to tell me that I am using an Unknown > Column. That's right, you are... :) > When I do a DESCRIBE on the table, I clearly see the > column. > > Since I can see the

RE: RE: null

ok , but I have now just programmed around the error to meet my deadline... -Original Message- From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 6:08 AM To: [EMAIL PROTECTED] Subject: Re: RE: null Mary, Wednesday, August 14, 2002, 7:23:47 PM,

temporary files

Hi, It's my first time for using MySQL. I would know, why does it generate such giant temporary files. And what should i do to save my disk from getting filled by these files. Regards Semia - Before posting, please check: htt

temporary files,

Hi, It's my first time for using MySQL. I would know, why does it generate such giant temporary files. And what should i do to save my disk from getting filled by these files. Regards Semia - Before posting, please check: htt

Zombie slave process on my master

Our server seems to think it is a slave. It has a slave thread rnning, whose only action is to complain once a minute about not being able to connect to master "". This just started one day, when we took the server down and brought it right back up. I'd like to get rid of the slave thread, but

Re: Setting root password in mysql for windows

Art, Thursday, August 15, 2002, 7:12:40 AM, you wrote: AF> Having a hard time coming to grips with the password setup for mysql in AF> windows. I follow the instructions below from the documentation. AF> C:\> C:\mysql\bin\mysql mysql AF> mysql> DELETE FROM user WHERE Host='localhost' AND User=''

Re: Speed problems.. Still

On Thu, 15 Aug 2002, Benjamin Pflugmann wrote: > Let me try to explain. > Last, an introduction into LEFT JOINs: Benjamin, this was a very good explanation. I would love to see an edited version of your post included in the "Tutorial" section of the very fine manual. Regards, Thomas Spah

Fwd: RE: Newbie With a Question

Well, that's strike one for me! I sent my first post to the list and accidently ONLY sent it to one member of the list (who was kind enough to respond anyway!) My problem is that I am unable to change data in an existing table. I use the UPDATE function and it continues to tell me that I am using

  1   2   >