about hostnames after setup of MySQL

2002-09-30 Thread trogers
Mac OS XS 10.2 when you install the OS you have the oppt'y to put in a machine name (not the AppleTalk, Sharing name). i almost always put in a name. that name (mbase), it is also my default web host; that name also shows up at my terminal prompt (instead of the usual localhost). if i look

function as default value

2002-09-30 Thread Daya Krishan Dubey
Hi, Can anybody tell me is it possible in the my sql to set the function as default value, for example can i set the now() function for the date column field. Thanks in advance. Regards Daya Krishan Dubey Core Solucomm Ltd 423 B, Hamilton court DLF phase IV Gurgaon, India Ph# 91-124-6392896/7

RE: A rookie question

2002-09-30 Thread Peter Lovatt
--- Excellence in internet and open source software --- Sunmaia www.sunmaia.net tel. 0121-242-1473 --- -Original Message- From: Paul Romanic

Re: Question about HEAP tables

2002-09-30 Thread MySQL
From: [EMAIL PROTECTED] Date: Tue, 24 Sep 2002 13:41:23 +0800 (WST) I've got a problem with HEAP tables (undoubtedly the way that I'm using them). I'm running MySQL v.3.23.51 under Debian Linux with a 2.4.17 kernel. If anyone can help clear some of the fog, I'd

RE: How to file a bug: Can not handle spaces in paths for the arguments given on the commandline to the mysqld-nt command.

2002-09-30 Thread Tobias Eriksson
Hi, I have now been able to solve this problem. I used MySQL 3.23, but when I installed MySQL 4.0.3 it worked fine. Great Tobias Tobias Eriksson ComOpt AB Michael Löfmans gata 6 254 38 Helsingborg, Sweden Direct: +46 42 389918 Phone: +46 42 389900 e-mail: [EMAIL PROTECTED] Hi How do I

re: Is MySQL server running OK?

2002-09-30 Thread Egor Egorov
DeNewbie, Sunday, September 29, 2002, 12:46:29 AM, you wrote: D I am a newbie and I have just recently installed MySQL. I am somewhat confused as to why the tests that I am running from my command prompt are not showing any results yet I believe that my MySQL D server is running; D

re: mysql server won't keep running

2002-09-30 Thread Victoria Reznichenko
David, Monday, September 30, 2002, 4:44:19 AM, you wrote: DG I am attempting to use mysql 3.23.52 on win2000pro. I have installed DG it and I believe everything went okay for that. At least I did get any DG errors. DG When I open services, mysql is set for automatic but it is

re: function as default value

2002-09-30 Thread Egor Egorov
Daya, Friday, September 28, 2001, 10:36:30 AM, you wrote: DKD Can anybody tell me is it possible in the my sql to set the function as DKD default value, for example can i set the now() function for the date column DKD field. No, you can't: http://www.mysql.com/doc/en/CREATE_TABLE.html --

re: Mysqld always shuts down after running mysqld

2002-09-30 Thread Egor Egorov
mailto, Friday, September 27, 2002, 8:52:25 PM, you wrote: majdd i am a mysql newbie (my first time i install it) majdd i give up, i can't solve the problem without help. majdd all the time i try to start the mysqld, it ends up instantly with a shutdown majdd of mysqld, i cant run the prog: i

re: MySQL a quotas?

2002-09-30 Thread Victoria Reznichenko
Jiri, Sunday, September 29, 2002, 11:18:51 PM, you wrote: JM I'm solving problem how to set up quota on MySQL db. I've look for that JM in mailing lists and docummentation but with no success. JM Can someone help me with this problem? You can do it using disk quotas. -- For technical

re: Replication question

2002-09-30 Thread Egor Egorov
Alexander, Saturday, September 28, 2002, 12:47:19 PM, you wrote: AS Is it feasible to use replication to keep the database which powers my AS website up-to-date? The database itself is on the hosting companies server AS and contacted via dialup so the connection isn't there all of the time. AS

re: mysql.sock mystery!

2002-09-30 Thread Victoria Reznichenko
ÀÌö¿ì(õ¸®¾È), Saturday, September 28, 2002, 9:42:24 AM, you wrote: Àà I'm new to MySQL. Àà Anyway... Àà My O/S is FreeBSD 4.6. Àà In /etc/hosts there are only two line. Àà 127.0.0.1localhostlocalhost.paldal.com Àà 192.168.0.88unix.paldal.comunix Àà And in

