how to backup mySQL database?

2001-02-27 Thread Keneth
Anyone know how to backup mySQL database? with best regards, TOM

Re: Mysql ERROR

2001-02-27 Thread Ryan Snow
When ever i add a new number i get a processing form error in the SQL statements? tells me to report this error? does anyone know what is going on happens when i try to add a new item to the database. - Before posting, please c

problem compiling mysql 3.23.33 under Solaris8/gcc2.95.2

2001-02-27 Thread Gérard Gachelin
Hello, here attached you'll find a mysqlbug report des cribing a compilation problem of the mysql client. Thanks for any help -- Gérard GACHELIN e-mail : [EMAIL PROTECTED] Université de la Réunion Tél: 0262 93 82 72 15, Avenue René Cassin - BP 7151

SQLException not being caught

2001-02-27 Thread Micah Daniels
Hi. > > I have a jdbc problem. I create a Connection object from a Datasource or a Driver manager. Everything works except when i purposefully enter the incorrect user name or password, the program crashes.I catch a SQLException and an interbase specific UserUnauthorisedException but none of t

Re: MySqwl does not start (server)

2001-02-27 Thread Rolf Hopkins
You really should reply to the list and not just me. I may not be able to help you or I may not have the time. If my memory serves me correctly, my mysql.host is in /var/lib/mysql directory. I'd have to check but I'm too lazy to right now. Do a find on your PC for that file. IF it doesn't exi

Re: load large data files?

2001-02-27 Thread Rolf Hopkins
You really should reply to the list and not just me. I may not be able to help you or I may not have the time. - Original Message - From: "Lisa M. FitzGerald" <[EMAIL PROTECTED]> To: "Rolf Hopkins" <[EMAIL PROTECTED]> Sent: Wednesday, February 28, 2001 9:07 Subject: Re: load large data f

Re: Question

2001-02-27 Thread Rolf Hopkins
You really should reply to the list and not just me. I may not be able to help you or I may not have the time. Also, do not send attachments that aren't universally accepted. What you can send is Preferred: pure text Pictures: JPG, GIF only Most people on this list are Unix based, not windows

Re: storage and retrieval of images

2001-02-27 Thread Rolf Hopkins
Firstly, images ARE binary files no matter which way you look at it. How else do store images if they are not in binary? What I think you want to ask is Can mysql store images? YES Can mysql display it as an actual image? NO You can use the blob type to store images. You'll find this in the

Problem compiling mysql on FreeBSD

2001-02-27 Thread Shawn Heeley
Hi folks, This appears to be a common problem that I can't seem to find a solution. No matter which approach I take to trying to install mysql-server, the end result is the same. It doesn't work. I apologize for the long message. Thanks for the help. System Specs FreeBSD www.machine.com 4.0-RELE

Re: Mysql GUI

2001-02-27 Thread Rolf Hopkins
Try downloading mysqladmin from www.mysql.com - Original Message - From: "Karl Chen" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, February 28, 2001 3:35 Subject: Mysql GUI > Hi : > > > Would you please email me a mysql GUI for Red Hat Linux 7 > > > Thankx > > karl

storage and retrieval of images

2001-02-27 Thread Geetha Narayanan
Dear sir, can i able to store images in database, not in binary format but directly as image and retrieve easily. Now,i am using file uploading from client and just filename i am storing in database.Instead of that can we able to store image directly in database ASAP reply me soon.

Table design - "Second Options"

2001-02-27 Thread MikeBlezien
Hello all, Sorry about the slightly off-topic request, but table designs structures are not my strong point as of yet! :) I have a project we are working on, and have a rough draft put together before actually starting. I would greatly appreciate some feedback if improvements, changes or additio

Re: Error 1006

2001-02-27 Thread sridhvenk
Where can i get the list all such errors and their descriptions. Sridhar On Tue, 27 Feb 2001, Gerald L. Clark wrote: > Sridhar-Yahoo wrote: > > > > Hello , > > > > I am using MySQL3.23 on linux . I am getting an error when creating a database now. > > I usually dont get this error. > > >

RE: Complex Query Problems

