Convert ISAM table to MyISAM

Hi all. I'm going to upgrade a mysql-3.22 Linux Pentium server to mysql-3.23.49a. Which is the best way to convert a database of ISAM table to MyISAM? mysqldump? How to do it? Iago. - Before posting, please check:

RE: running script through C program

-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 14, 2002 1:00 PM To: Chetan Lavti Subject: Re: running script through C program Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass

RE: Retrive distinct data from two tables

Try: SELECT B.name FROM B LEFT JOIN A ON A.name = B.name WHERE A.name is null; -Original Message- From: Pichan M. [mailto:[EMAIL PROTECTED]] Sent: Thursday, 14 March 2002 12:19 PM To: [EMAIL PROTECTED] Subject: Retrive distinct data from two tables I have 2 tables, let says, table A

RE: mysql, query :running script through C program

-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 14, 2002 2:22 PM To: Chetan Lavti Subject: Re: mysql, query :running script through C program Your message cannot be posted because it appears to be either spam or simply off topic to our

[mysql] Multiple WHERE options in SELECT

i wonder if its possible to perform multiple WHERE statements in one mysql SELECT statement like: SELECT * FROM table WHERE field1=3D'one' AND field2=3D'two' OR field3=3D'three'; it works with as many AND and it works with OR but not together is there something like brackets or other logical

Making UPDATE return the no. of rows matched

Hi all, I have changed database for my Java app to MySQL. The app was developed with SQL Server. Some of the logic is dependent on getting the no. of rows updated returned after an UPDATE query. MySQL does only return the rows that are really updated, not the rows matched of an UPDATE. This

Re: [mysql] Multiple WHERE options in SELECT

Jan, i wonder if its possible to perform multiple WHERE statements in one mysql SELECT statement like: SELECT * FROM table WHERE field1=3D'one' AND field2=3D'two' OR field3=3D'three'; it works with as many AND and it works with OR but not together is there something like brackets or other

Re: Changing character X to Y in a table

Hi Jari, have not figured out if one can do character changes with mysql, any one know how to do the following for fields in a table Altering all the x-characters to character y ? =You sure can. Manual reference: 6.3.2 String Functions REPLACE() will find the x-characters and replace them all

two-way replication

hello, i'm new to the list and don't know if this has been discussed before, so excuse me if repeating. i have the idea of setting up a two-way replication system with 2 mysql servers for my radius database. i need them to act interchangeably: 1. if server1 is alive, all selects and updates

Re: mysql hotcopy

Mark, Wednesday, March 13, 2002, 9:53:08 PM, you wrote: MS Quick question - MS I have a db named content with user admin and pass mypass Do I still MS use -u root p maypass ? or would I use MS mysqlhotcopy -u admin -p mypass content /path/to/copy/the/data/to MS Thanks again for your help. If

adding administrative users in mysql

mailing, Wednesday, March 13, 2002, 9:41:11 PM, you wrote: ml I am attempting to add the ROOT user as a MYSQL administrator using the ml following syntax: ml mysqladmin -u root password 12345 This command doesn't add user 'root', it can only change password for that user. ml and I recieve the

Retrive distinct data from two tables

Pichan, Thursday, March 14, 2002, 6:19:23 AM, you wrote: PM I have 2 tables, let says, table A and table B. Each table record person PM name. PM select B.name from B, A where B.name = A.name PM Query above should return the name which recorded in both tables (duplicate PM name) PM In

a quick sanity check...