[NEWBIE] Master Account

2002-09-30 Thread Stéphane Pinel
I've just installed MySQL on a MacOS X 10.2 system. Everything is OK but I can't find how I can login as a master to create users and give privileges ? Thanks. -- S.PINEL - Before posting, please check:

re: MySQL a quotas?

2002-09-30 Thread Iikka Meriläinen
On Mon, 30 Sep 2002, Victoria Reznichenko wrote: Jiri, Sunday, September 29, 2002, 11:18:51 PM, you wrote: JM I'm solving problem how to set up quota on MySQL db. I've look for that JM in mailing lists and docummentation but with no success. JM Can someone help me with this problem? You

cannot connect to local mysql server through socket

2002-09-30 Thread Lawrence Strydom
Hi, I am trying to set up a mail server using Postfix, Web-cyradm and mysql on SusE 8. I have followed all the steps in Luc de Louw's documentation so far and MySQL server is running. When I try to use the scripts that came with Web-Cyradm to create the databases and tables I get the folowing

re: DB Problems

2002-09-30 Thread Egor Egorov
Odhiambo, Saturday, September 28, 2002, 9:05:00 AM, you wrote: OW I have some problems with my database and not being quite profficient in SQL, OW I did myisamcheck and posted the data on the site below: OW http://ns2.wananchi.com/~wash/RT2/myisamcheck.txt OW I am wondering if someone can take

re: [NEWBIE] Master Account

2002-09-30 Thread Victoria Reznichenko
Stéphane, Monday, September 30, 2002, 2:34:17 PM, you wrote: SP I've just installed MySQL on a MacOS X 10.2 system. Everything is OK but I SP can't find how I can login as a master to create users and give privileges ? It's not so difficult. You should connect to the MySQL server as root:

re: cannot connect to local mysql server through socket

2002-09-30 Thread Egor Egorov
Lawrence, Monday, September 30, 2002, 2:47:44 PM, you wrote: LS I am trying to set up a mail server using Postfix, Web-cyradm and mysql LS on SusE 8. I have followed all the steps in Luc de Louw's documentation LS so far and MySQL server is running. When I try to use the scripts that LS came

Re: Japanese Charset

2002-09-30 Thread Michael T. Babcock
Joel Rees wrote: If I compile MySQL using --with-charset=sjis , how will it handle the Latin, Chinese, and Korean characters? Multiple databases on multiple servers? Try this one on for size: CREATE TABLE Customers ( Name VARCHAR(100) ); Now ... if your customers have names in

Re: [bug] koi8-r codepage bug

2002-09-30 Thread Cyril Zlachevsky
Victoria Reznichenko wrote: Cyril, Friday, September 27, 2002, 4:19:25 PM, you wrote: CZ if I build mysql with CZ ./configure --with-charset=koi8_ru CZ then check (make; make check; make test) failed! Because MySQL by default uses latin1 character set and you have compiled only with

re: How to see warning messages for load data infile

2002-09-30 Thread Egor Egorov
David, Saturday, September 28, 2002, 2:37:00 AM, you wrote: DY Hi all. I'm trying to load a file into mysql using load data infile and DY got a ton of warnings. Is there any way to see what the warnings are? MySQL doesn't store warnings anywhere. -- For technical support contracts, goto

FileMaker Pro Schema Export?

2002-09-30 Thread Jan Steinman
Before I go and write one, does anyone know of any tools to create MySQL tables from FMP databases? All that I've seen are commercial products that synch the two, but the MySQL tables have to already exist. (I have hundreds of columns that I'd rather not key in manually!) -- : Jan Steinman

RE: Replication question

2002-09-30 Thread Luc Foisy
That would be a great way to keep your website up to date. The slave can handle loss of connection (though some data may not make sense if part of it is missing), and resume where it has left of previously. Or you could also manually start and stop the slave process when you know there is a

re: Re: [bug] koi8-r codepage bug

2002-09-30 Thread Victoria Reznichenko
Cyril, Monday, September 30, 2002, 3:35:40 PM, you wrote: Cyril, Friday, September 27, 2002, 4:19:25 PM, you wrote: CZ if I build mysql with CZ ./configure --with-charset=koi8_ru CZ then check (make; make check; make test) failed! Because MySQL by default uses latin1 character set and

