Re: Ingres vs MySQL

2003-08-28 Thread Joel Rees
and came up with the following: http://www3.ca.com/Solutions/Product.asp?ID=1013 Note that's Computer Associates you would be dealing with on that one. Mixed in with the links to information about the artist, Jean Auguste Dominique Ingres, there were other links to potential sources of informa

Re: PHP or Perl?

2003-08-17 Thread Joel Rees
s are not carefully used, and I have never seen those problems when using PHP, but that is less about speed than about programming.) -- Joel Rees, programmer, Systems Group Altech Corporation (Alpsgiken), Osaka, Japan http://www.alpsgiken.co.jp -- MySQL General Mailing List For list archi

Re: PHP or Perl?

2003-08-17 Thread Joel Rees
and PostGreSQL can be mixed in at will, and ... -- Joel Rees, programmer, Systems Group Altech Corporation (Alpsgiken), Osaka, Japan http://www.alpsgiken.co.jp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: How can I enable unicode and japanese support?

2003-08-07 Thread Joel Rees
re mysql to use unicode? Have you looked at section 8 of the MySQL manual? http://www.mysql.com/doc/en/Charset.html -- Joel Rees, programmer, Systems Group Altech Corporation (Alpsgiken), Osaka, Japan http://www.alpsgiken.co.jp -- MySQL General Mailing List For list archives: http://lists.mys

Re: Using a foreign character set in MYSQL

2003-08-06 Thread Joel Rees
system also has to know what character set you're going to use. Likewise, you'll have to tell people's browsers it's Chinese. And if you're using Big-5 with Java, you'll have to tell Java to convert between Unicode and BIG-5. HTH -- Joel Rees, programmer, Systems

Re: Using a foreign character set in MYSQL

2003-08-06 Thread Joel Rees
ners keep thinking that \u is a solution for the CJK languages, but that's off-topic.) -- Joel Rees, programmer, Systems Group Altech Corporation (Alpsgiken), Osaka, Japan http://www.alpsgiken.co.jp -- MySQL General Mailing List For list archives: http://lists.mysql.com/m

Re: How does one get off of this list

2003-07-31 Thread Joel Rees
ql.com/[EMAIL PROTECTED] (Hmm. That's changed in the recent month or so.) I assume what you've tried is the above link? You should receive a confirmation e-mail, and you need to reply to that. Did you receive the confirmation e-mail? -- Joel Rees, programmer, Systems

Re: MySQL vs. PostgreSQL -- speed test

2003-07-14 Thread Joel Rees
gt; is to blame, but bear it it mind. Actually, Unicode is much more difficult to handle than the small character encoding sets. Some slowdown is probably to be expected. -- Joel Rees, programmer, Kansai Systems Group Altech Corporation (Alpsgiken), Osaka, Japan http://www.alpsgiken.co.jp --

Re: MySQL vs. PostgreSQL -- speed test

2003-07-14 Thread Joel Rees
27;t get enough performance out of PostGreSQL, you should by then have identified what tables need to be high-performance, and you should be able to use MySQL for those. Use all your tools. -- Joel Rees, programmer, Kansai Systems Group Altech Corporation (Alpsgiken), Osaka, Japan http://www.al

Re: Root@?

2003-07-08 Thread Joel Rees
> Not sure where these came from, but in my users I've got a [EMAIL PROTECTED] and a > [EMAIL PROTECTED] Is this redundant, or is there a reason for this? Well, some people might say it's redundant, but it _is_ by design -- http://www.mysql.com/doc/en/Privileges.html >

Re: OS X downloads

2003-07-02 Thread Joel Rees
> Todd I think the word, "package" is the key here. One would be a traditional unix-ish install, the other would be set up to install as a package in the Mac OS X definition of a package. -- Joel Rees, programmer, Kansai Systems Group Altech Corporation (Alpsgiken), Osaka, Japan

Re: License?

2003-07-02 Thread Joel Rees
supporting the people who are building your tools. -- Joel Rees, programmer, Kansai Systems Group Altech Corporation (Alpsgiken), Osaka, Japan http://www.alpsgiken.co.jp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: License?

2003-07-01 Thread Joel Rees
dangerous one, and when you hear the suits talk about "frictionless economy", tell them to take their manure generators elsewhere.) -- Joel Rees, programmer, Kansai Systems Group Altech Corporation (Alpsgiken), Osaka, Japan http://www.alpsgiken.co.jp -- MySQL General Mailing List