2001-02-27 Thread Quentin Bennett
Hi, So long as there is some way of joining your two tables, this shouldn't be a problem: SELECT name FROM mytable, myothertable WHERE (mytable.ID = myothertable.idlistcolumn); Regards Quentin -Original Message- From: John Coggeshall [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 28 Febr

RE: XML support under mySQL

2001-02-27 Thread Cal Evans
reHi Jan, Sorry, this one slipped under my radar. I wasn't ignoring you. Your arguments are well thought out but the fact of the matter is that until we change the major databases of the world from RDBMS to something more suited to XML then all you will ever be doing is providing an insulation

Complex Query Problems

2001-02-27 Thread John Coggeshall
I've got a complex query... I was wondering if someone could give me some advice.. Is there any way that I can base the WHERE clause of a query on the contents of another table?? for instance... SELECT name FROM mytable WHERE(ID=myothertable.idlistcolumn); where myothertable is a HEAP construc

RE: XML support under mySQL

2001-02-27 Thread Cal Evans
Florian, Without trying to be condescending, now you are just being silly. :) We replace traditional files with computer files because of (just to name a few) their ease of storage, replication, indexing and retrieval. We replace traditional accounting systems with computer based accounting sys

Re: ERROR 2003

2001-02-27 Thread Miguel Angel Solórzano
At 22:25 27/02/2001 +, David Murphy wrote: Hi! >I have been running MySQL server for four weeks now and have not had any >problems, until now >I loaded Windows 2000 Server up this morning and tried to connect to >mysql...I got the following error > >ERROR 2003: Can't connect to MySQL server o

Select bug?

2001-02-27 Thread Mike Machado
There seems to be a matching bug in MySQL. Why will it match if I do a > of a number smaller that is in the custom_price column, or if I do a strcmp(custom_price, '355.62'), but will NOT match if I do "WHERE custom_price = '355.62'" OR if I try "WHERE custom_price = 355.62"? This happens in b

Re: XML support under mySQL

2001-02-27 Thread John Jensen
Re: > Because it _might_ be the great, stable and matura language for > storing and querying data of tomorrow.. I think not. XML is a standard being pushed by a few big corporations, but lacks serious grassroots development, or even adequate support from recent browser versions. PHP, on the

Bad ISAM index on creation

2001-02-27 Thread Scott Vanderweyst
Hi, We're attempting to get mysql running on our System: SunOS hsNavMrySun2 5.6 Generic_105182-21 i86pc i386 i86pc Architecture: i86pc We're using the Workshop pro compilers, and can compile the source v 3.23.33 without problems. However, nothing on the system that I've found can create tables cor

Unique ID's Alphanumeric to save digits ?

2001-02-27 Thread S A
Can MySQL help with generation of ALPHANUMERIC unique identifiers ? ID's that use the full ASCII char range create more possible combinations with the same # of characters which can be important when squeezing into cookie storage space. 4 character numeric ID has 10,000 combinations. 4 charac

Re: ORDER BY optimisation

2001-02-27 Thread John Jensen
You neglected to say how much memory your system has. I am a newbie, but one of the first things I learned about mysql, is that it needs a lot of memory to handle any kind of load. If you do not have at least 500meg, add some. On 26 Feb 2001, at 13:22, Joseph Bueno wrote: > Hi list, > > I hav

GROUP BY problem.

2001-02-27 Thread Angel Behar
Hi !!! I'm running 3.23.28-gamma under windows NT, but I have the following problem. I need to query some data and gruop by some field (codigo in this case) so I run the following query : SELECT codigo from ropa where cve_depto='3' AND cve_clase='06' AND activo = 'A' AND p_credito <> 0 GROUP

Online manual 'section' links seem not so good

2001-02-27 Thread Dennis Gearon
The end of this quote is a link. When I loaded the whole manual in my browser NS4.7x, I expected the link to move through the manual copy in my browser's cache. Instead, it tried to link to a copy on the MySQL site and gave a 404 error message from the MySQL site. >From manual (Section 5.1): >Us

Re: Re: Re: Youch!