RE: Database Replication

2002-09-30 Thread Luc Foisy
-Original Message- From: Paul Darius [mailto:[EMAIL PROTECTED]] Subject: Database Replication 'lock database with read lock' command already done before the above replication started and followed by 'unlock all' when finished. Question, how to sync an unsync table or the

RE : How to see warning messages for load data infile

2002-09-30 Thread BPF Webmaster
Maybe try one line... I got this tons of warnings this morning making an import from Excel. But it was apparently successful...but all decimal value where store truncated like 128.00 , the reason is I'm in France and Excel exports decimal with coma 128,34 but MySQL expects 128.34 so I just

RE: Setting Permission For Column Level Only

2002-09-30 Thread Luc Foisy
You know that process would be much easier if you used the GRANT syntax http://www.mysql.com/doc/search.php?q=GRANTfrom=%2Fdoc%2Fen%2Findex.html -Original Message- From: Insanely Great [mailto:[EMAIL PROTECTED]] Subject: Setting Permission For Column Level Only Greetings... I

re: re: MySQL a quotas?

2002-09-30 Thread Victoria Reznichenko
Iikka, Monday, September 30, 2002, 2:40:32 PM, you wrote: Jiri, Sunday, September 29, 2002, 11:18:51 PM, you wrote: JM I'm solving problem how to set up quota on MySQL db. I've look for that JM in mailing lists and docummentation but with no success. JM Can someone help me with this

Re: A FAQ type question, but not in the FAQ - How to change my hostname,but not make replication puke

2002-09-30 Thread gerald_clark
Did you make the changes to master.onfo to point to the new master? Did mysql own master.info when you were through? Eric Frazier wrote: Hi, I changed my hostname(The DNS change was taken care of elseware) in FreeBSD 4.6 in the rc.conf file, rebooted. Mysql had no problems starting, but

Re: A FAQ type question, but not in the FAQ - How to change my hostname, but not make replication puke

2002-09-30 Thread Eric Frazier
Hi, I didn't have a new mysql master, just the slave name was changed. Yes on the second question too. Thanks, Eric At 09:09 AM 9/30/02 -0500, gerald_clark wrote: Did you make the changes to master.onfo to point to the new master? Did mysql own master.info when you were through? Eric

Re: [bug] koi8-r codepage bug

2002-09-30 Thread Cyril Zlachevsky
Victoria Reznichenko wrote: Cyril, Monday, September 30, 2002, 3:35:40 PM, you wrote: Cyril, Friday, September 27, 2002, 4:19:25 PM, you wrote: CZ if I build mysql with CZ ./configure --with-charset=koi8_ru CZ then check (make; make check; make test) failed! Because MySQL by default uses

Re: MySQL a quotas?

2002-09-30 Thread Bill Leonard
on 9/30/02 9:47 AM, Victoria Reznichenko at [EMAIL PROTECTED] wrote: It's not a so good decision and not suitable if database contains InnoDB tables, but you can't limit database size only with MySQL. Is this a planned feature anywhere on the MySQL roadmap for 4.x? A database size quota?

Re: Storing 100 million images in the database

2002-09-30 Thread Ben Goodwin
Mmm.. filter goodness. Trying again with the required words: sql query ... along the lines of using the database as a pointer to the real file in a normal filesystem that others have suggested.. may I add the idea of using a 'hashed' directory structure such that you don't end up with an

re: Re: Re: Replication

2002-09-30 Thread Victoria Reznichenko
CP, Monday, September 30, 2002, 3:48:31 AM, you wrote: C The Master's server id is 1 while the slave's server id was set to 5. There C is no problem for the slave to establish connection to the master. However, C the slave complains that error reading packet from server, the reason is C

Re: Unknown auto ROLLBACK

2002-09-30 Thread gerald_clark
Because you did not set autocommit on? Noor Dawod wrote: Hi all, I found out today that MySQL is adding a 'ROLLBACK' command to each session connecting to it, without explicitly ordering this. This is new since we never had this behavior before. Why is this happening, and how can I revert to

re: granting FILE privileges

2002-09-30 Thread Mark Hennessy
+-+ | Grants for [EMAIL PROTECTED] | |

Re: A FAQ type question, but not in the FAQ - How to change my hostname, but not make replication puke