denonymous, Wednesday, March 13, 2002, 9:06:48 PM, you wrote: d Hi all -- I just need a quick sanity check on a query. d I have two tables: d CREATE TABLE users ( d userID VARCHAR(10) NOT NULL PRIMARY KEY, d [many other fields] d ) d CREATE TABLE subscriptions ( d userID

Convert ISAM table to MyISAM

Iago, Thursday, March 14, 2002, 10:17:10 AM, you wrote: IS I'm going to upgrade a mysql-3.22 Linux Pentium server to mysql-3.23.49a. IS Which is the best way to convert a database of ISAM table to MyISAM? IS mysqldump? IS How to do it? You can use mysqlcheck or ALTER TABLE statement. You can

Re: Changing character X to Y in a table

Hi Jari, have not figured out if one can do character changes with mysql, any one know how to do the following for fields in a table Altering all the x-characters to character y ? =You sure can. Manual reference: 6.3.2 String Functions REPLACE() will find the x-characters and replace

Re: a quick sanity check...

- Original Message - From: Victoria Reznichenko [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, 14 March, 2002 12:48 Subject: a quick sanity check... : denonymous, : Wednesday, March 13, 2002, 9:06:48 PM, you wrote: : : d Hi all -- I just need a quick sanity check on a query. :

LEFT OUTER JOIN where not null datetime column is null gives incorrect result.

Description: Left outer join on null datetime column produces incorrect result. The 2nd select below produces no rows, which is incorrect and inconsistent with the fourth select which produces 1 row. I get the same results with server version 3.23.41 - binary version from

Re: Compiling problem 3.23.49 under linux (mysql.cc)

It looks like you hit some C++ code on the first line. There are still major problems in using gcc 3.x for compiling C++ on Linux. On my own box, I had to downgrade to gcc 2.9.6. MySQL compiles flawlessly now. On Thu, 2002-03-14 at 01:19, MWP wrote: Hi all... I get: c++-303

Please send me urgent reply

I want to access the mysql through C-language. Please tell me which files I have to patch , from which sites. If u can give me any tuitorial that will be great. Please reply me on my Email-Id given below. My Email-Id is :- [EMAIL PROTECTED] __

3rd time and last

This is my last mail trying to get an answer from you to those 2 questions. You could at least say: go to the manual or don't know or don't ask it again or something Is the subject boring ?!?!?! _ Subject: Default RPMs and RAID support I want to

Re: Replication 2 way

- Original Message - From: [EMAIL PROTECTED] To: Patrick [EMAIL PROTECTED] Sent: Thursday, March 14, 2002 2:05 PM Subject: Re: Replication 2 way 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

Re: constraints in InnoDB, or is 3.23.43b _really_ 4.0.1?

Tomasz, are you using a non-latin1 character set? The bug fixed in 3.23.49 MySQL/InnoDB-3.23.49, February 17, 2002 * Fixed a bug: if one defined a non-latin1 character set as the default character set, then definition of foreign key constraints could fail in an assertion failure in

SSL

Hi All Do any of you use SSL option in MySQL and if so are there and performance problems when connecting to MySQL? Thanks Simon Green -- Live Life in Broadband www.telewest.co.uk The information transmitted is intended only for the person or entity to

RE: 3rd time and last

* ds This is my last mail trying to get an answer from you to those 2 questions. You could at least say: go to the manual or don't know or don't ask it again or something I don't think it is a good idea to reply I don't know or similar... don't know how many readers are on this list, but

Re: [bug] MySQLGUI 1.7.5-1 crash with year column type

Alex Vandiver writes: Heya, I've managed to repeatably crash mysqlgui by running a query that returns a column of type year. Though it dumps core, gdb does not provide a useful stack trace. Though this is not a serious bug, it is a bit of an annoyance. - Alex Vandiver --

Re: a quick sanity check...

Konstantin, Thursday, March 14, 2002, 1:04:42 PM, you wrote: KT : denonymous, KT : Wednesday, March 13, 2002, 9:06:48 PM, you wrote: KT : KT : d Hi all -- I just need a quick sanity check on a query. KT : KT : KT : d I have two tables: KT : KT : d CREATE TABLE users ( KT : d userID

unable to invoke mysql prompt after installation and unable to run mysql_install_db

Unable to invoke mysql prompt after the trial download on sun solaris 2.8 Unix. attaching the error which i got after running the ./scripts/mysql_install_db -- ./scripts/mysql_install_db ld.so.1: ./bin/my_print_defaults: fatal: libz.so: open failed: No such file or directory WARNING:

major performance disparities with mysql/php

Hello Again - I'm posting this again, since it still is an issue that I can not resolve - please help! I've recently installed mySQL on a RH7.2 box without any problems - it runs great. I've been testing some long running queries (full table scans, etc) under different scenarios, and get

Please send me urgent reply

fdfghd, Thursday, March 14, 2002, 2:06:05 PM, you wrote: fg I want to access the mysql through C-language. fg Please tell me which files I have to patch , from fg which sites. fg If u can give me any tuitorial that will be great. What about C API for MySQL? You can read about in at:

Mysql memory problem

Hi guys, I have a quad Xeon 550 server, 4gb RAM, with a RH Linux 6.2 + patches, kernel 2.4.8 and mysql Ver 11.17 Distrib 3.23.49a. After the start, mysql starts to grow memory usage. It grows until it consumes all machine memory. After a restart it uses only 17Mb of memory, 18

Re: a quick sanity check ++

right, of course ;-) (i neglected the join part) so, now i know exactly whom to ask ;-) i have the following bother (it's in the planning state): i have the idea of setting up a two-way replication system with 2 mysql servers for my radius database. i need them to act interchangeably: 1. if

Mysql memory problem

Hi guys, I have a quad Xeon 550 server, 4gb RAM, with a RH Linux 6.2 + patches, kernel 2.4.8 and mysql Ver 11.17 Distrib 3.23.49a. After the start, mysql starts to grow memory usage. It grows until it consumes all machine memory. After a restart it uses only 17Mb of memory, 18

Dumping binary data

If a table has a blob type containing binary data, like jpeg images or PDF files for example, can mysqldump be told to encode the data so it is ASCII compatible? (using uuencode or something like that..) I am not sure of the 'right' way to do this, but some informal tests where I dump and

automating mysql command

Hi folks, Let me first say that I am used to using mysql through PHP rather than command line . . . And, as I understand it mysql does not support any sort of “timers”. I need to use a Unix command like cron to automate either a mysql command or php script to output a selection from a few mysql

Re: 3rd time and last

You said This is my last mail trying to get an answer from you to those 2 questions. You could at least say: go to the manual or don't know or don't ask it again or something Is the subject boring ?!?!?! I reply--- Who is the you you are addressing? This list is a self-help list for

Re: Error 2002 can't connect to MySQL server through socket /var/lib...

Hello, I work with Suse 7.1 and mysql 3.23.30 gamma. I have killed the mysql settings and so I remove the mysql-RPMs and install mysql 3.23.41 with yast1. Perhaps a mistake, I didn´t reboot the system after removing the RPMs. Then I have same Problems, like: I Funny I still have the same exact

Re: automating mysql command

On Thursday, 14. March 2002 15:13, Andrew Hazen wrote: Can I just write the mysql commands as a .sql file and tell Unix to execute it? Or is there another way? When you already use PHP, why don't use php-cli and execute it via cron?! Regards Georg

Re: [mysql] Multiple WHERE options in SELECT

From: schwingenschloegl jan [EMAIL PROTECTED] i wonder if its possible to perform multiple WHERE statements in one mysql SELECT statement like: SELECT * FROM table WHERE field1=3D'one' AND field2=3D'two' OR field3=3D'three'; it works with as many AND and it works with OR but not

Re: 3rd time and last

and yet there is another novel option to this particular problem. you can pay someone to teach you how to do it. in just about any case where money is in fact exchanging hands, results are expected. then you'd have an actual reason to bitch. jay downs - Original Message - From:

RE: automating mysql command

You sure can do it.. Just put your sql commands into a .sql file and use mysql file.sql syntax to to have them executed by mysql. And you can always use cron in Unix to do it periodically.In your Unix box do: man crontab man cron to learn more about cron jobs. You can also consult to

glitch or me?

Hi I have 2 SQL fragments that pull up 2 differing results and I have no idea why. The two pieces of code are identical bar one line which is : AND individual_id ='AB00090004' AND Category = 'DXS1047' The code that produces the correct code is: select Raw3_2.category,

glitch or me?

Hi I have 2 mySQL fragments that pull up 2 differing results and I have no idea why. The two pieces of code are identical bar one line which is : AND individual_id ='AB00090004' AND Category = 'DXS1047' The code that produces the correct code is: select Raw3_2.category,

Couldn´t Performe the edit because another user changer

MySQL Hi all, I am receving this error message sometimes when I tried to update a record. I am using Delphi 3, ODBC connection and TTable object. What I have to do ? Somebody can help me ? Tks, Roberto Alexandre -

Re: 3rd time and last

This has nothing to do with this list... It's just that i'm sorry for the message i sent today, i agree with ppl who answered me and realised i was being..well...you know what. Once again, sorry, i won't do it again and thank you for the answers. -- dsoares (sql)

RE: How to set permissions?

This might not be the best way, but for the people here at my office who aren't familiar with command line interfaces, I've setup MyODBC and MS Access. This let's them add/edit user's account info directly. The only thing you can't do (afaik), is change a user's password. -- Mike Miller --

Re: Couldnt Performe the edit because another user changer

The record you want to update is locked by another client. Check return value of your update() What you have to do is approx. the following: while( record_locked) { sleep(...) if( update(...) == OK ) break; } Roberto Freitas Alexandre wrote: MySQL Hi all, I am receving

RE: Convert ISAM table to MyISAM

Thanks for your help Victoria. Iago. -Mensaje original- De: Victoria Reznichenko [mailto:[EMAIL PROTECTED]] Enviado el: jueves 14 de marzo de 2002 11:48 Para: [EMAIL PROTECTED] Asunto: Convert ISAM table to MyISAM Iago, Thursday, March 14, 2002, 10:17:10 AM, you wrote: IS I'm going

Checking if table empty

I have a strange, but probably easy to fix problem. I need to check to see if something is in a table...that part is easy, but if the table is empty, it doesn't go through my while statement so that I can create something in it. I am sure that if there was something in the table, that I

UDF's and Windows

Perhaps this is common knowledge, but is there still no support for UDFs in Windows. If not, are there any work arounds for trying to perform complicated calculations on the server?] Thanks, Craig mysql, query - Before

request: mysql install question

After I went through the following steps successfully, (The previous problem I had regarding inability to untar files was solved by downloading stuff on that computer where it was untarred. Before that I was trying to untar stuff downloaded on to a samba share !!!) shell groupadd mysql shell

Files *.TMM and *.TMD

Hi. For what are files with extension .TMM and .TMD? Are residual files of mysqldump? I killed a mysqldump, and I see these files on the directory of the database but I don't know if they were before the mysqldump. Iago. -

Re: constraints in InnoDB, or is 3.23.43b _really_ 4.0.1?

At 01:57 2002-03-14, Heikki Tuuri wrote: Tomasz, are you sure you are running 4.0.1? In the rpm of 4.0.0 there were no foreign keys. I tested this on mysql-max-4.0.1, and it worked. Well... [root@flow11 httpd]# mysqladmin -p version Enter password: mysqladmin Ver 8.23 Distrib 4.0.1-alpha, for

RE: glitch or me?

* Richard [...] When the same code is run but without the line: AND individual_id ='AB00090004' AND Category = 'DXS1047' a fragment of the results is: +--+---++---+-+-+ | category | Individual_ID | Inactivate | count | minkey | maxkey

RE: How to set permissions?

I have totally different task. I don't want to give users any other privileges but SELECT. But because I use MERGE tables for showing reports to users I must give for these tables UPDATE and DELETE privileges. And here I am talking about several hundreds tables for each user. MySQL doesn't have

Re: constraints in InnoDB, or is 3.23.43b _really_ 4.0.1?

At 07:22 2002-03-14, Heikki Tuuri wrote: Tomasz, are you using a non-latin1 character set? No, didn't change the charset. As You can see from my reply to Victoria yesterday, will need to, eventually (for different reasons, though, not books), but right now I am in a proof-of-concept stage:

VB/MySql/CrystalReport Problem?

Dear folks, Now i try to migrate my Visual Basic Application from MS SQL Server to My SQL, I met problem when my crystal report connect ot My SQL, Below is my code: CrystalReport1.connect = DSN=testDB;uid=amy;pwd=test CrystalReport1.Destination = 0 CrystalReport1.ReportFileName =

Re: automating mysql command

Hi Andrew, Let me first say that I am used to using mysql through PHP rather than command line . . . And, as I understand it mysql does not support any sort of “timers”. I need to use a Unix command like cron to automate either a mysql command or php script to output a selection from a few

Re: constraints in InnoDB, or is 3.23.43b _really_ 4.0.1?

Tomasz, I tested also with mysql-4.0.1 and it worked. But are you using a non-latin1 character set? If yes, the bug which was fixed in 3.23.49 might cause the problem. Did you compile MySQL yourself? If yes, what compiler? Please download the official MySQL-Max-3.23.49a binary from

Re: a quick sanity check ++

At 08:14 2002-03-14, Konstantin Tsolov wrote: right, of course ;-) (i neglected the join part) so, now i know exactly whom to ask ;-) i have the following bother (it's in the planning state): i have the idea of setting up a two-way replication system with 2 mysql servers for my radius

Stop query after first match

Danny, Wednesday, March 13, 2002, 2:30:10 PM, you wrote: DK I'd like to know how I can do the following: DK I want to query a single table like this: DK select field1, field2, field3 from table1 where field1='something' and DK field2=0; DK This query will result in more then one match. It's

RE: How to set permissions?

Yana, Thursday, March 14, 2002, 5:00:40 PM, you wrote: Y Helo! Y Is there any other way to set permissions to the list of Y tables in mysql db (big list!) with similar names (f.e. c%), Y then running a script on it? No, it's impossible. You should use database name, table name etc or '*' to

Re: Checking if table empty

Thank You. This did the trick. I knew that it had to be something simple. I wasn't even thinking of a if(!$row) statement. Steve At 10:05 AM 3/14/2002, you wrote: - Original Message - From: Steve Buehler [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, 14 March, 2002 17:46

Re: UDF's and Windows

OK. So I just read in CHANGES FOR 3.23.37 (patch by Ralph Mason) that there is now support for UDFs in Windows . So anyone know where I might find some Windows specific examples (or info) on them? Thanks, Craig At 09:47 AM 3/14/2002 -0600, you wrote: Perhaps this is common knowledge, but is

Re: Case sensitivity in Mysql

At 02:05 AM 3/14/2002, you wrote: Hi, I run mysql on windows as well as linux. table creation and access right are given by java program. Problem im facing is., i create a table with name TEMP in windows in creates table with name temp and linux TEMP while giving rights thru GRANTstatement ,

Checking if table empty

as you said, the table is empty. mysql_fetch_object should return NULL. that's why the block in the while statement doesn't got executed. while (($row = mysql_fetch_object($result))){ if($row-team_id == $team_id){ echo It is in there; }else{ echo We will need to add it to the table;

MySQL as database for AutoCAD

Has anyone used MySQL as the datasource for AutoCAD? Specifically AUTODESK MAP? Autodesk lists as a capability: # Link to ODBC-compliant databases including Microsoft Access, Excel, Oracle, dBase, FoxPro, Paradox, and SQL Server. Sounds like MAP _should_ work with MyODBC. Has anyone tried

root user Access Denied

I am trying to set up MyODBC on a Win2K box to access MySQL on a Linux machine. I am getting an error message that says my host is not allowed to connect. I then tried to run a GRANT query under the mysql on the Linux machine to create a valid user in the hosts table. I am using version

Re: Case sensitivity in Mysql

On Thursday 14 March 2002 9:32 am, BD wrote: Why or why couldn't MySQL have used case insensitive names in the first place? Store everything in lower case internally, but allow the user to use Invoice_Number or invoice_number or INVOICE_NUMBER in the SQL statement and it should refer to the

Re: New MySQL user question: record security

Hi All; I have just recieved a request to build a database using mySQL and I have a bit of a dilemma. The database is to be used for relations between politicians and their constituents, and I have to have tables for constituents and their information. I would like to have one main database

manip.cc

is anyone getting errors when trying to install mysql++, after installing the patch for gcc3? i've gotten a flood of errors which i've fixed, step by step, by adding std:: to various variables. manip.cc is spitting out error messages like this one: manip.cc:141:choosing

Re: VB/MySql/CrystalReport Problem?

IMHO - I would use ADO over the MyODBC layer to retrieve disconnected recordsets representing your report data from MySQL, then pass said adors to Crystal Report's viewer. To learn more about this approach, search seagate.com for ado disconn. rs, which utilizes ttx files (tab delimited text

Re: Making UPDATE return the no. of rows matched

At 10:41 +0100 3/14/02, Rune Steinseth wrote: Hi all, I have changed database for my Java app to MySQL. The app was developed with SQL Server. Some of the logic is dependent on getting the no. of rows updated returned after an UPDATE query. MySQL does only return the rows that are really

root user Access Denied

Rob, Thursday, March 14, 2002, 7:01:02 PM, you wrote: RQ I am trying to set up MyODBC on a Win2K box to access MySQL on a Linux machine. I am getting an error message that says my host is not allowed to connect. I then tried to run a GRANT query RQ under the mysql on the Linux machine to

Using MySQL with Mingw32

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi: I'm using MySQL 3.2.3.39 for Win98. Has anybody been able to develop applications using Mingw32 compiler? If so, where can I get a version of the libmysqlclient library that will work with this compiler? Thank you. - -- Alfredo J. Cole

innodb or Berkeley DB default for mysql max

What is the default table engine used in the binary version of mysql-max -- innodb or Berkeley? If not innodb, how do I get the innodb to be the default? Can someone point me to the manual section? - Before posting, please

Invalid Duplicate Key 1062 Error

Product : MySql Version : 3.23.45 Error : Invalid duplicate key error for large numeric primary key's Description --- When a large numeric primary key is created ID NUMERIC(38) PRIMARY KEY (ID) And you insert two records with different

Linux 7.1 Professional MySQL startup.

Hi: Installed the following packages (with no errors) from the Red Hat Linux V7.1 RPM files. It installed MySQL3 3.23.36-1, MySQL-devel3.23.36-1, MySQL-Server3.23.36-1, and MySQLclient9.3.23.22.4. However, following instructions, I typed in, at the command line, mysql and received the

Re: Changing Default for Not Null to NOTHING

ok, more specific: here is a table: CREATE TABLE FOO (foo1 int NOT NULL, foo2 int NOT NULL Default 1) If I do an insert into the FOO table with the following: INSERT INTO FOO (foo1,foo2) VALUES (1,1) Everything works as planned. If I do an insert into the FOO table with the following:

Re: MySQL Quits in Replication

We are having a serious problem with a simple replication setup using MySQL. One small database with 12 tables is being replicated one way - one master, one slave. Write transaction load is small, about 1 record per second, usually on only one of the tables. Read load is also light. The

Re: Linux 7.1 Professional MySQL startup.

Hi Joe, On Thu, 14 Mar 2002 11:00:33 -0800 Joe Krusick [EMAIL PROTECTED] wrote: Hi: Installed the following packages (with no errors) from the Red Hat Linux V7.1 RPM files. It installed MySQL3 3.23.36-1, MySQL-devel3.23.36-1, MySQL-Server3.23.36-1, and MySQLclient9.3.23.22.4. However,

Problem in Instalation DBD-mysql-2.1011

Hi: I work with Linux Cobalt (identic to RedHAT), gcc-2.7.2 and MySQL-3.22.32-1. I need install DBD-mysql-2.1011, but I received the next error in the instalation: (I execute make): rm -f blib/arch/auto/DBD/mysql/mysql.so LD_RUN_PATH=/usr/lib/mysql:/usr/lib /sbin/perl myld cc -shared

Re: replication through port forwarded firewall

John Hunter wrote: I have a mysql server behind a firewall. The firewall forwards port 3306 requests to the server, so the outside world can use it. I want to replicate this database with a slave outside the firewall. So the slave would request port 3306 on the firewall, but get the

ARG! Anyone using webmin on Solaris to manage MySQL?

I have tried the last 10 releases of webmin and cannot get it to work with MySQL. I have a standard install of Mysql 3.23 into /usr/local/mysql. Webmin keeps complaining that it cannot find the libraries. The MySQL libraries are here: /usr/local/mysql/lib/mysql I have set that path both in the

RE: replication through port forwarded firewall

Treat the master and slave as if the firewall wasn't there. It shouldn't be any different than a router. The outside computer shouldn't care what it is called on the internal network. If that's not fact, then its my strong opinion :) -Original Message- From: John Hunter [mailto:[EMAIL

Re: MySQL Quits in Replication

From: Al Johnson [EMAIL PROTECTED] Nothing in the MySQL error logs. Don't know what you are refering to as the replication log. There is no binlog for the slave and there are no other logs in the data directory or log directory. Is this something that has to be enabled? I was referring to

Re: Case sensitivity in Mysql

At 11:17 AM 3/14/2002, you wrote: On Thursday 14 March 2002 9:32 am, BD wrote: Why or why couldn't MySQL have used case insensitive names in the first place? Store everything in lower case internally, but allow the user to use Invoice_Number or invoice_number or INVOICE_NUMBER in the SQL

RE: problem in telent to mysql server

Can you telnet into anything else? How about a webserver? Try port 80 or 25 if you have a mail server. If you can't, you need to make sure you have telnet rights -Original Message- From: Jianping Zhu [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 14, 2002 1:58 PM To: [EMAIL

Re: problem in telent to mysql server

At 14:58 -0500 3/14/02, Jianping Zhu wrote: I use: telnet mysqlserverhostname 3306 and get following response: Host 'mylocalcomputer' is not allowed to connect to this MySQL server What does this mean? and how to fix the problem? The MySQL client-server protocol is a binary protocol. It

Re: root user Access Denied

Show me the output of the following: SHOW GRANTS FOR 'username'@'hostname'; output: mysql show grants for 'root@localhost'; ERROR 1064: You have an error in your SQL syntax near 'grants for 'root@localhost'' at line 1 I noticed that my user table doesn't seem to have all the fields it

RE: problem in telent to mysql server

On Thu, 14 Mar 2002, Todd Williamsen wrote: telbet to webserer is OK, I use telnet thesamename 80 get following messge !DOCTYPE HTML PUBLIC -//IETF//DTD HTML 2.0//EN HTMLHEAD

MySQL on OSF1

While doing make on a Dec 3000 OSF1 V4.0 I got the following error: echo timestamp linked_libmysql_r_sources make all-recursive No Suffix list Making all in include No suffix list. Make: % rule can only use a single ''/ Stop. Exit 1 There currently isn't a y2k patch installed. I haven't

RE: problem in telent to mysql server

I didn't realize you were trying to telnet to a client. You cannot do that. You need to telnet to the SERVER. Whatever the server is You need to make sure the user you are trying to use has access rights for the user for telnet -Original Message- From: Paul DuBois [mailto:[EMAIL

Fw: character encoding problems with org.gjt.mm.mysql jdbc1.0

lol list spam filter is quite severe sql, query - Original Message - From: Sylvain Hamel [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, March 14, 2002 3:47 PM Subject: character encoding problems with org.gjt.mm.mysql jdbc1.0 environment : java jdbc, with MM driver, jdk

Re: mysqlbug

On Thu, 2002-03-14 at 00:04, [EMAIL PROTECTED] wrote: Please, i'll need some help. I've installed mysql-3.22.32 in my machine, and when i run (from /usr/local/mysql) ./bin/safe_mysqld this is the bug that present (from my *.err file)

Re: where are my.cnf anf mysql log file.

I don't know if this will help you but try this: # mysqld --help | grep dir: basedir: / datadir: /var/lib/mysql/ tmpdir: /tmp/ So, you'll find mysql log files in your datadir (is this case, /var/lib/mysql/). my.cnf is usually at /etc/my.cnf If you don't have it, find a

RE: problem in telent to mysql server

At 14:46 -0600 3/14/02, Todd Williamsen wrote: I didn't realize you were trying to telnet to a client. You cannot do that. You need to telnet to the SERVER. Whatever the server is He *is* telnet-ing to the server (port 3306 is the server port). But it doesn't make sense. A Web server might

Upgrading to InnoDB tables

Hi, We have Mysql standard distribution (ver 3.23.32) for Solaris and we just realised that we needed InnoDB support. What would be the easiest way to add InnoDB table type? Is it possible to do it without affecting the tables and databases that are already present. thanks, Sanjay Chigurupati

RE: problem in telent to mysql server

Thanks for your advices. In the offical mysql webpage, there is a paragraph tell us how to usinng telnet test mysql server connectivity. --- http://www.mysql.com/doc/C/a/Can_not_connect_to_server.html If you get the error message

RE: problem in telent to mysql server

Thanks for your advices. In the offical mysql webpage, there is a paragraph tell us how to usinng telnet test mysql server connectivity. That test tells you only whether or not there's a MySQL server listening on the port. It doesn't tell you that you should actually try to communicate with

mysqld dies on MATCH query using IN BOOLEAN MODE

Description: When I run a MATCH query against a full-text index using the IN BOOLEAN MODE option, the mysqld server crashes. How-To-Repeat: see the information below Fix: I haven't figured it out yet. Submitter-Id: none Originator:Owen Borseth Organization:

  1   2   >