2001-02-27 Thread John Jensen
I had sent this earlier, but it got waylaid (twice). Perhaps the mail- server was temporarily down. Okay, I got rid of EVERYTHING (except the data, which got backed up in douplicate), and did a fresh install from a tarball, f

Re: Search Engine Theory

2001-02-27 Thread Jonothan Farr
http://www.google.com/search?q=search+engine+theory ;) --jfarr - Original Message - From: "Jamie Krasnoo" <[EMAIL PROTECTED]> To: "MySQL" <[EMAIL PROTECTED]> Sent: Tuesday, February 27, 2001 2:25 PM Subject: Search Engine Theory > Could anyone point me to any documents on creating a s

ERROR 2003

2001-02-27 Thread David Murphy
I have been running MySQL server for four weeks now and have not had any problems, until now I loaded Windows 2000 Server up this morning and tried to connect to mysql...I got the following error ERROR 2003: Can't connect to MySQL server on 'localhost' (10061) >From Component Services MySQL is s

Re: Key Word Query

2001-02-27 Thread Web master
I agree, I don't think there is a function in MySql, it will do the job. May be you can use the following algorithm 1. fetch all rows item description. 2. Split into words and put it in a array. 3. Create a counter array of the same limit of word array. 4. in a for loop, count number of time tha

Search Engine Theory

2001-02-27 Thread Jamie Krasnoo
Could anyone point me to any documents on creating a search engine using MySQL or search engine theory in general? Thanks, Jamie Krasnoo www.MyEBoard.com [EMAIL PROTECTED] PGP Key - http://www.planetphat.com/jkrasnoo/pgp.html ---

Re: XML support under mySQL

2001-02-27 Thread Patrick Goetz
On Mon, 26 Feb 2001, Colin Faber wrote: > Don't forget, Microsoft and Oracle are behind it so it _MUST_ be the > greatest thing to come along since sliced bread. You folks need to keep > in mind that with the microsoft system the XML layer IS NOT part of the > database it self but an additional ap

Re: PHP and mysql

2001-02-27 Thread Atle Veka
Chris, I *strongly* suggest you read up on SQL. You simply don't know the difference between the most important commands :) There shouldn't be a space in your database (and it cannot either). Please also post what commands you're using to select your database etc. From what you show us here, we

Re: Problem with mysql

2001-02-27 Thread Atle Veka
On Tue, 27 Feb 2001, Ron Beck wrote: > No, it's not normal. You managed to create your database with a space > in front. You'll probably have to delete and recreate the database. > This *is* normal. It's got nothing to do with the database :) The behavior we see here is quite normal from wha

RE: PHP and mysql

2001-02-27 Thread Quentin Bennett
Hi, If you still have that space, I'd take it out. -Original Message- From: Chris Hallgren [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 28 February 2001 10:15 a.m. To: [EMAIL PROTECTED] Subject: PHP and mysql PHP and mysql dont work for some reason i installed both as directed with the

Re: Help with Create Table

2001-02-27 Thread John Jensen
Okay, what is this binary file, smime.p7s that you had attached to your post? I don't open attachments without explanation. To do so is a SERIOUS security risk. PLEASE, if you attach ANYTHING except a business card or graphic file, tell us about it in your message, so we know it is deliberate

RE: MySQL for Mac OS X Beta

2001-02-27 Thread C. Duncan Hudson
> I would like to know where I can get the MySQL build for Mac OS X Beta? Or, > if anyone has built it from the source? > > Thanks, > > Manoj Manoj, You can get a binary installation here: http://homepage.mac.com/LightyearDesign/MacOSX/ . I'm using it and it's working just fine. Now if only I

Re: MySql Install problems

2001-02-27 Thread John Jensen
Now, why didn't I find that in the docs? That might have saved me a lot of frustration. On 24 Feb 2001, at 1:53, Verdius wrote: > These RPM's tend to set you up to run mysql automatically upon > boot. > Instead of trying to run mysql, just log into it: > > %> mysql -h localhost -u root -p

Re: Key Word Query

2001-02-27 Thread MikeBlezien
On Tue, 27 Feb 2001 13:53:52 -0700, Steve Ruby <[EMAIL PROTECTED]> wrote: You maybe able to adapt the FullText search for this. You can read the details on this at: http://www.mysql.com/doc/M/y/MySQL_full-text_search.html depending what version of MySQL your using. >>> >>> Is there anyway to