2002-09-30 Thread gerald_clark
You need to grant privileges on the master to the new slave machine. Eric Frazier wrote: Hi, I didn't have a new mysql master, just the slave name was changed. Yes on the second question too. Thanks, Eric At 09:09 AM 9/30/02 -0500, gerald_clark wrote: Did you make the changes to

IFNULL || NULLIF

2002-09-30 Thread Gramos Brestovci
Does MySQL 3.23.39(version) support IFNULL(NULL,0) || NULLIF(0,NULL) Thanks, Gramos - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive)

RE: IFNULL || NULLIF

2002-09-30 Thread Luc Foisy
http://www.mysql.com/doc/en/Control_flow_functions.html top of the page -Original Message- From: Gramos Brestovci [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 11:47 AM To: [EMAIL PROTECTED] Subject: IFNULL || NULLIF Does MySQL 3.23.39(version) support

Re: Urgent!!

2002-09-30 Thread William R. Mussatto
On Sun, 29 Sep 2002, Insanely Great wrote: Date: Sun, 29 Sep 2002 22:43:43 +0530 From: Insanely Great [EMAIL PROTECTED] To: Ibrahim Al-Tawil [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: Urgent!! Greetings... I believe that ASP works well with MySQL thru ODBC. As of learning other

Re: Urgent!!

2002-09-30 Thread Mike Roest
William R. Mussatto wrote: On Sun, 29 Sep 2002, Insanely Great wrote: Date: Sun, 29 Sep 2002 22:43:43 +0530 From: Insanely Great [EMAIL PROTECTED] To: Ibrahim Al-Tawil [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: Urgent!! Greetings... I believe that ASP works well with MySQL thru

RE: Urgent!!

2002-09-30 Thread Dan Harrington
[.snip.] ? How do you intend to run .ASP on linux? [.snip.] Its called Sun ONE from SUN. http://www.chilisoft.com/ Dan -Original Message- From: William R. Mussatto [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 10:29 AM To: Insanely Great Cc: Ibrahim Al-Tawil;

RE: Urgent!!

2002-09-30 Thread Chuck Payne
There is a package called Chilisoft that will let you take your ASP pages and change them to PHP, I am not sure how well it works. I had a client that want to run ASP on linux and told I didn't think you could but PHP works and to me is better. But the price of Chilisoft was a little hight. I

Re: about hostnames after setup of MySQL

2002-09-30 Thread Jim Dickenson
On 9/30/2002 12:14 AM, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Mac OS XS 10.2 when you install the OS you have the oppt'y to put in a machine name (not the AppleTalk, Sharing name). i almost always put in a name. that name (mbase), it is also my default web host; that name also

ASP Chilisoft (OT)

2002-09-30 Thread Michael T. Babcock
Chuck Payne wrote: There is a package called Chilisoft that will let you take your ASP pages and change them to PHP, I am not sure how well it works. I had a client that want to run ASP on linux and told I didn't think you could but PHP works and to me is better. But the price of Chilisoft was

Please confirm (conf#92c92eb943e40c0d6fb2262ddcc31bdc)

2002-09-30 Thread Chuck PUP Payne
IMPORTANT INFORMATION! This is an automated message. The message you sent (attached below) requires confirmation before it can be delivered. To confirm that you sent the message below, just hit the Reply button and send this message back (you don't need to edit anything). Once this is done,

Re: Urgent!!

2002-09-30 Thread Dan Donald
Chuck, ChiliSoft ASP is actually a Linux port of ASP 3 (I think). On the whole we've found it to run OK but there are a few features that are not included in the more recent Microsoft releases. While it makes it easy for IIS users to port their sites to a Linux server I personally wouldn't

RE: Urgent!!

2002-09-30 Thread Keith C. Ivey
Its called Sun ONE from SUN. http://www.chilisoft.com/ Don't most people who use ASP want to use Visual Basic? So the problem isn't really lack of ASP on Linux but lack of VB. Somehow I doubt that Microsoft (at least in its current incarnation) is going to come out with VB for Linux.

MySQLGUI: Win32 zipped binary seems corrupted

2002-09-30 Thread Pavel Hlouek
Hi, I've just tried to download the Win32 binaries of the MySQLGUI tool. I recieved about 50kB. When I tried to unpack the archive, WinCommander told me, that the zip archive is corrupted. Hope it helps, thanx guys for wonderfull MySQL. Pavel

Mixing Linux and Windows and paying for it

2002-09-30 Thread Drulli B
Hi, I have a grand total of two very important but possibly humiliatingly daft questions, that I hope some kind soul will patiently solve: 1. Can I run a mySQL server on a Linux computer, and query it through myODBC running on a Windows computer? 2. The licensing info seems only relevant to

Re: Mixing Linux and Windows and paying for it

2002-09-30 Thread William R. Mussatto
On Mon, 30 Sep 2002, Drulli B wrote: Date: Mon, 30 Sep 2002 18:13:51 - From: Drulli B [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Mixing Linux and Windows and paying for it Hi, I have a grand total of two very important but possibly humiliatingly daft questions, that I hope

Re: ASP Chilisoft (OT)

2002-09-30 Thread Michael T. Babcock
Ryan Fox wrote: I think you mean asp2php. I don't know any reason that someone would want to convert from php to asp. :) Thanks for that; I'm sure the clarification would be obvious to anyone reading the thread; my mind must have been fried from so much MFC programming today ...

Re: [NEWBIE] Master Account

2002-09-30 Thread Clayburn W. Juniel, III
On Monday, September 30, 2002, at 04:34 24h, Stéphane Pinel wrote: I've just installed MySQL on a MacOS X 10.2 system. Everything is OK but I can't find how I can login as a master to create users and give privileges ? Thanks. With the server running you first need to give root a

Testing New Install

2002-09-30 Thread DeNewbie
I am a MySQL newbie and i am somewhat confused. Firstly did I make a mistake running mysql_install_db and afterwards running the commands; /usr/bin/mysqladmin -u root password 'new-password' mysqladmin -u pazin1 sqlpass and; /usr/bin/mysqladmin -u root -h cords-orj86jfje password

Re: FileMaker Pro Schema Export?

2002-09-30 Thread Brent Baisley
I never actually looked into it. There are so many work arounds I need to do in FileMaker that I just redesign the tables in MySQL. If there isn't a FileMaker converter, I'm sure there is a DBF converter. You can just save you FileMaker databases as DBF and then convert them. On Monday,

Re: Mixing Linux and Windows and paying for it

2002-09-30 Thread michael . mouer
JMichael William R. Mussatto [EMAIL PROTECTED] 09/30/2002 02:23 PM To: Drulli B [EMAIL PROTECTED] cc: [EMAIL PROTECTED] Subject:Re: Mixing Linux and Windows and paying for it On Mon, 30 Sep 2002, Drulli B wrote: Date: Mon, 30 Sep 2002 18:13:51

RE: Japanese Charset

2002-09-30 Thread Dawn Friedland
I welcome the pedantics! Multiple databases on multiple servers? That is what I thought...which I assume means multiple machines (not an option). And I'm glad you pointed it out that it still wouldn't solve the problem. Go re-read the section of the manual on string literals. Ask yourself

RE: FileMaker Pro Schema Export?

2002-09-30 Thread Chuck Payne
Question are you want to take your data from Filemaker to Excel? Because what I had to do was re-create the tables in MySQL then out putting the data to cvs table. Making sure the data was divide by a command, then I use mysqladmin or you can use phpMyAdmin import it into you MySQL. If that what

RE: Japanese Charset

2002-09-30 Thread Dawn Friedland
CREATE TABLE Customers ( Name VARCHAR(100) ); Now ... if your customers have names in Japanese, Russian and German, how do you compile MySQL so it can store them all in Customers? You use Unicode with a binary field and do post-processing work (like ORDER BY) yourself. I have

MySQL - Which DB gives best sql performance?

2002-09-30 Thread Brian Safford
Which DB type will provide the best performance? We're currently using MyISAM, but I'm curious if switching to InnoDB will provide any performance improvements. Regards, Brian Safford EDS Messaging Note: The following was added to get this posting through the spam filters: sql query

Re: Japanese Charset

2002-09-30 Thread gerald_clark
Your webform application must call the appropriate mysql escape string function for the language in which it is written. Dawn Friedland wrote: CREATE TABLE Customers ( Name VARCHAR(100) ); Now ... if your customers have names in Japanese, Russian and German, how do you compile MySQL so it

Max number of merged tables?

2002-09-30 Thread Kevin Old
Hello all, I am currently creating a table per hour for some data I have. Each table has 502 fields (yeah, I knownothing I can do about it, this is a very special situation) and about 100,000 records. A few hours worth of data creates a 2GB table, and I don't really want to increase the

sub-select workaround

2002-09-30 Thread joseph speigle
hi! The application is a password-username-location-type store. The types are web,mysql, and entries for different computers to I can see all usernames/passwords on certain computers I would like to make myIsam tables into innodb to provide foreign keys, but I have a 'missing link' I

RE: RE: date column

2002-09-30 Thread Tewfic Kidess
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 6:21 PM To: Tewfic Kidess Subject: Re: RE: date column Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you

Re: Mixing Linux and Windows and paying for it

2002-09-30 Thread Drulli B
William R. Mussatto [EMAIL PROTECTED] On Mon, 30 Sep 2002, Drulli B wrote: 1. Can I run a mySQL server on a Linux computer, and query it through myODBC running on a Windows computer? Why not query it directly on its std port? What language are you using? Perl (including ISAPI version .plx)

RE: Japanese Charset

2002-09-30 Thread Dawn Friedland
I found a solution!!! ***Replace all backlashes with two backslashes.*** (The hex value of the backslash is 0x5c, see Joel Rees' previous emails for an explanation on how multibyte Japanese characters contain the hex value 0x5c and that MySQL uses that value as an escape character.) VBscript

Re: MySQL - Which DB gives best sql performance?

2002-09-30 Thread walt
Brian Safford wrote: Which DB type will provide the best performance? We're currently using MyISAM, but I'm curious if switching to InnoDB will provide any performance improvements. Regards, Brian Safford EDS Messaging Note: The following was added to get this posting through the spam

MySQL BLOB Visual Basic

2002-09-30 Thread Bruno Batarelo
Greetings. I try to save 7MB large binary string to mysql blob field in the latest mysql server. I use innodb tables. Error I receive from myodbc driver says: Memory allocation error. Here is my.ini extract: set-variable=max_allowed_packet=30M set-variable=wait_timeout=10 set-variable =

Re: MySQL - Which DB gives best sql performance?

2002-09-30 Thread Jeremy Zawodny
On Mon, Sep 30, 2002 at 03:45:20PM -0400, Brian Safford wrote: Which DB type will provide the best performance? We're currently using MyISAM, but I'm curious if switching to InnoDB will provide any performance improvements. It depends. There are cases when MyISAM is the clear winner and

Setting the password for root user in mysql

2002-09-30 Thread Palash Mohanlal Kasodhan
Hi everyone, I am just starting to work with MySql on MAC OS X.When i installed mysql i got the following message : PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is done with: /usr/local/bin/mysqladmin -u root -p password 'new-password' /usr/local/bin/mysqladmin -u

RE: mysql server won't keep running - SOLVED..... NEXT!

2002-09-30 Thread David Gerler
Thanks to all who responded. It seems that my problem was two fold. 1) I needed the my.cnf file in the root on C:/ for one. 2) I had install it the first time to my D drive. When I couldn't get it to work I uninstalled and reinstalled it to the C: drive. For some reason, the services command to

Re: Setting the password for root user in mysql

2002-09-30 Thread Clayburn W. Juniel, III
On Monday, September 30, 2002, at 03:03 24h, Palash Mohanlal Kasodhan wrote: Hi everyone, I am just starting to work with MySql on MAC OS X.When i installed mysql i got the following message : PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is done with:

Re: Setting the password for root user in mysql

2002-09-30 Thread tlr7425
Is MySQL running? Use Process Viewer to see if there is an entry for mysqld. If not, I would ask if you issued the install_db command and then started mysql. Ted On Monday, September 30, 2002, at 06:03 PM, Palash Mohanlal Kasodhan wrote: Hi everyone, I am just starting to

RE: MySQL BLOB Visual Basic

2002-09-30 Thread Mike Hillyer
What does your VB code look like? Mike Hillyer -Original Message- From: Bruno Batarelo [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 3:42 PM To: [EMAIL PROTECTED] Subject: MySQL BLOB Visual Basic Greetings. I try to save 7MB large binary string to mysql blob field in

Re: Mixing Linux and Windows and paying for it

2002-09-30 Thread Joshua J . Kugler
On Monday 30 September 2002 10:13, Drulli B wrote: Hi, I have a grand total of two very important but possibly humiliatingly daft questions, that I hope some kind soul will patiently solve: 1. Can I run a mySQL server on a Linux computer, and query it through myODBC running on a Windows

Re: Creating/droping database using mySQL JDBC driver

2002-09-30 Thread Clayburn W. Juniel, III
On Monday, September 30, 2002, at 03:53 24h, Slava Imeshev wrote: Hello All, Could anyone help me with this issue? Is it possible to create/drop database using mySQL JDBC driver? Yes. -- Clayburn W. Juniel, III -- Effective Software Solutions Phone: (602) 326-7707Mobile:

Re: Japanese Charset

2002-09-30 Thread Joel Rees
Multiple databases on multiple servers? That is what I thought...which I assume means multiple machines (not an option). For future reference, MySQL can actually run multiple servers with different configurations on a single machine in Linux. (*BSD and Mac OS X, too, I think.) They are

Re: Japanese Charset

2002-09-30 Thread Joel Rees
I found a solution!!! Hooray! ***Replace all backlashes with two backslashes.*** You probably want to consider whether you want to replace all quotes with backslash-quote, as well. Backslashes in the English text would only show up for something like file paths on MS OSses, but your customer

Re: Mixing Linux and Windows and paying for it

2002-09-30 Thread John Ragan
the answer to your question is yes. however, what you're considering is a complex technical exercise while it's being set up. after you get it going, it'll work like a charm, but your technical people will need to know what they are doing. corereader is a ms. windows app and one of its

select problem with not equal syntax

2002-09-30 Thread Gebhardt, Karsten
I have two tables CREATE TABLE pid_segment ( id INT NOT NULL UNIQUE PRIMARY KEY, msg TEXT) TYPE=INNODB CREATE TABLE hl7incom( id INT NOT NULL AUTO_INCREMENT UNIQUE PRIMARY KEY REFERENCES pid_segment (id). msg TEXT, time TIMESTAMP NOT NULL) TYPE=INNODB There are few data stored in both tables.

Re: select problem with not equal syntax

2002-09-30 Thread John Coder
On Mon, 2002-09-30 at 23:44, Gebhardt, Karsten wrote: I have two tables CREATE TABLE pid_segment ( id INT NOT NULL UNIQUE PRIMARY KEY, msg TEXT) TYPE=INNODB CREATE TABLE hl7incom( id INT NOT NULL AUTO_INCREMENT UNIQUE PRIMARY KEY REFERENCES pid_segment (id). msg TEXT, time TIMESTAMP

RE: select problem with not equal syntax

2002-09-30 Thread Gebhardt, Karsten
No way, I've already tried this. I have two tables CREATE TABLE pid_segment ( id INT NOT NULL UNIQUE PRIMARY KEY, msg TEXT) TYPE=INNODB CREATE TABLE hl7incom( id INT NOT NULL AUTO_INCREMENT UNIQUE PRIMARY KEY REFERENCES pid_segment (id). msg TEXT, time TIMESTAMP NOT NULL)

RE: select problem with not equal syntax

2002-09-30 Thread Sean Moshenko
Just a suggestion: SELECT hl7incom.id FROM hl7incom, pid_segment WHERE hl7incom.msg LIKE '%PID%' AND not(pid_segment.id = hl7incom.id) GROUP BY hl7incom.id; Otherwise my only other suggestion would involve using the 'NOT IN' logic, but I think that might be too convoluted for your needs.

RE: select problem with not equal syntax

2002-09-30 Thread Gebhardt, Karsten
Same result, also if I do not define unique index. Just a suggestion: SELECT hl7incom.id FROM hl7incom, pid_segment WHERE hl7incom.msg LIKE '%PID%' AND not(pid_segment.id = hl7incom.id) GROUP BY hl7incom.id; Otherwise my only other suggestion would involve using the 'NOT IN' logic, but I

Re: MySQLGUI: Win32 zipped binary seems corrupted

2002-09-30 Thread Insanely Great
Greetings.. Even the MySQLGui does not work for me. It is not getting downloaded. What should I do ? Insane SQLyog ( http://www.webyog.com/sqlyog ) The Definative GUI for MySQL - Original Message - From: Pavel Hlouek [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, September 30,