Re: Speed:: mysql 3.23.35 vs mysql 3.23.33
Thanks for suggestions, just downgrading now. Alexander - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problem with chars case in naming under WIN98
Description: I started replication from UNIX_server(Distrib 3.23.33) to windows_server(3.23.35a for win95/98). When I creating a table JJJ on a master host, i see table jjj on slave instead of JJJ. And more - any created locally on slave side in upper case table appearing as lower case ... Under UNIX there is no such problem... tables JJJ and jjj are different and can exist at the same time. So, It's impossible to replicate such tables. I can't test slave on other platforms... How-To-Repeat: build replication then do CREATE TABLE JJJ(a char(1));CREATE TABLE jjj(b char(7)); on master side and do SHOW TABLES; on slave(windows platform) side. U'll see an error on slave side and slave side will stop replication process. Fix: Submitter-Id: submitter ID Originator:Grebennikov Alexander Organization: MySQL support: none Synopsis: Bug in chars case Severity: serious Priority: medium Category: mysql Class: Release: mysql-3.23.35a (win98) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql.3.23.35 under Solaris-2.6 (Sparc)
Hi, I have to run my application under Solaris-2.6 (we cannot upgrade our web server) and I need some 3.23.x functionality. I tried to compile the 3.23.35 sources but "configure" complained about the compiler. Could somebody provide me a binary version of 3.23.x (the best would be of course 35) for Solaris-2.6 Sparc? Zsolt -- Zsolt Koppany Intland GmbH www.intland.com Schulze-Delitzsch-Strasse 16 D-70565 Stuttgart Tel: +49-711-7871080 Fax: +49-711-7871017 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Complex mysql query
Hi everybody. I got a complexe question well according to me. I am working with PHP and i am making some queries to some database. here is a description of the tables. provider book video music provider_id title title title name provider_id provider_id provider_id I need to select all the title from book, video, music that matches a provider name and not a provider id. I know i can make 2 queries to do it but i am shure i can do a complexe join somewhere that would allow me only to connect once. I want to do it this one because to connect twince to a db could slow down the performance. This problem goes beyound my knowledge of MySQL a bit of help would be appreciated :-) Thanks Yann Larrive www.ProtonicDesign.Com Sorry if this is the second post i got a problem while sending it...
Converting Decimal value to Binary
Hi, WHAT DO I WANT TO DO: I want to have the binary value of a part of a decimal value. 1)I have a decimal value in column called intag : 262204 2)From this value I'am only interested in the last two bits of the HEX value of this decimal HEX value = 4003C My interest 3C part of used SQL query: substring(HEX(intag), (length(HEX(intag))-1), 2) 3)For the last two bits(3C) I like to have the binary value HEX value = 3C Binary = 00 Final SQL query: BIN(substring(HEX(intag), (length(HEX(intag))-1), 2)) PROBLEM When running the last query, the returned value is 11 instead of 00. Probably it has something to do with the fact that I requested a substring of length 2. What do I need to do to get the complete binary value? If one you SQL geniuses knows this, please let me know. Thanks in advance FS - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
keywords in CREATE TABLE?
what are the basic differences in the CREATE TABLE command for the following keywords? I checked the MySQL manual but couldnt make much sense outa it. KEY INDEX PRIMARY KEY UNIQUE plz. could anyone ellaborate more on UNIQUE AND PRIMARY KEY.? it seems that both are doing the same job?... duke. Website: http://www.ilug-bom.org.in/ Ftp site: ftp.ilug-bom.org.in Chat: irc.ilug-bom.org.in Linuxers mailing list: [EMAIL PROTECTED] http://ilug-bom.org.in/mailman/listinfo/linuxers Get free email and a permanent address at http://www.netaddress.com/?N=1 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re:pulling audio out of a blob and playing it. = just a question about performance
Hi Just a question. What about performance when storing audio files in a blob. What effect does it have on the database(load, space requirements compared to audio files,...) I will be confronted with this question in the near future where I will have to decide to store on disk or in blob. I you have some statistics, can you provide them? Thanks in advance. FS - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql database - dsn
Dear Sir, Re:MySQL Database - DSN How to create a DSN for MYSQL DATABSE on online LINUX server. Pl provide me the syntax. And also I need the syntax for FOREIGN KEY with references to access two tables in MYSQL. for eg. (A) Table name : Parent (column name is PARTY varchar(10) primary key); (B) Table Name : Child (column name is PARTY varchar(10) references parent(party)); its showing an error : the above command is working in MS-SQL SERVER 7.0 / Oracle 8 Kindly send the SYNTAX for the above. I fervently hope that the next ring of my mail will be of yours. Thanks and regards. truly yours Palaniappan. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mySQL Gui problem
To Whom It May Concern: I have set up a mySQL server on a Windows NT Server and use the mySQL Gui client on a Window 98 workstation to connect to the server. But the client reports that Access is denied for user [EMAIL PROTECTED] (my workstations DNS on the network). I am using the right password. Is there something I'm doing wrong? Hope you can help Neil Craig Technical Support Consultant QEDI (Pty) Ltd Tel: (011) 266 6947 Fax: (011) 266 5080 Cell: 083 601 4686 E-mail: [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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
help on mysql tables
Dear Sir, I have created the following table: create table test(name varchar(10) NOT NULL); query is ok I HAVE TRIED THE FOLLOWING QUERY : insert into test values(""); MYSQL COMMAND IS ACCEPTING THE ABOVE QUERY WHICH VIOLATES NOT NULL CONSTRAINTS. PLEASE CHECK THE ABOVE QUERY KINDLY INFORM ME THE CORRECT SYNTAX SIR. THANKS AND REGARDS. Palaniappan. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
problem with devel 3.23.35
Hello. I have installed the source of RPM 3.23.35 (Mysql,client and devel) without problems. But when I execute a makefile of a easy program this error appears: /usr/lib/mysql/libmysqlclient.a(my_compress.o): In function `my_uncompress': my_compress.o(.text+0x97): undefined reference to `uncompress' /usr/lib/mysql/libmysqlclient.a(my_compress.o): In function `my_compress_alloc': my_compress.o(.text+0x12b): undefined reference to `compress' collect2: ld returned 1 exit status make: *** [prueba] Error 1 The same program and makefile executed with devel 3.22.25 (my old version of mysql) woks fine. Thanks for your help. Iaki de Miguel (Serconsur)
Re: ADO problem with MYSQL datetime column
- Original Message - From: "Samantha Savvakis" [EMAIL PROTECTED] To: "MySQL" [EMAIL PROTECTED] Sent: Tuesday, March 27, 2001 12:39 AM Subject: ADO problem with MYSQL datetime column I have a table that I'm querying that has 'datetime' columns. If these columns are null or 0 - "-00-00 00:00:00", I have problems reading from the ADO recordset. What kind of problems are you having specifically? If you already have your data in an ADO recordset, then it is fairly simple to "massage" the data in any way you want. Have you checked the field with IsEmpty or IsNull? Using a conditional statement to check for null or empty values should prevent these dates from passing through to your script. I was wondering if this is an ADO issue with the MYSQL column type of datetime, or perhaps an issue with the MyODBC driver and ADO ? If the data is already in the recordset, and the values for the other fields are correct, then I don't think that it would be an ODBC error. It might just be a matter of using some further code to verify the data before you use it in the rest of your scripts. Good luck, Dennis **' Beridney Computer Services [EMAIL PROTECTED] http://www.beridney.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQLGUI: where is the code for wString::Initialize() ?
Hubert Feyrer writes: Well, subject says it pretty much all - I'm trying to build mysqlgui 1.7.4 on NetBSD 1.5/i386, and get linker warnings: single.o: In function `EditorEngine::LoadSQL(char const *)': /usr/cvs/pkgsrc/databases/mysqlgui.work/work.i386/mysqlgui-1.7.4/FL/wstrings.h:23: undefined reference to `wString::Initialize(char const *, long)' single.o: In function `EditorEngine::LoadSQL(char const *)': /usr/cvs/pkgsrc/databases/mysqlgui.work/work.i386/mysqlgui-1.7.4/single.cc:27: undefined reference to `wString::~wString(void)' ... looking in FL/wstrings.h, I wonder where the actual code for wString::Initialize() is. There is the prototype in the class definition, but where is the code? FWIW, I have the following packages installed: fltk-1.0.10, flvw-2224, mysql-client-3.23.35, mysql-server-3.23.35, mysql++-1.7.8. (Did I miss something?) - Hubert -- Hubert Feyrer [EMAIL PROTECTED] HI! First of all, good luck with building on NetBSD. You also need fl_editor package. You will find a link on mysqlgui page. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
question ...
Hi, i have a big problem ... why this doesnt work?: INSERT INTO mytable (login, heslo) VALUES ('login', Password('heslo')); SELECT * FROM mytable WHERE login='login' AND heslo=Password('heslo'); the second line gives me no result ... i have spent a lot of time looking at that, but i cant find, where the problem is, but the password function ... i have read all the documentation around it, but i have no idea, whats wrong ... if you can help me, please tell me, whats wrong ... thanx a lot, jsimlo ;) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How do i put integrity constraints?
How do i put in an integrity constraint? ie. say i have 2 tables Person (PersonID[pk], PersonName) School (SchoolID[pk], SchoolName, PersonID[fk]) as you can see PersonID is the foreign key in School. So how do keep update and delete restricted constraints etc,? could anyone tell me the SQL code for bot the tables? duke. Sir, look up REFERENCES in the documentation. But the documentation points out that this is for compatibility with other DBMSs, and doesn't actually do anything. MySQL doesn't enforce integrity constraints on foreign keys. Bob Hall Know thyself? Absurd direction! Bubbles bear no introspection. -Khushhal Khan Khatak - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re:pulling audio out of a blob and playing it. = just a questionabout performance
(I think) most people figure that the disadvantages of having images and most other binary files stored within the DBMS far outweigh any advantages. From the top of my head... Advantages -- - tidiness - ease of backup - all data is in one respository. Disadvantages - - DB is bigger, therefore repairs/checks/etc take longer (?) - for website apps, you can have your binary files (eg images/wavs) stored under the web heirarchy, meaning that a mysql application is not required to retrieve the file from disk. I'm sure there's more...I'm a bit short of time at the moment! P On Tue, 27 Mar 2001, Filip Sergeys wrote: Hi Just a question. What about performance when storing audio files in a blob. What effect does it have on the database(load, space requirements compared to audio files,...) I will be confronted with this question in the near future where I will have to decide to store on disk or in blob. I you have some statistics, can you provide them? Thanks in advance. FS - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: help on mysql tables
Sir, please tell me how to stop mysql from accepting empty string values. it accepts empty string values even when i enclosed in single quotes. pl inform me with the syntax. rgds palani From: "Dennis Salguero" [EMAIL PROTECTED] To: "Ramasamy Palaniappan" [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: help on mysql tables Date: Tue, 27 Mar 2001 07:08:29 -0500 - Original Message - From: "Ramasamy Palaniappan" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, March 27, 2001 6:53 AM Subject: help on mysql tables I have created the following table: create table test(name varchar(10) NOT NULL); query is ok Yes, but notice that you put a constraint of NOT NULL on the field. This means that there has to be a value in this field, in every record. I HAVE TRIED THE FOLLOWING QUERY : insert into test values(""); MYSQL COMMAND IS ACCEPTING THE ABOVE QUERY WHICH VIOLATES NOT NULL CONSTRAINTS. First problem is that you should specify a table field after the table name and you should specify a corresponding piece of data in the VALUES portion of your statement. Next, you need to make sure that the data you enter is NOT blank since the field has a NOT NULL constraint. Finally, you should encase your data in single quotation marks, not double quotation marks. Therefore, change your statement to: INSERT INTO test(name) VALUES('something'); If your table has only one field, you can also use the statement below: INSERT INTO test VALUES('something'); Good luck, Dennis **' Beridney Computer Services [EMAIL PROTECTED] P: 703-566-3196 http://www.beridney.com _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Converting access to mysql
Hello all. I was wondering if anyone could help me out with a little project I have to do. I have a win98 machine with a access database. I would like to transfer everything into mysql on a red hat 7 linux box. How would I do this? Plus how would I be able to connect once it transfer to mysql threw a any windows machine. If anyone know were I could find a HOWTO or a site that show me. Thank you Luis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: to upper case function
http://www.mysql.com/doc/S/t/String_functions.html UCASE(str) UPPER(str) Returns the string str with all characters changed to uppercase according to the current character set mapping (the default is ISO-8859-1 Latin1): mysql select UCASE('Hej'); - 'HEJ' This function is multi-byte safe. Cal http://www.calevans.com -Original Message- From: Zhu George-CZZ010 [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 27, 2001 11:22 AM To: [EMAIL PROTECTED] Subject: to upper case function There's a function in SQL to convert strings to upper case (sounds like to_upper()? ), I don't have the reference book at hand, does anyone know the syntax or that function? Thank you very much in advance. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Documents Spesifications Does Not Match
Tha instructions on mysql web pages , downloaded documents and relelased product versions are not the same for Windows. I still could not understand did 3.23.35a or 3.23.36 support bdb on windows and if supports how can i implement this. Regards. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Another Localtion for databases
Hi Folks!! I have a question, How may set another location for my productions db, so, for instance if i want put my db in /mydb filesystem in my Linux Redhat??? because when i create a db, this is in /var/lib/mysql/data Please , help me Thanks !! Pablo - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: tinyint issue
At 7:49 PM +0200 3/27/01, Dacian Herbei wrote: Hi, I wonder if anyone had a problem like this one. I have created a table with one field autoincrement. The field is tinyint(4). whenever I try to introduce more then 127 records it refuses to introduce them. I tried with tinyint(5) 6.. and so on. It works only with integer. dacian What you're trying to do is impossible. TINYINT takes one byte, and has a range of -128 to 127. There's no way to get a larger value unless you do one of the following: - Declare your column to be UNSIGNED. That changes the range to 0-255, but will only extend your range by 128 values. - Declare your column using a larger integer type. -- Paul DuBois, [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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: tinyint issue
In the last episode (Mar 27), Dacian Herbei said: I wonder if anyone had a problem like this one. I have created a table with one field autoincrement. The field is tinyint(4). whenever I try to introduce more then 127 records it refuses to introduce them. I tried with tinyint(5) 6.. and so on. It works only with integer. dacian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) From the manual: `TINYINT[(M)] [UNSIGNED] [ZEROFILL]' A very small integer. The signed range is `-128' to `127'. The unsigned range is `0' to `255'. -- Dan Nelson [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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Another Localtion for databases
At 12:56 PM -0500 3/27/01, Marglobal - Pablo Salazar (Jefe de Sistemas) wrote: Hi Folks!! I have a question, How may set another location for my productions db, so, for instance if i want put my db in /mydb filesystem in my Linux Redhat??? because when i create a db, this is in /var/lib/mysql/data The quick and dirty way could be to copy everything in /var/lib/mysql/data to /mydb, then remove /var/lib/mysql/data and make it a symlink to /mydb. Please , help me Thanks !! Pablo -- Paul DuBois, [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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: mySQL INSTR function problem
3.23.35-log reports it correctly. Cal http://www.calevans.com -Original Message- From: Gordon Werner [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 27, 2001 12:01 PM To: [EMAIL PROTECTED] Subject: mySQL INSTR function problem Hi there ... I am running mySQL Ver. 9.33 Distrib. 3.22.25 and I have run into the following problem. When I type: mysql select INSTR('foobarbar', 'bar'); it outputs +---+ | INSTR('foobarbar', 'bar') | +---+ | 7 | +---+ Shouldn't the output be 4? If it should be 4, does any one know why it is returning 7? Thanks in advance Gordon Werner _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Gordon Karel Werner - [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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: tinyint issue
On 3/27/01 10:08 AM, "Cal Evans" [EMAIL PROTECTED] wrote: yep. That's the point of a tinyint, it only holds numbers 0-127. if you need more then try smallint, int or bigint. (and please read the manual regarding data types. It's clearly explained there.) Cal http://www.calevans.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Dacian Herbei Sent: Tuesday, March 27, 2001 11:50 AM To: [EMAIL PROTECTED] Subject: tinyint issue Hi, I wonder if anyone had a problem like this one. I have created a table with one field autoincrement. The field is tinyint(4). whenever I try to introduce more then 127 records it refuses to introduce them. I tried with tinyint(5) 6.. and so on. It works only with integer. dacian If you aren't putting more than 256 items into the table, then you could define the column as tinyint unsigned. Stating tinyint(4) only indicates a maximum display width of 4 characters. It does nothing for the stroed value size. Tinyint will only ever be 1 byte in size, with a possible 256 values (0-255). Use unsigned if all your values are going to be positive. Somehow though, I think you would be better off with: column smallint unsigned auto_increment, for your column def. (0-65535) for a smaller database. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
[NEWBIE] safe_mysqld
When I attempt to launch mysql server with command safe_mysqld, the console return this: "starting mysqld daemon with databases from /var/lib/mysql" "010327 19:33:37 mysqld ended" I use RedHat 7.0 Linux on Intel -- Stphane Pinel 39, Rue du Docteur Heulin 75017 Paris (FRANCE) 33 1 53 11 05 77 33 6 08 94 63 16 [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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: NT installation
Doesn't MySQL on NT support networking? You should be able to install the mysql client on the workstation and give it the IP address, port number and database name on the server to connect. You don't have to install telnet. I don't use NT, so if there really is some reason MySQL on NT won't work through a TCP port, I would love to know (and add it to the list of reasons I run my dbs on linux or BSD) ;) On 3/27/01 8:57 AM, "Chad Nielsen" [EMAIL PROTECTED] wrote: Hi, I'm trying to install mySQL on NT Server 4.0 I guess I need to install a Telnet Server so I can manage mySQL from a workstation. What's a good Cheap or Free Telnet Server for NT? Also, any instructions on how to set this up would be great. Thanks, Chad Chad M. Nielsen, GIS Programmer/Analyst Tillamook County Performance Partnership (TCPP) Tillamook Coastal Watershed Resource Center (TCWRC) GIS: http://gisweb.co.tillamook.or.us TCPP: http://www.co.tillamook.or.us/countygovernment/Estuary/homepage.htm TCWRC: http://www.tcwrc.org - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Mysql in a 4-way / 2 GByte server / raid 5
-Original Message- From: Rafael Martinez [mailto:[EMAIL PROTECTED]] Sent: martes, 27 de marzo de 2001 15:28 To: [EMAIL PROTECTED] Subject: Mysql in a 4-way / 2 GByte server / raid 5 Hello I am thinking to install our DB server in a 4-way machine with Intel Xeon processors/1MB cache. I can see in the mysql documentation that mysql works OK in a 2-way machine but that in a 4-way system has to be tested. Is this true? Or the documentation is not updated? Anybody out there with a 4-way machine that runs mysql without problems? (kernel 2.4.x glibc 2.2.12) Our DB has around 120.000.000 "questions" per week and our 2-way/1Gb system works OK, but the trafic is growing very fast and I would like to have a backup plan incase I need it. Thanks for your help. Rafael Martinez I've had MySQL running on a 12 CPU 16 GB machine running Tru64. Runs OK. I normally run it on a 4 CPU 4 GB machine and another one with 3 CPUs and only 512 MB. Both Tru64 Alpha. In recent (3.23) versions there are some my.cnf parameters related to SMP machines. You might want to take a look at them : set-variable= thread_cache=8 set-variable= thread_concurrency=8 # Try number of CPU's*2 The only problem I have is that there appears to be a problem with memory allocation when running MySQL on Tru64. I haven't found out exactly what the problem is, but the result is a crashed MySQL with a "Out of memory" error. Which is rather misleading since there is plenty of free memory and no ulimit or any other limiting kernel parameters. l8r/Jspr - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: How to index this properly (to make it go faster) ?
-Original Message- From: Benjamin Pflugmann [mailto:[EMAIL PROTECTED]] Sent: martes, 27 de marzo de 2001 10:00 To: Nemholt, Jesper Frank Cc: '[EMAIL PROTECTED]' Subject: Re: How to index this properly (to make it go faster) ? [clip] Why that, usertime systemtime are data values, they are never used in any where clause. As far as I can see it's complete waste to put index on those. If all columns of the SELECT clause are part of the index, MySQL will solve the query only with reading from the index file and never touch the data file itself. Since the index is quite big already and usertime+systemtime only add 8 bytes per row, this may pay off regarding the speed win / size increase. Aha. I'll think about that, but I'll have to look in the logfiles to see if there's a pattern regarding what the users select. I don't think it's just usertime systemtime every time. [clip] Depending on the Cardinality of the different columns you may want to change the order to (username,processname,system_id,timecode) or alike. Aha, I'll have to test more with the individual order of combined indexes to see what I can get from it. Well, normally that is not really important, but in your case, processname has a low cardinality and therefore one value has a lot of matches in the index and it is worth a try to put it to the right. So the lower the cardinality the more to the right in a combined index ? [clip] May I bother you to add the following indexes and post the EXPLAIN after adding them:. (system_id, processname, timecode) (system_id, processname, timecode, username) (system_id, processname, timecode, username, usertime, systemtime) I'll try. Tonight I'm going for system_id, processname, timecode I will probably make the next tests on the disk table, since recreating indexes and analyzing/optimizing on the process table takes too many hours. The disk table only takes 20 minutes. Every explain ends up saying "where used" and the showing the full number of rows. This is in 3.22.32. My test setup is the latest, it might be different there. Well, using two different systems isn't a good idea, except if you plan to upgrade your 3.22.32 system, because if we find a solution on your test setup (3.23.?), it won't behave the same on the older MySQL. In most cases, 3.23 is faster than 3.22 (which is to be expected). I plan to upgrade asap, but had a few problems building the latest stable under 4.0f ev56. On a side note, with 3.22.32 I have some weird memory allocation problems. The database runs on a 4 CPU machine with 4 GB memory, and most of these 4 GB are free (or rather used for filesystem cache by the OS). The memory is free if any process want it. With the default settings (ie. no custom my.cnf) everything runs fine, but MySQL use allmost no memory which is not optimal given the size of the database indexes. If I instead use the my-huge.cnf that comes with MySQL which makes a key buffer of 384 MB, a big select makes MySQL crash with a "Out of memory" error. I have ulimit set to unlimited, and no memory allocation errors are logged to /var/adm/messages (Tru64 allways logs to that file if some user hit the limit of some sysconfigtab/kernel parameter). This means that the "Out of memory" error from MySQL was not caused but the OS disallowing mysqld to allocate more memory. I have tried this several times to be sure it's reproduceable. I get a crash every time. Is there a memory allocation bug in MySQL on Tru64 ? Anothing thing: If you cannot get it work with combined indexes, can you post some testcase (i.e. the SQL commands to build a sample database), so that we can play around and see if we have more luck? Sure. Everything will in fact be put on a web page soon, since it's a OpenSource solution. The database is used to store performance info for Tru64, Solaris Linux (and others soon). A bit like MRTG/RDDTool/Cricket but much more dynamic detailed. l8r/Jspr - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
another way to install mysql ?
Is it the only way to get mysql to work on d: is to install on c: then move to d: ? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Mysql makes connection to mysql.com WASSUP?
Hi, I entered netstat and saw among other conections this one: tcp4 0 0 deepthroat.3179 web.mysql.com.auth TIME_WAIT Deepthroat is my bsd machine. it's a pure webserver. Why is my machine making a connection to mysql.com?(and why auth) Mysql is not bound to a tcp socket.. (skip-networking). Thanks in advance, pdw - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Complexe query ....
But could i use something like a subselect ... I know they are not supported by mysql but i see in my book that there is a substitute for it. Also i am not to familiar with LEFT JOIN ... and all those ... can you give me explanation ? So really would it make what would be the real answer to my problem , make 2 databse query, make a LEFT OUTER JOIN or the substitute for subselect withch i have noclue of... ? To make 2 queries seems more simple i would record the result from the first one in a varaible then use the variable in the other query. But this is not really optimised this way. Thanks Yann - Original Message - From: "Cal Evans" [EMAIL PROTECTED] To: "Ren Tegel" [EMAIL PROTECTED]; "Amazing-Books.Com" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, March 27, 2001 10:53 AM Subject: RE: Complexe query Wouldn't using LEFT OUTER JOINs in your query work instead of just a where clause? It still wouldn't give the optimum response but it would probably give a usable one. Unfortunately, I don't see a way to do what the user really wants to do in MySQL. In MySQL, the UNION clause does not mean what it means in other implementations of SQL. In M$ SQL you could use the UNION to aggregate 3 different select's into a single result set, thus giving him 1 result set with all books, movies and music from a single provider. I usually add a field at the end of each SELECT that contains a constant representing the source for that record. Cal http://www.calevans.com -Original Message- From: Ren Tegel [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 27, 2001 9:43 AM To: Ren Tegel; Amazing-Books.Com; [EMAIL PROTECTED] Subject: Re: Complexe query excuse me, this just wouldn't work. and excuse last unfinished message. if one on of the tables matches none, the query will return no match, which is maybe not what you want. else it'll return all data matched against each other, which is again not likely what you want (since you get multiple results for each table). guess you'll have to query each of the music, video and book tables seperate to return sensefull results (read: presentable results). only circumstance when this give nice results is when each book/video/music table contains exactly one match. sorry for too rapid answering... regards, rene - Original Message - From: "Ren Tegel" [EMAIL PROTECTED] To: "Amazing-Books.Com" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, March 27, 2001 5:16 PM Subject: Re: Complexe query select book.title, video.title, music.title from provider, book, video, music where provider.name='providername' and book.provider_id=provider.provider_id and video.provider_id=provider.provider_id and music.provider_id=provider.provider_id; - Original Message - From: "Amazing-Books.Com" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, March 27, 2001 10:39 AM Subject: Complexe query Hi everybody. I got a complexe question well according to me. I am working with PHP and i am making some queries to some database. here is a description of the tables. provider book video music provider_id title title title name provider_id provider_id provider_id I need to select all the title from book, video, music that matches a provider name and not a provider id. I know i can make 2 queries to do it but i am shure i can do a complexe join somewhere that would allow me only to connect once. I want to do it this one because to connect twince to a db could slow down the performance. This problem goes beyound my knowledge of MySQL a bit of help would be appreciated :-) Thanks Yann Larrive www.ProtonicDesign.Com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mySQL for Sun Intel
Go back to version 3.22. It works very well. The most current vertion hasn't been ported yet. Brady... Original Message Follows From: "Esteban Cazarez" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: mySQL for Sun Intel Date: Mon, 26 Mar 2001 18:16:00 -0800 Has anyone found the lastest mySQL for SUN SOLARIS 7 Intel version? I know there's a SPARC binary for 3.23 but what about an Intel binary? Technology Consultant 310-426-5619 (h) / 888-431-7571 (p) http://www.access1.net/esteban1 _ Get your FREE download of MSN Explorer at http://explorer.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mySQL odbc driver for the mac
Hi All, Does any one know where I can find one? Thanks. Yours cheerfully, Andrew bush http://www.bushpro.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: NT installation
Hi Chad You do not need a Telnet client. Just install Myodbc and the mysql client. To connect to your server, type "mysql -h yourhostname -u userID" If you defined a password for the userID, add -p at the end of the line. The system will prompt you for the password. See manual for more options. You can also install a web server (PWS or Infradig) and the PHP scripting langage on your local machine, and run PHPmyAdmin. Take care to protect your local machine for intrusions. Hope this helps you, Jean-Claude , or install - Original Message - From: "Chad Nielsen" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, March 27, 2001 6:57 PM Subject: NT installation Hi, I'm trying to install mySQL on NT Server 4.0 I guess I need to install a Telnet Server so I can manage mySQL from a workstation. What's a good Cheap or Free Telnet Server for NT? Also, any instructions on how to set this up would be great. Thanks, Chad Chad M. Nielsen, GIS Programmer/Analyst Tillamook County Performance Partnership (TCPP) Tillamook Coastal Watershed Resource Center (TCWRC) GIS: http://gisweb.co.tillamook.or.us TCPP: http://www.co.tillamook.or.us/countygovernment/Estuary/homepage.htm TCWRC: http://www.tcwrc.org - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: help on MySQL tables
Hi Rick, You absolutely right, you are not required to specify field names in an Insert. But it's a good idea to do so. 1) It makes you code more readable for those following you. 2) If your table ever changes structure, your Insert will still work. (Assuming you didn't remove one or more of the fields you are inserting into.) Cal http://www.calevans.com -Original Message- From: Rick Emery [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 27, 2001 1:25 PM To: [EMAIL PROTECTED] Subject: RE: help on mysql tables You DO NOT need to specify table field names when INSERTing records. For instance, if the table were defined thus: CREATE TABLE mytable ( valueA varchar(10) NOT NULL, valueB varchar(25), valueC varchar(30) ); This statement will insert one record: INSERT INTO mytable VALUES("some text", "more text", "last text"); To insert multiple records, go with: INSERT INTO mytable VALUES("some text", "more text", "last text"),("record 2","text for 2","last text in 2"); - Original Message - From: "Ramasamy Palaniappan" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, March 27, 2001 6:53 AM Subject: help on mysql tables I have created the following table: create table test(name varchar(10) NOT NULL); query is ok Yes, but notice that you put a constraint of NOT NULL on the field. This means that there has to be a value in this field, in every record. I HAVE TRIED THE FOLLOWING QUERY : insert into test values(""); MYSQL COMMAND IS ACCEPTING THE ABOVE QUERY WHICH VIOLATES NOT NULL CONSTRAINTS. First problem is that you should specify a table field after the table name and you should specify a corresponding piece of data in the VALUES portion of your statement. Next, you need to make sure that the data you enter is NOT blank since the field has a NOT NULL constraint. Finally, you should encase your data in single quotation marks, not double quotation marks. Therefore, change your statement to: INSERT INTO test(name) VALUES('something'); If your table has only one field, you can also use the statement below: INSERT INTO test VALUES('something'); Good luck, Dennis **' Beridney Computer Services [EMAIL PROTECTED] P: 703-566-3196 http://www.beridney.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mySQL for Sun Intel
Esteban Cazarez wrote: Has anyone found the lastest mySQL for SUN SOLARIS 7 Intel version? I know there's a SPARC binary for 3.23 but what about an Intel binary? I was able to compile it fine on Solaris x86 2.6. -- Josh _ Joshua Chamas Chamas Enterprises Inc. NodeWorks free web link monitoring Huntington Beach, CA USA http://www.nodeworks.com1-714-625-4051 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mySQL for Sun Intel
On Tue, Mar 27, 2001 at 01:45:16PM -0600, Brady Orand wrote: Go back to version 3.22. It works very well. The most current vertion hasn't been ported yet. I could build a Solaris Intel 2.6 binary if needed. It'll probably work on Solaris 7. Lemme know if there is interest... Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: NT installation
Thanks Jean - Claude, NT Workstation comes with a built-in client. but from what I can tell, NT Server does not come with a built-in Telnet Server. The NT book I have says : "The Telnet program requires TCP/IP on both the client and server, and requires an account set up on the server being contacted. Microsoft NT doesn't provide the server process, but it does provide the client interface. " Am i interpreting this correctly? If so, does mySQL provide the Telnet Server process? Thanks again, Chad -Original Message- From: jcmaes [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 27, 2001 11:47 AM To: Chad Nielsen Cc: [EMAIL PROTECTED] Subject: Re: NT installation Hi Chad You do not need a Telnet client. Just install Myodbc and the mysql client. To connect to your server, type "mysql -h yourhostname -u userID" If you defined a password for the userID, add -p at the end of the line. The system will prompt you for the password. See manual for more options. You can also install a web server (PWS or Infradig) and the PHP scripting langage on your local machine, and run PHPmyAdmin. Take care to protect your local machine for intrusions. Hope this helps you, Jean-Claude , or install - Original Message - From: "Chad Nielsen" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, March 27, 2001 6:57 PM Subject: NT installation Hi, I'm trying to install mySQL on NT Server 4.0 I guess I need to install a Telnet Server so I can manage mySQL from a workstation. What's a good Cheap or Free Telnet Server for NT? Also, any instructions on how to set this up would be great. Thanks, Chad Chad M. Nielsen, GIS Programmer/Analyst Tillamook County Performance Partnership (TCPP) Tillamook Coastal Watershed Resource Center (TCWRC) GIS: http://gisweb.co.tillamook.or.us TCPP: http://www.co.tillamook.or.us/countygovernment/Estuary/homepage.htm TCWRC: http://www.tcwrc.org - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: NT installation
You do not need telnet to access a mysql server - mysql has it's own client-server protocol, accessible via the means described by Jean-Claude. regards, P On Tue, 27 Mar 2001, Chad Nielsen wrote: Thanks Jean - Claude, NT Workstation comes with a built-in client. but from what I can tell, NT Server does not come with a built-in Telnet Server. The NT book I have says : "The Telnet program requires TCP/IP on both the client and server, and requires an account set up on the server being contacted. Microsoft NT doesn't provide the server process, but it does provide the client interface. " Am i interpreting this correctly? If so, does mySQL provide the Telnet Server process? Thanks again, Chad -Original Message- From: jcmaes [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 27, 2001 11:47 AM To: Chad Nielsen Cc: [EMAIL PROTECTED] Subject: Re: NT installation Hi Chad You do not need a Telnet client. Just install Myodbc and the mysql client. To connect to your server, type "mysql -h yourhostname -u userID" If you defined a password for the userID, add -p at the end of the line. The system will prompt you for the password. See manual for more options. You can also install a web server (PWS or Infradig) and the PHP scripting langage on your local machine, and run PHPmyAdmin. Take care to protect your local machine for intrusions. Hope this helps you, Jean-Claude , or install - Original Message - From: "Chad Nielsen" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, March 27, 2001 6:57 PM Subject: NT installation Hi, I'm trying to install mySQL on NT Server 4.0 I guess I need to install a Telnet Server so I can manage mySQL from a workstation. What's a good Cheap or Free Telnet Server for NT? Also, any instructions on how to set this up would be great. Thanks, Chad Chad M. Nielsen, GIS Programmer/Analyst Tillamook County Performance Partnership (TCPP) Tillamook Coastal Watershed Resource Center (TCWRC) GIS: http://gisweb.co.tillamook.or.us TCPP: http://www.co.tillamook.or.us/countygovernment/Estuary/homepage.htm TCWRC: http://www.tcwrc.org - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL vs MS-SQL performance
Hey guys, Most of the accounts I have read about MySQL was that it was one of the fastest databases around. Now, for development purposes I created a FreeBSD system with JUST MySQL (no other major processes). Then I created a separate Windows 2000 ASP server to server as our development server for our new site. The two servers communicated via ODBC. Anyways, a period of time elapsed and we decided to move to MS-SQL server for feature reasons, and when we had the MS-SQL ODBC driver point to the newly created MS-SQL server (roughly same specs), it was like 50% faster! What gives? Is MySQL *really* that slow, MS-SQL *really* that fast, or maybe there was some weird setting in the ODBC driver or the MySQL server that I didn't switch right which made it go slow. I am not sure. Or maybe Microsoft, in their monopolistic ways, created special hooks between ASP and MS-SQL server to make the communication go somehow faster. Anyone had similar experiences to mine? - Steve
mysql setup questions
I have a problem getting the mysql started. I am running slackware linux version 7.xx. Apparently mysql is installed. I downloaded the linux binary package of mysql and installed it. the mysql is installed in /usr/local/mysql. The problem is that mysql ** immediately ends **. Here is one of the ways I try to start MSQL. ** export MYSQL_UNIX_PORT=/tmp/mysql.sock export MYSQL_TCP_PORT=3307 export MYSQL_UNIX_PORT MYSQL_TCP_PORT /usr/local/mysql/scripts/mysql_install_db ** I get the following response: Installing all prepared tables To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is done with: ./bin/mysqladmin -u root -p password 'new-password' ./bin/mysqladmin -u root -h netwall -p password 'new-password' See the manual for more instructions. NOTE: If you are upgrading from a MySQL = 3.22.10 you should run the ./bin/mysql_fix_privilege_tables. Otherwise you will not be able to use the new GRANT command! You can start the MySQL daemon with: cd . ; ./bin/safe_mysqld You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory: cd sql-bench ; run-all-tests Please report any problems with the ./bin/mysqlbug script! The latest information about MySQL is available on the web at http://www.mysql.com Support MySQL by buying support/licenses at https://order.mysql.com # Starting mysqld daemon with database # Starting mysqld daemon with databases from /usr/local/mysql/data 010327 00:16:22 mysqld ended *** Question 1 ** ** cant some tell me why did it end ? what did it not like ? ** What is the problem that causes it to terminate. Could it be because safe_mysqld is alread running? When I do a `ps ` I see many mysqld procs. running. But I cannot start the interactive mysql session anyhow... *** Question 2 ** I try to set a password and I get the following message: # ./bin/mysqladmin -u root -p YES mypassword Enter password: ./bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (11 1)' Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists! ** question 3 ** Why does the start of mysqld fail ? # ./bin/mysqld [1] 6867 010327 0:18:17 Can't start server: Bind on TCP/IP port: Address already in use 010327 0:18:17 Do you already have another mysqld server running on port: 3306 ?# 010327 0:18:17 Aborting [1] + Done (1) ./bin/mysqld EVEN THOUGH I GET A MESSAGE THAT SAYS MYSQL ENDED A CHECK OF THE PROCESSES SHOWS I HAVE MYSQLD RUNNING. I EVEN HAVE safe_mysqld RUNNING. # ps -aux|grep mysqld root 3671 0.0 0.0 17880 pts/2SW Mar26 0:00 [safe_mysqld] root 3709 0.0 0.0 18572 32 pts/2SMar26 0:00 [mysqld] root 3711 0.0 0.0 18572 32 pts/2SMar26 0:00 [mysqld] root 3712 0.0 0.0 18572 32 pts/2SMar26 0:00 [mysqld] root 6869 0.0 0.7 1316 468 pts/2R00:18 0:00 grep mysqld yet I cannot connect to the mysqld anywhere # mysql ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) ** question summary ** HOW CAN I START MYSQL. HOW CAN I TELL IT WHAT PASSWORD TO USE ? HOW DO I CREATE THE SOCKET IT CANNOT CONNECT THROUGH ? It says : To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system. WHAT MIGHT THE RIGHT LOCATION BE FOR SLACKWARE LINUX VERSION 7.XX ? Any help will be much appreciated. /// than / - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL vs MS-SQL performance
On Tue, Mar 27, 2001 at 02:12:36PM -0800, Steve Quezadas wrote: Anyways, a period of time elapsed and we decided to move to MS-SQL server for feature reasons, and when we had the MS-SQL ODBC driver point to the newly created MS-SQL server (roughly same specs), it was like 50% faster! What gives? Is MySQL *really* that slow, MS-SQL *really* that fast, or maybe there was some weird setting in the ODBC driver or the MySQL server that I didn't switch right which made it go slow. I am not sure. Or maybe Microsoft, in their monopolistic ways, created special hooks between ASP and MS-SQL server to make the communication go somehow faster. Anyone had similar experiences to mine? Odds are that you didn't tune MySQL at all. Unlike most commercial database servers, MySQL "out of the box" isn't tuned for heavy usage. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How to index this properly (to make it go faster) ?
Hi. On Tue, Mar 27, 2001 at 08:22:39PM +0100, [EMAIL PROTECTED] wrote: -Original Message- From: Benjamin Pflugmann [mailto:[EMAIL PROTECTED]] [...] Aha, I'll have to test more with the individual order of combined indexes to see what I can get from it. Well, normally that is not really important, but in your case, processname has a low cardinality and therefore one value has a lot of I think I mixed it up and actually you said that username has only few different values. matches in the index and it is worth a try to put it to the right. So the lower the cardinality the more to the right in a combined index ? Yes, I think so. But let me emphasize it again: Usually you need not to care about this, but only if the ratio of Cardinality / amount of rows is magnitudes lower than for other columns (and it sounded as this is the case for username). On the other hand, I only happened to come across this twice (I mean, that changing the order of combined index resulted in an speed increase), and I don't know too much about the internals of the trees used in the MySQL indexes, so take this with a grain of salt. I think, it is of interest, what the Cardinality of the sub key is, i.e. if you only have 20 different usernames, but system_id splits them up (i.e. only 20 entries for each system_id), of course, you don't need to think about. But you it probably works with 20 different usernames, which each 'contain' 1 system_id's. Then it's better to start with the system_id, I think. Someone may want to correct me, if I am mistaken. Just try if it helps, and if not, ignore my suggestion. [...] I'll try. Tonight I'm going for system_id, processname, timecode I will probably make the next tests on the disk table, since recreating indexes and analyzing/optimizing on the process table takes too many hours. The disk table only takes 20 minutes. Good idea. [...] On a side note, with 3.22.32 I have some weird memory allocation problems. [some Tru64 stuff deleted] Sorry, but I cannot help with that, someone else hopefully can answer this. Bye, Benjamin. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysqlbinlog
I've looked through the manual and about 9000 posts from multiple mailing lists.. Is there a way to have mysqlbinlog take a log file and dump just the sql statements to a file? Am I using the wrong program to do that? Any help would be most appreciated. Mat
Re: [NEWBIE] safe_mysqld
on 27/03/01 21:42, Rick Emery at [EMAIL PROTECTED] wrote: I had the same problem. Ensure that /var, /var/lib, and /var/lib/mysql have their permissions set to: drwxr-xr-x /var/lib/mysql hasn't these permissions but now, it's OK. But I still have the same answer: "starting mysqld daemon with databases from /var/lib/mysql" "010327 23:11:20 mysqld ended" I saw that even the owner of /var /var/lib is 'root', the owner of /var/lib/mysql is 'mysql'. Is it right ? Thanks for your help. Stephane -Original Message- From: Stephane Pinel [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 27, 2001 12:58 PM To: [EMAIL PROTECTED] Subject: [NEWBIE] safe_mysqld When I attempt to launch mysql server with command safe_mysqld, the console return this: "starting mysqld daemon with databases from /var/lib/mysql" "010327 19:33:37 mysqld ended" I use RedHat 7.0 Linux on Intel -- Stphane Pinel 39, Rue du Docteur Heulin 75017 Paris (FRANCE) 33 1 53 11 05 77 33 6 08 94 63 16 [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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysqlbinlog
Just use mysqldump! At 03:59 PM 3/27/2001 -0700, Mat Murdock wrote: I've looked through the manual and about 9000 posts from multiple mailing lists.. Is there a way to have mysqlbinlog take a log file and dump just the sql statements to a file? Am I using the wrong program to do that? Any help would be most appreciated. Mat - Scott Baker - Webster Internet - Network Technician 503.266.8253 - [EMAIL PROTECTED] "It has been said that the primary function of schools is to impart enough facts to make children stop asking questions. Some, with whom the schools do not succeed, become scientists." - Knut Schmidt-Nielson - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Views !!
Hi again Folks !! How may create a view in mysql, o make some seem to the queiries in access !!! THanks Pablo - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
master and slave source code
Hi there, I was looking for the master and client source code but I was unable to find, I found the rpm but not source in tar format. I ma tiring to configure 2 linux server one master and one slave, can you tell me what's the best way to accomplish this and what settings I have to change. any help will be really appreciated. Thanks Ali, Mohammed Systems Administrator iWon.com One Bridge Street, Suite #42 Irvington, NY 10533 (914) 591-2000 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Views !!
Hi, How may create a view in mysql, o make some seem to the queiries in access !!! As discussed already many times over and over again and as it can be read in the mySQL documentation (http://www.mysql.com) views are (not yet) implemented in the current 3.23.36 version. Regards ... Ralph ... - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MySQL vs MS-SQL performance
Mike, Excuse me if I'm wrong, but isn't using persistent connections more server resource intensive? I'm trying to optimize the database on a heavy site, and I decided not to use persistent connections. Chris -Original Message- From: Michael Betts [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 27, 2001 4:18 PM To: [EMAIL PROTECTED]; Steve Quezadas Subject: Re: MySQL vs MS-SQL performance Steve, I also experienced the same results you did until I realized that the MS-SQL connection was using pooled connections and my use of MySQL wasn't. After I started using persistent connections to MySQL, it was much faster than MS-SQL on identical hardware and no tuning on either system. Also if you are looking for a performance improvement, drop ODBC and try the native API; it's much faster. Mike - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Core dump on MySQL 3.23.36 on RedHat 7.0
On the subject of RPMs, do they contain Innobase and BDB yet, or are those still only in the source releases? - Original Message - From: Scott Baker [EMAIL PROTECTED] To: Jack Lauman [EMAIL PROTECTED]; MySQL Mailing List [EMAIL PROTECTED] Sent: Tuesday, March 27, 2001 4:52 PM Subject: Re: Core dump on MySQL 3.23.36 on RedHat 7.0 I highly recommend installing from source. I've had many problems with the RPMs. At 04:42 PM 3/27/2001 -0800, Jack Lauman wrote: I'm getting the following error when I try to install the 3.23.36 RPM's on a P3-450 RedHat 7.0 box. I'd appreciate any suggestions. Starting mysql daemon with databases from /var/lib/mysql /usr/bin/safe_mysqld: line 258: 8692 Segmentation fault (core dumped) $NOHUP_NICENESS $ledir/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR $USER_OPTION --pid-file=$pid_file --skip-locking $err_log 21 010327 16:23:36 mysqld ended I can't find any indications of whats wrong in the error logs. Thanks, Jack - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Scott Baker - Webster Internet - Network Technician 503.266.8253 - [EMAIL PROTECTED] "It has been said that the primary function of schools is to impart enough facts to make children stop asking questions. Some, with whom the schools do not succeed, become scientists." - Knut Schmidt-Nielson - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How to reindex fulltext index?
How to reindex fulltext index? Thanks == xiewer Emailto:[EMAIL PROTECTED] CAD Garden -- http://xyzcad.yeah.net == - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: advice sought on using a select to extract binary data
On 3/27/01 4:54 PM, "WeAreUs" [EMAIL PROTECTED] wrote: Hi! I enter some .wav encoded (windows) data into a MySql table as follows: $data = addslashes(fread(fopen($form_data, "r"), filesize($form_data))); $result=MYSQL_QUERY("INSERT INTO b(audio,filename,filesize,filetype,audio_description) ". "VALUES ('$data','$form_data_name','$form_data_size','$form_data_type', '$audio_description')"); $uid= mysql_insert_id(); Later, I try to reconstruct the original audio file as follows: $query = mysql_query("select audio from dupe_b where uid='87' into outfile 'c:/windows/desktop/data.wav' "); This does not yield the correct format. I take it that I require "fields terminated by" or something like that to make this work. However, I cannot get any further with this. Any suggestions? Thanks for the time! Have you tried putting the returned value into a variable, opening up a file for writing(as binary) In php (which it looks like you are using) $fh=fopen('newfile.wav','wb'); fputs($fh,$fielddata); fclose($fh); I think that selecting into an outfile does some textencoding and newline conversion type stuff (just guessing). The above is the way I would do it, if I had to put my files into a db. I would rather store my files, as files, in a directory, and store the meta information (file location, name,size,description,copyright whatever) in the database. It is so much easier to have the file path/name inserted into the html, than to pull all the data out, create the file, insert the filename, server up the html. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
New ODBC
Hello, I'm new here ... I'm trying to use MySQL qith ASP, so I use ODBC .., but when I'm trying to connect to the server, it always respons: Microsoft OLE DB Provider for ODBC Drivers error '80004005' [TCX][MyODBC]Access denied for user: '[EMAIL PROTECTED]@mbtpc20.bau-verm.uni-karlsruhe.de' (Using password: YES) Any idea on this ..? Thank you for your reply -ws- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: New ODBC
Yes, your grant tables are not set up correctly. For full information, see the manual. For now try this: Choose a userid and password just for your db connection. It can be different from every other userid password you have. With the mysql client issue the following to SQL statements GRANT ALL ON *.* TO userid@%.uni-karlsruhe.de IDENTIFIED BY 'password'; FLUSH PRIVILEGES; Then try to connect with ODBC using the above userid and password. The effect of the GRANT statement allows userid to connect from any machine in the un-karlsruhe.de domain. The *.* means all databases and all their tables. The % is the wildcard that MySQL needs to allow the domain match. If your connection is always going to come from the same host, you can put that exact hostname or ip address after the @ in that section. MySQL maintains a totally separate user list from the system it is on, which is why you are getting the error. On 3/27/01 6:34 PM, "Wawan Setiawan" [EMAIL PROTECTED] wrote: Hello, I'm new here ... I'm trying to use MySQL qith ASP, so I use ODBC .., but when I'm trying to connect to the server, it always respons: Microsoft OLE DB Provider for ODBC Drivers error '80004005' [TCX][MyODBC]Access denied for user: '[EMAIL PROTECTED]@mbtpc20.bau-verm.uni-karlsruhe.de' (Using password: YES) Any idea on this ..? Thank you for your reply -ws- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Progress DB to MySQL DB
Has anyone seen any tool that would connect to a Progress DB and dump out a .sql (DB structure data) so I can then load it into MySQL. I know very little about Progress, but... I have managed to get PHP http://www.php.net talking to both MySQL and Progress 8.3 using the openlink drivers http://www.openlinksw.com Using the functions from within php you can extract information about tables and then build create statements and then transfer the data. It works very well. You could also write some kind of script that would convert a progress .df file into true SQL TABLE statements. Also, another thing I want to achive is to be able to run Progress 4GL code against MySQL DB. Has anyone heard anything about this before? Pass. Although Progress do have a product that talks to ODBC data source (which would include MySQL). Hope this helps. Regards Grant Walters Brainbench 'Most Valuable Professional' for Unix Admin Walters Associates, P O Box 13-043 Johnsonville, Wellington, NEW ZEALAND Telephone: +64 4 4765175, CellPhone 025488265, ICQ# 23511989 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
upgrading mysql
What process do you guys usually follow when upgrading your version of MySQL? I have yet to perform an upgrade, but my first thought would be to dump the databases, uninstall the old version (remove all the files), install the new version, and import the dump file. Is this a good plan, or is there a better method? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php