Re: Problems with SHOW DATABASES / TABLES

2001-02-27 Thread Greg Cope
Sinisa Milivojevic wrote: > > HI! > > In response to several mail messages on mailing list that were > centered around some misbehaviour of SHOW DATABASES / TABLES, I have > tested thoroughly (with several --user=... options) 3.23.33 and found > out that it works perfectly. Hum Not meanin

PHP and mysql

2001-02-27 Thread Chris Hallgren
PHP and mysql dont work for some reason i installed both as directed with the rpm and it doesnt work for some reason i get the error MySQL said: Unknown database ' chrishallgren' has anyone see this error with php and mysql or should i be posting to a php list it seems that php likes to use the se

Re: date comparison?

2001-02-27 Thread Cindy
Steve Ruby writes: >Ignore my hasty and wrong response from moments ago. you should be fine >if date_resolved is a datetime type column if it is only a date you >will need to use date_format to convert your date_sub(now()) to a date, >otherwise the later returns datetime and cannot be compar

Clipper RDD for MySQL ?

2001-02-27 Thread Ari
Where i found Clipper RDD for MySQL ? Ari [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-ma

Re: Problem with mysql

2001-02-27 Thread Ron Beck
No, it's not normal. You managed to create your database with a space in front. You'll probably have to delete and recreate the database. Chris Hallgren wrote: > > ok here is my problem i have redhat 7 i installed mysql via the rpm and > i get the following error > > mysql> select chrishallg

Re: more Youch

2001-02-27 Thread John Jensen
I wish I could say that helped, Sean. I still don't know if I should try a specific command to fix things, or move/remove a specific file first, or completely reinstall Linux and start from scratch. The last option is least desirable, as I will have the most things to reconstruct on the system.

compiling problem on HPUX

2001-02-27 Thread Frans Fierens
Has anyone ever compiled mysql on a HpUX (9.01) machine ? I always got : "mysqld got signal 4" when executing the mysqld daemon. debugging gives in mysqld.trace : T@1: >fn_format T@1: | enter: name: /opt/mysql dsk: form: flag: 16 T@1: | >dirname_part T@1: | | enter: '/opt/mysq

MySQL for Mac OS X Beta

2001-02-27 Thread Manoj Patwardhan
I would like to know where I can get the MySQL build for Mac OS X Beta? Or, if anyone has built it from the source? Thanks, Manoj - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://list

Re: date comparison?

2001-02-27 Thread Steve Ruby
Cindy wrote: > > SELECT >Foster_Dogs.dog_name, >Foster_Dogs.dog_status, >Foster_Dogs.date_resolved, >Foster_Dogs.adopting_family, >Foster_Dogs.foster_paperwork, >Foster_Dogs.dog_id, >Adoption_Applications.firstname, >Adoption_Applic

Re: date comparison?

2001-02-27 Thread Steve Ruby
Cindy wrote: > > > SELECT >Foster_Dogs.dog_name, >Foster_Dogs.dog_status, >Foster_Dogs.date_resolved, >Foster_Dogs.adopting_family, >Foster_Dogs.foster_paperwork, >Foster_Dogs.dog_id, >Adoption_Applications.firstname, >Adoption_App

Re: Key Word Query

2001-02-27 Thread Steve Ruby
Dale Frohman wrote: > > Is there anyway to do a query and search for the most frequent > word that appears in a particular field in a table? > > ie: > > ITEM DESCRIPTION > > > Blue Dog > Red Dog > Yellow Cat > > I would want to spit out "Dog" as being the most reoccuring word

Re: MySQL as spider database.

2001-02-27 Thread John Jensen
Okay, so I'm slow getting caught up on this list. ht::/Dig is practically useless! Having done an extensive search on college websites tracking down essential details on the schools and their programs, I have run across a number that use ht::/Dig. In every single case, ht::/Dig returned the mo

RE: Problem with mysql

2001-02-27 Thread Rick Emery
I also have MySQL on Redhat 7. I don't have the problem you mention. I installed from RPM. You might try re-installing. rick -Original Message- From: Chris Hallgren [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 27, 2001 1:47 PM To: [EMAIL PROTECTED] Subject: Problem with mysql o

Re: Problem with mysql

2001-02-27 Thread Stephen Johnson
It is not that you need the space -- it is that you need to have the quotes. -- Stephen Johnson [EMAIL PROTECTED] http://www.pets4u.com Owner / Founder -- your next best friend is waiting for you -- - Before posti

Re: Problem with mysql

2001-02-27 Thread Jason Landry
You need to select the table name, and frankly, perhaps read up a bit more on SQL in general. You're second command is simply creating a string. For example, "select 'this is an arbitrary string'" will return similar results. You need to be form your query like this select * from chrishallgre

Re: Problem with mysql

2001-02-27 Thread Atle Veka
On Tue, 27 Feb 2001, Chris Hallgren wrote: > ok here is my problem i have redhat 7 i installed mysql via the rpm and i get the >following error > > mysql> select chrishallgren; > ERROR 1054: Unknown column 'chrishallgren' in 'field list' > mysql> select ' chrishallgren'; > ++

RE: Problem with mySQL

2001-02-27 Thread Cal Evans
myself> select ' chrishallgren'; is not selecting the contents of chrisallgren, it's selecting the literal ' chrishallgren' your select statement is not complete. it should be Select from Your statement does not have a from tablename specified. If you are trying to switch databases then it'

Logfile message???

2001-02-27 Thread Stephan Skusa
What does this message in my logfile mean?? 010227 21:23:01 Verbindungsabbruch 1976 zu db: 'database' user: 'user' host: `archimedes.int.lippe-net.de' (Fehler beim Lesen eines Communication-Packets) TIA Stephan Skusa --

Innobase

2001-02-27 Thread Phil Daintree
Looked at the Innobase web site - very exciting looking specs. SQL: -a small interpreter with stored procedure syntax like in Oracle, no SQL optimizer Does this mean that MySQL using Innobase tables, will this allow for stored procedures of multiple SQL statement

RE: Problem with mysql

2001-02-27 Thread Johnny Withers
Don't really understand your question, however: 1) to select a database, you use the keyword 'use': mysql>use chrishallgren; 2) what you are doing is: mysql>select chrishallgren; This is a select statement, it's looking for data. It thinks chrishallgren is a colu

date comparison?

2001-02-27 Thread Cindy
[best viewed in fixed-width font] OK, I've been bapping my head against tihs one for a while -- I've *done* time restrictions before, tho normally by weeks or days. In this case, i want to restrict to records from the past six months. What am I missing? If I take out the time restriction in the

Re: Sample .cnf files

2001-02-27 Thread Mark Chalkley
Nope, not that I could find. I've deleted it, already, but I searched for *.cnf and came up with a couple of files, but they were sample db specific. Mark *** REPLY SEPARATOR *** On 2/27/2001 at 11:44 AM Jeremy D. Zawodny wrote: >Really? Is there no "support-files" subdirect

Re: more Youch

2001-02-27 Thread Sean Conley
It sounds like the problem is that you originally installed from RPM and later installed from source, or vice versa. RPMs often use a different file layout than source distributions, this is one reason why I always install software that I consider system critical from source, so that there are no

Re: Multiple Column list index

2001-02-27 Thread Eric Fitzgerald
depends fully on how you query the data out. If your going to be using only one field at a time, make seperate indexes. If your going to be ALWAYS using all 3 fields, then I don't see how a single combined index would be a problem. - Original Message - From: "MikeBlezien" <[EMAIL PROTEC

Key Word Query

2001-02-27 Thread Dale Frohman
Is there anyway to do a query and search for the most frequent word that appears in a particular field in a table? ie: ITEM DESCRIPTION Blue Dog Red Dog Yellow Cat I would want to spit out "Dog" as being the most reoccuring word. Thanks ---

Problem with mysql

2001-02-27 Thread Chris Hallgren
ok here is my problem i have redhat 7 i installed mysql via the rpm and i get the following error mysql> select chrishallgren; ERROR 1054: Unknown column 'chrishallgren' in 'field list' mysql> select ' chrishallgren'; ++ | chrishallgren | ++ | chrishallgren |

Re: Sample .cnf files

2001-02-27 Thread Jeremy D. Zawodny
On Tue, Feb 27, 2001 at 02:04:24PM -0500, Mark Chalkley wrote: > > Can anyone tell me where I can download the sample .cnf > configuration files mentioned in the documentation. I downloaded > the Win32 source package (I paid for a license) and they're not in > it. Are they only in the Unix sourc

Re: Multiple Column list index

2001-02-27 Thread MikeBlezien
On Tue, 27 Feb 2001 12:39:31 -0700, Steve Ruby <[EMAIL PROTECTED]> wrote: thanks Steve, this helps. I think I have a better picture now how to set up the index for the table. appreciate the info :) Mickalo >>Depends on the situation.. Mysql will use only one index per table per query. >> >>so

Re: Multiple Column list index

2001-02-27 Thread Vivek Khera
> "M" == MikeBlezien <[EMAIL PROTECTED]> writes: M> I have a table that stores business locations, which contains M> 'city','state' and 'zip' and this table is utilize for search M> queries. Which type of indicing take full advantage of the MySQL M> optimizer, create a multiple column index

Mysql GUI

2001-02-27 Thread Karl Chen
Hi : Would you please email me a mysql GUI for Red Hat Linux 7 Thankx karl chen Programmer , Information System Department Valley Presbyterian Hospital Tel (818) 782-6600 ext. 5141 - Before posting, please check:

Table Limit Crashing Machine?

2001-02-27 Thread Weber, Jeff
Mysql recently crashed my Linux box during a cron. Mysql quit responding and then the cron keep opening mysql until it cooked the memory. I rebooted, and now I can't restart mysql, I can't use mysqldump or mysqladmin either. They all just hang. Could it be possible that the table locked up becaus

Re: Multiple Column list index

2001-02-27 Thread Steve Ruby
Depends on the situation.. Mysql will use only one index per table per query. so if you very often query on all three you should put them in a multi-column index.. If you also often search on only one of the three you should put it first.. If you often search on another one of the three you shou

more Youch

2001-02-27 Thread John Jensen
There must be a bug here somewhere. I have just made three attempts to reinstall mysql, one from rpm, two from tarball. This is a Redhat6.1 system with 160meg of ram and mysql once ran on it, until I gave it an incorrect shutdown command. (It should not break so easily.) User and group "mysql

Re: any ASP/ADO/MySQL programmers out there? (LONG answer)

2001-02-27 Thread Carsten Gehling
- Original Message - From: "Henrik Lebtien Mohr" <[EMAIL PROTECTED]> Sent: Friday, February 23, 2001 3:57 PM > If any of you have tried the following with ASP/ADO and MySQL, please inform > me of how you did it: I've done a lot of this in my time, so I know most of the tricks. > I use

Sample .cnf files

2001-02-27 Thread Mark Chalkley
Can anyone tell me where I can download the sample .cnf configuration files mentioned in the documentation. I downloaded the Win32 source package (I paid for a license) and they're not in it. Are they only in the Unix source package or are they somewhere else? Or, perhaps, if someone has a c

Multiple Column list index

2001-02-27 Thread MikeBlezien
Hello all, I have a table that stores business locations, which contains 'city','state' and 'zip' and this table is utilize for search queries. Which type of indicing take full advantage of the MySQL optimizer, create a multiple column index (city,state,zip) or separate indices on each column. T

Re: Security Question

2001-02-27 Thread Donald Korth
LOAD DATA [LOW_PRIORITY] [LOCAL] INFILE 'file_name.txt' [REPLACE | IGNORE] INTO TABLE tbl_name [FIELDS [TERMINATED BY '\t'] [OPTIONALLY] ENCLOSED BY ''] [ESCAPED BY '\\' ]] [LINES TERMINATED BY '\n'] [IGNORE number LINES] [(col_name,...)] The LOAD DATA

Re: build problems on NT 5

2001-02-27 Thread Miguel Angel Solórzano
At 18:10 27/02/2001 +0100, Cynic wrote: Hi! The masm is a separate product of Microsoft. You can remove the .asm files from the MySQL tree. When your compiler reach the linking process, the linker will claims for some files of the strings directory, then add all these files from /strings directory

Compiling Problem

2001-02-27 Thread Christian Springub
Hi, I have a problem with compiling mysql. I use Suse 7.0 and mysql 3.23.33. I run "./configure --prefix=/usr/local/mysql". There was no error. By running "make", I got the following error: -- [..] /usr/lib/crt1.o: In function '_start': /usr/lib/crt1.o(.text+0x18): undefined reference to 'main' c

Re: RDBMS question on coding "expanding series-like fields"

2001-02-27 Thread Peter R. Wood - Mailing Lists
Hi Warren, What I personally would do is simply include some sort of 'ID' field. In other words, each question would have a unique ID. Question 1's ID would be 1, Question 2's ID would be 2, etc. Or however you wanted to number them. You could even set this up as an auto_increment and have t

Re: help file

2001-02-27 Thread Miguel Angel Solórzano
At 00:24 28/02/2001 +0800, Alan Thum Joo Soon wrote: Hi! >Is there any help file which I can download? Or how do I setup MySQL to >allow connection from a Win2k system to the Linux MySQL server? First read the MySQL Manual all about the privileges system (GRANT/REVOKE command, How works the priv

Re: mysql.server ignoring my.cnf?

2001-02-27 Thread Joel Gwynn
As far as my fuzzy memory of the install process goes, the install_db script made the /etc/mysql directory and put the my.cnf file there. In the my.cnf file, it says # You can copy this to one of: # /etc/mysql/my.cnf to set global options, # mysql-data-dir/my.cnf to set server-specific options (

RE: RDBMS question on coding "expanding series-like fields"

2001-02-27 Thread Julian Strickland
You need to re structure it using a table called say Questions with the following sorts of fields QID Id number QTitle Title eg Question1 Q The question text A The answer text R The rank or score of the question That way you add questions simply by adding records to the table. you might find the

international character string comparisons

2001-02-27 Thread William T Morgan
Hi, I'm having a problem with comparing international characters in strings in MySQL. I couldn't find any information in the manual that addresses the issue. MySQL seems to treat accented characters as equal to their non-accented counterparts. For example, the string `men' is treated as equal to

Re: RDBMS question on coding "expanding series-like fields"

2001-02-27 Thread Basil Hussain
Hi, > I have a Test Questions database. Right now I have a hard-coded limit of > 200 questions in it; I actually made a table with field names like Quest1, > Quest2. . . Quest200. However, I know that I am not using the power of > MySql in setting it up this way. This is more an example of m

Re: mysql.user puzzler

2001-02-27 Thread pollyp
Rolf Hopkins says: >If your client is really a production server, look up flush privileges in >the manual or restart the mysql server. I had been doing a flush privileges in another script later on, but for whatever reason it wasn't having the intended effect. It turns out a mysqladmin reload

build problems on NT 5

2001-02-27 Thread Cynic
Should MySQL build out of the box on NT? I tried to build 3.23.32 and 3.23.33 on NT 5, and both attempts failed on the assembler code. The custom build step for /strings/Strings.asm is as follows: masm -Mx -t -DDOS386 -DM_I386 $(InputPath),$(OutDir)\$(InputName).obj,,, I believe I have MA

Re: doubt urgent

2001-02-27 Thread Miguel Angel Solórzano
At 10:50 27/02/2001 +, gopinath rajagopal n wrote: Hi! First you need to set the privileges rights on the MySQL server for the NT machine, user and db's. Read the GRANT/REVOKE commands and How works the privileges system in the MySQL Manual. To connect you have several ways: - A telnet sessi

modification of my last question

2001-02-27 Thread WCBaker
Hi! I just realised that the question I posed moments ago was not explained fully and therefore sounds even more silly than it perhaps is. My need is to have a number of fields that can be expanded and fit the form of field[i] where "i" can be expanded as desired. So I would like to know how to

Re: mod_auth_mysql

2001-02-27 Thread Vivek Khera
> "JDZ" == Jeremy D Zawodny <[EMAIL PROTECTED]> writes: >> Does anyone know if mod_auth_mysql is still under active >> development, and if so, where can I find current information on it? JDZ> Which one? JDZ> There appear to be two. Go here and search for "mysql" JDZ> http://modules.apa

RDBMS question on coding "expanding series-like fields"

2001-02-27 Thread WCBaker
Hi! I have a Test Questions database. Right now I have a hard-coded limit of 200 questions in it; I actually made a table with field names like Quest1, Quest2. . . Quest200. However, I know that I am not using the power of MySql in setting it up this way. This is more an example of my own ig

help file

2001-02-27 Thread Alan Thum Joo Soon
Is there any help file which I can download? Or how do I setup MySQL to allow connection from a Win2k system to the Linux MySQL server? Thanks -Alan ** \\ Alan Thum Joo Soon /// *

setup problems under windows.(error 102)

2001-02-27 Thread Nice Nick
i am trying to set mysql up but i have lots of problems the last of them was: setup requires a different version of windows. Check to make sure that you are running Setup on the windows platform for wich it is intended. Error 102 i downloaded the version for win95/98/nt/2000 and my computer has

mysql max size

2001-02-27 Thread Markus H. Maussner
hi.. does annybody know the limitations of mysql ? i am planing to make a big database. with big i mean something like 1,5TB ... the hardware seems not to be the problem (we get a big RAID for that, and our sysadmin sais that our linux system can take that much hdd space (told me something of a

Re: Deleting Tables

2001-02-27 Thread wen
coter> Can someone tell me how to delete tables with MYSQL Version 3.23? I have a database named homework, with 5 tables in it. (Home1, home2, home3, etc...) I have cleared the databases, and they are empty. But when I try to run my script to repopulate Home1... I get the following... cote

Re: Deleting Tables

2001-02-27 Thread j.urban
Your script likely includes a CREATE TABLE statement that is tripping on the fact the table already exists. The table can be deleted using the DROP TABLE statement: mysql> drop table home1; You might consider adding the DROP TABLE IF EXISTS to the script as well. Please see the MySQL Manual:

Mysql dbi modules

2001-02-27 Thread daveclark
I have almost installed all of the dbi/dbm modules but can't get thru the 'make test'. I get the error msg: 't/10dsnlist.DBI->connect(database=test) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) at t/10dsnlist.t line 45' MySql is ruuning bu

Deleting Tables

2001-02-27 Thread Cote, Ronald
Good Morning, Can someone tell me how to delete tables with MYSQL Version 3.23? I have a database named homework, with 5 tables in it. (Home1, home2, home3, etc...) I have cleared the databases, and they are empty. But when I try to run my script to repopulate Home1... I get the fol

need help to set mysql up(error 105)

2001-02-27 Thread Nice Nick
Dear our mailing list friends, i am very new and i tried to install mysql to my computer(windows based ,i downloaded the software for windows ) but i failed. the error is: setup is unable to find installation languages in C:\PROGRA~1\ALZIP_HZTMP_\SETUP.LID file Error 105 i am looking for your he

Re: Error 1006

2001-02-27 Thread Gerald L. Clark
Sridhar-Yahoo wrote: > > Hello , > > I am using MySQL3.23 on linux . I am getting an error when creating a database now. > I usually dont get this error. > > This is the error: > > mysql> create database j; > ERROR 1006: Can't create database 'j'. (errno: 28) > mysql> > > Can u help me out >

Re: Question

2001-02-27 Thread Rolf Hopkins
Do you have an english OS? Should work fine, even in english. You sure those codes are right? It look like you're 2 hex numbers short! But that shouldn't matter anyway. What are you're error messages? - Original Message - From: "조충선" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <

Re: insert

2001-02-27 Thread Sinisa Milivojevic
Rolf Hopkins writes: > Firstly, Jarle, when you reply don't just reply to me but the whole list. I > may not know the answer or may not have the time to answer you. Secondly, > you should include the full conversation so that others know what's going > on. > > My meaning was that you shou

  1   2   >