Re: .fil

2003-06-29 Thread Joel Rees
ing the script, of course. -- Joel Rees, programmer, Kansai Systems Group Altech Corporation (Alpsgiken), Osaka, Japan http://www.alpsgiken.co.jp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Can't compile on NetBSD

2003-06-29 Thread Joel Rees
> Can any one help me? Hard to tell without more information. Also, since the issues are likely to be system/CPU dependent, you may need to ask on a netBSD list, as well. -- Joel Rees, programmer, Kansai Systems Group Altech Corporation (Alpsgiken), Osaka, Japan http://www.alpsgiken.co.jp

Re: mysql.sock doesn't exist

2003-06-26 Thread Joel Rees
nually created was blown away after trying to light > it up. Not surprising. -- Joel Rees, programmer, Kansai Systems Group Altech Corporation (Alpsgiken), Osaka, Japan http://www.alpsgiken.co.jp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysql.sock doesn't exist

2003-06-26 Thread Joel Rees
cket is supposed to be created in? Do you have a user for mysqld to run as? What group is mysqld running under? (Etc.) -- Joel Rees, programmer, Kansai Systems Group Altech Corporation (Alpsgiken), Osaka, Japan http://www.alpsgiken.co.jp -- MySQL General Mailing List For list archives: http:/

Re: 4.1 character set documentation

2003-06-16 Thread Joel Rees
> At 15:05 +0900 6/12/03, Joel Rees wrote: > >Paul DuBois advised us that > >> Alexander Barkov and Peter Gulutzan have written up some documentation > >> on the new character set support in MySQL 4.1, which has now been added > >> to the online manual. Y

Re: Set no root password

2003-06-15 Thread Joel Rees
to be able to get to the data with myphpadmin > too. But now I know where it is I put the password in. And now I want to > protect phpmyadmin so that only folks with a username/password can access it. -- Joel Rees <[EMAIL PROTECTED]> -- MySQL General Mailing List For list archi

Re: FULLTEXT Search and Charsets

2003-06-12 Thread Joel Rees
to handle latin as if it were single-byte. You don't get all of the latin sets, though. -- Joel Rees <[EMAIL PROTECTED]> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: 4.1 character set documentation

2003-06-11 Thread Joel Rees
current for 4.1.1 and some things have changed > since 4.1.0. -- Joel Rees <[EMAIL PROTECTED]> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Unicode(ucs2) setup question

2003-06-10 Thread Joel Rees
> I'd like to use ucs2 character set for MySQL. You do understand that Unicode support is not yet complete in MySQL, including the current alpha? Also, I would expect UTF-8 to be in better condition that UTF-16. -- Joel Rees <[EMAIL PROTECTED]> -- MySQL General Mailing

Re: mysql query output get wrapped

2003-06-04 Thread Joel Rees
. Stretch your terminal window wide. If that isn't enough, pipe to a file and break out a text editor that scrolls horizontally as well as vertically. -- Joel Rees <[EMAIL PROTECTED]> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Cannot find uppercase user from mysql.user table

2003-06-03 Thread Joel Rees
. But, if the entry in the user field is all > lowercase then, the recordset is returned with the appropriate values. Sorry to give you a hit-and-run answer, but I think I read something in the on-line manual about case problems with file names on some OSses. Might have something to do with i

Re: Oracle to MySQL or ?

