Re: Newbie--Easy data loading question
Because mysql needs 'rx' permissions to read and search the directory. 755 should have been sufficient. Menard, Inc. Information Systems wrote: I figured it out but I'm a bit confused as to why it happened. I'm running the load as user1. The file resides at /home/user1/data/filename Permissions: filename 666 data 777 user1 700 I had to change permissions on user1 to 777 in order for it to work. If I'm logged in as that user, why would I have to do that??? - 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: Read Only on User table
Richard, Friday, May 24, 2002, 5:04:49 PM, you wrote: RD I'm rather new to MySQL and trying to figure out GRANT and REVOKE so a RD password is required for access. RD Both GRANT and REVOKE give errors saying Table 'User' is read only. A text RD search in the manual for read only did not yield anything. RD Is this an OS attribute that should be dealt with manually, such as with RD Windows-NT explorer or DOS ATTRIB? Or is there a MySQL command that should RD be used to make tables read-only and read-write? This error mostly occurs when user that has run MySQL server doesn't have permissions on MySQL data dir or files. Please, check your permissions. RD Thanks, RD Rick -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.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: Read Only on User table
Rick: I believe this is a faq, but check permissions. bash-2.05$ ls -lrtd /mysql/ drwxr-x--- 42 mysqlmysql4096 May 1 11:34 /mysql/ [root@winslow RPMS]# ls -lrt /var/lib/mysql/ total 12 drwx--2 mysqlmysql4096 May 24 22:01 test -rw-rw1 mysqlmysql 146 May 24 22:01 winslow.log drwx--2 mysqlmysql4096 May 24 22:01 mysql srwxrwxrwx1 mysqlmysql 0 May 24 22:01 mysql.sock The first invocation from a source distro. The second from a binary RH 7.2 installation. Send the about to the list, and someone should be able to give the command to fix your problem to you. Regards, Van -- = Linux rocks!!! http://www.dedserius.com/ = Richard Davidson wrote: Hi, I'm rather new to MySQL and trying to figure out GRANT and REVOKE so a password is required for access. Both GRANT and REVOKE give errors saying Table 'User' is read only. A text search in the manual for read only did not yield anything. Is this an OS attribute that should be dealt with manually, such as with Windows-NT explorer or DOS ATTRIB? Or is there a MySQL command that should be used to make tables read-only and read-write? Thanks, Rick - 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: File created by mysqldump cannot be read into MySQL
Don't use 'more'. It adds characters to the output. Instead: mysql --host=host --user=user --password=pwd error_repeat.sql Elliot Smith wrote: Description: I used mysqldump to create an SQL file containing a dump of all databases on the server, including all tables and data (using --all-databases). However, when I tried to restore from this file, the mysql command line tool reported errors. I guessed that this was due to the --extended-insert option (I was using --opt); when I turned this off (but kept all of the other --opt options) the errors disappeared. How-To-Repeat: I used mysqldump to create a dump of all databases on the server, as follows: mysqldump --host=host --user=user --password=pwd --all-databases --opt --result-file=backup.sql However, the problem can be duplicated by running the following SQL alone against a MySQL database using the mysql command line tool: -- MySQL dump 8.21 -- -- Host: pathia.bham.ac.ukDatabase: test - -- Server version 3.23.49-max -- -- Current Database: test -- CREATE DATABASE /*!32312 IF NOT EXISTS*/ test; USE test; -- -- Table structure for table 'up_layout_struct' -- DROP TABLE IF EXISTS up_layout_struct; CREATE TABLE up_layout_struct ( USER_ID int(11) NOT NULL default '0', LAYOUT_ID int(11) NOT NULL default '0', STRUCT_ID int(11) NOT NULL default '0', NEXT_STRUCT_ID int(11) default NULL, CHLD_STRUCT_ID int(11) default NULL, EXTERNAL_ID int(11) default NULL, CHAN_ID int(11) default NULL, NAME varchar(35) default NULL, TYPE varchar(35) default NULL, HIDDEN char(1) default NULL, IMMUTABLE char(1) default NULL, UNREMOVABLE char(1) default NULL, PRIMARY KEY (LAYOUT_ID,USER_ID,STRUCT_ID) ) TYPE=MyISAM; /*!4 ALTER TABLE up_layout_struct DISABLE KEYS */; -- -- Dumping data for table 'up_layout_struct' -- LOCK TABLES up_layout_struct WRITE; INSERT INTO up_layout_struct VALUES (1,1,1,4,2,NULL,NULL,'Header folder','header',NULL,'Y','Y'),(1,1,2,3,NULL,NULL,10,NULL,NULL,NULL,NULL,NUL L),(1,1,3,NULL,NULL,NULL,99,NULL,NULL,NULL,NULL,NULL),(1,1,4,9,5,NULL,NULL,' Main',NULL,NULL,'Y','Y'),(1,1,5,7,6,NULL,NULL,'Column 1',NULL,NULL,NULL,NULL),(1,1,6,NULL,NULL,NULL,5,NULL,NULL,NULL,NULL,'N'),(1, 1,7,NULL,8,NULL,NULL,'Column 2',NULL,NULL,NULL,NULL),(1,1,8,NULL,NULL,NULL,8,NULL,NULL,NULL,NULL,'N'),(1, 1,9,14,10,NULL,NULL,'Misc',NULL,NULL,'Y','Y'),(1,1,10,12,11,NULL,NULL,'Colum n 1',NULL,NULL,NULL,NULL),(1,1,11,NULL,NULL,NULL,9,NULL,NULL,NULL,NULL,'N'),(1 ,1,12,NULL,13,NULL,NULL,'Column 2',NULL,NULL,NULL,NULL),(1,1,13,NULL,NULL,NULL,11,NULL,NULL,NULL,NULL,'N'),( 1,1,14,22,15,NULL,NULL,'News',NULL,NULL,'Y','Y'),(1,1,15,17,16,NULL,NULL,'Co lumn 1',NULL,NULL,NULL,NULL),(1,1,16,NULL,NULL,NULL,12,NULL,NULL,NULL,NULL,'N'),( 1,1,17,NULL,18,NULL,NULL,'Column 2',NULL,NULL,NULL,'N'),(1,1,18,19,NULL,NULL,6,NULL,NULL,NULL,NULL,'N'),(1,1, 19,NULL,NULL,NULL,13,NULL,NULL,NULL,NULL,'N'),(1,1,22,25,23,NULL,NULL,'User Preferences',NULL,'Y','Y','Y'),(1,1,23,24,NULL,NULL,90,NULL,NULL,NULL,NULL,' Y'),(1,1,24,NULL,NULL,NULL,92,NULL,NULL,NULL,NULL,'Y'),(1,1,25,NULL,26,NULL, NULL,'Footer folder','footer',NULL,'Y','Y'),(1,1,26,NULL,NULL,NULL,19,NULL,NULL,NULL,'Y', 'Y'),(2,1,1,4,2,NULL,NULL,'Header folder','header',NULL,'Y','Y'),(2,1,2,3,NULL,NULL,10,NULL,NULL,NULL,NULL,NUL L),(2,1,3,NULL,NULL,NULL,99,NULL,NULL,NULL,NULL,NULL),(2,1,4,10,5,NULL,NULL, 'Main',NULL,NULL,NULL,NULL),(2,1,5,8,6,NULL,NULL,'Column 1',NULL,NULL,NULL,NULL),(2,1,6,7,NULL,NULL,11,NULL,NULL,NULL,NULL,NULL),(2,1 ,7,NULL,NULL,NULL,14,NULL,NULL,NULL,NULL,NULL),(2,1,8,NULL,9,NULL,NULL,'Colu mn 2',NULL,NULL,NULL,NULL),(2,1,9,29,NULL,NULL,3,NULL,NULL,NULL,NULL,NULL),(2,1 ,29,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL),(2,1,10,17,11,NULL,NULL,'Deve lopment',NULL,NULL,NULL,NULL),(2,1,11,13,12,NULL,NULL,'Column 1',NULL,NULL,NULL,NULL),(2,1,12,18,NULL,NULL,4,NULL,NULL,NULL,NULL,NULL),(2, 1,18,NULL,NULL,NULL,15,NULL,NULL,NULL,NULL,NULL),(2,1,13,NULL,1 5,NULL,NULL,'Column 2',NULL,NULL,NULL,NULL),(2,1,15,14,NULL,NULL,20,NULL,NULL,NULL,NULL,NULL),(2 ,1,14,16,NULL,NULL,7,NULL,NULL,NULL,NULL,NULL),(2,1,16,37,NULL,NULL,16,NULL, NULL,NULL,NULL,NULL),(2,1,37,NULL,NULL,NULL,22,NULL,NULL,NULL,NULL,NULL),(2, 1,17,21,19,NULL,NULL,'User Preferences',NULL,'Y','Y','Y'),(2,1,19,20,NULL,NULL,90,NULL,NULL,NULL,NULL,' Y'),(2,1,20,NULL,NULL,NULL,92,NULL,NULL,NULL,NULL,'Y'),(2,1,21,27,22,NULL,NU LL,'CWebProxy Examples',NULL,NULL,NULL,NULL),(2,1,22,25,23,NULL,NULL,'Column 1',NULL,NULL,NULL,NULL),(2,1,23,24,NULL,NULL,17,NULL,NULL,NULL,NULL,NULL),(2 ,1,24,NULL,NULL,NULL,17,NULL,NULL,NULL,NULL,NULL),(2,1,25,NULL,26,NULL,NULL, 'Column 2',NULL,NULL,NULL,NULL),(2,1,26,NULL,NULL,NULL,18,NULL,NULL,NULL,NULL,NULL), (2,1,27,NULL,28,NULL,NULL,'Footer folder','footer',NULL,NULL,NULL),(2,1,28,NULL,NULL,NULL,19,NULL,NULL,NULL,NU LL,NULL); /*!4 ALTER TABLE up_layout_struct ENABLE KEYS */; UNLOCK
foreign key and check ICs: implementation suggestion
Hello, The documentation often mentions that foreign key support in mysql is not implemented because it slows down the database server. The argument is that since the applications built on top of mysql have to check for database integrity constraints (ICs) it is redundant for the database to perform these checks as well. However it would be very convenient to have a setting in /etc/my.cnf for enabling/disabling the checking of foreign keys with the default being off in the interest of speed. The reason a user would want this is that if there is a lot of data in an existing database then the application developer does not want the application to mess up the data due while the application is not yet stable. Thus, in such a scenario, foreign keys are helpful. Thus in addition to a setting in /etc/my.cnf it would be helpful to have commands such as ENABLE FOREIGN KEYS and DISABLE FOREIGN KEYS allowing more flexibility on multiuser systems. The same mechanism could be use to enable/disable CHECK constraints including CHECK constraints involvins SELECT statements. These could always be enforced/not enforced with commands such as ENABLE CHECK IC and DISABLE CHECK IC or something similar, with the default set to DISABLED in the intrest of speed, but with the syntax in the table data definition language (DDL) still being parsed and accepted in both cases, as for foreign keys. Thank you for mysql, Neil Zanella [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: Help with REPLACE INTO statement syntax
At 21:27 -0500 5/23/02, Andrew Lietzow wrote: Dear MySQL wizards, I have two tables, call them a and b. The database structure is identical. I want the records in b to overwrite the records in (REPLACE INTO) a. This is the statement that does NOT work. REPLACE INTO a SELECT b.* FROM b WHERE a.field1 = b.field1 The field names in A are identical to B. On Thursday 23 May 2002 09:33 pm, Paul DuBois wrote: The SELECT part has to be a legal SELECT statement, which yours isn't. (The WHERE part names two tables, but the FROM part names only one.) Thank you for your reply, Paul. I now have two statements; one which works, one which does not. I do not know why the second will not work. *WORKS to create a new table* INSERT INTO a_copy SELECT a.field1, a.field2, a. field.6, b.field7 FROM a,b WHERE a.field1 = b.field1 My resultant table has the data from b that I wanted to put directly into a but could not (because of MySQL rules regarding manipulation of Two Tables?) and writing back to one of them. Is this the reason that I can't get this next statement to work (returns ERROR 1066 - Not unique table/alias. ) *Does NOT work to replace data in table a * REPLACE INTO a SELECT b.* FROM a, b WHERE a.field1 = b.field1 The FROM part now names two tables, as does the WHERE part. (I'm attempting to follow your curative recommendation). So what is wrong with this statement? I want to read records from one file, write them to another, stepping on the contents of the entire record based on a unique index key value. I have 2215 records with correct data (b) and the key matches a key in a file with 4935 records (a). Is this not feasible with MySQL until version 4.X? Maybe I can just say: REPLACE INTO a FROM b USING (field1) ??? TIA for any help... Andrew Lietzow - 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: Servers Tables
Dear Curtis, RE: How do I log in and see the table layout and data? How do I create a connection to access the tables and data from my ASPs? The first question is a popular one, asked and answered multiple times in the FAQ's. I would also recommend that you look into a GUI front end, like mySQLMan, very early on. I was very frustrated with MySQL until I fount that package. It is a free download from Gossamer-Threads. I have no vested interest in this company, only a vested interest in being productive with MySQL. Too bad about that Windoze thing, however. Can't get out of it, eh? -- Andrew Lietzow The ACL Group, Inc. - 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: Newbie--Easy data loading question
Dear Jake and MySQL listers, RE: I had to change permissions on user1 to 777 in order for it to work. If I'm logged in as that user, why would I have to do that??? I can't say for certian, though I would imagine that the mysqld actually does the processing on this type of a table load, i.e. it controls access to the mysql engine, not the user. This is why, whenever I want to do an import, I execute thusly: # mysql -u mysql -p script_to_load_file Again, this may not be 100% requisite, but I'm into error prevention and this pretty much ensure that I won't bump into permissions issues. I don't lke setting a fill to 777 but prefer 755. Others can help with greater accuracy but this may be of some help for the future. Andrew Lietzow The ACL Group, Inc. On Friday 24 May 2002 08:44 am, Menard, Inc. Information Systems wrote: I figured it out but I'm a bit confused as to why it happened. I'm running the load as user1. The file resides at /home/user1/data/filename Permissions: filename 666 data 777 user1 700 I had to change permissions on user1 to 777 in order for it to work. If I'm logged in as that user, why would I have to do that??? Thanks Jake -Original Message- From: Menard, Inc. Information Systems [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 8:26 AM To: Jay Blanchard; [EMAIL PROTECTED] Subject: RE: Newbie--Easy data loading question yes. I tried all of these methods: 1) //dir1//dir2//file 2) /dir1/dir2/file running load from file dir using: ./file .//file I also check the file permissions and it is all read/write. I can't remember if I tried to run it using mysqls root yet...that would be the next step, but I prefer not to go there. -Original Message- From: Jay Blanchard [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 8:22 AM To: 'Menard, Inc. Information Systems'; [EMAIL PROTECTED] Subject: RE: Newbie--Easy data loading question did you supply the /full/path/to/the/file/ ? -Original Message- From: Menard, Inc. Information Systems [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 8:15 AM To: [EMAIL PROTECTED] Subject: Newbie--Easy data loading question Hello Forgive me for being a little naive but. I am trying to load a table with a text file using the load data infile command in mysql. I can do it if I place the text file in the db directory, but I want it to reside in a different dir. I am getting the error 13: Can't get stat on What am I doing wrong?? Thank you very much in advance for your help! Jake - 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 -- Andrew Lietzow The ACL Group, Inc. 515-274-0300 v/f 515-710-1955 c - 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: Installing / Running
I had a weird problem similar to this on an older version of Red Hat. Debuging init.d etc...I found that the socket was being created in one location and mysql was trying to use it in a different locationThe process of launching is kinda complicated, so rather then spend a whole bunch of time isolating this (could not find anything obvious...) I solved the problem by creating a config file to explicitly set the socket path and made sure my config file was the last one looked at... Hope this Helps, -- Erik - Original Message - From: Gurhan Ozen [EMAIL PROTECTED] To: [EMAIL PROTECTED]; MySql [EMAIL PROTECTED] Sent: Wednesday, May 22, 2002 4:00 PM Subject: RE: Installing / Running How did you try to connect it??? IS your mysql server running? If yes is the mysql.sock location correct? Gurhan -Original Message- From: Glenn Hancock [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 22, 2002 4:48 PM To: MySql Subject: Installing / Running I have installed MySQL on my RH Linux 7.3 box. I am trying to use it with the Apache web server but haven't gotten that far. I downloaded the source version because I am new to Linux and felt that I would understand better where everything was as far as the files and source code. The original attempt was to install the rpm file and it did so without a problem. However, when I started going through some testing I couldn't find some of the files I needed so I opted to install the source. The reason I mention this is just in case that might be a problem. I have MySQL installed in the /usr/local/mysql folder and everything appears to have compiled and installed just fine. All tasks listed on your website for installing the source worked without an issue until I get to the part where I am actually testing it. Starting the server seems to work as I have the processes running, however, when I attempt to connect to the server in any way (and this happened with the rpm and the source) I receive a message stating the following: Can't connect to local MySQL server through socket 'tmp/mysql.sock' (2) Can anyone tell me what I have done wrong and what I need to do in order to get the database server operational? Thanks in advance, Glenn Hancock -glenn hancock [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] SofTek Software Int'l, Inc. www.softeksoftware.com http://www.softeksoftware.com 678-583-8439 - 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
bug in dynamic linker?
Hello, I have a script with INSERT statements. I run it quite often and today for the first time I got the following message while inserting from the mysql client: BUG IN DYNAMIC LINKER ld.so: rtld.c: 621: dl_main: Assertion `_dl_rtld_map.l_libname' failed! I simply reran the script and it worked fine. Any ideas of what the problem was here? Just thought I'd report it. The version of MySQL is 3.22.32 so that may be a little bit old. Thanks, Neil - 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
Greek characters support
Hi! First of all I would like to congratulate you for MySQL, which I, among many users, have found a both useful and powerfull tool. My name is Dennis Bekatoros. I am a pretty new user of MySQL but having some experience with other SQL platforms I managed to get used to MySQL environment in short time using of course your manuals and documentation. I am currently developing a DBMS application using MySQL and Visual Basic (with ODBC 3.51). Many of the data to be put in the database must be in Greek but I've encountered the following problem: When I insert data to a table from MySQL Monitor, I can normally load them from my VB application but I can't read them as the Greek characters are replaced from others. Also, when I insert data to a table from my VB application I can't read them from MySQL monitor for the same reason. Is there some setting in MyODBC driver I should check? It is very imortant to solve this problem because, due to the nature of my application, I need to be able to access the database from both environments. I hope tha you will soon answer to my question as it is critical for the continuation of my work. Thanks in advance and I am looking forward to hear from you... Dennis Bekatoros _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. - 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
Cannot find header files
When I try to install Php like this: ./configure --with-mysql=/usr/local/lib/mysql I get: configure: error: Cannot find header files under /usr/local/lib/mysql I have installed: http://www.mysql.com/Downloads/MySQL-4.0/MySQL-4.0.1-2.i386.rpm http://www.mysql.com/Downloads/MySQL-4.0/MySQL-client-4.0.1-2.i386.rpm http://www.mysql.com/Downloads/MySQL-4.0/MySQL-devel-4.0.1-2.i386.rpm What am I doing wrong ? Regards Jacob - 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
A Proprietary MySQL Business Model
How much third party software is incorporated into the non-GPL version of MySQL. Obviously the included software can't itself be under the GPL. How does MySQL get around this? Does MySQL have contracts with contributors instead of contributions being under the GPL? It seems like an interesting business model and one that deserves attention. - 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
Connection Problem
Greets Folks,
I am trying to get an online database set up and running, but I keep getting
error messages at login.
Here are two sample scripts I have been running (both are from Paul DuBois'
book MySQL and Perl for the Web).
## SCRIPT 1 ##
#! /usr/bin/perl -w
# intro4.pl - generate a Web page using the CGI.pm object-based interface
use strict;
use CGI;
my $cgi = new CGI;
print $cgi-header (),
$cgi-start_html (My Page Title),
$cgi-p (My page body),
$cgi-end_html ();
exit (0);
## SCRIPT 2 ##
#! /usr/bin/perl -w
# intro6.pl - connect to MySQL, retrieve data, write plain text output
use strict;
use DBI;
use CGI qw(:standard);
my ($dbh, $sth, $count);
$dbh = DBI-connect (DBI:mysql:host=localhost;database=***,
**, ***, {PrintError = 0, RaiseError = 1});
$sth = $dbh-prepare (SELECT name, wins, losses FROM teams);
$sth-execute ();
$count = 0;
while (my @val = $sth-fetchrow_array ())
{
print p (sprintf (name = %s, wins = %d, losses = %d\n,
$val[0], $val[1], $val[2]));
++$count;
}
print $count rows total\n;
$sth-finish ();
$dbh-disconnect ();
exit (0);
I have double checked everything. CGI.pm works withother scripts. Thwe
server I know for a fact has MySQL on it, DBI and DBD::mysql. the fiedls
have been uploaded in ASCII format, and I've CHMOD-ed them to 755.
I can't tell what else could be wrong. The only thing I can think of might
be the login command. I had to block out the real user names and passwords
and stuff with asterisks here, but the username and password I use are for
the DBA, an I am assuming that that user has read/write permissions. The
only other thing I can think of might be that the line
DBI:mysql:host=localhost might be different on the actual system than in the
book. Do any of these things sound possible? If so, how can I correct them
or get the right info?
Thanks,
Will
_
Chat with friends online, try MSN Messenger: http://messenger.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 mysql-unsubscribe-##L=##[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Is the Mysql list down?
I am just checking to see if the mysql server is down I haven't gotten any e-mails today? - 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: php+apache+mysql installation. Help
Do I need to uninstall the old Apache before installing the newer version? How do I uninstall the old Apache in linux? Do I just use the package manager to remove the package? What does make do? I don't know how linux work. Please advise. Thanks. From: Andrew Lietzow [EMAIL PROTECTED] To: Andy Cheng [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: php+apache+mysql installation. Help! Date: Thu, 23 May 2002 21:34:37 -0500 Dear Andy, Here's a thought. Before you go much further, install Apache 2.0.36. It's easy to install and lots of improvements will be gained that you'll appreciate down the road, i.e. mod_ssl is preconfigured into the system. Andrew Lietzow The ACL Group, Inc. On Thursday 23 May 2002 06:33 pm, you wrote: Hi, I am new to linux and trying to install Apache, php and mysql on my Redhat 7.2.Linux box. When I run the configure for PHP 4.2.1, I got this error: checking whether build environment is sane..configure error:newly created file is older than distributed files! I have Apache 1.3.20 (from RH 7.2) and Mysql 3.23.49a installed on my box. Would appreciated if some one could advise how to install PHP. Thanks P.S. I have start Mysql manually. How do I make it auto start and shutdown? _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx - 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 -- Andrew Lietzow The ACL Group, Inc. 515-274-0300 v/f 515-710-1955 c _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx - 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: query
saraswathy saras wrote: is there any other specific command instead order by ID DESC to select all the record from table where the ID is the last ID.The ID is autoincrement. Not sure from your message if you already know this, but ORDER BY ID DESC LIMIT 1 gives you what you want. -myk mysql, query - 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
Bug fix for MySQL v3.23.49
Hi, We have identified a rather serious bug in libmysqlclient of v3.23.49. The client we are using is RIPE 3.1.0 (an Internet Routing Registry server) proivded by RIPE. This latest version uses threaded libraries. Upon starting this server it would very shortly thereafter crash. This occured because of a bug in the MYSQL client library (libmysqlclient). The bug was an improperly formed for loop in a routine called mysql_read_default_options() (libmysql.c:715). The for statement used to read as follows: for (end= *option ; (end= strcend(end,'_')) ; ) The patched statement that has been tested and works fine is: for (end= *option ; (end= strcend(end,'_')) *end ; ) //* detect null */ Have a great day!!! Mike Bluett Denis Laplante Network Engineering The Univeristy of British Columbia - 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 / Firewall
Hi all. I've just been forced to install a hardware firewall by our parent company. We now have our MySQL server in a DMZ zone, and I am having trouble opening up access to it. The firewall doesn't have an entry for the MySQL service, so I create a user-defined service and fill in the following details: SourcePort Low: 3306 SourcePort High: 3306 DestPort Low: 3306 DestPort High: 3306 Transport: TCP (choices are TCP-6, UDP-17, and Other) I then edit the firewall policy to allow the MySQL service between our DMZ and protected network, in both directions. The problem is that our database app gives a 'timeout connecting to MySQL' error. However, if I edit the firewall policy and tell it to allow ALL services between the DMZ and our protected network, it works fine. I have tried rebooting the firewall and all other computers involved. I am sure our MySQL server is running on port 3306, as I have verified this from the MyODBC-3.51 config screen. Does MySQL only use port 3306 under default configuration, or does it connect on 3306 and then use a range of ports? Anyone have any ideas on what I'm doing wrong? Thanks in advance! Dan -- Daniel Kasak IT Developer * NUS Consulting Group* Level 18, 168 Walker Street North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: www.nusconsulting.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: Locking TABLES for myisamchk, please help!!
I understand all of the reasons given by Alexander. Yet I think that in 99% of cases, it would be best for myisamchk to do as Mark suggest, and not run when a MySQL server is active. Safety would be the default. There could be a special option (--no-safety) for myisamchk to override that check. - Original Message - From: Alexander Keremidarski [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Thursday, May 23, 2002 1:54 AM Subject: Re: Locking TABLES for myisamchk, please help!! Mark wrote: Wednesday, May 22, 2002, 9:23:02 AM, louie wrote: cut Personally, I find the behavior of myisasmchk to be a bit beta when it comes live tables. It would be real easy for myisasmchk to refuse to run when mysqld is running. That should be a built-in precaution. I can understand possible objections to myisasmchk globally locking tables out of the blue (it might disrupt what some clients are doing), but if myisamchk cannot run on a live table, it should not run on a live table. As simple as that. Hi, It is not that simple. You can run several mysqld simultaneously. So checking if mysqld is running is not enough. Or you might wish to use myisamchk knowing in advance that mysqld will not write to table. Typical case is to check 'offline' database or table. Backup copy for example. Another case: You want to check table which is read-only for all mysql users and for some reason (different priority, buffers used etc.) you don't want to do it with REPAIR TABLE. myisamchk uses tables as files so it is admin responcibility to avoid problems. It is dangerous to use it but it is possible. You can compare it to filesystem checks. It is admin to decide if he can handle it with live server or not. - 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: [7241] Indexes on columns that are declared differently?
I am hoping that a MySQL person will give a definite answer to my question. Thanks, Stephen - Original Message - From: Dan Nelson [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Monday, May 20, 2002 3:18 PM Subject: Re: [7241] Indexes on columns that are declared differently? In the last episode (May 20), Stephen Brownlow said: The MySQL online manual says that MySQL cannot use indexes efficiently unless the columns have the same type and the same length. I can see no release notes that this problem has been fixed. My question: Is this still a problem? Probably. I doubt anyone's even trying to fix it, since a field-length mismatch between related fields means that one or the other fields has the wrong length. You'll never get a 20-character string to match if the other table's field definition is char(10); either make both 10, or both 20 :) - 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 corrupted abruptly.
Yesterday my server died abruptly. I can't even guess the reason. Fortunately there remain error messages, following are the messages mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked agaist is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail key_buffer_size=268431360 record_buffer=1044480 sort_buffer=4194296 max_used_connections=133 max_connections=400 threads_connected=60 It is possible that mysqld could use up to key_buffer_size + (record_buffer + sort_buffer)*max_connections = 2308536 K bytes of memory Hope that's ok, if not, decrease some variables in the equation Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Stack range sanity check OK, backtrace follows: 0x80a926a 0x4002b8d5 0x80a4aa6 0x80a4c66 0x80adbd3 0x80aded1 0x80adbd3 0x80aded1 Stack trace seems successful - bottom reached Please read http://www.mysql.com/doc/U/s/Using_stack_trace.html and follow instructions o n how to resolve the stack trace. Resolved stack trace is much more helpful in diagnosing the problem, so please do resolve it Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd-query at (nil) is invalid pointer thd-thread_id=129599 Successfully dumped variables, if you ran with --log, take a look at the details of what thread 129599 did to cause the crash. In some cases of really bad corruption, the values shown above may be invalid The manual page at http://www.mysql.com/doc/C/r/Crashing.html contains information that should help you find out what is causing the crash Number of processes running now: 21 mysqld process hanging, pid 338 - killed 020526 13:01:41 mysqld restarted /usr/local/libexec/mysqld: ready for connections ~ Does anybody know the reason? It's critical to me. If you know anything about it, please let me know. Any information will be appreciated. - 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
INSERT IF NOT EXISTS?
(filter fodder: sql, query) Hello group! Quick question: Is there a simple way to do something like INSERT IF NOT EXISTS, other than first doing a SELECT and checking if it returns any rows? If not, that would be pretty high up on my whish-list : ) Cheers, Markus -- Markus Lervik Linux-administrator Vaasa City Library - Regional Library, Finland [EMAIL PROTECTED] +358-6-325 3589/+358-40-832 6709 - 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
Is the list server down?
I haven't seen a mysql question since friday? - 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
Thread leak in libmysqld for win32
The embedded server of 4.0.1 for win32 leaks one thread (the server thread
to be exact) per mysql_server_init / mysql_server_end pair. I've
experimented
with mysql_shutdown and mysql_thread_end as well, but they do not resolve
the issue. Eventually (after 10 times or so starting/ending the server
within the
same process) the process crashes.
Example:
int main(void)
{
static char *my_argv[] = {
mysqld,
--skip-networking,
--skip-name-resolve,
NULL
};
int i;
for (i = 0 ; i 5 ; ++i) {
mysql_server_init(sizeof (my_argv) / sizeof (*my_argv) - 1,
my_argv, NULL);
mysql_server_end();
}
while (1)
Sleep(1000);
/* never reached */
return 0;
}
A process viewer shows 6 threads remaining (the initial process + 5 left
overs
from mysql).
Kind regards,
Frans van Dorsselaer
[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
ODBC Questions
Hey guys, I have some questions concerning ODBC, I'm doing a job on a server which requires me to access a MS Access DB and write a front end for it, so employees of the company can run query's. I just have some questions. I'm using mysql w/ odbc drivers and php. Does teh server (NT 4) need to have access installed in order to run query's? I was able to access a db using odbc_connect(DSN_Name, user, password); but i couldn't run the query CREATE TABLE customers (customerid INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, name CHAR(30) NOT NULL); It gave me an error saying error in SQL syntaz at CREATE TABLE.. i used odbc_exec() but MS Access is not installed on that machine yet. Do i need to do this in order to create tables and run queries? and if so is the SQL sytnax exactly the same as 'normal' SQL syntax? thanks Jule - 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
What files are these?
I have some very big files in my /var/lib/mysql. [root@nias mysql]# ls -l nias-bin* -rw-rw1 mysqlmysql1073741921 5$B7n(B 8 04:33 nias-bin.001 -rw-rw1 mysqlmysql875448838 5$B7n(B 9 18:31 nias-bin.002 -rw-rw1 mysqlmysql 86 5$B7n(B 9 19:36 nias-bin.003 -rw-rw1 mysqlmysql1073741901 5$B7n(B 12 04:32 nias-bin.004 -rw-rw1 mysqlmysql1073741885 5$B7n(B 14 04:35 nias-bin.005 -rw-rw1 mysqlmysql1073741878 5$B7n(B 16 04:37 nias-bin.006 -rw-rw1 mysqlmysql1073741948 5$B7n(B 18 04:39 nias-bin.007 -rw-rw1 mysqlmysql750078444 5$B7n(B 20 03:25 nias-bin.008 -rw-rw1 mysqlmysql1073742339 5$B7n(B 22 04:32 nias-bin.009 -rw-rw1 mysqlmysql1073742314 5$B7n(B 24 04:32 nias-bin.010 -rw-rw1 mysqlmysql1073742497 5$B7n(B 26 04:32 nias-bin.011 -rw-rw1 mysqlmysql453278435 5$B7n(B 26 04:51 nias-bin.012 -rw-rw1 mysqlmysql 180 5$B7n(B 26 04:32 nias-bin.index What files are them? Is it ok to delete all of them? Since I am running out of space. - 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
What happened??
What happened to this MySQL list?? For the last two days all I got was a Connecyion deferred, and I have not received mail from it for the last two days either. - Mark - 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: multi-table delete bug
- Original Message -
From: Jocelyn Fournier [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Saturday, May 25, 2002 3:35 PM
Subject: Re: multi-table delete bug
Hi,
Yes, you're right, but to see the problem, you have to restart mysql
between
INSERT INTO t2 (mot) VALUES
('test'),('joce'),('ouee');
Query OK, 3 rows affected (0.02 sec)
Records: 3 Duplicates: 0 Warnings: 0
AND
DELETE FROM t2,t3 USING t2 as a,t3 as
b,t1 as c WHERE b.numreponse=a.numreponse AND
b.topic=c.numeropost AND c.date'2002-05-30';
Then you will obtain :
mysql INSERT INTO t2 (mot) VALUES
- ('test'),('joce'),('ouee');
Query OK, 3 rows affected (0.01 sec)
Records: 3 Duplicates: 0 Warnings: 0
mysql exit
[root@forum] /home/mysql-4.0 mysqladmin -uroot -p shutdown
Enter password:
[root@forum] /home/mysql-4.0 mysqld_safe
[1] 22419
[root@forum] /home/mysql-4.0 Starting mysqld daemon with databases from
/home/mysql
[root@forum] /home/mysql-4.0 mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 95 to server version: 4.0.2-alpha
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql use Hardwarefr;
Database changed
mysql DELETE FROM t2,t3 USING t2 as a,t3 as
- b,t1 as c WHERE b.numreponse=a.numreponse AND
- b.topic=c.numeropost AND c.date'2002-05-30';
Query OK, 0 rows affected (0.00 sec)
Regards,
Jocelyn
- Original Message -
From: Sinisa Milivojevic [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Saturday, May 25, 2002 12:57 PM
Subject: Re: multi-table delete bug
Hi!
Thank you for your test case.
However, with latest 4.0.2 code I am getting correct results with
it. Difference in number of rows in select and delete are stemming
from the fact that select reports number of rows in result set, while
delete reports total number of rows deleted.
These are results that I get. If you still think that those are not
correct, please let me know.
I get this :
create database xx;
Query OK, 1 row affected (0.00 sec)
use xx;
Database changed
CREATE TABLE `t1` (
`titre` char(80) NOT NULL default '',
`numeropost` mediumint(8) unsigned NOT NULL auto_increment,
`ouvert` tinyint(1) unsigned NOT NULL default '1',
`date` datetime NOT NULL default '-00-00 00:00:00',
`auteur` char(35) NOT NULL default '',
`icone` tinyint(2) unsigned NOT NULL default '0',
`nbrep` mediumint(8) unsigned NOT NULL default '0',
`maxnumrep` int(10) unsigned NOT NULL default '0',
`vue` mediumint(8) unsigned NOT NULL default '0',
`lastauteur` char(35) NOT NULL default '',
`sondage` tinyint(1) NOT NULL default '0',
`next` int(10) NOT NULL default '0',
`prev` int(10) NOT NULL default '0',
`subcat` mediumint(8) unsigned NOT NULL default '0',
PRIMARY KEY (`numeropost`),
KEY `date` (`date`),
KEY `maxnumrep` (`maxnumrep`),
KEY `auteur` (`auteur`),
KEY `sondage` (`sondage`),
KEY `subcat` (`subcat`)
) TYPE=MyISAM;
Query OK, 0 rows affected (0.01 sec)
CREATE TABLE `t2` (
`mot` char(30) NOT NULL default '',
`numreponse` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`mot`,`numreponse`),
KEY `numreponse` (`numreponse`)
) TYPE=MyISAM ROW_FORMAT=FIXED;
Query OK, 0 rows affected (0.00 sec)
CREATE TABLE `t3` (
`topic` mediumint(8) unsigned NOT NULL default '0',
`date` datetime NOT NULL default '-00-00 00:00:00',
`pseudo` char(35) NOT NULL default '',
`numreponse` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`date`,`numreponse`,`topic`),
UNIQUE KEY `pseudo` (`pseudo`,`date`,`numreponse`,`topic`),
UNIQUE KEY `numreponse` (`numreponse`),
KEY `topic` (`topic`)
) TYPE=MyISAM ROW_FORMAT=FIXED;
Query OK, 0 rows affected (0.00 sec)
INSERT INTO t1 (titre) VALUES ('test');
Query OK, 1 row affected (0.00 sec)
INSERT INTO t3 (topic,pseudo) VALUES (1,'joce');
Query OK, 1 row affected (0.00 sec)
INSERT INTO t2 (mot) VALUES
('test'),('joce'),('ouee');
Query OK, 3 rows affected (0.02 sec)
Records: 3 Duplicates: 0 Warnings: 0
mot numreponse topic date pseudo numreponse titre numeropost ouvert date
auteur icone nbrep maxnumrep vue lastauteur sondage next prev subcat
test 0 1 -00-00 00:00:00 joce 0 test 1 1 -00-00 00:00:00 0 0 0 0
0
0 0 0
joce 0 1 -00-00 00:00:00 joce 0 test 1 1 -00-00 00:00:00 0 0 0 0
0
0 0 0
ouee 0 1 -00-00 00:00:00 joce 0 test 1 1 -00-00 00:00:00 0 0 0 0
0
0 0 0
DELETE FROM t2,t3 USING t2 as a,t3 as
b,t1 as c WHERE b.numreponse=a.numreponse AND
b.topic=c.numeropost AND c.date'2002-05-30';
Query OK, 4 rows affected (0.01 sec)
SELECT * FROM t2 as
a,t3 as b,t1 as c WHERE
b.numreponse=a.numreponse AND b.topic=c.numeropost AND
c.date'2002-01-01'
Grant Tables Creation
Hi! Glenn == Glenn Hancock [EMAIL PROTECTED] writes: Glenn I also have had trouble with the script that creates my user access tables. Glenn I am assuming those tables should get created in the ./var/mysql folder. Glenn Its my fault but I removed those tables just to see if they had anything to Glenn do with me not being able to use the mysql database server. I figured it Glenn was ok because I thought they had been created by the script but now they Glenn are no longer their and subsequent runs of the script are not creating them. Glenn Am I missing something? Yes, mysql_install_db should recreate everything. Please check that your MySQL server is down before running the script. If things still don't work, please check the hostname.err file in the data directory for the reson why things didn't work. Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland ___/ www.mysql.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: Re: MySQL 3.23.44 not using indexes
Hi! Luciano == Luciano Barcaro [EMAIL PROTECTED] writes: Luciano Hi Monty, Luciano Michael Widenius wrote: Hi! Jeremy Is that supposed to happen in 4.0.x? I don't recall having seen a Jeremy commit that affected the key cache yet. Sanja has been trying to do improvements to the key cache code, but we are still not satisfied with this. He just went back to the sub select code, so we can't just now give a definite answer when we have a new key cache. (I am myself totally concentrating on getting 4.0.2-beta out; When this is done I hope to have time to take a look a the key cache problem) Luciano 4.0.2 will be labelled beta ? Yes; 4.0.1 has in practiced work very well for a lot of users. With 4.0.2-beta we are shifting new development (except bug fixes) to the 4.1 tree to ensure that 4.0 will stabilize quickly. Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland ___/ www.mysql.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
replication error
Placed At : Hi.. I'm facing another problem with replication..I have jus one table with over 4 million records in it. I run mysql-3.23.49 on both my master and slave.following is the problem am facing.. I had taken a consistent dump from the master and applied the dump on the slave.and all works fine when i do a show slave status and a show master status. both show me the same same log file position and logfile name.and when any insert happens in the master then the log file postions change on both slave and master.but the count on the slave never increases. i'm not able to find the newly inserted data on the slave even thought the logfile position is in sync with the master.. has anyone faced this problem?? or have I overlooked the obvious.. regards kannan ** Quality Policy To be the best-in-class service provider by practising international standards in providing world-class services and end-to-end network solutions. ** - 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 retrieve the lastest update or insert record?
Dear all I had a table which containing (date/time) field, now i want to retrieve 5 most latest update / insert record from that table, what query should i use? Thx a lot! Jack [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: multi-table delete bug
Hi!
Thank you for your test case.
However, with latest 4.0.2 code I am getting correct results with
it. Difference in number of rows in select and delete are stemming
from the fact that select reports number of rows in result set, while
delete reports total number of rows deleted.
These are results that I get. If you still think that those are not
correct, please let me know.
I get this :
create database xx;
Query OK, 1 row affected (0.00 sec)
use xx;
Database changed
CREATE TABLE `t1` (
`titre` char(80) NOT NULL default '',
`numeropost` mediumint(8) unsigned NOT NULL auto_increment,
`ouvert` tinyint(1) unsigned NOT NULL default '1',
`date` datetime NOT NULL default '-00-00 00:00:00',
`auteur` char(35) NOT NULL default '',
`icone` tinyint(2) unsigned NOT NULL default '0',
`nbrep` mediumint(8) unsigned NOT NULL default '0',
`maxnumrep` int(10) unsigned NOT NULL default '0',
`vue` mediumint(8) unsigned NOT NULL default '0',
`lastauteur` char(35) NOT NULL default '',
`sondage` tinyint(1) NOT NULL default '0',
`next` int(10) NOT NULL default '0',
`prev` int(10) NOT NULL default '0',
`subcat` mediumint(8) unsigned NOT NULL default '0',
PRIMARY KEY (`numeropost`),
KEY `date` (`date`),
KEY `maxnumrep` (`maxnumrep`),
KEY `auteur` (`auteur`),
KEY `sondage` (`sondage`),
KEY `subcat` (`subcat`)
) TYPE=MyISAM;
Query OK, 0 rows affected (0.01 sec)
CREATE TABLE `t2` (
`mot` char(30) NOT NULL default '',
`numreponse` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`mot`,`numreponse`),
KEY `numreponse` (`numreponse`)
) TYPE=MyISAM ROW_FORMAT=FIXED;
Query OK, 0 rows affected (0.00 sec)
CREATE TABLE `t3` (
`topic` mediumint(8) unsigned NOT NULL default '0',
`date` datetime NOT NULL default '-00-00 00:00:00',
`pseudo` char(35) NOT NULL default '',
`numreponse` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`date`,`numreponse`,`topic`),
UNIQUE KEY `pseudo` (`pseudo`,`date`,`numreponse`,`topic`),
UNIQUE KEY `numreponse` (`numreponse`),
KEY `topic` (`topic`)
) TYPE=MyISAM ROW_FORMAT=FIXED;
Query OK, 0 rows affected (0.00 sec)
INSERT INTO t1 (titre) VALUES ('test');
Query OK, 1 row affected (0.00 sec)
INSERT INTO t3 (topic,pseudo) VALUES (1,'joce');
Query OK, 1 row affected (0.00 sec)
INSERT INTO t2 (mot) VALUES
('test'),('joce'),('ouee');
Query OK, 3 rows affected (0.02 sec)
Records: 3 Duplicates: 0 Warnings: 0
mot numreponse topic datepseudo numreponse titre numeropost
ouvert dateauteur icone nbrep maxnumrep vue lastauteur
sondage nextprevsubcat
test0 1 -00-00 00:00:00 joce0 test1 1
-00-00 00:00:00 0 0 0 0 0 0
0 0
joce0 1 -00-00 00:00:00 joce0 test1 1
-00-00 00:00:00 0 0 0 0 0 0
0 0
ouee0 1 -00-00 00:00:00 joce0 test1 1
-00-00 00:00:00 0 0 0 0 0 0
0 0
DELETE FROM t2,t3 USING t2 as a,t3 as
b,t1 as c WHERE b.numreponse=a.numreponse AND
b.topic=c.numeropost AND c.date'2002-05-30';
Query OK, 4 rows affected (0.01 sec)
SELECT * FROM t2 as
a,t3 as b,t1 as c WHERE
b.numreponse=a.numreponse AND b.topic=c.numeropost AND c.date'2002-01-01'
LIMIT 0,30;
Empty set (0.00 sec)
DELETE FROM t2,t3 USING
t2 as a,t3 as
b,t1 as c WHERE b.numreponse=a.numreponse AND
b.topic=c.numeropost AND c.date'2002-05-30';
Query OK, 0 rows affected (0.00 sec)
drop database xx;
Query OK, 0 rows affected (0.01 sec)
mysql quit
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
___/ www.mysql.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 starting server
I keep getting the following error: error: 'Can't connect to MySQL server through the socket '/var/lib/mysql/mysql.sock' (111)' Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists! This wouldn't be a problem, but mysql.sock does exist and when I try to run either mysqld or safe_mysqld, it immediately stops (within a tenth of a second of starting). Any ideas? I'm sure it's my fault, since I just reinstalled the server fresh from the RedHat 7.2 CD and used the OS install to install the MySQL server. Any help would be appreciated. Matt Hargraves - 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
Indexing Question
Hi all, I have developed a system that lets people send messages to each other, with a MySQL database and PHP. Among the tables that exist, one is called Users and contains information such as Username, password (md5'd of course), email address etc. This table has a primary key UserID that is auto-incremented. When I created the table, I also indexed username, to ensure that no two users had the same username. I should also point out that there are two types of users, admin and normal. Admin user are able to add, modify and delete users that belong to them. A little further down the line I have realised that I need to extend my auditing capabilities. Currently, if a message is sent and then a user is deleted, there is no way to tell who sent the message. I am looking for advice on how to manage this, but here is what I have come up with: Add a field called Active, default value=1. When a user is deleted, the value of Active is set to 0. When a user logs in, as well as checking the user name and password, the system checks that the user is active. Works fine, but it means that if an admin user creates a user Ben then deletes that user, they cannot re-create the user because Username is indexed. Because the users still exist in the database, auditing is solved. 1. Does this seem like a good way to do it (the only other alternative that I could think of was to create a Deleted Users table that the rows are moved to, but this seemed to have too many cons compared to the other idea) 2. Assuming that this is a sensible approach to take, how do I un-index the Username field? I know how to alter a table to make it unique, but not how to undo it :) Cheers, Ben - 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: building tree view in mysql?
HI, For trees you need self joins. Could You please explain that ? Regards, At 19:11 23/05/02, Georg Richter wrote: On Thursday, 23. May 2002 16:16, Sagi Bashari wrote: Hi, snip How can I get MySQL to sort it like that? I tried to use group/order by, but I cannot get it to sort it this way.. Any ideas? /snip For trees you need self joins. Regards Georg mysql, query - 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 ___ Hassan El Forkani Founder And Mantainer of : http://WarmAfrica.com EveryOne's Africa Freelance Internet Consultant / Web Applications Developper. Email: [EMAIL PROTECTED] Tel : 0021671880014 ___ - 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
InnoDB and temp. tables
I note by experiment (by observing the content of the binary log) that I get the following actions when trying to use a temporary table during a transaction: -- on creating a temporary table, the create (only) is committed -- on dropping a temporary table, the current transaction is committed All tables are InnoDB, including the temporary table. Using Linux: 3.23.49-max-log What are the rules? Can I use a temporary table to hold temporary results during a transaction, and, if so, will I still be able to use the binary log for recovery purposes? From my experiment, it looks as if I could do so, provided I use a different name each time and I don't drop the temporary tables explicitly, but let them go away when connections are terminated. There aren't many, and this would be acceptable. I'd like to know if it would be safe to do so. (Different names are needed since, in principle, two concurrent transactions could create temporary tables, and the operations on the temporary tables could be interleaved in the binary log.) Note. I get the same actions with a table which is not declared temporary--though, of course, it doesn't go away when the connection does. I wasn't able to find anything on this in the manual. I seem to recall that some other databases--such as Oracle--automatically commit before any DDL statement. sql,query - 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: Connection Problem
Will,
In your $dbh connection handler, you need to change the host=localhost and
database= to just localhost and the database name.
$dbh = DBI-connect (DBI:mysql:localhost;database_name,
**, ***, {PrintError = 0, RaiseError = 1});
On Fri, 24 May 2002 16:43:50 +, Will K. [EMAIL PROTECTED] wrote:
I am trying to get an online database set up and running, but I keep getting
error messages at login.
Here are two sample scripts I have been running (both are from Paul DuBois'
book MySQL and Perl for the Web).
## SCRIPT 1 ##
#! /usr/bin/perl -w
# intro4.pl - generate a Web page using the CGI.pm object-based interface
use strict;
use CGI;
my $cgi = new CGI;
print $cgi-header (),
$cgi-start_html (My Page Title),
$cgi-p (My page body),
$cgi-end_html ();
exit (0);
## SCRIPT 2 ##
#! /usr/bin/perl -w
# intro6.pl - connect to MySQL, retrieve data, write plain text output
use strict;
use DBI;
use CGI qw(:standard);
my ($dbh, $sth, $count);
$dbh = DBI-connect (DBI:mysql:host=localhost;database=***,
**, ***, {PrintError = 0, RaiseError = 1});
$sth = $dbh-prepare (SELECT name, wins, losses FROM teams);
$sth-execute ();
$count = 0;
while (my @val = $sth-fetchrow_array ())
{
Mike(mickalo)Blezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Tel: 1(225)686-2002
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
-
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 mysql-unsubscribe-##L=##[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
replication error
Placed At : Hi.. I'm facing another problem with replication..I have jus one table with over 4 million records in it. I run mysql-3.23.49 on both my master and slave.following is the problem am facing.. I had taken a consistent dump from the master and applied the dump on the slave.and all works fine when i do a show slave status and a show master status. both show me the same same log file position and logfile name.and when any insert happens in the master then the log file postions change on both slave and master.but the count on the slave never increases. i'm not able to find the newly inserted data on the slave even thought the logfile position is in sync with the master.. has anyone faced this problem?? or have I overlooked the obvious.. regards kannan ** Quality Policy To be the best-in-class service provider by practising international standards in providing world-class services and end-to-end network solutions. ** - 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: Newbie--Easy data loading question
-Original Message- From: Menard, Inc. Information Systems Sent: Friday, May 24, 2002 3:44 PM I figured it out but I'm a bit confused as to why it happened. I'm running the load as user1. The file resides at /home/user1/data/filename Permissions: filename 666 data 777 user1 700 I had to change permissions on user1 to 777 in order for it to work. If I'm logged in as that user, why would I have to do that??? 1. I'm a newbie too, so don't be angry if my solution doesn't work. 2. I had similar problem. I changed permissions for my home folder on user mysql. It works. 3. I think, user in MySQL isn't the same as user in linux, despite the same name. I suppose, that there must be permissions for user 'mysql', and MySQL will do the rest. If I'm wrong, please correct me. Slavko Duda-Klimaszewski - 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
2 way replication ?
Hi! I've watched the development of replication on mysql with great joy. However I haven't been able to understand when og if mysql is going to support 2 way replication. In other words. Will it be possible to have 2 databases on 2 different locations, that synchronize with each other in a way, that the users of the databases can change data on both ends and when the link comes up again, the data will be updated both ways. I've read about master/slave relations, but as i can understand, it is only possible to chance data on the master now. If you change data on the slave it wont come on the master. Will that be or is it available on mysql now or in the future? Thanks Greetings from Denmark Bjarne Joergensen [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
2 way replication
Hi! I've watched the development of replication on mysql with great joy. However I haven't been able to understand when og if mysql is going to support 2 way replication. In other words. Will it be possible to have 2 databases on 2 different locations, that synchronize with each other in a way, that the users of the databases can change data on both ends and when the link comes up again, the data will be updated both ways. I've read about master/slave relations, but as i can understand, it is only possible to chance data on the master now. If you change data on the slave it wont come on the master. Will that be or is it available on mysql now or in the future? Thanks Greetings from Denmark Bjarne Joergensen [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: INSERT IF NOT EXISTS?
On Monday 27 May 2002 10:59, Markus Lervik wrote: (filter fodder: sql, query) Hello group! Quick question: Is there a simple way to do something like INSERT IF NOT EXISTS, other than first doing a SELECT and checking if it returns any rows? If not, that would be pretty high up on my whish-list : ) Yes: INSERT IGNORE INTO ... You can read more at http://www.mysql.com/doc/I/N/INSERT.html -- João Paulo Vasconcellos Gerente de Tecnologia - NetCard Tel. 21 3852-9008 Ramal 31 [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: ODBC Questions
It gave me an error saying error in SQL syntaz at CREATE TABLE.. I think that's because your query does not look to me like valid MS Access SQL syntax. is the SQL sytnax exactly the same as 'normal' SQL syntax? Both Access and MySQL implement quite a lot of standard SQL syntax (if that's what you mean by normal), and both implement their own extensions. If you throw proprietary MySQL SQL syntax at Access it won't like it, and vice versa. You will need to read the Access documentation to find out what is allowed and how to spell it. Just as I had to read the MySQL documentation to find the different way I had to do things I was used to doing in Access. Tim Ward Brett Ward Limited - www.brettward.co.uk - 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
BLOB field and ADO
Greetings! Has anyone ever had the following problem with ADO ODBC connection: I create a table with a BLOB field. From MySQL shell I update that field using insert into statement and all works perfectly. But when I try to execute that query from VB usnig ADO and ODBC connection (MyODBC 2.50 or 3.51) it results with a new record, but the value in the BLOB field is always Null. Notice that it only happens with BLOB fields in combination with ODBC. Thank You Bruno - 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 retrieve the lastest update or insert record?
Hi Jack select * from TableName order by DateTimeField DESC limit 5 Should do it. Peter At 05:04 PM 5/27/2002 +0800, Jack wrote: Dear all I had a table which containing (date/time) field, now i want to retrieve 5 most latest update / insert record from that table, what query should i use? Thx a lot! Jack [EMAIL PROTECTED] - Please check http://www.mysql.com/Manual_chapter/manual_toc.html; before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail [EMAIL PROTECTED] instead. - 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: Indexing Question
Since I been working implementing some triggers in my system recently this suggestion first came into my mind: create a delete trigger for the user table. Every time a user it deleted, the trigger fires and could for example moves this information to a history table, with date of deletion, etc. This table could then be scanned in case no user was found. -Original Message- From: Ben Holness [mailto:[EMAIL PROTECTED]] Sent: Sunday, May 26, 2002 9:48 PM To: [EMAIL PROTECTED] Subject: Indexing Question Hi all, I have developed a system that lets people send messages to each other, with a MySQL database and PHP. Among the tables that exist, one is called Users and contains information such as Username, password (md5'd of course), email address etc. This table has a primary key UserID that is auto-incremented. When I created the table, I also indexed username, to ensure that no two users had the same username. I should also point out that there are two types of users, admin and normal. Admin user are able to add, modify and delete users that belong to them. A little further down the line I have realised that I need to extend my auditing capabilities. Currently, if a message is sent and then a user is deleted, there is no way to tell who sent the message. I am looking for advice on how to manage this, but here is what I have come up with: Add a field called Active, default value=1. When a user is deleted, the value of Active is set to 0. When a user logs in, as well as checking the user name and password, the system checks that the user is active. Works fine, but it means that if an admin user creates a user Ben then deletes that user, they cannot re-create the user because Username is indexed. Because the users still exist in the database, auditing is solved. 1. Does this seem like a good way to do it (the only other alternative that I could think of was to create a Deleted Users table that the rows are moved to, but this seemed to have too many cons compared to the other idea) 2. Assuming that this is a sensible approach to take, how do I un-index the Username field? I know how to alter a table to make it unique, but not how to undo it :) Cheers, Ben - 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: Indexing Question
Why not have the application check for existing usernames, if one exists,present the info the admin user and ask if this is the user they are trying to create, if yes, then change the active flag, if not, tell them they need to choose a different username. That way your auditing and your unique indexing is preserved. Andrew Hazen -Original Message- From: Ben Holness [mailto:[EMAIL PROTECTED]] Sent: Sunday, May 26, 2002 3:48 PM To: [EMAIL PROTECTED] Subject: Indexing Question Hi all, I have developed a system that lets people send messages to each other, with a MySQL database and PHP. Among the tables that exist, one is called Users and contains information such as Username, password (md5'd of course), email address etc. This table has a primary key UserID that is auto-incremented. When I created the table, I also indexed username, to ensure that no two users had the same username. I should also point out that there are two types of users, admin and normal. Admin user are able to add, modify and delete users that belong to them. A little further down the line I have realised that I need to extend my auditing capabilities. Currently, if a message is sent and then a user is deleted, there is no way to tell who sent the message. I am looking for advice on how to manage this, but here is what I have come up with: Add a field called Active, default value=1. When a user is deleted, the value of Active is set to 0. When a user logs in, as well as checking the user name and password, the system checks that the user is active. Works fine, but it means that if an admin user creates a user Ben then deletes that user, they cannot re-create the user because Username is indexed. Because the users still exist in the database, auditing is solved. 1. Does this seem like a good way to do it (the only other alternative that I could think of was to create a Deleted Users table that the rows are moved to, but this seemed to have too many cons compared to the other idea) 2. Assuming that this is a sensible approach to take, how do I un-index the Username field? I know how to alter a table to make it unique, but not how to undo it :) Cheers, Ben - 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
synopsis of the problem (one line)
Description: How-To-Repeat: Fix: Submitter-Id: submitter ID Originator:root Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: Severity: Priority: Category: mysql Class: Release: mysql-3.23.49a (Official MySQL RPM) Environment: System: Linux linux 2.4.7-10 #1 Thu Sep 6 17:27:27 EDT 2001 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-98) Compilation info: CC='gcc' CFLAGS='-O6 -fno-omit-frame-pointer -mpentium' CXX='gcc' CXXFLAGS='-O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 5ÔÂ 22 04:49 /lib/libc.so.6 - libc-2.2.4.so -rwxr-xr-x2 root root 1282588 9ÔÂ 5 2001 /lib/libc-2.2.4.so -rw-r--r--1 root root 27304836 9ÔÂ 5 2001 /usr/lib/libc.a -rw-r--r--1 root root 178 9ÔÂ 5 2001 /usr/lib/libc.so Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --with-other-libc=/usr/local/mysql-glibc --without-berkeley-db --without-innodb --enable-assembler --enable-local-infile --with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ --with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/info --includedir=/usr/include --mandir=/usr/man '--with-comment=Official MySQL RPM' CC=gcc 'CFLAGS=-O6 -fno-omit-frame-pointer -mpentium' 'CXXFLAGS=-O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' CXX=gcc - 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: Newbie question: Which is better InnoDB or BDB?
Hello. On Thu, May 23, 2002 at 11:53:49AM -0400, [EMAIL PROTECTED] wrote: Hello, I'm new to MySql. I plan to switch my Java/JDBC web application to use MySql. The application requires transactions so, as I understand it, I need the table types to be BDB or InnoDB. Can anyone offer comments on which file type is preferred? Is one more stable than another? InnoDB is more actively supported. Is there a significant difference in speed? Answers to such statements always depend on your kind of usage. I have looked in the manual. One difference I saw was page locking versus record locking. At this point, I'm not sure that difference is significant. That's the point. As long as you are not sure about your needs, there is no reason to bother. Just start with the table type which looks nicer to you at first glance. If you should learn that it doesn't fit your needs, the other table types are only one ALTER TABLE command away. Regards, Benjamin. -- [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: How to retrieve the lastest update or insert record?
Dear Jack, If (date/time) field means the last time updated or inserted, how about this; select * from [the table] order by (date/time) desc limit 1, 5; -Original Message- From: Jack [mailto:[EMAIL PROTECTED]] Sent: Monday, May 27, 2002 6:05 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: How to retrieve the lastest update or insert record? Dear all I had a table which containing (date/time) field, now i want to retrieve 5 most latest update / insert record from that table, what query should i use? Thx a lot! Jack [EMAIL PROTECTED] - Please check http://www.mysql.com/Manual_chapter/manual_toc.html; before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail [EMAIL PROTECTED] instead. - 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
Visualizing the shema of the db
Hi there, I am wondering if there is a software (free or shareware) which is visualizing the shema (table strukture) of the mysql database. thanx for any hint, Andy query - 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: Replication problem
Hi. As I have seen no answer yet, just a wild guess: Maybe you have some query which used both databases, something like INSERT INTO fdf.whatever SELECT FROM access.pagespromo ... You can always use the binlog utilities and have a look at the query which caused the failure. Regards, Benjamin. On Thu, May 23, 2002 at 12:54:29PM -0400, [EMAIL PROTECTED] wrote: Hi all, I have master - Linux 7.2, mysql-4.0.1 and slave - win2000, mysql-4.0.1. I have the following error on my replication server: Table 'access.pagespromo' doesn't exist. Slave error 'Table 'access.pagespromo' doesn't exist.' on query '%' error-code=1146. Error running query, slave aborted. But on my slave I make replication only on database fdf: [...] and on my master I am logging only database fdf -- [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
Any Luck Running Threaded Client on Win95 and/or WinNT
Hi, I am running MySQL 3.23.44 and MyODBC 2.50.39. I am developing a client application that submits queries to MySQL. The queries are threaded. The Win2000 version runs great, but I have problems running on Win95 and WinNT. I was curious to see if anyone has created a threaded client on those platforms that works. Thanx for any feedback. -- *** John Shackelford Tritera Incorporated *** - 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 / Firewall
Hi, The firewall doesn't have an entry for the MySQL service, so I create a user-defined service and fill in the following details: SourcePort Low: 3306 SourcePort High: 3306 DestPort Low: 3306 DestPort High: 3306 Transport: TCP (choices are TCP-6, UDP-17, and Other) Your problem here is that the source port for connections to your MySQL server won't be coming from port 3306. In fact, the client chooses a random port. That's why your connections are failing in the client, because it can't initiate the connection in the first place. So, you need to specify a source port of 'any' instead of 3306. Regards, Basil Hussain --- Internet Developer, Kodak Weddings 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
Re: Indexing words
Hi. If FULLTEXT indexes are out of question, what your suggestion is the way to go. Although I would usually use an additional table: CREATE TABLE places ( idp INT(8) NOT NULL, place CHAR(32), /* Ex: New York */ PRIMARY KEY(idp) ); CREATE TABLE tokens ( idt INT(8) NOT NULL AUTO_INCREMENT, token CHAR(32), /* Ex: New OR York */ PRIMARY KEY (idt), UNIQUE KEY (token) ); CREATE TABLE token2places ( idt INT(8) NOT NULL, idp INT(8) NOT NULL, PRIMARY KEY (idt,idp) ); The above is the standard approach for implementing a M to N relationship. Inserts become a bit more complex, selects usually faster. If your tables are rather small or the indexed strings consist seldom of more than one or two words, the additional effort may not be worthwhile. Above I have tried to keep your design as far as possible. IMHO, you should consider if you really need the range of INT for the different ids or use a smaller type like MEDIUMINT instead. Regards, Benjamin. On Thu, May 23, 2002 at 05:09:36PM -0300, [EMAIL PROTECTED] wrote: We have an application that needs to index every word (token) in a name, separately. Ex: New York must be indexed under New and York. One solution is to create an auxiliary table, extract the tokens one word at a time, and cross-reference to the key of the original table. Ex: CREATE TABLE places ( idp INT(8) NOT NULL, place CHAR(32), /* Ex: New York */ PRIMARY KEY(idp) ) CREATE TABLE tokens ( idt INT(8) NOT NULL AUTO_INCREMENT, token CHAR(32), /* Ex: New OR York */ idp INT(8) /* refers to same key in 'places' */ PRIMARY KEY (idt), INDEX (token) ) Is there a faster/more elegant way to do this? 'FULLTEXT' is not suitable. (Please forgive my naïveté, I am new to MySQL). [...] -- [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: Servers Tables
Hi. Sounds as if you should start with reading the manual or a good tutorial (some are listed in the manual): http://www.mysql.com/documentation/index.html Regards, Benjamin. On Fri, May 24, 2002 at 09:34:28AM -0400, [EMAIL PROTECTED] wrote: I just got ViewPoint, which generates web based graphical stats for firewall use. It collects syslog data, and it stores the data in mySQL. These web based stats only display data for one day at a time (you get to choose your day), and does not serve my needs, so I want to get into the data that is being stored. To start with I want to simply browse the data and the tables. If I can do that, then I want to start using custom reports I will build using ASP, populating the report through SELECT statements. I spent a long time reading the MySQL manual and archives, but could not figure out my problems. I'm in a Windows based environment, and mySQL is running on a Win200 Pro Workstation. How do I log in and see the table layout and data? How do I create a connection to access the tables and data from my ASPs? [...] -- [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: What files are these?
Batara, Sunday, May 26, 2002, 11:11:25 AM, you wrote: BK I have some very big files in my /var/lib/mysql. BK [root@nias mysql]# ls -l nias-bin* BK -rw-rw1 mysqlmysql1073741921 5$B7n(B 8 04:33 nias-bin.001 BK -rw-rw1 mysqlmysql875448838 5$B7n(B 9 18:31 nias-bin.002 BK -rw-rw1 mysqlmysql 86 5$B7n(B 9 19:36 nias-bin.003 BK -rw-rw1 mysqlmysql1073741901 5$B7n(B 12 04:32 nias-bin.004 BK -rw-rw1 mysqlmysql1073741885 5$B7n(B 14 04:35 nias-bin.005 BK -rw-rw1 mysqlmysql1073741878 5$B7n(B 16 04:37 nias-bin.006 BK -rw-rw1 mysqlmysql1073741948 5$B7n(B 18 04:39 nias-bin.007 BK -rw-rw1 mysqlmysql750078444 5$B7n(B 20 03:25 nias-bin.008 BK -rw-rw1 mysqlmysql1073742339 5$B7n(B 22 04:32 nias-bin.009 BK -rw-rw1 mysqlmysql1073742314 5$B7n(B 24 04:32 nias-bin.010 BK -rw-rw1 mysqlmysql1073742497 5$B7n(B 26 04:32 nias-bin.011 BK -rw-rw1 mysqlmysql453278435 5$B7n(B 26 04:51 nias-bin.012 BK -rw-rw1 mysqlmysql 180 5$B7n(B 26 04:32 nias-bin.index BK What files are them? Is it ok to delete all of them? Since I am running BK out of space. These are log files. Your MySQL server is running with --log-bin option. take a look at: http://www.mysql.com/doc/B/i/Binary_log.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.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: INSERT IF NOT EXISTS?
Markus, Monday, May 27, 2002, 4:59:30 PM, you wrote: ML Is there a simple way to do something like INSERT IF NOT EXISTS, ML other than first doing a SELECT and checking if it returns any rows? ML If not, that would be pretty high up on my whish-list : ) You can use IGNORE keyword in INSERT statement, but it's not quite the same as INSERT IF NOT EXIST. If you specify IGNORE, any rows that duplicate an existing PRIMARY or UNIQUE key in the table will be ignored in INSERT: http://www.mysql.com/doc/I/N/INSERT.html Also check REPLACE statement: http://www.mysql.com/doc/R/E/REPLACE.html ML Cheers, ML Markus -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.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: Problem starting server
Matt, Monday, May 27, 2002, 9:20:32 AM, you wrote: MH I keep getting the following error: MH error: 'Can't connect to MySQL server through the socket MH '/var/lib/mysql/mysql.sock' (111)' MH Check that mysqld is running and that the socket: MH '/var/lib/mysql/mysql.sock' exists! MH This wouldn't be a problem, but mysql.sock does exist and when I try to run MH either mysqld or safe_mysqld, it immediately stops (within a tenth of a MH second of starting). MH Any ideas? I'm sure it's my fault, since I just reinstalled the server MH fresh from the RedHat 7.2 CD and used the OS install to install the MySQL MH server. If your mysql.sock exists, check where is it located and specify path to your mysql.sock with --socket option. Please, check the following link: http://www.mysql.com/doc/C/a/Can_not_connect_to_server.html MH Any help would be appreciated. MH Matt Hargraves -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.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: bug in dynamic linker?
Neil, Friday, May 24, 2002, 8:14:08 PM, you wrote: NZ I have a script with INSERT statements. I run it quite often and NZ today for the first time I got the following message while inserting NZ from the mysql client: NZ BUG IN DYNAMIC LINKER ld.so: rtld.c: 621: dl_main: Assertion NZ `_dl_rtld_map.l_libname' failed! NZ I simply reran the script and it worked fine. NZ Any ideas of what the problem was here? NZ Just thought I'd report it. The version NZ of MySQL is 3.22.32 so that may be a NZ little bit old. You have an outdated version of MySQL. It would be better to upgrade MySQL server to a newer version. NZ Thanks, NZ Neil -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.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: Read Only on User table
Hi. AFAIK, a table is considered read only, if either the underlying filesystem says so (what you called OS attribute) or it is a compressed table. If it would be a problem with the privileges, you would rather get an error like Access denied for ... to So your problem is quite probably that the user, the MySQL daemon is running as, has not right to access the database file. I do not know how it is supposed to look like under NT or how to change it as I do not use NT. Regards, Benjamin. On Fri, May 24, 2002 at 10:04:49AM -0400, [EMAIL PROTECTED] wrote: Hi, I'm rather new to MySQL and trying to figure out GRANT and REVOKE so a password is required for access. Both GRANT and REVOKE give errors saying Table 'User' is read only. A text search in the manual for read only did not yield anything. Is this an OS attribute that should be dealt with manually, such as with Windows-NT explorer or DOS ATTRIB? Or is there a MySQL command that should be used to make tables read-only and read-write? Thanks, Rick -- [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: What files are these?
These are binary update log files. They keep track of all updates to your database. They are often used when restoring from a backup and also are required for replication. You can doa FLUSH LOGS and then move away the old logs or delete them if that is what you want to do. Be sure to always leave the log that is currently in use. You can check out for more information: http://www.mysql.com/doc/L/o/Log_file_maintenance.html Harrison On Sun, 26 May 2002, Batara Kesuma wrote: I have some very big files in my /var/lib/mysql. [root@nias mysql]# ls -l nias-bin* -rw-rw1 mysqlmysql1073741921 5$B7n(B 8 04:33 nias-bin.001 -rw-rw1 mysqlmysql875448838 5$B7n(B 9 18:31 nias-bin.002 -rw-rw1 mysqlmysql 86 5$B7n(B 9 19:36 nias-bin.003 -rw-rw1 mysqlmysql1073741901 5$B7n(B 12 04:32 nias-bin.004 -rw-rw1 mysqlmysql1073741885 5$B7n(B 14 04:35 nias-bin.005 -rw-rw1 mysqlmysql1073741878 5$B7n(B 16 04:37 nias-bin.006 -rw-rw1 mysqlmysql1073741948 5$B7n(B 18 04:39 nias-bin.007 -rw-rw1 mysqlmysql750078444 5$B7n(B 20 03:25 nias-bin.008 -rw-rw1 mysqlmysql1073742339 5$B7n(B 22 04:32 nias-bin.009 -rw-rw1 mysqlmysql1073742314 5$B7n(B 24 04:32 nias-bin.010 -rw-rw1 mysqlmysql1073742497 5$B7n(B 26 04:32 nias-bin.011 -rw-rw1 mysqlmysql453278435 5$B7n(B 26 04:51 nias-bin.012 -rw-rw1 mysqlmysql 180 5$B7n(B 26 04:32 nias-bin.index What files are them? Is it ok to delete all of them? Since I am running out of space. - 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
The silence...
Wow, what happened today ? Never saw that list so quiet. SQL. -- João Paulo Vasconcellos Gerente de Tecnologia - NetCard Tel. 21 3852-9008 Ramal 31 [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
Replication out of sync
My replication became out of sync. (Which in turn seems to rewrite my master.info with some garbage) In this particular instance, the LOG_FILE name had a bunch of spaces appended to it, and the PORT got changed to 0. The slave was running, but not going anywhere of course. Usually I can just reset the LOG_FILE name and the replication would resume. The port was still at 0, and replication resumed!! So I changed the PORT to 3306, and then my replication stopped. It tried to resume from -bin.001, so I switched it to the last known LOG_FILE and LOG_POS and replication will not resume. And of course I tried to start it multiple times. Below is the entries in the err file. What I would like to know, is how can I get this kick started again, and would there have been some corruption occur (it would have been trying to do some inserts and updates) 020527 9:41:43 Error reading packet from server: Could not find first log (read_errno 0,server_errno=65535) 020527 9:42:43 Slave: Failed reading log event, reconnecting to retry, log 'QBSLXDB1-bin.044 ' position 1683820 020527 9:42:44 Slave: reconnected to master '[EMAIL PROTECTED]:0',replication resumed in log 'QBSLXDB1-bin.044 ' at position 1683820 020527 9:42:44 Error reading packet from server: Could not find first log (read_errno 0,server_errno=65535) 020527 9:43:44 Slave: Failed reading log event, reconnecting to retry, log 'QBSLXDB1-bin.044 ' position 1683820 020527 9:43:44 Slave: reconnected to master '[EMAIL PROTECTED]:0',replication resumed in log 'QBSLXDB1-bin.044 ' at position 1683820 020527 9:43:44 Error reading packet from server: Could not find first log (read_errno 0,server_errno=65535) 020527 9:43:49 Slave thread exiting, replication stopped in log 'QBSLXDB1-bin.044 ' at position 1683820 020527 9:43:49 Slave: connected to master '[EMAIL PROTECTED]:0', replication started in log 'QBSLXDB1-bin.044' at position 1683820 020527 9:44:34 Slave thread exiting, replication stopped in log 'QBSLXDB1-bin.044' at position 2753978 020527 9:44:34 Slave: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'FIRST' at position 4 ERROR: 1062 Duplicate entry '242' for key 1 020527 9:44:35 Slave: error running query 'INSERT INTO REPORT (CreateStamp) VALUES (NOW())' 020527 9:44:35 Error running query, slave aborted. Fix the problem, and re-start the slave thread with mysqladmin start-slave - log 'QBSLXDB1-bin.001' position 841 020527 9:44:35 Slave thread exiting, replication stopped in log 'QBSLXDB1-bin.001' at position 841 020527 9:46:08 Slave: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'QBSLXDB1-bin.044' at position 2337362 ERROR: 1062 Duplicate entry '2234960' for key 1 020527 9:46:08 Slave: error running query 'INSERT INTO DISPATCHLOG (CreateStamp) VALUES (NOW())' 020527 9:46:08 Error running query, slave aborted. Fix the problem, and re-start the slave thread with mysqladmin start-slave - log 'QBSLXDB1-bin.044' position 2338640 020527 9:46:08 Slave thread exiting, replication stopped in log 'QBSLXDB1-bin.044' at position 2338640 020527 9:46:15 Slave: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'QBSLXDB1-bin.044' at position 2338640 ERROR: 1062 Duplicate entry '2234961' for key 1 020527 9:46:15 Slave: error running query 'INSERT INTO DISPATCHLOG (CreateStamp) VALUES (NOW())' 020527 9:46:15 Error running query, slave aborted. Fix the problem, and re-start the slave thread with mysqladmin start-slave - log 'QBSLXDB1-bin.044' position 2339258 020527 9:46:15 Slave thread exiting, replication stopped in log 'QBSLXDB1-bin.044' at position 2339258 020527 9:54:42 Slave: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'QBSLXDB1-bin.044' at position 2753978 ERROR: 1062 Duplicate entry '2235105' for key 1 020527 9:54:43 Slave: error running query 'INSERT INTO DISPATCHLOG (CreateStamp) VALUES (NOW())' 020527 9:54:43 Error running query, slave aborted. Fix the problem, and re-start the slave thread with mysqladmin start-slave - log 'QBSLXDB1-bin.044' position 2757402 020527 9:54:43 Slave thread exiting, replication stopped in log 'QBSLXDB1-bin.044' at position 2757402 020527 10:09:57 Slave: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'QBSLXDB1-bin.044' at position 2753978 ERROR: 1062 Duplicate entry '294169' for key 1 020527 10:09:58 Slave: error running query 'INSERT INTO ORDERHEADER (CreateStamp) VALUES (NOW())' 020527 10:09:58 Error running query, slave aborted. Fix the problem, and re-start the slave thread with mysqladmin start-slave - log 'QBSLXDB1-bin.044' position 2753978 020527 10:09:58 Slave thread exiting, replication stopped in log 'QBSLXDB1-bin.044' at position 2753978 - Before posting, please check: http://www.mysql.com/manual.php (the manual)
Re: multi-table delete bug
Hi!
I still can not reproduce your case.
I first ran this script:
create database xx;
use xx;
CREATE TABLE `t1` (
`titre` char(80) NOT NULL default '',
`numeropost` mediumint(8) unsigned NOT NULL auto_increment,
`ouvert` tinyint(1) unsigned NOT NULL default '1',
`date` datetime NOT NULL default '-00-00 00:00:00',
`auteur` char(35) NOT NULL default '',
`icone` tinyint(2) unsigned NOT NULL default '0',
`nbrep` mediumint(8) unsigned NOT NULL default '0',
`maxnumrep` int(10) unsigned NOT NULL default '0',
`vue` mediumint(8) unsigned NOT NULL default '0',
`lastauteur` char(35) NOT NULL default '',
`sondage` tinyint(1) NOT NULL default '0',
`next` int(10) NOT NULL default '0',
`prev` int(10) NOT NULL default '0',
`subcat` mediumint(8) unsigned NOT NULL default '0',
PRIMARY KEY (`numeropost`),
KEY `date` (`date`),
KEY `maxnumrep` (`maxnumrep`),
KEY `auteur` (`auteur`),
KEY `sondage` (`sondage`),
KEY `subcat` (`subcat`)
) TYPE=MyISAM;
CREATE TABLE `t2` (
`mot` char(30) NOT NULL default '',
`numreponse` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`mot`,`numreponse`),
KEY `numreponse` (`numreponse`)
) TYPE=MyISAM ROW_FORMAT=FIXED;
CREATE TABLE `t3` (
`topic` mediumint(8) unsigned NOT NULL default '0',
`date` datetime NOT NULL default '-00-00 00:00:00',
`pseudo` char(35) NOT NULL default '',
`numreponse` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`date`,`numreponse`,`topic`),
UNIQUE KEY `pseudo` (`pseudo`,`date`,`numreponse`,`topic`),
UNIQUE KEY `numreponse` (`numreponse`),
KEY `topic` (`topic`)
) TYPE=MyISAM ROW_FORMAT=FIXED;
INSERT INTO t1 (titre) VALUES ('test');
INSERT INTO t3 (topic,pseudo) VALUES (1,'joce');
INSERT INTO t2 (mot) VALUES
('test'),('joce'),('ouee');
Then I ran `mysqladmin shutdown`.
Then I ran this script :
use xx;
DELETE FROM t2,t3 USING t2 as a,t3 as
b,t1 as c WHERE b.numreponse=a.numreponse AND
b.topic=c.numeropost AND c.date'2002-05-30';
I get 4 rows here
SELECT * FROM t2 as
a,t3 as b,t1 as c WHERE
b.numreponse=a.numreponse AND b.topic=c.numeropost AND c.date'2002-01-01'
LIMIT 0,30;
0 here .
DELETE FROM t2,t3 USING
t2 as a,t3 as
b,t1 as c WHERE b.numreponse=a.numreponse AND
b.topic=c.numeropost AND c.date'2002-05-30';
and 0 here
I ran latest mysqld 4.0.2 with these options:
--one-thread --datadir=/usr/local/var --skip-stack-trace --core-file
I also tried without --one-thread and still have got the above result.
Please check if I did something wrong.
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
___/ www.mysql.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: Visualizing the shema of the db
Hello andy, http://www.datanamic.com/ a Hi there, a I am wondering if there is a software (free or shareware) which is a visualizing the shema (table strukture) of the mysql database. a thanx for any hint, a Andy a query a - a Before posting, please check: ahttp://www.mysql.com/manual.php (the manual) ahttp://lists.mysql.com/ (the list archive) a To request this thread, e-mail [EMAIL PROTECTED] a To unsubscribe, e-mail [EMAIL PROTECTED] a Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Best regards, Yegor __ Yegor Bryukhov, PhD student at GC CUNY office: 4330 office phone: +1(212)817-8653 home phone: +1(718)842-4250 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
Re: BLOB field and ADO
view this article, it's work fine with vb6 : http://support.microsoft.com/default.aspx?scid=kb;EN-US;q194975 ' insert Dim ts As String, Sql As String Dim RS Set RS = CreateObject(ADODB.Recordset) RS.CursorLocation = adUseServer RS.Open tbl_test, CreateConnexionString(CnxSGDB), 3, 2, 2 RS.AddNew ' create a new record FileToBlob c:\test\barre.bmp, RS!test RS.Update RS.Close ' select Sql = select * from tbl_test order by ID desc Limit 1 Set tstcnxADO = New ADODB.Connection tstcnxADO.ConnectionString = CreateConnexionString(CnxSGDB) tstcnxADO.CursorLocation = adUseServer tstcnxADO.Open If tstcnxADO.State = adStateOpen Then Set RS = New ADODB.Recordset RS.Open Sql, tstcnxADO, adOpenStatic, adLockReadOnly BlobToFile RS!test, c:\test\testmysql.bmp, RS!test.ActualSize RS.Close tstcnxADO.Close End If Bien a vous Philippe http://www.devparadise.com/ - Original Message - From: Bruno Batarelo [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, May 27, 2002 3:04 PM Subject: BLOB field and ADO Greetings! Has anyone ever had the following problem with ADO ODBC connection: I create a table with a BLOB field. From MySQL shell I update that field using insert into statement and all works perfectly. But when I try to execute that query from VB usnig ADO and ODBC connection (MyODBC 2.50 or 3.51) it results with a new record, but the value in the BLOB field is always Null. Notice that it only happens with BLOB fields in combination with ODBC. Thank You Bruno - 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: A Proprietary MySQL Business Model
On Mon, 27 May 2002, Solomon John HART wrote: How much third party software is incorporated into the non-GPL version of MySQL. Obviously the included software can't itself be under the GPL. How does MySQL get around this? Does MySQL have contracts with contributors instead of contributions being under the GPL? It seems like an interesting business model and one that deserves attention. Some keypoints: 1. There is some non-GPL code in MySQL. But this software uses less restrictive licences than GPL. Public Domain for example, so you should not be worried about it. There is no reason to get around it. 2. Yes, MySQL has contracts with all needed parties. I also wrote some code to MySQL and have signed contract. 3. Yes, it is interesting model in software world but actually it is not so new model at all. For example if you get free ticket to cinema then you don't expect receive free DVD too ? :). This is dual licencing and any author of any inntelectual property is allowed to do so. GPL is privilege, not limitation (for users) and does nut put handcuffs on authors hands. Tonu - 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
Approximate(?) numeric data types WAS: Indexing words
CREATE TABLE places ( idp INT(8) NOT NULL, Contex: SQL, database Just curious, but is this a 8-bit (smalint maybe?) or approximate 8-byte integer? - 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: query
did you try MAX(ID)? cheers, Ki Mien -Original Message- From: Myk Melez [EMAIL PROTECTED] Sent: Saturday, May 25, 2002 1:41 AM To: saraswathy saras [EMAIL PROTECTED], mysql [EMAIL PROTECTED] Subject:Re: query saraswathy saras wrote: is there any other specific command instead order by ID DESC to select all the record from table where the ID is the last ID.The ID is autoincrement. Not sure from your message if you already know this, but ORDER BY ID DESC LIMIT 1 gives you what you want. -myk mysql, query - 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 Take part in the Penning on Squares Chinese Essay Writing Contest. Submit your masterpieces or vote for your favourite works, and win attractive prizes. Be there or be SQUARE! http://sea.litcontest.lycosasia.com cOntact @ Lycos http://contact.lycosasia.com = 20MB for email and filestore + lots of other goodies... - 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: INSERT IF NOT EXISTS?
And one of the built-ins work on totally general cases: they restrict you to duplication of unique keys. If you want a general insert-if-not-condition format, you can do your full insert into a temporary table, left join that table against the real table on your general condition and selecting those rows which did *not* match (leaving null in the second-table fields) into a second temporary table (since you can't select and insert into the same table in one query), and then insert that entire second table into the original. Annoying and picky, but you can do the whole thing with no client-side language support and you can even set the DELAYED flag on all three statements. Just watch your synchronization since it's no longer a one-statement operation... On 27/5/02 at 5:14 pm, Victoria Reznichenko [EMAIL PROTECTED] wrote: Markus, Monday, May 27, 2002, 4:59:30 PM, you wrote: ML Is there a simple way to do something like INSERT IF NOT EXISTS, ML other than first doing a SELECT and checking if it returns any rows? ML If not, that would be pretty high up on my whish-list : ) You can use IGNORE keyword in INSERT statement, but it's not quite the same as INSERT IF NOT EXIST. If you specify IGNORE, any rows that duplicate an existing PRIMARY or UNIQUE key in the table will be ignored in INSERT: http://www.mysql.com/doc/I/N/INSERT.html Also check REPLACE statement: http://www.mysql.com/doc/R/E/REPLACE.html ML Cheers, ML Markus -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.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
triggers and stored procudures
Hi all, I would like to find out if anyone here has any experience writing stored prods and triggers in mySQL. Hopefully someone can tell me which version of mySQL is more stable if I want to write stored prods and triggers. cheers, Ki Mien Take part in the Penning on Squares Chinese Essay Writing Contest. Submit your masterpieces or vote for your favourite works, and win attractive prizes. Be there or be SQUARE! http://sea.litcontest.lycosasia.com cOntact @ Lycos http://contact.lycosasia.com = 20MB for email and filestore + lots of other goodies... - 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
Fw: Problem starting server
I keep getting the following error: error: 'Can't connect to MySQL server through the socket '/var/lib/mysql/mysql.sock' (111) 'Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists! This wouldn't be a problem, but mysql.sock does exist and when I try to run either mysqld or safe_mysqld, it immediately stops (within a tenth of a second of starting). Any ideas? I'm sure it's my fault, since I just reinstalled the server fresh from the RedHat 7.2 CD and used the OS install to install the MySQL server. Any help would be appreciated. Matt Hargraves - 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: Visualizing the shema of the db
andy, Monday, May 27, 2002, 4:48:24 PM, you wrote: a I am wondering if there is a software (free or shareware) which is a visualizing the shema (table strukture) of the mysql database. What about MyCC? http://www.mysql.com/downloads/gui-mycc.html a thanx for any hint, a Andy a query -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.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: triggers and stored procudures
Ki, Monday, May 27, 2002, 6:41:02 PM, you wrote: KM I would like to find out if anyone here has any experience writing stored prods and triggers in mySQL. KM Hopefully someone can tell me which version of mySQL is more stable if I want to write stored prods and triggers. Stored procedures and triggers are not supported in MySQL yet. Look at: http://www.mysql.com/doc/A/N/ANSI_diff_Triggers.html KM cheers, KM Ki Mien -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.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
binary update log: configure by database, not daemon?
Greetings, We plan to use the binary update log plus backups to enable us to restore databases and then re-apply updates when necessary. It appears to me that the binary update log contains updates to all databases on the mysqld-max process, and that there is no way to keep a separate binary update log for each database. Is there any simple way to restore and apply updates to one database on the server but not any of the others? We're running MySQL-max 3.23-49 with BDB tables on both RedHat linux 6.2 (for production) and Win 2000/XP (for development). Thanks, Jim Hopp [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: Indexing words
Is this approach still of use if many more tables are added? so basically you create a lot of 'relations' tables to store key relations rather than store the relation in each table? olinux --- Benjamin Pflugmann [EMAIL PROTECTED] wrote: Hi. If FULLTEXT indexes are out of question, what your suggestion is the way to go. Although I would usually use an additional table: CREATE TABLE places ( idp INT(8) NOT NULL, place CHAR(32), /* Ex: New York */ PRIMARY KEY(idp) ); CREATE TABLE tokens ( idt INT(8) NOT NULL AUTO_INCREMENT, token CHAR(32), /* Ex: New OR York */ PRIMARY KEY (idt), UNIQUE KEY (token) ); CREATE TABLE token2places ( idt INT(8) NOT NULL, idp INT(8) NOT NULL, PRIMARY KEY (idt,idp) ); __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.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: Fw: Problem starting server
On 27/5/02 at 12:47, [EMAIL PROTECTED] (Matt Hargraves) wrote: I keep getting the following error: error: 'Can't connect to MySQL server through the socket '/var/lib/mysql/mysql.sock' (111) 'Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists! Try the manual: http://www.mysql.com/doc/C/a/Can_not_connect_to_server.html HTH, Regards, Phil. - 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: building tree view in mysql?
create a table like this: id | parent_id | category parent_id points to the parent categories id. Top level categories get parent_id of '0' ex: 1 | 0 | auto 2 | 1 | repair 3 | 2 | body 4 | 2 | windshields 5 | 1 | detailing 6 | 2 | tires Tree would look like: auto repair body windshields tires detailing olinux --- hassan [EMAIL PROTECTED] wrote: HI, For trees you need self joins. Could You please explain that ? Regards, At 19:11 23/05/02, Georg Richter wrote: On Thursday, 23. May 2002 16:16, Sagi Bashari wrote: Hi, snip How can I get MySQL to sort it like that? I tried to use group/order by, but I cannot get it to sort it this way.. Any ideas? /snip For trees you need self joins. Regards Georg mysql, query - 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 ___ Hassan El Forkani Founder And Mantainer of : http://WarmAfrica.com EveryOne's Africa Freelance Internet Consultant / Web Applications Developper. Email: [EMAIL PROTECTED] Tel : 0021671880014 ___ - 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 __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.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: building tree view in mysql?
Yeah, thats exactly what I wanted to do. But how do I make MySQL sort it like that? Show the parent first, and then all its childs, so the application can determite if it's subcategory by checking if the parent is was changed. Sagi From: olinux [EMAIL PROTECTED] create a table like this: id | parent_id | category parent_id points to the parent categories id. Top level categories get parent_id of '0' ex: 1 | 0 | auto 2 | 1 | repair 3 | 2 | body 4 | 2 | windshields 5 | 1 | detailing 6 | 2 | tires Tree would look like: auto repair body windshields tires detailing olinux - 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
SV: building tree view in mysql?
Well you'll neew to do some coding in your application language. What are you using to connect to MySQL? Perl? PHP? Java? Tell me, and I'll give you an example where you only query the database once (for optimum performance). - Carsten -Oprindelig meddelelse- Fra: Sagi Bashari [mailto:[EMAIL PROTECTED]] Sendt: 27. maj 2002 20:50 Til: olinux; [EMAIL PROTECTED]; [EMAIL PROTECTED] Emne: Re: building tree view in mysql? Yeah, thats exactly what I wanted to do. But how do I make MySQL sort it like that? Show the parent first, and then all its childs, so the application can determite if it's subcategory by checking if the parent is was changed. Sagi From: olinux [EMAIL PROTECTED] create a table like this: id | parent_id | category parent_id points to the parent categories id. Top level categories get parent_id of '0' ex: 1 | 0 | auto 2 | 1 | repair 3 | 2 | body 4 | 2 | windshields 5 | 1 | detailing 6 | 2 | tires Tree would look like: auto repair body windshields tires detailing olinux - 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: Fw: Problem starting server
Been there, done that. Didn't change a thing.
Guess I should have changed the e-mail before resending it, but I'm not
really sure what the problem is. The server won't start for more than a
tenth of a second. Here's what happens when I try to start mysqld:
[root@server mysql]# safe_mysqld
Starting mysql daemon with databases from /var/lib/mysql
020527 02:26:27 mysql ended
Both statements ('Starting...' and '0205...') pop up within a tenth of a
second of each-other and when I check processes, there is nothing that
starts with 'my' running.
Does that help?
- Original Message -
From: Phil Dobbin [EMAIL PROTECTED]
To: Matt Hargraves [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, May 27, 2002 1:32 PM
Subject: Re: Fw: Problem starting server
On 27/5/02 at 12:47, [EMAIL PROTECTED] (Matt
Hargraves) wrote:
I keep getting the following error:
error: 'Can't connect to MySQL server through the socket
'/var/lib/mysql/mysql.sock' (111) 'Check that mysqld is running and
that the
socket: '/var/lib/mysql/mysql.sock' exists!
Try the manual:
http://www.mysql.com/doc/C/a/Can_not_connect_to_server.html
HTH,
Regards,
Phil.
-
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
InnoDB logs
Hello, I have a couple of questions regarding InnoDB logs' structure. -Are the innodb logs stored in the main innodb tablespace? -How is the information stored in the logs? Does it look like SQL queries as the mysql binary update logs do? -What is the difference between the mysql binary logs and the innodb logs? (apart from the fact that update logs are used in case of a manual recovery and innodb logs are used in case of a automatic recovery.) Thanks in advance, Balteo. - 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
timestamp(8) GROUP BY problem
Description: Problem with timestamp(8) and GROUP BY How-To-Repeat: mysql CREATE TABLE test ( - id int auto_increment, - dd timestamp(8), - data int, - PRIMARY KEY (id) - ); Query OK, 0 rows affected (0.01 sec) mysql INSERT INTO test (data) VALUES(1),(2),(3),(4); Query OK, 4 rows affected (0.00 sec) Records: 4 Duplicates: 0 Warnings: 0 mysql SELECT * FROM test; ++--+--+ | id | dd | data | ++--+--+ | 1 | 20020527 |1 | | 2 | 20020527 |2 | | 3 | 20020527 |3 | | 4 | 20020527 |4 | ++--+--+ 4 rows in set (0.00 sec) mysql SELECT dd,count(*) FROM test GROUP BY dd; +--+--+ | dd | count(*) | +--+--+ | 20020527 |4 | +--+--+ 1 row in set (0.00 sec) mysql UPDATE test SET dd='2002052701' WHERE id=1; Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql UPDATE test SET dd='2002052702' WHERE id=2; Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql UPDATE test SET dd='2002052703' WHERE id=3; Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql UPDATE test SET dd='2002052704' WHERE id=4; Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql SELECT dd,count(*) FROM test GROUP BY dd; +--+--+ | dd | count(*) | +--+--+ | 20020527 |1 | | 20020527 |1 | | 20020527 |1 | | 20020527 |1 | +--+--+ 4 rows in set (0.00 sec) Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.23.49a-max-log Protocol version10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 65 days 4 hours 9 min 10 sec Threads: 6 Questions: 69973912 Slow queries: 688 Opens: 129933 Flush tables: 3 Open tables: 506 Queries per second avg: 12.427 Environment: System: Linux gap 2.4.18 #3 SMP Fri Mar 15 14:40:03 EET 2002 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i486-suse-linux/2.95.3/specs gcc version 2.95.3 20010315 (SuSE) Compilation info: CC='gcc' CFLAGS='-Wimplicit -Wreturn-type -Wid-clash-51 -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wimplicit-function-dec -Wimplicit-int -Wparentheses -Wsign-compare -Wwrite-strings -Wunused -mcpu=pentiumpro -O3 -fno-omit-frame-pointer' CXX='gcc' CXXFLAGS='-Wimplicit -Wreturn-type -Wid-clash-51 -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wimplicit-function-dec -Wimplicit-int -Wparentheses -Wsign-compare -Wwrite-strings -Woverloaded-virtual -Wextern-inline -Wsign-promo -Wreorder -Wctor-dtor-privacy -Wnon-virtual-dtor -felide-constructors -fno-exceptions -fno-rtti -mcpu=pentiumpro -O3 -fno-omit-frame-pointer' LDFLAGS='' LIBC: -rwxr-xr-x1 root root 1384040 Dec 18 18:24 /lib/libc.so.6 -rw-r--r--1 root root 25214756 Dec 18 18:07 /usr/lib/libc.a -rw-r--r--1 root root 178 Dec 18 18:07 /usr/lib/libc.so Configure command: ./configure --prefix=/usr/local/mysql --enable-assembler --with-extra-charsets=complex --enable-thread-safe-client --with-innodb --with-berkeley-db --enable-thread-safe-client --with-other-libc=/usr/local/mysql-glibc '--with-comment=Official MySQL Binary' --prefix=/usr/local/mysql --with-extra-charset=complex --enable-thread-safe-client --enable-local-infile --with-server-suffix=-max 'CFLAGS=-Wimplicit -Wreturn-type -Wid-clash-51 -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wimplicit-function-dec -Wimplicit-int -Wparentheses -Wsign-compare -Wwrite-strings -Wunused -mcpu=pentiumpro -O3 -fno-omit-frame-pointer' 'CXXFLAGS=-Wimplicit -Wreturn-type -Wid-clash-51 -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wimplicit-function-dec -Wimplicit-int -Wparentheses -Wsign-compare -Wwrite-strings -Woverloaded-virtual -Wextern-inline -Wsign-promo -Wreorder -Wctor-dtor-privacy -Wnon-virtual-dtor -felide-constructors -fno-exceptions -fno-r! tti -mcpu=pentiumpro -O3 -fno-omit-frame-pointer' CXX=gcc - 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: InnoDB logs
Guys, i get the following error. What does this mean? DBI-connect(myskycastle) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at teamstats.pl line 16 - 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
Shared message queue?
I have a bunch of processes running on the same machine that should be able to send unicast, multicast and broadcast messages to each other. Messages should be received in the same order that they were sent. I'm trying to figure out how to implement that. These processes are already sharing the same MySQL database, so I'm thinking that a process which wants to send a message could INSERT it into a table, then another process can SELECT it to read it. This would seem to require all processes to constantly poll the table, though, so I'm thinking maybe I should use something other than MySQL for the shared message queue functionality... Suggestions? Should I: (1) use MySQL as I described above, (2) use MySQL with some other method I haven't thought of, or (3) use something else? - 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: Fw: Problem starting server
On 27/5/02 at 14:39, [EMAIL PROTECTED] (Matt Hargraves) wrote:
Been there, done that. Didn't change a thing.
Guess I should have changed the e-mail before resending it, but I'm
not
really sure what the problem is. The server won't start for more than
a
tenth of a second. Here's what happens when I try to start mysqld:
[root@server mysql]# safe_mysqld
Starting mysql daemon with databases from /var/lib/mysql
020527 02:26:27 mysql ended
Both statements ('Starting...' and '0205...') pop up within a tenth of
a
second of each-other and when I check processes, there is nothing that
starts with 'my' running.
Does that help?
Not really. Try looking in /usr/local/mysql/bin where on most *nixs the start-up
script resides (safe_mysqld).
To modify it there is a file called /etc/rc.local (or rc.local). See if this has been
altered. There is also the error log called hostname.err which will give you (and
anybody else trying to help) a more verbose message than the one you've posted.
Regards,
Phil.
p.s. I'm getting a Sorry. Your message could not be delivered to:
w3d3demo (Mailbox or Conference is full.) when posting to your address (in the To:
Field).
- Original Message -
From: Phil Dobbin [EMAIL PROTECTED]
To: Matt Hargraves [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, May 27, 2002 1:32 PM
Subject: Re: Fw: Problem starting server
On 27/5/02 at 12:47, [EMAIL PROTECTED] (Matt
Hargraves) wrote:
I keep getting the following error:
error: 'Can't connect to MySQL server through the socket
'/var/lib/mysql/mysql.sock' (111) 'Check that mysqld is running
and
that the
socket: '/var/lib/mysql/mysql.sock' exists!
Try the manual:
http://www.mysql.com/doc/C/a/Can_not_connect_to_server.html
HTH,
Regards,
Phil.
-
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]
com
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: Approximate(?) numeric data types WAS: Indexing words
Hi. On Mon, May 27, 2002 at 05:21:20PM +0200, [EMAIL PROTECTED] wrote: CREATE TABLE places ( idp INT(8) NOT NULL, Contex: SQL, database Just curious, but is this a 8-bit (smalint maybe?) or approximate 8-byte integer? That is an 4 byte integer with an supposed display-width of 8 characters. See http://www.mysql.com/doc/C/o/Column_types.html Bye, Benjamin. -- [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: The silence...
On Fri, May 24, 2002 at 06:17:09PM -0300, João Paulo Vasconcellos wrote: Wow, what happened today ? Never saw that list so quiet. The machine hosting the lists was unavailable for the past several days. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 4.0.2: up 3 days, processed 34,666,349 queries (115/sec. avg) - 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: Indexing words
Hello. On Mon, May 27, 2002 at 10:31:52AM -0700, [EMAIL PROTECTED] wrote: Is this approach still of use if many more tables are added? As I said (in the not-quoted part) [This] is the standard approach for implementing a M to N relationship. so basically you create a lot of 'relations' tables to store key relations rather than store the relation in each table? Not any relation. Only for M-to-N relations. This is basic database theory and because I am not good at technical explanations, I suggest you to read about normalization in some tutorial/book. In the original example the need is not so obvious, because no additional attributes are used. That was also the reason why I said that one could argue whether that step is wanted there. Regards, Benjamin. -- [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: Fw: Problem starting server
- Original Message -
From: Matt Hargraves [EMAIL PROTECTED]
To: Phil Dobbin [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, May 27, 2002 8:39 PM
Subject: Re: Fw: Problem starting server
Been there, done that. Didn't change a thing.
[root@server mysql]# safe_mysqld
Starting mysql daemon with databases from /var/lib/mysql
020527 02:26:27 mysql ended
Both statements ('Starting...' and '0205...') pop up within a tenth
of a second of each-other and when I check processes, there is
nothing that starts with 'my' running.
Does that help?
Been there, had that done to me too. :)
I had compiled MySQL with innodb support; but you specifically need to
confige that in your /etc/my.cnf before mysqld will run. When I ran
safe_mysqld the first time, it immediately exited too. So, I added,
skip-innodb
(without the quotes, of course), to my /etc/my.cnf, and it ran like a charm
ever since. :)
You have given us too little information about your setup (you may actually
wanna use innodb, for instance), but it is worth checking out.
P.S. As for your MySQL client saying,
error: 'Can't connect to MySQL server through the socket
'/var/lib/mysql/mysql.sock' (111)'
Check that mysqld is running and that the socket:
'/var/lib/mysql/mysql.sock' exists!
You may wanna make sure the new compile actually places the sock in
/var/lib/mysql/, and not in /tmp/ (the latter is default, I believe). As you
were about to check your /etc/my.cnf anyway, you may look into that too.
- Mark
-
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
MyODBC connection to Linux MySQL
Hi, I tried to connect to a mysql database running on a linux server using an odbc connection in windows 98. I get the following message: [TCX][MyODBC]Host x.x.x.x is not allowed to connect to this MySQL server (#1130)[Microsoft][ODBC Driver Manager] Connection not open (#0) The username specified in the data source name is root and I can ping the server where MySQLis running. What did I do wrong or did not do at all on client or server side? Plase help me. __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.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: building tree view in mysql?
I'm using PHP From: Carsten Gehling [EMAIL PROTECTED] Well you'll neew to do some coding in your application language. What are you using to connect to MySQL? Perl? PHP? Java? Tell me, and I'll give you an example where you only query the database once (for optimum performance). - Carsten -Oprindelig meddelelse- Fra: Sagi Bashari [mailto:[EMAIL PROTECTED]] Sendt: 27. maj 2002 20:50 Til: olinux; [EMAIL PROTECTED]; [EMAIL PROTECTED] Emne: Re: building tree view in mysql? Yeah, thats exactly what I wanted to do. But how do I make MySQL sort it like that? Show the parent first, and then all its childs, so the application can determite if it's subcategory by checking if the parent is was changed. Sagi From: olinux [EMAIL PROTECTED] create a table like this: id | parent_id | category parent_id points to the parent categories id. Top level categories get parent_id of '0' ex: 1 | 0 | auto 2 | 1 | repair 3 | 2 | body 4 | 2 | windshields 5 | 1 | detailing 6 | 2 | tires Tree would look like: auto repair body windshields tires detailing olinux - 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: Visualizing the shema of the db
I think most of the data modeling tools (ERwin, SilverRun RDM, for example) will reverse engineer your schema into them. Have not tried the two I specifically mention with MySQL, but they have reverse engineering functionality. HTH Mike - Original Message - From: Yegor N. Bryukhov [EMAIL PROTECTED] To: [EMAIL PROTECTED]; andy [EMAIL PROTECTED] Sent: Monday, May 27, 2002 10:54 AM Subject: Re: Visualizing the shema of the db Hello andy, http://www.datanamic.com/ a Hi there, a I am wondering if there is a software (free or shareware) which is a visualizing the shema (table strukture) of the mysql database. a thanx for any hint, a Andy a query a - a Before posting, please check: ahttp://www.mysql.com/manual.php (the manual) ahttp://lists.mysql.com/ (the list archive) a To request this thread, e-mail [EMAIL PROTECTED] a To unsubscribe, e-mail [EMAIL PROTECTED] a Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Best regards, Yegor __ Yegor Bryukhov, PhD student at GC CUNY office: 4330 office phone: +1(212)817-8653 home phone: +1(718)842-4250 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 - 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: Fw: Problem starting server
OK, that helps a lot. There is no '/usr/local/mysql directory' Any chance that this is different in RedHat? There is very little in the rc.local file and nothing having to do with mysql. Matt - Original Message - From: Phil Dobbin [EMAIL PROTECTED] To: Matt Hargraves [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, May 27, 2002 3:56 PM Subject: Re: Fw: Problem starting server Not really. Try looking in /usr/local/mysql/bin where on most *nixs the start-up script resides (safe_mysqld). To modify it there is a file called /etc/rc.local (or rc.local). See if this has been altered. There is also the error log called hostname.err which will give you (and anybody else trying to help) a more verbose message than the one you've posted. Regards, Phil. p.s. I'm getting a Sorry. Your message could not be delivered to: w3d3demo (Mailbox or Conference is full.) when posting to your address (in the To: Field). - Original Message - From: Phil Dobbin [EMAIL PROTECTED] To: Matt Hargraves [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, May 27, 2002 1:32 PM Subject: Re: Fw: Problem starting server On 27/5/02 at 12:47, [EMAIL PROTECTED] (Matt Hargraves) wrote: I keep getting the following error: error: 'Can't connect to MySQL server through the socket '/var/lib/mysql/mysql.sock' (111) 'Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists! Try the manual: http://www.mysql.com/doc/C/a/Can_not_connect_to_server.html HTH, Regards, Phil. - 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] com 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 - 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
ODBC Connection to Linux MySQL
Hi, I tried to connect to a mysql database running on a linux server using an odbc connection in windows 98. I get the following message: [TCX][MyODBC]Host x.x.x.x is not allowed to connect to this MySQL server (#1130)[Microsoft][ODBC Driver Manager] Connection not open (#0) The username specified in the data source name is root and I can ping the server where MySQLis running. What did I do wrong or did not do at all on client or server side? Plase help me. __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.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: InnoDB logs
On Mon, May 27, 2002 at 01:33:30PM -0600, Sherzod B. Ruzmetov wrote: Guys, i get the following error. What does this mean? DBI-connect(myskycastle) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at teamstats.pl line 16 Please *don't* hijack message threads. This has *nothing* to do witih InnoDB logs. -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 4.0.2: up 3 days, processed 34,969,270 queries (114/sec. avg) - 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: Is the list server down?
On Sun, May 26, 2002 at 01:35:00PM -0700, Jeremy P. McKay wrote: I haven't seen a mysql question since friday? It was, yes. -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 4.0.2: up 3 days, processed 35,009,784 queries (114/sec. avg) - 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