2003-05-30 Thread Joel Rees
ntermedia. Hmm. I guess I could look it up. http://www.google.com/search?hl=en&ie=ISO-8859-1&q=oracle+intermedia http://www.oracle.com/ip/deploy/database/oracle9i/index.html?cm_imedia.html Okay, it looks like a set of tools for managing multimedia databases. Could you explain how

Re: How to secure a MySQL database from people with physical access

2003-05-27 Thread Joel Rees
http://www.google.com/search?hl=en&ie=ISO-8859-1&q=encryption+mysql You might have to dig in a couple of pages, or maybe try a different set of search keys. (That's probably not much help, ...) -- Joel Rees, programmer, Kansai Systems Group Altech Corporation (Alpsgiken), Osaka, Japan http://www.alpsgiken.co.jp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Mac OS X package problems

2003-04-02 Thread Joel Rees
Haven$B!G(Bt been following your thread, but I thought I'd make a stupid (Bsuggestion ... (B (B> At startup, the computer says something about starting a MySQL server. (B> Could it be that the startup item is still trying to start mysqld even (B> though it no longer exists and in the proce

Re: [newbie] localhost login problems from MSW2k command line (solved)

2003-03-27 Thread Joel Rees
t on > the command line? Could this have something to do with named pipes? Is localhost folded to the loopback? That seems it might be a little awkward. -- Joel Rees <[EMAIL PROTECTED]> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Spanish

2003-03-25 Thread Joel Rees
> I need , obtain the month in spanish, $B%=(Bhow can do it...? (B> (B> NOTE: Linux is in spanish , and mysql also. (B (BWorst comes to worst, you could always build a small table of the month (Bnames in Spanish and index the table by the month number. (B (B-- (BJoel Rees <[EMAIL P

Re: Creating fulltext index never completes...?

2003-03-25 Thread Joel Rees
> ... > It dawned on me that perhaps the problem had to do with double-byte > characters, What language is this text in? Is it by chance a language that does not use whitespace to delimit words? -- Joel Rees <[EMAIL PROTECTED]> -- MySQL General Mailing List For list

[newbie] localhost login problems from MSW2k command line

2003-03-24 Thread Joel Rees
otten about and just can't find in the manual today? Second, why does it complain about the loopback when I said localhost on the command line? Could this have something to do with named pipes? -- Joel Rees <[EMAIL PROTECTED]> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: access primitives in php

2003-03-19 Thread Joel Rees
there. -- Joel Rees <[EMAIL PROTECTED]> - 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

access primitives in php

2003-03-18 Thread Joel Rees
re, but my searching skills seem weak this week. Anyone know of some good tutorial material on the subject? (I am not interested in arguments about which is better, by the way. The requirements of the current project specify that we do both.) -- Joel Rees <[EM

Re: Question about auto-increment columns

2003-02-19 Thread Joel Rees
scussed many times before and since, of course. My choice of search term wasn't very good, I guess.) http://marc.theaimsgroup.com/?l=mysql&m=94495471802684&w=2 -- Joel Rees <[EMAIL PROTECTED]> - Befor

Re: MySQl db as filesystem.

2002-10-11 Thread Joel Rees
database with csh, run ls and get a list of tables, run cat on a table and get a tab-delimited listing of the contents of the table? On the surface it didn't seem like such an unreasonable question, ... -- Joel Rees (thinking distractedly about trying to edit a MySQL table with vi, amon

utility for looking at hex values in strings from the command line (was Re: Japanese Charset)

2002-10-02 Thread Joel Rees
Enjoy. > Joel can I get a copy of that hex convert utility too? I am working on a > Korean version of mysql yet I currently speak only english. That utility > would help me gobbs. > > -Original Message----- > From: Joel Rees [mailto:[EMAIL PROTECTED]] > Sent: Sunday,

Re: Cannot install mysql on OS X 10.2

2002-10-01 Thread Joel Rees
Philip Lavine scrawled > To all, > > I can not configure mysql on OS X, using the latest build for that OS. Oh? > Thanks Sure. (I'm not telepathic. What error messages and/or misbehavior are you getting during the install?) -- Joel Rees

Re: install mysql on osx 10.2

2002-10-01 Thread Joel Rees
; http://www.entropy.ch/software/macosx/mysql/ I was able to install by hand from the instructions in the MySQL docs, but I am somewhat comfortable with UNIX. Still took me a good piece of a night, but I needed to know about the stuff going on underneath. -- Joel Rees <[EMAIL PROTECTED]> --

Archives are where (was Re: Filemaker database to MYSQL)

2002-10-01 Thread Joel Rees
more help. I don't use Filemaker myself. > Before you criticize someone, > you should walk a mile in their shoes. > That way, when you criticize them, > you're a mile away, and you have their shoes. Yeah, but they probably have your shoes. ;-) -- Joel Rees <[EMAIL

Re: Japanese Charset

2002-09-30 Thread Joel Rees
t your customer might want to put single or double quotes around something on a page, and the way it is right now MySQL should be throwing syntax errors when it gets embedded quotes. > (The hex value of the backslash is 0x5c, see Joel Rees' previous emails > for an explanation on how m

Re: Japanese Charset

2002-09-30 Thread Joel Rees
k.) They are working on methods for doing this in MSWindows, but the different user model in MSWindows requires a different approach than they are using for *NIX. -- Joel Rees <[EMAIL PROTECTED]> - Before posting, ple

Re: Japanese Charset

2002-09-29 Thread Joel Rees
How would you set up the database queries to store those strings? Say, do you want a little utility program in Java or C that will print the hexadecimal values of the characters in a string? Basically, it would be a command-line utility, so you would copy the text and the

Re: Filemaker database to MYSQL

2002-09-27 Thread Joel Rees
> Has anyone created a plugin or script that will allow me to > convert my filemaker database to MYSQL Check the archives. There has been some discussion of this in the past. -- Joel Rees <[EMAIL PROTECTED]> - Be

Re: Japanese Charset

2002-09-27 Thread Joel Rees
t definitely will fix the problem with getting your data into MySQL. But there is something else going on between getting the data out of MySQL and getting it into your pages. 0x836c somehow morphed to 0x8e4c. Or was that the other direction? That won't be a topic for the MySQL list, however. -

Re: Japanese Charset

2002-09-24 Thread Joel Rees
rd is a mess, it's a hard point to argue right now. But the escape sequence _is_ part of MySQL's spec.) > If option 1 were true, then why do the characters show up fine when in a > static HTML document? (see below). I want to see that static HTML. > In Response to

Re: Japanese Charset

2002-09-20 Thread Joel Rees
subject come up before on the list, just can't remember which way the turkey rolled. But your content tool will need to do something slightly different with the input. Could you search the archives about escape sequences or the backslash charac

Re: WG: ABUSE? , myisampack , sql , admin [T2002091901XL]

2002-09-19 Thread Joel Rees
. (You should look at the headers you get from some people. It's easy to understand how a machine could get confused.) -- Joel Rees <[EMAIL PROTECTED]> - Before posting, please check: http://www.mysql.com/manu

Re: anyone using OS X server and publishing mySQL?

2002-09-18 Thread Joel Rees
archives today. Probably not enough sleep last night.) Oh, yeah: http://www.google.com/search?hl=en&ie=ISO-8859-1&q=mac+os+x+mysql -- Joel Rees <[EMAIL PROTECTED]> - Before posting, please check: http:

Re: Japanese Charset

2002-09-18 Thread Joel Rees
the OS into either English or Japanese. (Mac OS X can set the language for the OS at log-in time, seems like MSW ought to be able to at least switch on boot.) > Question 3. How do I tell which charset MySQL is using, euc-

Re: JAMES KADEH mysql !

2002-08-28 Thread Joel Rees
James, I took the liberty of forwarding your requests to [EMAIL PROTECTED] I hope you don't mind. For those who are not familiar with poor James's situation, I offer (again) these links: http://home.rica.net/alphae/419coal/ http://www.ksu.edu/InfoTech/news/2002/08-20emailscam.htm

OT: Re: Info on 4.0.x release date

2002-08-28 Thread Joel Rees
back to MySQL AB. When you start needing answers on a timely basis, buy the support. -- Joel Rees <[EMAIL PROTECTED]> PS: Yes, they are breaking lots of new ground here. The mantra "This is business software!" has been repeated ad nauseum for longer than you have been in the busines

Re: Info on 4.0.x release date

2002-08-27 Thread Joel Rees
amp;w=2 http://marc.theaimsgroup.com/?l=postgresql-general&r=1&w=2 (Some people see MySQL and PostgreSQL as competitors. I've heard from many who use both as complementary tools.) http://marc.theaimsgroup.com/?l=ant-user&r=1&w=2 http://marc.theaimsgroup.com/?l=str

Re: Won't compile on Mac OS X 10.2

2002-08-25 Thread Joel Rees
r Mac OS X (10.1), I had to mkdir the socket directory and chown/chmod by hand. I think I also built the bin structure by hand, as well, don't remember why. You might try that, just to see. -- Joel Rees <[EMAIL PROTECTED]> ---

Re: 30th December 1899

2002-08-25 Thread Joel Rees
with a search tool to erase them all. But there are lots of other ways to get bad dates into records. -- Joel Rees <[EMAIL PROTECTED]> sql, query - Before posting, please check: http://www.mysql.com/manual.ph

Re: How do I uninstall mySQL?

2002-08-16 Thread Joel Rees
> How do I uninstall mySQL? MSWindows or *NIX? Which one? (And have you searched the archives? I think I've seen this question answered before, perhaps depending on your OS and version.) -- Joel Rees <[EMAI

OT put-on-vacation command for list server? (was Re: a newsserver ...)

2002-07-31 Thread Joel Rees
mands and I don't see such a command. I guess I should see if I can figure out how hard it would be. -- Joel Rees <[EMAIL PROTECTED]> - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Re: about big5 charset

2002-07-23 Thread Joel Rees
some time, and the necessary files should be in place. The file you need to edit (or make) for MSWinjunk is probably C:\WINNT\my.ini. Look over the manual carfully. -- Joel Rees <[EMAIL PROTECTED]> Ben Koo inquired > Dear Sirs, > > would you mind to tell me how to add "big5

Re: MySQL in different OSes

2002-07-17 Thread Joel Rees
est to use mysqldump. Unless, of course, you're just curious to see what happens when bits aren't where the CPU thinks they're supposed to be. -- Joel Rees <[EMAIL PROTECTED]> - Before posting, please che

Re: Goodday

2002-07-11 Thread Joel Rees
> Attn: mysql , > > My name is Mr. Oluwafunmi G, the manager, credit > and foreign bills of Ecobank Plc. I am writing in Well, they're getting smart enough to vary the story line a bit now: http://www.google.com/search?hl=en&ie=ISO-8859-1&q=nigeria+money+laundering+419 http://home.rica.net/alph

Re: multi-byte characters

2002-07-03 Thread Joel Rees
7;ve seen it > called ejis in a MySQL context), and was wondering if anyone can point > me to information on how to do that with MySQL and PHP. Have you tried setting the language to Japanese and the encoding to shift-JIS yet?

Re: need your attn: can mysql support japanese and korean simultaneously in same database

2002-06-30 Thread Joel Rees
to pick up some oddball cases. Or, you might consider keeping the Japanese and Korean data in separate tables on separate servers. From what I understand, that should be possible. > if you can sugest any other package or addin for this, that would > also be >

Re: help starting up mysql

2002-06-23 Thread Joel Rees
tmp/mysql.sock' (61) > >> > >> What do I need to do, please? I myself made the directory to store the sockets in by hand. I doubt that was the right thing to do, but I was able to get mySQL to run, query the permissions table from the command line, etc. > >> (Does this li

Re: to_asci

2002-06-06 Thread Joel Rees
ering if something like to_ascii() is really going to do what you want. I'm guessing you would prefer auxilliary fields or tables, but that is just my guess. -- Joel Rees <[EMAIL PROTECTED]> > sql,query,table -

Re: How to convert non latin characters?

2002-06-06 Thread Joel Rees
s on how consistent the authors were. Japanese has five vowels, a, i, u, e, and o. People don't usually do anything strange with the consonants, at least not in the last hundred years or so. But that doesn't help for Tibet or Myanmar, of course. Unicode is helping bring these sorts of

Re: UTF-8 national characters

2002-05-15 Thread Joel Rees
Sven Bentlage asked > Is there a way to get UTF-8 national characters sets working when you > only have user access to a database (it's my ISP's)? Whether you use the my.cnf/my.ini configuration file or the startup parameter, it's a startup option. You have to have access to one or the other.

Re: Errors catalog, character-sets-dir .

2002-05-01 Thread Joel Rees
-sets-dir=d:\mysql\share\charsets. > but when I start the client, It continues to look on > c:\mysql\\share\charsets. Hmm. Shot in the dark, but you aren't by any chance trying to put your my.ini file on your d: drive, are you? Joel Rees Alps

Re: mysql /bin directory

2002-04-30 Thread Joel Rees
installing: http://www.mysql.com/doc/I/n/Installing_binary.html http://www.mysql.com/doc/L/i/Linux-RPM.html Joel Rees Alps Giken Kansai Systems Develoment Suita, Osaka - Before posting, please check: http://www.mysql.com/

Re:  character

2002-04-24 Thread Joel Rees
n and retrieve it > in tact, so there must be a way... Lasso -- would mean you're on a Mac? Hmm. Does MySQL have a charset for the Mac version of extended ASCII? You may find yourself making a charset. (If so, please share it.) Check under localization in the manual, section 4.something.

Re: OpenBSD and MySql

2002-04-12 Thread Joel Rees
openbsd packages > > collection? Is it too old? If not, it will probably be the quickest > > solution for now. > > I'm using openbsd to host a server from home, and the default binary isn't > configured correctly. What configurations are you having problems with? Most of the

Re: search pattern matching

2002-04-12 Thread Joel Rees
ained, but aren't really related. Joel Rees Alps Giken Kansai Systems Develoment Suita, Osaka blasted filter fodder: sql,query - Before posting, please check: http://www.mysql.com/manual.php (the manu

Re: mysql & japanese

2002-04-12 Thread Joel Rees
n the list can. I'll this to the list and BCC you, hope you don't mind. (BCCing you means you'll have to watch the list for answers.) Thanks for making me look up the charset options for MySQL again. Now maybe I'll get my machine set up right. ;-) Joel Re

Re: mysql & japanese

2002-04-10 Thread Joel Rees
acter sets they work with, etc. And we don't even know for sure if you are going to try to keep English and Japanese together in one database, or if you plan to separate the databases so you don't have to mess too much with keeping the browser environments and character encodings and dat

Re: adding 8-bit character encoding to mysql-max-3.23.49-win

2002-04-09 Thread Joel Rees
ork for 8-bit character sets. Try it and see. The manual says you must re-compile to get the new character set recognized. Joel Rees Alps Giken Kansai Systems Develoment Suita, Osaka - Before posting, please check: http://w

Re: MySQL database changes for japanese Lang..

2002-04-09 Thread Joel Rees
Have you read section 4.6 of the manual? Do you know what parts of the database will store Japanese data, what parts of stored Japanese data will need to be search and/or sorted, that sort of thing? Joel Rees Alps Giken Kansai Systems Develomen

Re: OpenBSD and MySql

2002-04-08 Thread Joel Rees
there a reason you don't want to use the binary in the openbsd packages collection? Is it too old? If not, it will probably be the quickest solution for now. Joel Rees Alps Giken Kansai Systems Develoment Suita, Osaka

Re: Uninstalling on MacOS X

2002-04-08 Thread Joel Rees
(Does anyone?) > 2) several weeks go by without use, forget password to mysql > 3) cannot remember password, at all > 4) install mysql over itself, doesn't fix problem When you forget your password, see the manual about the "--skip-grant-tables" option. And don't forg

Re: regarding MySql boolean field/datatypes is there a equvilent bool

2002-04-02 Thread Joel Rees
manual page as above). Or you may just want to use 0 and 1 in a TINYINT field. Depends on what you need. I note that with neither SET nor ENUM can you define 'FALSE' as zero. Joel Rees Alps Giken Kansai Systems Develoment Suita, Osaka > Come on - let me out of my misery as im a P

Re: Is Addition To Previous Post

2002-04-02 Thread Joel Rees
check the archives. ;) Joel Rees Alps Giken Kansai Systems Develoment Suita, Osaka - Original Message - From: "Marcus - Videomoviehouse.com" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, April 03, 2002 11:59 AM Subject: Is Addition To Previous Post &

Re: PERL/SQL, again? - Re: Procedures

2002-04-02 Thread Joel Rees
se I have yet to convince the management at my current shop of the advantages of perl "over PHP or Java". Still have to show them that it gains more than it costs to have perl as an additional tool.) Don't have much time, but if you have some short tasks that might help lay some gr

Re: filemaker to mysql

2002-03-31 Thread Joel Rees
ing links: http://www.filemaker.com/ti/105748.html http://www.profdata.nl/pdm/generic.jsp?taxonomy_id=5 (I asked in the devoloper discussions area, if anyone's curious.) Joel Rees Alps Giken Kansai Systems Develoment Suita, Osaka ---

Re: GUI

2002-03-29 Thread Joel Rees
DL Neil wrote: > Various scripting/programming languages will interface to MySQL. > PHP (and therefore C++) fit into that happy intersection. _^^^ Perl? - Before posting, please check: http://www.mysql.co

Re: [newbie post] linked lists..

2002-03-29 Thread Joel Rees
he disk, it is usually best to avoid actual linked lists in tables. Joel Rees Alps Giken Kansai Systems Develoment Suita, Osaka - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.

Re: filemaker to mysql

2002-03-28 Thread Joel Rees
orted on Mac OS X, but they seem to indicate they are working on it. It looks like it supports JDBC, so you may be in luck if you use Java. Not much information. Joel Rees Alps Giken Kansai Systems Develoment Suita, Osaka sql, query --

Re: Importing fixed-length records

2002-03-28 Thread Joel Rees
ILE Syntax. http://www.mysql.com/doc/L/O/LOAD_DATA.html 6.4.9 LOAD DATA INFILE Syntax HTH Joel Rees Alps Giken Kansai Systems Develoment Suita, Osaka sql, query - Before posting, please check: http://www.mysql.com/manua

Re: auto_increment question

2002-03-28 Thread Joel Rees
make your index (in this case, client ID) so huge that you don't care if there are gaps. An unsigned INT (instead of MEDIUMINT) will give you so many keys that it will take over thirteen years at an average ten new clients per second to overflow. Joel Rees Alps Giken Kansai Systems Deve

Re: binary expansion?

2002-03-26 Thread Joel Rees
2. A result of 1 says it's a hit, 0 says it's a miss. Incidentally, have you considered using a SET type here (manual section 6.2.3.4)? Joel Rees Alps Giken Kansai Systems Develoment Suita, Osaka - Before posting,

Re: Enforcing Column Types

2002-03-26 Thread Joel Rees
in a database? that the database software has to either allocate the maximum width for each variable length field, or use an additional level of indirection in the indexing? Just a thought. Joel Rees Alps Giken Kansai Systems Develoment Suita, Osaka Filter fodder: sql,query (I thought the filter als

Re: OSX and Virtual Hosting set-up?

2002-03-19 Thread Joel Rees
f MySQL, or a separate instance of MySQL, per the manual, section 4.1.4, "Running Multiple Copies"? Am I off base thinking this would be appropriate? (Just a thought.) Joel Rees Alps Giken Kansai Systems Develoment Suita, Osaka > phpmyadmin (saves using the command line!) to gr

Re: Application security

2002-03-19 Thread Joel Rees
. Or perhaps a server for each party. Again, you would have a lot of trade-offs to consider. Joel Rees Alps Giken Kansai Systems Develoment Suita, Osaka - Before posting, please check: http://www.mysql.com/manual.php (t

Inquiring minds want to know about Unicode in 4.1

2002-03-19 Thread Joel Rees
encodable space, allowing all the current additions (Unicode 3.1) in the first extension plane? Joel Rees Alps Giken Kansai Systems Develoment Suita, Osaka mysql, tables, select good food - Before posting, please check: http

Re: Access denied on use mysql;

2002-03-19 Thread Joel Rees
on as you know how. You may have a my.cnf (root of your system drive, I did see a c:> didn't I?) or my.ini (Windows directory) left over from the previous install. That may have a default password set in it for root. As was mentio

Re: Mysql dump

2002-03-18 Thread Joel Rees
Uma Shankari T queried: > I am having all mysql database contents in one txt file.how i will dump > all those contents to mysql database tablespls tell me how to do it Have you looked at the manual, section 4.8.7? mysqlimport Joel Rees Alps Giken Kansai Systems Develoment Suita,

Re: copy osx db to win2k

2002-03-18 Thread Joel Rees
jake williamson 28 queried: > hello! > > i've been developing a MySQL database in mac osX - i would like to transfer > it to work onto a win2k box running apache and mysql. Have you looked at mysqldump and mysqlhotcopy, in section 4.8 of the manual? > what files from X do i need to copy over? i

Re: Foreign languages

2002-03-18 Thread Joel Rees
kinds of searches in, etc? I'm curious about > Chinese and Japanese (and other asian languages) specifically. Using it light duty with Japanese (s-jis) here. Don't really know why it works yet. (No problems yet.) Joel Rees Alps Giken

Re: Access denied on use mysql;

2002-03-18 Thread Joel Rees
er And there's a password option, too, which you may need. Joel Rees Alps Giken Kansai Systems Develoment Suita, Osaka - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.co

Re: (newbie) how can I regenerate the data/mysql tables?

2002-03-18 Thread Joel Rees
Some airhead wrote: > Ehhhtto. You're using windows, right? Have you checked in your php.ini file? I think that airhead must have meant the my.ini file. Or the my.cnf file. :^, PS: The MySQL Reference Manual, section 2.1.2.2 for MSWindows and section 4.1.2 in general. Airhead Alps Giken Kansa

Re: (newbie) how can I regenerate the data/mysql tables?

2002-03-18 Thread Joel Rees
ows, right? Have you checked in your php.ini file? This is mentioned in the manual, where it describes the install process. I have my data directories on a different drive, no problems. Joel Rees Alps Giken Kansai Systems Develoment Suita, Osaka

Re: adding messages and a character set for shift-jis

2002-03-18 Thread Joel Rees
Michael Widenius wrote: > >>>>> "Joel" == Joel Rees <[EMAIL PROTECTED]> writes: > > Joel> But comp_err doesn't seem to be in the win32 distribution. So I am thinking, > Joel> I should be able to load mysql into openBSD and do the conversio

Re: delete old mysql users

2002-03-18 Thread Joel Rees
MySQL script to do it. The database name is mysql and the tables in it are user and db, I think. Joel Rees Alps Giken Kansai Systems Develoment Suita, Osaka - Before posting, please check: http://www.mysql.com/manual.php

Re: Mailing list manager

2002-03-18 Thread Joel Rees
sible to build in a man-week. The biggest headache was scheduling using MSW2k's services. (Well, no, the biggest headache is an alternate download feature which I am trying to re-build right now, another curse for MSIE for not handling headers and timeouts very well.) Joel

  1   2   >