Re: Newbie: How do I copy over a new database?
A file with extension .sql is an SQL set of statements. Perhaps it is the CREATE TABLE query to create the table in MySQL. You can open the .sql file with any trxt editor and examine the query it contains. HTH Mike - Original Message - From: "Doug Coning" <[EMAIL PROTECTED]> To: "MySQL List" <[EMAIL PROTECTED]> Sent: Friday, May 17, 2002 11:45 PM Subject: Newbie: How do I copy over a new database? > Please forgive this easy question from a newbie: > > I was given a MySQL database file from a client with a .sql extension. I > already have several databases setup and running under MySQL on our server. > But how would I copy this new database over? Do I need to load it or can I > copy it as is into a directory. > > Please advise. > > Thanks in advance! > > Doug Coning > > > - > 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
Newbie: How do I copy over a new database?
Please forgive this easy question from a newbie: I was given a MySQL database file from a client with a .sql extension. I already have several databases setup and running under MySQL on our server. But how would I copy this new database over? Do I need to load it or can I copy it as is into a directory. Please advise. Thanks in advance! Doug Coning - 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: Remote admin of MySQL from Win 2K
Unless I am missing something (and that is very likely), MySQL is installed on the "closed" Yahoo RaQ-4 Cobalt server. Now on my Linux server*, I had to go in as root and enter a user and give what servers are allowed to access it. With the yahoo server, the *only* access is via a Web page. When I tried to access MySQL mysqladmin, it said the the URL that was attempting the access was not allowed. Of course, the URL was that of my ISP. I have told my client that either they need a server with full access rights *or* put the DB on my Linux server (not really on the top of my list - not my business). Todd * This is the first time I have ever used MySQL and I am trying to see if I can around not being able to access Interbase (my usual DBMS). -- Todd Cary Ariste Software 2200 D Street Extension Petaluma, CA 94952 707-773-4523 [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: MyISAM -> Innodb
- Original Message - From: "Sherzod Ruzmetov" <[EMAIL PROTECTED]> To: "Edilson Vasconcelos de Melo Junior" <[EMAIL PROTECTED]>; "MYSQL" <[EMAIL PROTECTED]> Sent: Saturday, May 18, 2002 12:29 AM Subject: Re: MyISAM -> Innodb > I heard about Innodb here a lot, but where can i find more info > about it. I search mysql manuals, but no results. > > Any resources? I am getting real interested too. :) I took a look at the manual, but I did not see answers to a simple question like whether innodb files are compatible (query-wise) with MyISAM tables, for instance, or whether I need to rewrite all queries. Perhaps a guru here could explain this. My MySQL powered news server I am building may not contain the world's most vital data; but in case of a crash, all clients connected would have their message-ID tables screwed up permanently. And it seems like innodb can handle crash-recovery a lot better than MyISAM tables. Would anyone be willing to shed some light on this? Thanks! - 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: MyISAM -> Innodb
Or goto http://www.innodb.com of course. Ric. - Original Message - From: "Dan Nelson" <[EMAIL PROTECTED]> To: "Sherzod Ruzmetov" <[EMAIL PROTECTED]> Cc: "Edilson Vasconcelos de Melo Junior" <[EMAIL PROTECTED]>; "MYSQL" <[EMAIL PROTECTED]> Sent: Friday, May 17, 2002 11:49 PM Subject: Re: MyISAM -> Innodb > In the last episode (May 17), Sherzod Ruzmetov said: > > I heard about Innodb here a lot, but where can i find more info about > > it. I search mysql manuals, but no results. > > Try the mysql manual :) > > Chapter "MySQL Table Types", Section "InnoDB Tables" > > http://www.mysql.com/doc/I/n/InnoDB.html > > -- > Dan Nelson > [EMAIL PROTECTED] > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - 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
Check tables?
Hello, Is there a way I can do a "CHECK TABLES" which will return an exit code of some sort, to use in a shell-script? Looking at the output of a myisamchk is fun, but I rather have a utility too that will report an error-status that I can use to decide whether to make a backup/restore, etc. Thanks - Mark P.S. Keeping the bot happy: mysql - 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: Alter table and add cell at a time.
You have a different row for each answer because each answer has its own INSERT. A solution would be to do a single INSERT (with quiz question or some other data) and then for each answer do an: UPDATE $table SET $value2='$value' WHERE id='$question_id' You'd just have to keep track of the row ID (which would be the primary key in this example). Nice to see quiz software being built by an .EDU! Ron Jamison -Original Message- From: Jule [mailto:[EMAIL PROTECTED]] Sent: Friday, May 17, 2002 5:27 PM To: [EMAIL PROTECTED] Subject: Alter table and add cell at a time. Quick little followup question: if i have this: for ($n = 1; $n <= $quiz[number_answers]; $n++) { $table = $qcode."_answers"; $value = $answers["answer".$n]; $value2 = "answer".$n; $query_alter_table = "ALTER TABLE $table ADD $value2 TEXT NOT NULL"; $query_add_answers = "INSERT INTO $table ($value2) VALUES('$value')"; if (mysql_db_query($database_glob, $query_alter_table, $link_glob)) { if (mysql_db_query($database_glob, $query_add_answers, $link_glob)) { echo "Answer $n: $value has successfully been added to the Quiz\n"; } else { echo mysql_error() ." 1"; } } else { echo mysql_error()." 2"; } } How do I get the $value to be in the same row as the preceding one? now it comes like this: ++-+-+-+-+ | id | answer1 | answer2 | answer3 | answer4 | ++-+-+-+-+ | 1 | answer1 | | | | | 2 | | answer2 | | | | 3 | | | answer3 | | | 4 | | | | answer4 | ++-+-+-+-+ so it's like this? ++-+-+-+-+ | id | answer1 | answer2 | answer3 | answer4 | ++-+-+-+-+ | 1 | answer1 | answer2 | answer3 | answer4 | ++-+-+-+-+ thanks, Jule On Friday 17 May 2002 19:17, you wrote: > Hello, > > Try using "NOT NULL". As weird as MySQL can be, don't think it is > that NUTty. =) > > Harrison > > - Original Message - > From: "Jule" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Friday, May 17, 2002 7:00 PM > Subject: "ALTER TABLE $table ADD $value2 TEXT NUT NULL" > > > Hey i'm getting this error: > > You have an error in your SQL syntax near 'NUT NULL' at line 1 > > when i run this query, > > "ALTER TABLE $table ADD $value2 TEXT NUT NULL" > > from the documentation i understood that this was the correct > notation. > > any ideas? > thanks > Jule > -- > > |\/\__/\/| > | Jule Slootbeek | > | [EMAIL PROTECTED] | > | http://blindtheory.cjb.net | > | __ | > |/\/ \/\| > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > > - > 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 -- |\/\__/\/| | Jule Slootbeek | | [EMAIL PROTECTED]| | http://blindtheory.cjb.net | | __ | |/\/ \/\| - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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
Alter table and add cell at a time.
Quick little followup question: if i have this: for ($n = 1; $n <= $quiz[number_answers]; $n++) { $table = $qcode."_answers"; $value = $answers["answer".$n]; $value2 = "answer".$n; $query_alter_table = "ALTER TABLE $table ADD $value2 TEXT NOT NULL"; $query_add_answers = "INSERT INTO $table ($value2) VALUES('$value')"; if (mysql_db_query($database_glob, $query_alter_table, $link_glob)) { if (mysql_db_query($database_glob, $query_add_answers, $link_glob)) { echo "Answer $n: $value has successfully been added to the Quiz\n"; } else { echo mysql_error() ." 1"; } } else { echo mysql_error()." 2"; } } How do I get the $value to be in the same row as the preceding one? now it comes like this: ++-+-+-+-+ | id | answer1 | answer2 | answer3 | answer4 | ++-+-+-+-+ | 1 | answer1 | | | | | 2 | | answer2 | | | | 3 | | | answer3 | | | 4 | | | | answer4 | ++-+-+-+-+ so it's like this? ++-+-+-+-+ | id | answer1 | answer2 | answer3 | answer4 | ++-+-+-+-+ | 1 | answer1 | answer2 | answer3 | answer4 | ++-+-+-+-+ thanks, Jule On Friday 17 May 2002 19:17, you wrote: > Hello, > > Try using "NOT NULL". As weird as MySQL can be, don't think it is that > NUTty. =) > > Harrison > > - Original Message - > From: "Jule" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Friday, May 17, 2002 7:00 PM > Subject: "ALTER TABLE $table ADD $value2 TEXT NUT NULL" > > > Hey i'm getting this error: > > You have an error in your SQL syntax near 'NUT NULL' at line 1 > > when i run this query, > > "ALTER TABLE $table ADD $value2 TEXT NUT NULL" > > from the documentation i understood that this was the correct notation. > > any ideas? > thanks > Jule > -- > > |\/\__/\/| > | Jule Slootbeek | > | [EMAIL PROTECTED] | > | http://blindtheory.cjb.net | > | __ | > |/\/ \/\| > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > > - > 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 -- |\/\__/\/| | Jule Slootbeek | | [EMAIL PROTECTED]| | http://blindtheory.cjb.net | | __ | |/\/ \/\| - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: "ALTER TABLE $table ADD $value2 TEXT NUT NULL"
Hello, Try using "NOT NULL". As weird as MySQL can be, don't think it is that NUTty. =) Harrison - Original Message - From: "Jule" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, May 17, 2002 7:00 PM Subject: "ALTER TABLE $table ADD $value2 TEXT NUT NULL" Hey i'm getting this error: You have an error in your SQL syntax near 'NUT NULL' at line 1 when i run this query, "ALTER TABLE $table ADD $value2 TEXT NUT NULL" from the documentation i understood that this was the correct notation. any ideas? thanks Jule -- |\/\__/\/| | Jule Slootbeek | | [EMAIL PROTECTED] | | http://blindtheory.cjb.net | | __ | |/\/ \/\| - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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: "ALTER TABLE $table ADD $value2 TEXT NUT NULL"
Hello, Try using "NOT NULL". As weird as MySQL can be, don't think it is that NUTty. =) Harrison - Original Message - From: "Jule" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, May 17, 2002 7:00 PM Subject: "ALTER TABLE $table ADD $value2 TEXT NUT NULL" Hey i'm getting this error: You have an error in your SQL syntax near 'NUT NULL' at line 1 when i run this query, "ALTER TABLE $table ADD $value2 TEXT NUT NULL" from the documentation i understood that this was the correct notation. any ideas? thanks Jule -- |\/\__/\/| | Jule Slootbeek | | [EMAIL PROTECTED] | | http://blindtheory.cjb.net | | __ | |/\/ \/\| - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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
"ALTER TABLE $table ADD $value2 TEXT NUT NULL"
Hey i'm getting this error: You have an error in your SQL syntax near 'NUT NULL' at line 1 when i run this query, "ALTER TABLE $table ADD $value2 TEXT NUT NULL" from the documentation i understood that this was the correct notation. any ideas? thanks Jule -- |\/\__/\/| | Jule Slootbeek | | [EMAIL PROTECTED]| | http://blindtheory.cjb.net | | __ | |/\/ \/\| - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MyISAM -> Innodb
In the last episode (May 17), Sherzod Ruzmetov said: > I heard about Innodb here a lot, but where can i find more info about > it. I search mysql manuals, but no results. Try the mysql manual :) Chapter "MySQL Table Types", Section "InnoDB Tables" http://www.mysql.com/doc/I/n/InnoDB.html -- Dan Nelson [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MyISAM -> Innodb
I heard about Innodb here a lot, but where can i find more info about it. I search mysql manuals, but no results. Any resources? > Hi, > > I have a lot of MyISAM table that i wanna convert ot Innodb. They don't > have any foreign keys nor BLOB or TEXT column as index. How should i do > this? Should i just "ALTER TABLE mytable TYPE=Innodb"? Is there any risk? > > Thank u very much, > Edilson. > > Edilson Vasconcelos de Melo Junior > [EMAIL PROTECTED] > (19) 3256-3577 > ICQ 136192234 > > 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 > 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: MyISAM -> Innodb
I heard about Innodb here a lot, but where can i find more info about it. I search mysql manuals, but no results. Any resources? > Hi, > > I have a lot of MyISAM table that i wanna convert ot Innodb. They don't > have any foreign keys nor BLOB or TEXT column as index. How should i do > this? Should i just "ALTER TABLE mytable TYPE=Innodb"? Is there any risk? > > Thank u very much, > Edilson. > > Edilson Vasconcelos de Melo Junior > [EMAIL PROTECTED] > (19) 3256-3577 > ICQ 136192234 > > 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 > 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: MyISAM -> Innodb
I heard about Innodb here a lot, but where can i find more info about it. I search mysql manuals, but no results. Any resources? > Hi, > > I have a lot of MyISAM table that i wanna convert ot Innodb. They don't > have any foreign keys nor BLOB or TEXT column as index. How should i do > this? Should i just "ALTER TABLE mytable TYPE=Innodb"? Is there any risk? > > Thank u very much, > Edilson. > > Edilson Vasconcelos de Melo Junior > [EMAIL PROTECTED] > (19) 3256-3577 > ICQ 136192234 > > 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 > 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
MyISAM -> Innodb
Hi, I have a lot of MyISAM table that i wanna convert ot Innodb. They don't have any foreign keys nor BLOB or TEXT column as index. How should i do this? Should i just "ALTER TABLE mytable TYPE=Innodb"? Is there any risk? Thank u very much, Edilson. Edilson Vasconcelos de Melo Junior [EMAIL PROTECTED] (19) 3256-3577 ICQ 136192234 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
[Fwd: Add existing related data to a table]
Sorry, I've been too long in a list where you just answer the questioner and then the questioner writes a summary of the answers to the list. Sabine Sabine Richter wrote: > > Hello Alexander, > > your problem is near to Taylor Lewick's and I have a similar suggestion > for you: > > 1) create newtab >select tableA.*, tableB.SubcatID >from tableA.*, tableB >where ... > 2) delete tablea > 3) rename table newtab to tablea > > If there are more rows in tableB (1:n), you don't loose data. The data > of tabA > will be dublicated. > > Ok, that are 3 statements. > > Bye > Sabine > > Alexander Shaw wrote: > > > > Hi, > > > > I'm looking for some suggestions of making a one time update to some of my > > tables to make them useable with new forms and queries I'm creating. I have > > a series of tables which hold related data and only the last part of the > > data is stored in a final table, which means to search data based on > > > > some of the information higher up the table structure is making some very > > complex and dodgy queries. > > > > I want to insert the related data into the final table but can't think of a > > way of doing it. The example below might help me explain better what I mean. > > > > Consider two tables - TableA which contains PicID and KeywordID > > > > TableB which contains SubcatID and KeywordID > > > > What I want to do is insert the corresponding values for relating to > > KeywordID for SubCatID into a new column in TableA. > > > > Any suggestions how to work this to add the extra information to existing > > records? > > > > Alex > > > > -- > > > > Alexander Shaw > > Agricultural Stock and Assignment Photography > > > > p.s. to get throught he spam trap - sql query > > > > --- > > Outgoing mail is certified Virus Free. > > Checked by AVG anti-virus system (http://www.grisoft.com). > > Version: 6.0.360 / Virus Database: 199 - Release Date: 07/05/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 <[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
[Fwd: Joining same table twice for different rows -- possible?]
Sorry, I've been too long in a list where you just answer the questioner and then the questioner writes a summary of the answers to the list. Sabine Sabine Richter wrote: > > Hi Ron, > > I suspect users.id and userid1 / userid2 have to be joined? > > Then: > > select your_desired_cols > from users u1, users u2, log > where u1.id=log.userid1 > and u2.id=log.userid2; > > Bye > Sabine > > Ron Jamison wrote: > > > > Hi, > > > > Consider the following schema: > > > > Database.Users: > > id > > username > > > > Database.Log: > > id > > userid1 > > userid2 > > entry > > > > If I'm SELECT'ing on the Log table and I want to pull usernames out of > > Users table for both users (which will most likely be unique) is there a > > specific JOIN for this? Forgive me if I've missed something in the > > manual pages; I've always had to do two SELECTs and thus have been > > looking for a quick[er] solution to this for some time now. > > > > Thank you in advance! > > > > Ron Jamison > > > > (moderators: although I've looked at the manual page plenty of times > > before, http://www.mysql.com/doc/manual.php?search_query=join today > > produced the following: > > > > "Search results > > > > Did you mean jan? > > > > The search for 'join' produced no results " -- kind of ironic) > > - 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
[Fwd: mysql query question]
Sorry, I've been too long in a list where you just answer the questioner and then the questioner writes a summary of the answers to the list. Sabine Sabine Richter wrote: > > Hello Taylor, > > as far as I see from the documentation and own trials you can just > delete from table where conditions_of_this_table. > So you can not delete values matching a temp table. > But I think I have a possible workaround for you: > > 1: create a new table with the opposite of your question, i.e. the rows > both tables have in common: > --> create table interim select table1.* > from table1, table2 where table1.ticker_name = table2.ticker_name; > 2. delete table1 > 3. rename table interim to table1 > > I think that will do what you want. > > Bye > Sabine > > Taylor Lewick wrote: > > > > How can I delete from a table the results of a join query.. > > > > I.e, join two tables together, get the resutls, now want to delete that data from >one of the tables... > > Do I have to create a tempory table, hold the data, and delete from the one table >data matching in the temp table, > > or can I just combine a delete statement with my original query...? > > > > here is my query, which works.. > > > > select distinct table1.ticker_name > > from table1 LEFT JOIN on table2 on (table1.ticker_name = table2.ticker_name) > > where table2.ticker_name IS NULL; > > > > Thanks, > > Taylor > > > > Taylor Lewick > > Unix System Administrator > > Fortis Benefits > > 816 881 6073 > > > > "Help Wanted. Seeking Telepath..." > > "You Know where to apply." > > > > > > Please Note > > The information in this E-mail message is legally privileged > > and confidential information intended only for the use of the > > individual(s) named above. If you, the reader of this message, > > are not the intended recipient, you are hereby notified that > > you should not further disseminate, distribute, or forward this > > E-mail message. If you have received this E-mail in error, > > please notify the sender. Thank you > > * > > > > - > > 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: How to Load a Database to other Server
don't forget to check the grant's! -Original Message- From: Dave Watkinson [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 12:32 PM To: Jack; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: How to Load a Database to other Server not sure about the Linux guys, but if you're using Windows just copy the directory for your database (in the mysql\data directory) to the new server. Restart MySQL Server on new machine Cheers Dave -Original Message- From: Jack [mailto:[EMAIL PROTECTED]] Sent: 16 May 2002 10:05 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: How to Load a Database to other Server Dear all I had a mysql Database in one of my Server, now i want to transfer this whole Database to another Server, what should i do? 1. How i can export this Database to a file 2. How i can Load this File into my another Server which create a database exactly same as the old Server? 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. - 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: How to limit database size?
At 10:28 AM 5/17/2002, you wrote: >Hello, > >- Original Message - >From: "Egor Egorov" <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]> >Sent: Friday, May 17, 2002 1:42 PM >Subject: Re: How to limit database size? >[how to limit database size?] > > > > You can't do it with MySQL, use disk quotas ... > > > >Thanks for your answer. > >What happens if a user tries to add more data to a table after the files >containing his database reached the hard disk quota limit. Does it make any >diffrence which file (.frm .myi .myd) reaches the disk quota limit ? > >Alexander Newald Alexander, Why not just have a record_limit column in the Member table that limits the member to a certain # of records. Before he inserts a new record, you do a lookup using his member_id and see if he is about to exceed his limit. If he does, display a warning message that allows him to buy more record space. You make more money off of him and if he doesn't like it, he is limited to the # of records he has and he will manage his records better. It is all automatic. Mike - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Joining same table twice for different rows -- possible?
Hi, Consider the following schema: Database.Users: id username Database.Log: id userid1 userid2 entry If I'm SELECT'ing on the Log table and I want to pull usernames out of Users table for both users (which will most likely be unique) is there a specific JOIN for this? Forgive me if I've missed something in the manual pages; I've always had to do two SELECTs and thus have been looking for a quick[er] solution to this for some time now. Thank you in advance! Ron Jamison (moderators: although I've looked at the manual page plenty of times before, http://www.mysql.com/doc/manual.php?search_query=join today produced the following: "Search results Did you mean jan? The search for 'join' produced no results " -- kind of ironic) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
question about differences with mysql on windows and unix
Group, On my unix box when I use mysql I can spawn vi and edit the sql statement or save it out for reuse. This feature does not appear to be present on the windows version - or did I miss something? Thanks. - 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
Add existing related data to a table
Hi, I'm looking for some suggestions of making a one time update to some of my tables to make them useable with new forms and queries I'm creating. I have a series of tables which hold related data and only the last part of the data is stored in a final table, which means to search data based on some of the information higher up the table structure is making some very complex and dodgy queries. I want to insert the related data into the final table but can't think of a way of doing it. The example below might help me explain better what I mean. Consider two tables - TableA which contains PicID and KeywordID TableB which contains SubcatID and KeywordID What I want to do is insert the corresponding values for relating to KeywordID for SubCatID into a new column in TableA. Any suggestions how to work this to add the extra information to existing records? Alex -- Alexander Shaw Agricultural Stock and Assignment Photography p.s. to get throught he spam trap - sql query --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.360 / Virus Database: 199 - Release Date: 07/05/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 <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MySQL/InnoDB question
I don't know the answer to this in mysql, but in oracle, while you can have big files, I've seen tables divided at, say, the 1 million record mark. So there could be 5 files for a fast 5 million record "table". This is seamless to the user if there are views. Alas, mysql doesn't have views :-(. -Original Message- From: Craig Vincent [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 6:28 PM To: MySQL Subject: MySQL/InnoDB question I'm not new to MySQL but have only recently familiarized myself with InnoDB. One question I have so far been able to find an answer on is the datafiles. Let's assume I have 5 GB worth of information, this information changes regularly. Performance wisewould I be better off using a single 5GB file, or would there be benefits to using multiple datafilessay 5 datafiles containing 1GB of information each? Any documentation/links providing additional information in regards to this would be much appreciated. I couldn't find anything at either the MySQL or InnoDB site in regards to this. Sincerely, Craig Vincent - 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 query question
How can I delete from a table the results of a join query.. I.e, join two tables together, get the resutls, now want to delete that data from one of the tables... Do I have to create a tempory table, hold the data, and delete from the one table data matching in the temp table, or can I just combine a delete statement with my original query...? here is my query, which works.. select distinct table1.ticker_name from table1 LEFT JOIN on table2 on (table1.ticker_name = table2.ticker_name) where table2.ticker_name IS NULL; Thanks, Taylor Taylor Lewick Unix System Administrator Fortis Benefits 816 881 6073 "Help Wanted. Seeking Telepath..." "You Know where to apply." Please Note The information in this E-mail message is legally privileged and confidential information intended only for the use of the individual(s) named above. If you, the reader of this message, are not the intended recipient, you are hereby notified that you should not further disseminate, distribute, or forward this E-mail message. If you have received this E-mail in error, please notify the sender. Thank you * - 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: Remote admin of MySQL from Win 2K
Told my client that dealing with Yahoo would have it's problems...they will not do anything to the server once they wipe the disk clean and install RaQ-4 :-) !! Thanks for the MySQL advice.. Todd -- Todd Cary Ariste Software 2200 D Street Extension Petaluma, CA 94952 707-773-4523 [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: Remote admin of MySQL from Win 2K
Uhh, Hmm you probably are the owner, aren't you? (Wasn't reading that as a server, was reading just a name) Contact your supplier or sun directly (whomever installed the software) and ask them for the root password for your mysql server ( default installation however does not require a password, it doesnt have a password ) Later you can use the mysql client GRANT function to create users for mysql ( or whatever your interface calls the user permission process) -Original Message- From: Luc Foisy [mailto:[EMAIL PROTECTED]] Sent: Friday, May 17, 2002 4:23 PM To: 'Todd Cary'; MYSQL-List (E-mail) Subject: RE: Remote admin of MySQL from Win 2K Do you want to access the whole MySQL server? Or do you just want to administer a single database on a MySQL server? You could contact the owners of the database server and ask them to create a user for you to be able to connect to your MySQL database. You do not need to be root to administer a mysql database, it has its own permissions tables. -Original Message- From: Todd Cary [mailto:[EMAIL PROTECTED]] Sent: Friday, May 17, 2002 3:56 PM To: [EMAIL PROTECTED] Subject: Re: Remote admin of MySQL from Win 2K Just installed MySQL Manger...great! But I cannot get into a Cobalt RaQ-4 - problem due to my inability to be root since I can only admin the server by a Web page. H Todd -- Todd Cary Ariste Software 2200 D Street Extension Petaluma, CA 94952 707-773-4523 [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 - 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 fulltext search in latest mysql-4.0.2 source
Hi, Sorry, I finally found I also have to add set-variable = ft_min_word_len=3 in my.cnf. Regards, Jocelyn Fournier - Original Message - From: "Jocelyn Fournier" <[EMAIL PROTECTED]> To: "Sergei Golubchik" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, May 16, 2002 1:58 PM Subject: Re: Bug in fulltext search in latest mysql-4.0.2 source > Hi, > > I don't understand, I modified ulong ft_min_word_len=3; in > myisam/ft_static.c, and then recompiled MySQL using > BUILD/compile-pentium --without-innodb script, but show variables still > displays after restarting mysql : > > | ft_min_word_len | 4 > | > | ft_max_word_len | 254 > | > | ft_max_word_len_for_sort| 20 > > Any idea of what could be wrong ? > > Thanks and regards, > Jocelyn Fournier > > - Original Message - > From: "Sergei Golubchik" <[EMAIL PROTECTED]> > To: "Jocelyn Fournier" <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]> > Sent: Thursday, May 16, 2002 12:58 PM > Subject: Re: Bug in fulltext search in latest mysql-4.0.2 source > > > > Hi! > > > > On May 15, Jocelyn Fournier wrote: > > > A small question : > > > > > > I have : > > > > > > CANON BCI-11N Cartouche noir ( BJC-70 / BJC-80 / BN-700 ) > > > > > > in the field 'nom' . > > > How could I match BCI-11N for exemple ? (BCI* return nothing :( ) > > > > > > Thanks, > > > Jocelyn > > > > Actually, it's a question for [EMAIL PROTECTED], not for bugs@, > > but anyway - you need to decrease ft_min_word_len variable and > > rebuild your indexes (the proper way to do it is to issue > > REPAIR table_name USE_FRM > > but be sure to use the latest sources, as I've just fixed a crash in > > this code). > > > > Regards, > > Sergei > > > > -- > > MySQL Development Team > >__ ___ ___ __ > > / |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]> > > / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ > > /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany > ><___/ > > > > > > > > - > > 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: Remote admin of MySQL from Win 2K
Do you want to access the whole MySQL server? Or do you just want to administer a single database on a MySQL server? You could contact the owners of the database server and ask them to create a user for you to be able to connect to your MySQL database. You do not need to be root to administer a mysql database, it has its own permissions tables. -Original Message- From: Todd Cary [mailto:[EMAIL PROTECTED]] Sent: Friday, May 17, 2002 3:56 PM To: [EMAIL PROTECTED] Subject: Re: Remote admin of MySQL from Win 2K Just installed MySQL Manger...great! But I cannot get into a Cobalt RaQ-4 - problem due to my inability to be root since I can only admin the server by a Web page. H Todd -- Todd Cary Ariste Software 2200 D Street Extension Petaluma, CA 94952 707-773-4523 [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: Remote admin of MySQL from Win 2K
Just installed MySQL Manger...great! But I cannot get into a Cobalt RaQ-4 - problem due to my inability to be root since I can only admin the server by a Web page. H Todd -- Todd Cary Ariste Software 2200 D Street Extension Petaluma, CA 94952 707-773-4523 [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: Database's Disappear from phpMyAdmin
Hi, try contacting the author, phpmyadmin != mysql Kelly Hamlin wrote: > > Im running MySQL 3.23.49/PHP 4.2.1/Apache 2.0.35 > I load of phpMyAdmin and i see one of my databases with a - after its name > like its empty, but the wierd thing is, its not. I have quote a large amount > of data in it and my sites all still function properly. Any idea on what > might be causing this? > thanks. > > // > ( o o ) > +--.oooO--(_)--Oooo.-+ > | [Kelly Hamlin] > | [EMAIL PROTECTED] > | http://www.bomb.net > | .oooO > | ( )Oooo. > +--- \ (( )+ > \_)) / > (_/ > > - > 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 -- Colin Faber (303) 736-5160 fpsn.net, 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
MyCC problems with qt3.0.4
On Fri, 17 May 2002 [EMAIL PROTECTED] wrote: > Your message cannot be posted because it appears to be either spam or > simply off topic to our filter. To bypass the filter you must include > one of the following words in your message: > > sql,query > > If you just reply to this message, and include the entire text of it in the > reply, your reply will go through. However, you should > first review the text of the message to make sure it has something to do > with MySQL. Just typing the word MySQL once will be sufficient, for example. > > You have written the following: > I'm running a pretty standard install of RedHat 7.2 on a x86 machine. I compiled MyCC with qt3.0.4 and everything worked well except when I closed a popup window the program would seg fault. I re-compiled it using qt3.0.2 and it works fine now. You might want to make sure that users know they must use 3.0.2 if they want it to work properly. Of course fixing the problem with qt3.0.4 would be nice as well. :) Thanks. --Kevin - 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: mysqld got signal 11;
> > A post from the MySQL list > MEMORY PROBLEM ... a pointers is "gone a way" ... > The signal is SIGSEV and this mean in fact: Invalid memory > reference. > > If this is a memory problem, how did it hit two servers ( several kilometers > apart ) at the same time? There could be several reasons for this, and one of them is a bug in MySQL. You are using version 3.23.32 which has plenty of known bugs that can coredump MySQL server. The first thing to do in this situation is upgrade the coredumping MySQL. -- MySQL Development Team For technical support contracts, visit https://order.mysql.com/?ref=mspa __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA <___/ - 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
Database's Disappear from phpMyAdmin
Im running MySQL 3.23.49/PHP 4.2.1/Apache 2.0.35 I load of phpMyAdmin and i see one of my databases with a - after its name like its empty, but the wierd thing is, its not. I have quote a large amount of data in it and my sites all still function properly. Any idea on what might be causing this? thanks. // ( o o ) +--.oooO--(_)--Oooo.-+ | [Kelly Hamlin] | [EMAIL PROTECTED] | http://www.bomb.net | .oooO | ( )Oooo. +--- \ (( )+ \_)) / (_/ - 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: mysqld got signal 11;
On vendredi, mai 17, 2002, at 05:26 , Luc Foisy wrote: > Can anyone tell me what this means?? > > mysqld got signal 11; [...] (Could be) Bad RAM ? R. - 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: set connection as instance variable ( servlet and mysql)
- Original Message - From: "bin cai" <[EMAIL PROTECTED]> To: "mysql list" <[EMAIL PROTECTED]> Sent: Friday, May 17, 2002 10:59 AM Subject: set connection as instance variable ( servlet and mysql) > Hi, > My application is about online exam with java servlet > as tool, tomcat 3.2.3 as server solution , mysql 3.49 > as the backend. > considering 180 students take the exam at same time > within 50 minutes, there are a lot of transactions > with database. > what i did right now is to define connection in local > variable(within doGet or doPost method), every time > this servlet is called, new connection is created. > after transaction is done, this connection is closed. > I am worrying the speed.(it will comsume a lot > connection and time for open new connection). > > so I am thinking to define connection as instance > variable in every servlet, so it can save sometime to > open new connection. However, I am not sure if it will > cause multi-thread problem? How and when i can close > the connection. You should definitely use a connection pool. Sharing an instance of a connection will work, but you will have performance problems, and it is impossible to demarcate transactions when you do this. If you upgrade to Tomcat-4, it has connection pooling built in. Otherwise you might want to take a look at the commons project at http://cvs.apache.org/viewcvs/jakarta-commons/dbcp/ -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
mysql InnoDB .my.cnf help
Hi. I am wanting to create an Innodb databse. I am using mysql 4.0 on unix. Could someone send me a sample configuration file of thier /etc/.my.cnf? I've looked at the documentation, but I always enjoy looking at something from a real system... Thanks, Taylor Taylor Lewick Unix System Administrator Fortis Benefits 816 881 6073 "Help Wanted. Seeking Telepath..." "You Know where to apply." Please Note The information in this E-mail message is legally privileged and confidential information intended only for the use of the individual(s) named above. If you, the reader of this message, are not the intended recipient, you are hereby notified that you should not further disseminate, distribute, or forward this E-mail message. If you have received this E-mail in error, please notify the sender. Thank you * - 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: Remote admin of MySQL from Win 2K
Have you tried using phpMyAdmin?? It allows you to connect to several different host quiteeasily. You can download it at: http://www.phpwizard.net/projects/phpMyAdmin/index.html And actually any of the GUI front end apps for M$ should be able to connect to a remote server (I think). You just have tomake sure your MySQL permissions allow for outside users to log on. -Nick > Is there an appl for administering MySQL on a remote Linux server from > a Win 2K client? > > Todd > > -- > Todd Cary > Ariste Software > 2200 D Street Extension > Petaluma, CA 94952 > 707-773-4523 > [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 To > unsubscribe, e-mail > 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
OSDL Introduces OSDL-DBT-1
Hello everyone, I thought some folks may be interested to know that the Open Source Development Lab (OSDL) has released a database test kit that is a derivative of the TPC-W (http://www.tpc.org/tpcw). The kit is currently adapted for SAP DB, but we hope that people are interested in contributing to the project to make it work with MySQL. For more details on the project, please see: http://www.osdl.org/projects/performance/osdldbt.html -- Mark Wong - - [EMAIL PROTECTED] Open Source Development Lab Inc - A non-profit corporation 15275 SW Koll Parkway - Suite H - Beaverton OR, 97006 (503)-626-2455 x 32 (office) (503)-626-2436 (fax) - 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: Remote admin of MySQL from Win 2K
You might try MyCC ( available at mysql.com somewhere) -Original Message- From: Todd Cary [mailto:[EMAIL PROTECTED]] Sent: Friday, May 17, 2002 1:54 PM To: [EMAIL PROTECTED] Subject: Remote admin of MySQL from Win 2K Is there an appl for administering MySQL on a remote Linux server from a Win 2K client? Todd -- Todd Cary Ariste Software 2200 D Street Extension Petaluma, CA 94952 707-773-4523 [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: RE: ECS Error with 4.0.07 opening DB (still) again -EMEA2490
Hi, > -Original Message- > From: Richard Morton [mailto:[EMAIL PROTECTED]] > Sent: Friday, May 17, 2002 4:14 AM > To: MySQL List; Mysql Bugs; MyODBC > Subject: FWD: RE: ECS Error with 4.0.07 opening DB (still) > again -EMEA2490 > > > please see below > > > -- Forwarded Message -- > > FROM: "euro.support" <[EMAIL PROTECTED]> > TO: "Richard Morton" <[EMAIL PROTECTED]> > DATE: Fri, 17 May 2002 10:26:06 +0200 > > RE: RE: ECS Error with 4.0.07 opening DB (still) again -EMEA2490 > > > Hi Richard, > > I have received an answer from our dev team, please see below: > > -- > MySQL does not accept > SQLSetConnectAttr function for setting the > SQL_ATTR_CONNECTION_TIMEOUT > which is added recently to the same value as the query timeout. > > Unfortunately although it is legal ODBC 3.0 parameter MySql > crashes instead of reporting error if it does not support it. > This should be considered MySQL bug. MySQL/MyODBC does accept connection timeout. Here is the code snippet from driver: case SQL_ATTR_CONNECTION_TIMEOUT: DBUG_RETURN(mysql_options(&dbc->mysql, MYSQL_OPT_CONNECT_TIMEOUT, (const char *)((SQLUINTEGER)ValuePtr))); break; So, driver does set correctly. Make a note that, the value '0' means default in ODBC, and that means no timedout. How does MySQL crash for this parameter ? Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA <___/ www.mysql.com > > Code is changed in PU 8 not to call this function if timeout > is set to 0. > I will post here just a FDbase.fdl which can be used even on > PU007 Release. > But customer still needs to change its script to set query > timeout to 0. > How-To-Repeat: - 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 Client fails to connect
You need a windows client, look in www.mysql.com/downloads graphical clients or contributed software - Original Message - From: "Todd Cary" <[EMAIL PROTECTED]> To: "Federico Coco" <[EMAIL PROTECTED]> Sent: Friday, May 17, 2002 3:10 PM Subject: Re: MySql Client fails to connect > Federico - > > I am new to MySQL, so I can use some advice/help. If you do not mind, how do > you administer the Linux MySQL? I just got MySQL installed on my Linux server > RH 7.2, but I need to be able to administer it via Win 2K. > > Can I do that? > > Todd > > -- > Todd Cary > Ariste Software > 2200 D Street Extension > Petaluma, CA 94952 > 707-773-4523 > [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
Fw: MySql Client fails to connect
> After installing MySql Client Version 1.75 on my Win98 Pc, I tried to > connect to mysql database on a Linux Box. > this is the error message > > Host not allowed to connect to this MySQL server. > > This is my configuration file > > user=root > host=192.168.10.105 > port=3306 > num_of_queries=100 > timeout=60 > defbase= > socket= > queries_file=c:\\mysql\\.mysql_history > help_file=c:\\mySQL\\MySQL.help > queries_root= > last_database_file= > terminator=, > enclose=' > password=1 > compress=0 > ask=1 > max_width=50 > update_timeout=10.00 > font_used=72 > style_file= > > I don't know if I have to configure something else on windows or the linux > server? > > TIA. > - 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
Problems with Greek character set
Hi to all, I am using MySQL Version 4.0.1 and some of my problems are: 1) Full text search operators does not work correctly 2) The * operator does not work at all 2) Some Greek chars are returned erroneusly by the LIKE statement 3) There is not an "Exact Phrase" operator 4) Stressed chars are considered different chars from the corresponding "not stressed" chars e.t.c Has anybody experienced similar problems? Any Ideas? P.S I made an extensive search threw the List and i found that some members had in the past similar problems: 1) Achilleas Mantzios 2) Nikos Balanis 3) Kostas Assimakopoulos 4) Boril Yonchev If they are still members i am begging them for help Georgiafentis Nikolaos - 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
Remote admin of MySQL from Win 2K
Is there an appl for administering MySQL on a remote Linux server from a Win 2K client? Todd -- Todd Cary Ariste Software 2200 D Street Extension Petaluma, CA 94952 707-773-4523 [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL on iSCSI or IPSAN?
In the last episode (May 18), Patrick Hsieh said: > Hello list, > > How does MySQL support iSCSI or IPSAN infrastructure? MySQL does not care. Your OS handles access to devices. As long as your OS can put a filesytem on it, MySQL will use it. > Is it wise to put MySQL data in iSCSI or IPSAN storage appliance? As long as your hardware is stable I don't see it as any different from a Fibre-channel SAN. -- Dan Nelson [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Real-time data warehousing
In the last episode (May 17), Brad Teale said: > We are warehousing real-time data. The data is received at up to T1 speeds, > and is broken up and stored into the database in approximately 25 different > tables. Currently MySQL is doing terrific, we are using MyISAM tables and > are storing 24 hours worth of data but we don't have any users and we need > to store 72 hours worth of data. > > Our concern is that when we start letting our users (up to 200 simultaneous) > hit the database, we won't be able to keep up with ingesting and serving > data with the MyISAM locking scheme. You probably don't want to be doing your archiving and reporting on the same database. Set up replication, and do your queries on the slave while the master gets the updates. Moving to InnoDB tables might help with table contention, since it's got row-level locking. If there are only updates and few changes, then even moving to MyISAM will get you a big win, since appending a row doesn't lock the table. > We have tested Oracle and PostgreSQL which fell behind on the ingest. > The current production system uses regular ISAM files, but we need to > make a certification which requires a relational database. Also, the > current production system doesn't have the feature list the new > system has. > > Is there a better database solution or do you think MySQL can handle > it? If MySQL can handle it, would we be better off using InnoDB or > MyISAM tables? ISAM is deprecated and only included for compatibility with old files. You should switch to MyISAM at minimum. http://www.mysql.com/doc/I/S/ISAM.html http://www.mysql.com/doc/M/y/MyISAM.html -- Dan Nelson [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Real-time data warehousing
We have used the predecessor to the OTL for many of our apps and were planning to use the OTL for the new system. I thought the OTL used ODBC to make its connection with databases other than Oracle. I know the OTL supports Oracle natively. Sadly we cannot move to Linux. We managed to get our web servers on Linux, but the big iron will always be Sun here (Company policy). There has been talk of getting Oracle 9i? because Oracle has told us it is much faster, but we are not holding our breath. Thanks, Brad Teale -Original Message- From: walt [mailto:[EMAIL PROTECTED]] Sent: Friday, May 17, 2002 12:27 PM To: Brad Teale Cc: '[EMAIL PROTECTED]' Subject: Re: Real-time data warehousing How are your apps written? We use OTL libaries from http://members.fortunecity.com/skuchin/home.htm which are compiled into our C/C++ code. Moving our apps from oracle to mysql only requires changing 3 or 4 lines per call to the db in the code. Its not odbc "compliant", but still allows our apps to be "farily" portable and fast. We debated rewriting our apps to be ODBC compiant, but figured that was one more layer for bugs and we'd have to switch db platforms 4 times for it to be cost effective. Have you tried Oracle on Linux? We did some testing before Oracle told us the cost of migrating our licence from Oracle8/Solaris to Oracle8i/Linux. We benchmarked our current db server, Sun Ultra single processor 768MB ram, against a 600Mhz 500MB ram Intel/Linux box. The Linux./8i/Intel box smoked our current db server. - 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 Client fails to connect
After installing MySql Client Version 1.75 on my Win98 Pc, I tried to connect to mysql database on a Linux Box. this is the error message Host not allowed to connect to this MySQL server. This is my configuration file user=root host=192.168.10.105 port=3306 num_of_queries=100 timeout=60 defbase= socket= queries_file=c:\\mysql\\.mysql_history help_file=c:\\mySQL\\MySQL.help queries_root= last_database_file= terminator=, enclose=' password=1 compress=0 ask=1 max_width=50 update_timeout=10.00 font_used=72 style_file= I don't know if I have to configure something else on windows or the linux server to connect? TIA. - 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: Real-time data warehousing
On Friday 17 May 2002 12:58 pm, Brad Teale wrote: > I forgot to mention, we have Oracle in-house, and the machine the MySQL > database will reside on is a 2 proc Sun box with 1.5G of RAM. The Oracle > databases reside on a 16 proc Sun box with 10G of RAM. How are your apps written? We use OTL libaries from http://members.fortunecity.com/skuchin/home.htm which are compiled into our C/C++ code. Moving our apps from oracle to mysql only requires changing 3 or 4 lines per call to the db in the code. Its not odbc "compliant", but still allows our apps to be "farily" portable and fast. We debated rewriting our apps to be ODBC compiant, but figured that was one more layer for bugs and we'd have to switch db platforms 4 times for it to be cost effective. Have you tried Oracle on Linux? We did some testing before Oracle told us the cost of migrating our licence from Oracle8/Solaris to Oracle8i/Linux. We benchmarked our current db server, Sun Ultra single processor 768MB ram, against a 600Mhz 500MB ram Intel/Linux box. The Linux./8i/Intel box smoked our current db server. - 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: mysqld got signal 11;
try to restart master and see what happen - Original Message - From: "Luc Foisy" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; "MYSQL-List (E-mail)" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, May 17, 2002 7:25 PM Subject: RE: mysqld got signal 11; > > >Luc Foisy writes: > >> Can someone give me some clue as to what this means to me? > >> > >> mysqld got signal 11; > >> The manual section 'Debugging a MySQL server' tells you how to use a > >> stack trace and/or the core file to produce a readable backtrace that may > >> help in finding out why mysqld died > >> Attemping backtrace. You can use the following information to find out > >> where mysqld died. If you see no messages after this, something went > >> terribly wrong > >> Cannot determine thread, ebp=0xb, backtrace may not be correct > >> Bogus stack limit or frame pointer, aborting backtrace > >> > >> Number of processes running now: 0 > >> > >> > >> Luc Foisy > >> > > >Hi! > > > >The above means that MySQL server has crashed for some reason. > > > >Can you provide us with more info. Is it our binary , what OS and > >system software do you use, what does error log contains and all other > >info that you can compile. > > > >You may use mysqlbug program to provide much of the above info. > > > >As corrupted tables can still cause crashes, please check your tables > >with CHECK TABLES command, or if MySQL server is not running, with > >myisamchk -s and repair all tables that are not OK. > > > > (note: I have editied some hostnames, don't need to advertise) > Did some looking around and was very surprised. The signal 11 above occured > on a slave server ( over LAN ), here is a little more of the err output > > 020513 9:06:13 Error reading packet from server: Could not find first log > (read_errno 0,server_errno=65535) > 020513 9:07:13 Slave: Failed reading log event, reconnecting to retry, log > 'QBSLXDB1-bin.040 > ' position 110194576 > 020513 9:07:13 Slave: reconnected to master > '[EMAIL PROTECTED]:3306',replication resumed in log 'QBSLXDB1-bin.040 > ' at position 110194576 > 020513 9:07:13 Error reading packet from server: Could not find first log > (read_errno 0,server_errno=65535) > 020513 9:07:15 Slave thread exiting, replication stopped in log > 'QBSLXDB1-bin.040 > ' at position 110194576 > 020513 9:07:15 Slave: connected to master '[EMAIL PROTECTED]:3306', > replication started in log 'QBSLXDB1-bin.040' at position 110194576 > 020514 5:55:00 Slave thread exiting, replication stopped in log > 'QBSLXDB1-bin.041' at position 18927577 > 020514 5:55:00 Slave: connected to master '[EMAIL PROTECTED]:3306', > replication started in log 'QBSLXDB1-bin.041' at position 18927577 > 020515 5:55:00 Slave thread exiting, replication stopped in log > 'QBSLXDB1-bin.041' at position 51129469 > 020515 5:55:00 Slave: connected to master '[EMAIL PROTECTED]:3306', > replication started in log 'QBSLXDB1-bin.041' at position 51129469 > 020516 5:55:00 Slave thread exiting, replication stopped in log > 'QBSLXDB1-bin.041' at position 73667044 > 020516 5:55:00 Slave: connected to master '[EMAIL PROTECTED]:3306', > replication started in log 'QBSLXDB1-bin.041' at position 73667044 > mysqld got signal 11; > The manual section 'Debugging a MySQL server' tells you how to use a > stack trace and/or the core file to produce a readable backtrace that may > help in finding out why mysqld died > Attemping backtrace. You can use the following information to find out > where mysqld died. If you see no messages after this, something went > terribly wrong > Cannot determine thread, ebp=0xb, backtrace may not be correct > Bogus stack limit or frame pointer, aborting backtrace > > Number of processes running now: 0 > 020516 14:52:47 mysqld restarted > /usr/sbin/mysqld: ready for connections > > -- > So after seeing this, we decided to check our other slave server ( > replicating the same master, over WAN ) > It too got a signal 11, here is output from err log > > 020516 14:55:10 Error reading packet from server: Lost connection to MySQL > server during query (read_errno 0,server_errno=2013) > 020516 14:55:10 Slave: Failed reading log event, reconnecting to retry, log > 'QBSLXDB1-bin.041' position 89957769 > 020516 14:55:11 Slave: reconnected to master > 'repslave2@:3306',replication resumed in log 'QBSLXDB1-bin.041' at > position 89957769 > 020516 15:01:14 Error reading packet from server: Lost connection to MySQL > server during query (read_errno 0,server_errno=2013) > 020516 15:01:14 Slave: Failed reading log event, reconnecting to retry, log > 'QBSLXDB1-bin.041' position 90472635 > 020516 15:01:14 Slave: reconnected to master > 'repslave2@:3306',replication resumed in log 'QBSLXDB1-bin.041' at > position 90472635 > 020516 15:23:43 Error reading packet from server: Lost connection to MySQL > server during query (read_errno 0,server_errno=2013) > 020516 15:23:4
RE: Multiple Slaves to single Master Replication
You can have multiple slaves to a single master 1. You can't have multiple masters to a single slave (You can however have multiple servers on the same computer, check the docs) (at least in the 3.x tree) 2. The Master does not update from the slave ( I don't think looping is permitted ) -Original Message- From: Paul Daniels [mailto:[EMAIL PROTECTED]] Sent: Friday, May 17, 2002 12:15 PM To: [EMAIL PROTECTED] Subject: Multiple Slaves to single Master Replication Having read the mysql release notes on replication, I am unsure whether mysql will support the following scenario. Can anyone tell me. 1. Multiple master databases into a single slave. If this can be done, I understand that the applications must control the update to avoid conflicts. 2. Data being updated on the slave being replicated to a selected master, again with the application controlling how the updates are managed. --- Paul Daniels Technical Director Evolution Systems Ltd Tel: 01270 588228 Fax: 01270580129 - 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: Real-time data warehousing
I forgot to mention, we have Oracle in-house, and the machine the MySQL database will reside on is a 2 proc Sun box with 1.5G of RAM. The Oracle databases reside on a 16 proc Sun box with 10G of RAM. The decision to go or not go with MySQL is not based on money, it needs to be based on performance. We currently use Oracle in-house for everything, but its speed hasn't been its selling point, and for this application we need lots of speed. That is why we are leaning toward MySQL, but were not sure if it could keep up with the addition of the user community. I had one other question, how much of a performance hit would we take with MySQL if we connected through MyODBC? Thanks again, Brad -Original Message- From: walt [mailto:[EMAIL PROTECTED]] Sent: Friday, May 17, 2002 11:47 AM To: Brad Teale Cc: '[EMAIL PROTECTED]' Subject: Re: Real-time data warehousing Brad, We're in process of evaluating mysql vs our current Oracle 8 system. Importing data is much faster in mysql than oracle according the numbers we're getting. However, from our benchmarking, Oracle seems to be faster on the queries (no writes to db during query time). The table were running our queries against has 46 coulmns and 14 indexes (some columns indexed twice in multi-column indexes). All queries are based on indexed columns. We've also run into some issues trying to delete indexes, 14+ hours before we killed the db and reloaded data, but I may be something stupid. One note on Oracle, $30,000+ for a single processor licence. From our testing, it looks like the bottleneck is disk I/O not processing power. With Oracle, you have better control over which disks your data resides on which lets you balance disk I/O better. However, for $30k, you can buy 10 15,000 rpm drives, stripe them, and then buy another server for replication of data and still have $25K left over. - 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: mysqld got signal 11;
What version of MySQL you use ? I hope is not 3.23.4x. - Original Message - From: "Luc Foisy" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; "MYSQL-List (E-mail)" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, May 17, 2002 7:25 PM Subject: RE: mysqld got signal 11; > > >Luc Foisy writes: > >> Can someone give me some clue as to what this means to me? > >> > >> mysqld got signal 11; > >> The manual section 'Debugging a MySQL server' tells you how to use a > >> stack trace and/or the core file to produce a readable backtrace that may > >> help in finding out why mysqld died > >> Attemping backtrace. You can use the following information to find out > >> where mysqld died. If you see no messages after this, something went > >> terribly wrong > >> Cannot determine thread, ebp=0xb, backtrace may not be correct > >> Bogus stack limit or frame pointer, aborting backtrace > >> > >> Number of processes running now: 0 > >> > >> > >> Luc Foisy > >> > > >Hi! > > > >The above means that MySQL server has crashed for some reason. > > > >Can you provide us with more info. Is it our binary , what OS and > >system software do you use, what does error log contains and all other > >info that you can compile. > > > >You may use mysqlbug program to provide much of the above info. > > > >As corrupted tables can still cause crashes, please check your tables > >with CHECK TABLES command, or if MySQL server is not running, with > >myisamchk -s and repair all tables that are not OK. > > > > (note: I have editied some hostnames, don't need to advertise) > Did some looking around and was very surprised. The signal 11 above occured > on a slave server ( over LAN ), here is a little more of the err output > > 020513 9:06:13 Error reading packet from server: Could not find first log > (read_errno 0,server_errno=65535) > 020513 9:07:13 Slave: Failed reading log event, reconnecting to retry, log > 'QBSLXDB1-bin.040 > ' position 110194576 > 020513 9:07:13 Slave: reconnected to master > '[EMAIL PROTECTED]:3306',replication resumed in log 'QBSLXDB1-bin.040 > ' at position 110194576 > 020513 9:07:13 Error reading packet from server: Could not find first log > (read_errno 0,server_errno=65535) > 020513 9:07:15 Slave thread exiting, replication stopped in log > 'QBSLXDB1-bin.040 > ' at position 110194576 > 020513 9:07:15 Slave: connected to master '[EMAIL PROTECTED]:3306', > replication started in log 'QBSLXDB1-bin.040' at position 110194576 > 020514 5:55:00 Slave thread exiting, replication stopped in log > 'QBSLXDB1-bin.041' at position 18927577 > 020514 5:55:00 Slave: connected to master '[EMAIL PROTECTED]:3306', > replication started in log 'QBSLXDB1-bin.041' at position 18927577 > 020515 5:55:00 Slave thread exiting, replication stopped in log > 'QBSLXDB1-bin.041' at position 51129469 > 020515 5:55:00 Slave: connected to master '[EMAIL PROTECTED]:3306', > replication started in log 'QBSLXDB1-bin.041' at position 51129469 > 020516 5:55:00 Slave thread exiting, replication stopped in log > 'QBSLXDB1-bin.041' at position 73667044 > 020516 5:55:00 Slave: connected to master '[EMAIL PROTECTED]:3306', > replication started in log 'QBSLXDB1-bin.041' at position 73667044 > mysqld got signal 11; > The manual section 'Debugging a MySQL server' tells you how to use a > stack trace and/or the core file to produce a readable backtrace that may > help in finding out why mysqld died > Attemping backtrace. You can use the following information to find out > where mysqld died. If you see no messages after this, something went > terribly wrong > Cannot determine thread, ebp=0xb, backtrace may not be correct > Bogus stack limit or frame pointer, aborting backtrace > > Number of processes running now: 0 > 020516 14:52:47 mysqld restarted > /usr/sbin/mysqld: ready for connections > > -- > So after seeing this, we decided to check our other slave server ( > replicating the same master, over WAN ) > It too got a signal 11, here is output from err log > > 020516 14:55:10 Error reading packet from server: Lost connection to MySQL > server during query (read_errno 0,server_errno=2013) > 020516 14:55:10 Slave: Failed reading log event, reconnecting to retry, log > 'QBSLXDB1-bin.041' position 89957769 > 020516 14:55:11 Slave: reconnected to master > 'repslave2@:3306',replication resumed in log 'QBSLXDB1-bin.041' at > position 89957769 > 020516 15:01:14 Error reading packet from server: Lost connection to MySQL > server during query (read_errno 0,server_errno=2013) > 020516 15:01:14 Slave: Failed reading log event, reconnecting to retry, log > 'QBSLXDB1-bin.041' position 90472635 > 020516 15:01:14 Slave: reconnected to master > 'repslave2@:3306',replication resumed in log 'QBSLXDB1-bin.041' at > position 90472635 > 020516 15:23:43 Error reading packet from server: Lost connection to MySQL > server during query (read_errno 0,server_errno=2013) >
Re: Real-time data warehousing
Brad Teale wrote: > We are warehousing real-time data. The data is received at up to T1 speeds, > and is broken up and stored into the database in approximately 25 different > tables. Currently MySQL is doing terrific, we are using MyISAM tables and > are storing 24 hours worth of data but we don't have any users and we need > to store 72 hours worth of data. > > Our concern is that when we start letting our users (up to 200 simultaneous) > hit the database, we won't be able to keep up with ingesting and serving > data with the MyISAM locking scheme. > > We have tested Oracle and PostgreSQL which fell behind on the ingest. The > current production system uses regular ISAM files, but we need to make a > certification which requires a relational database. Also, the current > production system doesn't have the feature list the new system has. > > Is there a better database solution or do you think MySQL can handle it? > If MySQL can handle it, would we be better off using InnoDB or MyISAM > tables? > > Thanks, > Brad > > - > 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 Brad, We're in process of evaluating mysql vs our current Oracle 8 system. Importing data is much faster in mysql than oracle according the numbers we're getting. However, from our benchmarking, Oracle seems to be faster on the queries (no writes to db during query time). The table were running our queries against has 46 coulmns and 14 indexes (some columns indexed twice in multi-column indexes). All queries are based on indexed columns. We've also run into some issues trying to delete indexes, 14+ hours before we killed the db and reloaded data, but I may be something stupid. One note on Oracle, $30,000+ for a single processor licence. From our testing, it looks like the bottleneck is disk I/O not processing power. With Oracle, you have better control over which disks your data resides on which lets you balance disk I/O better. However, for $30k, you can buy 10 15,000 rpm drives, stripe them, and then buy another server for replication of data and still have $25K left over. - 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: Real-time data warehousing
Hi, My opinion: If your DataBase is designed for OLTP then MySQL ver 3.23.4x with MyISAM can be a good choice and safety. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: "Brad Teale" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, May 17, 2002 6:49 PM Subject: Real-time data warehousing > We are warehousing real-time data. The data is received at up to T1 speeds, > and is broken up and stored into the database in approximately 25 different > tables. Currently MySQL is doing terrific, we are using MyISAM tables and > are storing 24 hours worth of data but we don't have any users and we need > to store 72 hours worth of data. > > Our concern is that when we start letting our users (up to 200 simultaneous) > hit the database, we won't be able to keep up with ingesting and serving > data with the MyISAM locking scheme. > > We have tested Oracle and PostgreSQL which fell behind on the ingest. The > current production system uses regular ISAM files, but we need to make a > certification which requires a relational database. Also, the current > production system doesn't have the feature list the new system has. > > Is there a better database solution or do you think MySQL can handle it? > If MySQL can handle it, would we be better off using InnoDB or MyISAM > tables? > > Thanks, > Brad > > - > 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: mysqld got signal 11;
- Original Message - From: "Victoria Reznichenko" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, May 17, 2002 6:52 PM Subject: Re: mysqld got signal 11; > Luc, > Friday, May 17, 2002, 6:26:19 PM, you wrote: > > LF> Can anyone tell me what this means?? > > LF> mysqld got signal 11; > LF> The manual section 'Debugging a MySQL server' tells you how to use a > LF> stack trace and/or the core file to produce a readable backtrace that may > LF> help in finding out why mysqld died > LF> Attemping backtrace. You can use the following information to find out > LF> where mysqld died. If you see no messages after this, something went > LF> terribly wrong > LF> Cannot determine thread, ebp=0xb, backtrace may not be correct > LF> Bogus stack limit or frame pointer, aborting backtrace > > LF> Number of processes running now: 0 > > Signal 11 is a "Segmentation fault", when the program cames out of it's address space. All signal which have action "C" generate "Segmentation fault". > There might be many causes of error, mostly incorrect compilation or broken hardware. > What did you tried to do which caused SIG11? > > LF> Luc Foisy > > > > > -- > 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
Performances with BLOB fields in mySql
> > Da: <[EMAIL PROTECTED]> > Data: Fri, 17 May 2002 16:30:58 CEST > A: [EMAIL PROTECTED] > Oggetto: Performances with BLOB fields in mySql > > My application (C++, mySql++, WINNT) is very time-critical and space-critical and >use blob field. > How can I improve performances? > Which parameters can I set? > There's literature about this question? > > Thak's, I'm sorry for my English. > Bye, Marco > > > > > > - 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
Can you replicate tables in MySQL version 3.23.44. As part of a University project I wish to distribute certain tables across the network and obviously keep the data synchronised with the original table. Unfortunately I am limited with only one server, so to demonstrate this is it posible to create a replicate table sitting on the same server that is regularly synchronised with changes. any idea how you can do this. Any help would be much appreciated. Regards, Faizal Mangera - 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
OSDL Introduces OSDL-DBT-1
Hello everyone, I thought some folks may be interested to know that the Open Source Development Lab (OSDL) has released a database test kit that is a derivative of the TPC-W (http://www.tpc.org/tpcw). The kit is currently adapted for SAP DB, but we hope that people are interested in contributing to the project to make it work with MySQL. For more details on the project, please see: http://www.osdl.org/projects/performance/osdldbt.html -- Mark Wong - - [EMAIL PROTECTED] Open Source Development Lab Inc - A non-profit corporation 15275 SW Koll Parkway - Suite H - Beaverton OR, 97006 (503)-626-2455 x 32 (office) (503)-626-2436 (fax) - 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 on iSCSI or IPSAN?
Hello list, How does MySQL support iSCSI or IPSAN infrastructure? Is it wise to put MySQL data in iSCSI or IPSAN storage appliance? Any experiences appreciated. -- Patrick Hsieh <[EMAIL PROTECTED]> GPG public key http://pahud.net/pubkeys/pahudatpahud.gpg - 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: mysqld got signal 11;
Compiliation Error : Official MySQL RPM Broken Hardware : Two computers of different design at two completely different locations, at the same time?? What did I try to do which caused SIG11 : Nothing, servers were replicating See other message posted for other details about versions and server info -Original Message- From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]] Sent: Friday, May 17, 2002 11:52 AM To: [EMAIL PROTECTED] Subject: Re: mysqld got signal 11; Luc, Friday, May 17, 2002, 6:26:19 PM, you wrote: LF> Can anyone tell me what this means?? LF> mysqld got signal 11; LF> The manual section 'Debugging a MySQL server' tells you how to use a LF> stack trace and/or the core file to produce a readable backtrace that may LF> help in finding out why mysqld died LF> Attemping backtrace. You can use the following information to find out LF> where mysqld died. If you see no messages after this, something went LF> terribly wrong LF> Cannot determine thread, ebp=0xb, backtrace may not be correct LF> Bogus stack limit or frame pointer, aborting backtrace LF> Number of processes running now: 0 Signal 11 is a "Segmentation fault", when the program cames out of it's address space. There might be many causes of error, mostly incorrect compilation or broken hardware. What did you tried to do which caused SIG11? LF> Luc Foisy -- 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
RE: Query question "average per hour per agent"
[snip] I have a database of tickets and I want to get "the average numbers of tickets created per agent per hour over a date range" in the format: Hour | Avg per agent This is what I have so far: SELECT HOUR(created) AS hourcreated, COUNT(*) AS sum-per-hour FROM remedy WHERE (created>='2002-4-25' AND created<='2002-04-30') GROUP BY HOUR(created) This query only gives the SUM of tickets per hour. Is there a way to get the number of distinct "submitters" per hour so I can divide that by count to get avg/hour? [/snip] You probably need a crosstab query and I would need to see some of the table to help you create it. It would look something like; SELECT DATE(created) AS DateCreated, SUM(IF(HOUR(created) = '10:00', 1, 0)) as "10 am", SUM(IF(HOUR(created) = '11:00', 1, 0)) as "11 am", SUM(IF(HOUR(created) = '12:00', 1, 0)) as "12 am", SUM(IF(HOUR(created) = '13:00', 1, 0)) as "1 pm" FROM remedy WHERE (created>='2002-4-25' AND created<='2002-04-30') GROUP BY DATE(created) would give something like; +-+---+--+-+---+ | DateCreated | 10 am |11 am | 12 am | 1 pm | +-+---+--+-+---+ | 2002-04-25 | 159 | 72 | 0 | 0 | | 2002-04-26 |28 |0 | 14 |14 | | 2002-04-27 |22 | 17 | 17 |17 | | 2002-04-28 |36 | 13 | 49 |85 | | 2002-04-29 |12 |0 | 12 |12 | | 2002-04-29 |12 | 83 | 72 |12 | +-+---+--+-+---+ HTH! Jay - 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: mysqld got signal 11;
>Luc Foisy writes: >> Can someone give me some clue as to what this means to me? >> >> mysqld got signal 11; >> The manual section 'Debugging a MySQL server' tells you how to use a >> stack trace and/or the core file to produce a readable backtrace that may >> help in finding out why mysqld died >> Attemping backtrace. You can use the following information to find out >> where mysqld died. If you see no messages after this, something went >> terribly wrong >> Cannot determine thread, ebp=0xb, backtrace may not be correct >> Bogus stack limit or frame pointer, aborting backtrace >> >> Number of processes running now: 0 >> >> >> Luc Foisy >> >Hi! > >The above means that MySQL server has crashed for some reason. > >Can you provide us with more info. Is it our binary , what OS and >system software do you use, what does error log contains and all other >info that you can compile. > >You may use mysqlbug program to provide much of the above info. > >As corrupted tables can still cause crashes, please check your tables >with CHECK TABLES command, or if MySQL server is not running, with >myisamchk -s and repair all tables that are not OK. (note: I have editied some hostnames, don't need to advertise) Did some looking around and was very surprised. The signal 11 above occured on a slave server ( over LAN ), here is a little more of the err output 020513 9:06:13 Error reading packet from server: Could not find first log (read_errno 0,server_errno=65535) 020513 9:07:13 Slave: Failed reading log event, reconnecting to retry, log 'QBSLXDB1-bin.040 ' position 110194576 020513 9:07:13 Slave: reconnected to master '[EMAIL PROTECTED]:3306',replication resumed in log 'QBSLXDB1-bin.040 ' at position 110194576 020513 9:07:13 Error reading packet from server: Could not find first log (read_errno 0,server_errno=65535) 020513 9:07:15 Slave thread exiting, replication stopped in log 'QBSLXDB1-bin.040 ' at position 110194576 020513 9:07:15 Slave: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'QBSLXDB1-bin.040' at position 110194576 020514 5:55:00 Slave thread exiting, replication stopped in log 'QBSLXDB1-bin.041' at position 18927577 020514 5:55:00 Slave: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'QBSLXDB1-bin.041' at position 18927577 020515 5:55:00 Slave thread exiting, replication stopped in log 'QBSLXDB1-bin.041' at position 51129469 020515 5:55:00 Slave: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'QBSLXDB1-bin.041' at position 51129469 020516 5:55:00 Slave thread exiting, replication stopped in log 'QBSLXDB1-bin.041' at position 73667044 020516 5:55:00 Slave: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'QBSLXDB1-bin.041' at position 73667044 mysqld got signal 11; The manual section 'Debugging a MySQL server' tells you how to use a stack trace and/or the core file to produce a readable backtrace that may help in finding out why mysqld died Attemping backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong Cannot determine thread, ebp=0xb, backtrace may not be correct Bogus stack limit or frame pointer, aborting backtrace Number of processes running now: 0 020516 14:52:47 mysqld restarted /usr/sbin/mysqld: ready for connections -- So after seeing this, we decided to check our other slave server ( replicating the same master, over WAN ) It too got a signal 11, here is output from err log 020516 14:55:10 Error reading packet from server: Lost connection to MySQL server during query (read_errno 0,server_errno=2013) 020516 14:55:10 Slave: Failed reading log event, reconnecting to retry, log 'QBSLXDB1-bin.041' position 89957769 020516 14:55:11 Slave: reconnected to master 'repslave2@:3306',replication resumed in log 'QBSLXDB1-bin.041' at position 89957769 020516 15:01:14 Error reading packet from server: Lost connection to MySQL server during query (read_errno 0,server_errno=2013) 020516 15:01:14 Slave: Failed reading log event, reconnecting to retry, log 'QBSLXDB1-bin.041' position 90472635 020516 15:01:14 Slave: reconnected to master 'repslave2@:3306',replication resumed in log 'QBSLXDB1-bin.041' at position 90472635 020516 15:23:43 Error reading packet from server: Lost connection to MySQL server during query (read_errno 0,server_errno=2013) 020516 15:23:43 Slave: Failed reading log event, reconnecting to retry, log 'QBSLXDB1-bin.041' position 91888510 020516 15:23:43 Slave: reconnected to master 'repslave2@:3306',replication resumed in log 'QBSLXDB1-bin.041' at position 91888510 020516 15:26:53 Error reading packet from server: Lost connection to MySQL server during query (read_errno 0,server_errno=2013) 020516 15:26:53 Slave: Failed reading log event, reconnecting to retry, log 'QBSLXDB1-bin.041' position 92103
Multiple Slaves to single Master Replication
Having read the mysql release notes on replication, I am unsure whether mysql will support the following scenario. Can anyone tell me. 1. Multiple master databases into a single slave. If this can be done, I understand that the applications must control the update to avoid conflicts. 2. Data being updated on the slave being replicated to a selected master, again with the application controlling how the updates are managed. --- Paul Daniels Technical Director Evolution Systems Ltd Tel: 01270 588228 Fax: 01270580129 - 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 question "average per hour per agent"
SELECT COUNT(DISTINCT(submitter)) AS submitters, HOUR(created) AS hourcreated, COUNT(*) AS sum-per-hour FROM remedy WHERE (created>='2002-4-25' AND created<='2002-04-30') GROUP BY HOUR(created); Is this what you want? Gurhan -Original Message- From: Graeme B. Davis [mailto:[EMAIL PROTECTED]] Sent: Friday, May 17, 2002 11:52 AM To: [EMAIL PROTECTED] Subject: Query question "average per hour per agent" I'm having a problem in a query that I'm trying to do. I have a database of tickets and I want to get "the average numbers of tickets created per agent per hour over a date range" in the format: Hour | Avg per agent This is what I have so far: SELECT HOUR(created) AS hourcreated, COUNT(*) AS sum-per-hour FROM remedy WHERE (created>='2002-4-25' AND created<='2002-04-30') GROUP BY HOUR(created) This query only gives the SUM of tickets per hour. Is there a way to get the number of distinct "submitters" per hour so I can divide that by count to get avg/hour? perhaps I'm not thinking straight and I'm missing something -- any ideas?? Thanks! graeme - 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
set connection as instance variable ( servlet and mysql)
Hi, My application is about online exam with java servlet as tool, tomcat 3.2.3 as server solution , mysql 3.49 as the backend. considering 180 students take the exam at same time within 50 minutes, there are a lot of transactions with database. what i did right now is to define connection in local variable(within doGet or doPost method), every time this servlet is called, new connection is created. after transaction is done, this connection is closed. I am worrying the speed.(it will comsume a lot connection and time for open new connection). so I am thinking to define connection as instance variable in every servlet, so it can save sometime to open new connection. However, I am not sure if it will cause multi-thread problem? How and when i can close the connection. __ Find, Connect, Date! http://personals.yahoo.ca - 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: Socket problem connecting
Todd, Friday, May 17, 2002, 4:36:37 PM, you wrote: TC> Egor - TC> Question 1: TC> I located where mysql.sock is located - /var/lib/mysql/mysql.sock - NOT /tmp. TC> However, it is a symbolic link. TC> Shouldn't there be an actual file in addition to the symbolic link? TC> Linux is very new to me, so I am not up to speed on many of the intricacies. If you create a symbolic link ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock you can have access to mysql.sock not only in /var/lib/mysql but in /tmp, too. You can also specify in my.cnf file or with "--socket" option where your socket file should be located. TC> Question 2: TC> There is not a my.cnf file on my system. How do I determine where mysql is TC> looking for my.cnf so that I can create one in that location? You can create my.cnf by yourself. Examples of my.cnf (my-huge.cnf, my-large.cnf my-small.cnf) you can find in share directory (for RedHat it is normally /usr/share/mysql). Depends on what options you want to specify in my.cnf; you should put it in /etc or in mysql data dir or in home dir. For more info about my.cnf check the following link: http://www.mysql.com/doc/O/p/Option_files.html Besides, please please don't send me questions in private mail, post them in the mail-list! TC> Many thanks. TC> Todd -- 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: mysqld got signal 11;
Luc, Friday, May 17, 2002, 6:26:19 PM, you wrote: LF> Can anyone tell me what this means?? LF> mysqld got signal 11; LF> The manual section 'Debugging a MySQL server' tells you how to use a LF> stack trace and/or the core file to produce a readable backtrace that may LF> help in finding out why mysqld died LF> Attemping backtrace. You can use the following information to find out LF> where mysqld died. If you see no messages after this, something went LF> terribly wrong LF> Cannot determine thread, ebp=0xb, backtrace may not be correct LF> Bogus stack limit or frame pointer, aborting backtrace LF> Number of processes running now: 0 Signal 11 is a "Segmentation fault", when the program cames out of it's address space. There might be many causes of error, mostly incorrect compilation or broken hardware. What did you tried to do which caused SIG11? LF> Luc Foisy -- 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: Socket trouble
Amy, Friday, May 17, 2002, 3:41:58 PM, you wrote: AZ> When trying to connect to mysql database i get this error message "Cant AZ> connect to local MySQL server through socket "/tmp/mysql.sock" Check if your MySQL is running. If yes, specify path to your socket file with --socket option ... AZ> Yet I can connect through TCP/IP ~ what happened to my socket? AZ> Any suggestions? AZ> Amy -- 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: Re: Re: How to limit database size?
Hello Alexander, Friday, May 17, 2002, 6:13:15 PM, you wrote: Alexander, send your questions in mail-list! >> You can't do it with MySQL, use disk quotas ... AN> Thanks for your answer. AN> What happens if a user tries to add more data to a table after the files AN> containing his database reached the hard disk quota limit. Does it make any AN> diffrence which file (.frm .myi .myd) reaches the disk quota limit ? User will get error 28: No space left on device Databases in MySQL are stored in separate dirs, you should set quotas on the database dir size. It doesn't matter which file reaches disk qouta limit. AN> Alexander Newald -- 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: Mysqlimport
Jonas, Friday, May 17, 2002, 4:54:18 PM, you wrote: JO> Receive the message: JO> "mysqlimport: Error: The used command is not JO> allowed with this MySQL version, when using table: t_parameter." Did you tried to use mysqlimport with --local option? If so, you should specify local-infile for MySQL client and server. Look at: http://www.mysql.com/doc/L/O/LOAD_DATA_LOCAL.html JO> What´s this?? JO> Thanks, JO> /Jonas -- 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
Query question "average per hour per agent"
I'm having a problem in a query that I'm trying to do. I have a database of tickets and I want to get "the average numbers of tickets created per agent per hour over a date range" in the format: Hour | Avg per agent This is what I have so far: SELECT HOUR(created) AS hourcreated, COUNT(*) AS sum-per-hour FROM remedy WHERE (created>='2002-4-25' AND created<='2002-04-30') GROUP BY HOUR(created) This query only gives the SUM of tickets per hour. Is there a way to get the number of distinct "submitters" per hour so I can divide that by count to get avg/hour? perhaps I'm not thinking straight and I'm missing something -- any ideas?? Thanks! graeme - 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
winmysqladmin problem (Win 2000)
A very simple question: I have installed mysql on Windows 2000 as administrator. I can use winmysqladmin as administrator, but I cannot use its service as normal user - the red signal cannot be forced to turn into green! Holger - 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
Real-time data warehousing
We are warehousing real-time data. The data is received at up to T1 speeds, and is broken up and stored into the database in approximately 25 different tables. Currently MySQL is doing terrific, we are using MyISAM tables and are storing 24 hours worth of data but we don't have any users and we need to store 72 hours worth of data. Our concern is that when we start letting our users (up to 200 simultaneous) hit the database, we won't be able to keep up with ingesting and serving data with the MyISAM locking scheme. We have tested Oracle and PostgreSQL which fell behind on the ingest. The current production system uses regular ISAM files, but we need to make a certification which requires a relational database. Also, the current production system doesn't have the feature list the new system has. Is there a better database solution or do you think MySQL can handle it? If MySQL can handle it, would we be better off using InnoDB or MyISAM tables? Thanks, Brad - 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: mysqld got signal 11;
Hi, MEMORY PROBLEM ... a pointers is "gone a way" ... The signal is SIGSEV and this mean in fact: Invalid memory reference. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: "Luc Foisy" <[EMAIL PROTECTED]> To: "MYSQL-List (E-mail)" <[EMAIL PROTECTED]> Sent: Friday, May 17, 2002 6:26 PM Subject: mysqld got signal 11; > Can anyone tell me what this means?? > > mysqld got signal 11; > The manual section 'Debugging a MySQL server' tells you how to use a > stack trace and/or the core file to produce a readable backtrace that may > help in finding out why mysqld died > Attemping backtrace. You can use the following information to find out > where mysqld died. If you see no messages after this, something went > terribly wrong > Cannot determine thread, ebp=0xb, backtrace may not be correct > Bogus stack limit or frame pointer, aborting backtrace > > Number of processes running now: 0 > > Luc Foisy > > > - > 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: How to limit database size?
The database's table files will be in the data directory where all the table files for the databases are kept. If the partition or the hard drive where the data directory is residing on is out of space then the MySQL server will throw an error for not having enough space .. Gurhan -Original Message- From: Alexander Newald [mailto:[EMAIL PROTECTED]] Sent: Friday, May 17, 2002 11:29 AM To: mySQL Mailing list Subject: Re: How to limit database size? Hello, - Original Message - From: "Egor Egorov" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, May 17, 2002 1:42 PM Subject: Re: How to limit database size? [how to limit database size?] > > You can't do it with MySQL, use disk quotas ... > Thanks for your answer. What happens if a user tries to add more data to a table after the files containing his database reached the hard disk quota limit. Does it make any diffrence which file (.frm .myi .myd) reaches the disk quota limit ? Alexander Newald - 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: Manual at mysql.com
Luc Foisy writes: > the search query is broken > > Luc Foisy > We shall notify our web team. -- 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: How to limit database size?
Hello, - Original Message - From: "Egor Egorov" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, May 17, 2002 1:42 PM Subject: Re: How to limit database size? [how to limit database size?] > > You can't do it with MySQL, use disk quotas ... > Thanks for your answer. What happens if a user tries to add more data to a table after the files containing his database reached the hard disk quota limit. Does it make any diffrence which file (.frm .myi .myd) reaches the disk quota limit ? Alexander Newald - 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
Manual at mysql.com
the search query is broken Luc Foisy - 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
mysqld got signal 11;
Can anyone tell me what this means?? mysqld got signal 11; The manual section 'Debugging a MySQL server' tells you how to use a stack trace and/or the core file to produce a readable backtrace that may help in finding out why mysqld died Attemping backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong Cannot determine thread, ebp=0xb, backtrace may not be correct Bogus stack limit or frame pointer, aborting backtrace Number of processes running now: 0 Luc Foisy - 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: Socket trouble
Amy - See my message and the fix for mysql. Todd -- Todd Cary Ariste Software 2200 D Street Extension Petaluma, CA 94952 707-773-4523 [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
Socket trouble
> When trying to connect to mysql database i get this error message "Cant > connect to local MySQL server through socket "/tmp/mysql.sock" > > Yet I can connect through TCP/IP ~ what happened to my socket? > > Any suggestions? > Thanks > Amy > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql case sentivity table names
Hi all, You surely take note that a mysql server under windows take the same table when selecting from T_User or t_user, it is case insensitive. Every update into these tables rename all case sensitive table into insensitive one. I have to be carfull to check my tables names before copying datadir file from my windows box to nix one. I found a utility which ca avoid me to do that : http://www.0x00.org/programs/CASElow/index.php It make caseinsentive shell !!! Can we put it in the distrib ? Thanks _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.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
date question
for mysql, if I have a text file that has the date as 5/17/2002, is there a way I can translate that to mysql's version of the date, i.e. 2002-05-17? With Load Data as well? Thanks, Taylor Taylor Lewick Unix System Administrator Fortis Benefits 816 881 6073 "Help Wanted. Seeking Telepath..." "You Know where to apply." Please Note The information in this E-mail message is legally privileged and confidential information intended only for the use of the individual(s) named above. If you, the reader of this message, are not the intended recipient, you are hereby notified that you should not further disseminate, distribute, or forward this E-mail message. If you have received this E-mail in error, please notify the sender. Thank you * - 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
Performances with BLOB fields in mySql
My application (C++, mySql++, WINNT) is very time-critical and space-critical and use blob field. How can I improve performances? Which parameters can I set? There's literature about this question? Thak's, I'm sorry for my English. Bye, Marco - 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
Mysqlimport "not allowed"
Hi! Receive the message: "mysqlimport: Error: The used command is not allowed with this MySQL version, when using table: t_parameter." What´s this?? Thanks, /Jonas - 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: Sorting a varchar field...
SELECT ... FROM tablename ORDER BY varcharcolumn+0; Gurhan -Original Message- From: Maksim Rogov [mailto:[EMAIL PROTECTED]] Sent: Friday, May 17, 2002 9:44 AM To: [EMAIL PROTECTED] Subject: Sorting a varchar field... Hi, I am new to the list :) Have a question, I have not been able to find any information on this on the MySQL site. Is it possible to sort a varchar field that contains numbers as an integer field? ie. right now it is sorting 1,2,4,10,11,12 as: 1 10 11 2 4 I would like to see it properly sorted. The reason the field is varchar is because we may *sometimes* have string characters in the field. Thanks for your help, Maksim - 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
Sorting a varchar field...
Hi, I am new to the list :) Have a question, I have not been able to find any information on this on the MySQL site. Is it possible to sort a varchar field that contains numbers as an integer field? ie. right now it is sorting 1,2,4,10,11,12 as: 1 10 11 2 4 I would like to see it properly sorted. The reason the field is varchar is because we may *sometimes* have string characters in the field. Thanks for your help, Maksim - 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: Socket problem connecting
Egor - Question 1: I located where mysql.sock is located - /var/lib/mysql/mysql.sock - NOT /tmp. However, it is a symbolic link. Shouldn't there be an actual file in addition to the symbolic link? Linux is very new to me, so I am not up to speed on many of the intricacies. Question 2: There is not a my.cnf file on my system. How do I determine where mysql is looking for my.cnf so that I can create one in that location? Many thanks. Todd -- Todd Cary Ariste Software 2200 D Street Extension Petaluma, CA 94952 707-773-4523 [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
16+ hours to drop an index?
Does anyone have an idea why it would take over 16 hours to drop an index on an innodb table. The table has/had about 1.7 million records. I used the sql query "alter table table_name drop index index_name". I issued the command before I left work yesterday and it was still running this morning. TOP reported 0% idle. -- Walter Anthony System Administrator National Electronic Attachment Atlanta, Georgia 1-800-782-5150 ext. 1608 "If it's not broketweak it" - 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
Looking for OS X Developer
Hi there. I'm looking for a BSD developer to start talks about developing on OSX. Components: - Darwin (Macintosh OS X Open Source) - MySQL - HylaFax If anybody knows where I can find a developer to do this, I would appreciate a quick note. Please contact me via email. Cheers. @@@ Rich Fortnum / Viaduct Productions / Toronto (EST) @@@ Web Design / Databases / Internet Video / Wireless Data @@@ [EMAIL PROTECTED] / http://www.viaduct-productions.com @@@ Canadian Lasso Association http://www.canlasso.ca - 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
Socket trouble
When trying to connect to mysql database i get this error message "Cant connect to local MySQL server through socket "/tmp/mysql.sock" Yet I can connect through TCP/IP ~ what happened to my socket? Any suggestions? Thanks Amy - 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
Index X No Index
Hi, Let´s supose that we have a table with this features : - about 7 records; - only a primary index; - about 30 fields; - 50% of SELECTS and 50% of INSERTS/UPDATES. The SELECTS typically uses about 3 or 4 fields in the WHERE clause. Creating indexes, one for each field used on SELECTS, will speed up things ? Or the overhead of updating the indexes on INSERTS/UPDATES does not compensate ? MySQL v 3.22.32, Linux Kernel 2.2.17, Pentium III, 256 Ram, 50 dbs, 15 tables in avg / db, 1 db with 200 tables, about 10 simultaneous users. Regards, João Alexander Marques [EMAIL PROTECTED] Uranet Projetos & Sistemas Ltda. Tel. : 55 11 3242-1353 - 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
Performances with BLOB field in mySql
My application (C++, mySql++, WINNT) is very time-critical and space-critical and use blob field. How can I improve performances? Which parameters can I set? There's literature about this question? Thak's and excuse my English. Bye, Marco - 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 fulltext search in latest mysql-4.0.2 source
Hi! On May 16, Jocelyn Fournier wrote: > Hi, > > I don't understand, I modified ulong ft_min_word_len=3; in > myisam/ft_static.c, and then recompiled MySQL using > BUILD/compile-pentium --without-innodb script, but show variables still > displays after restarting mysql : > > | ft_min_word_len | 4 > | ft_max_word_len | 254 > | ft_max_word_len_for_sort| 20 > > Any idea of what could be wrong ? > > Thanks and regards, > Jocelyn Fournier In 4.0 it's a true variable - you don't need to recompile MySQL - just add to /etc/my.cnf ft_min_word_len=3 :) Regards, Sergei -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany <___/ - 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: boolean-mode fulltext search: problems with +searchterm*
Hi! On May 17, Carl J Meyer wrote: > >Description: > It appears that MySQL can have trouble with a searchterm > in a boolean-mode fulltext index search which is both prefixed > with + and suffixed with *, when that searchterm is paired > with another required term. The empty set is returned when there are rows > which should match. There were a number of bugs fixed in boolean fulltext search since 4.0.1. Several of them were truncation-operator-related. So - if you will fail to create a test case, you may wait for 4.0.2 to be out (it should not take more than a one-two weeks), and see whether this bug is fixed. Regards, Sergei -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany <___/ - 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: please advice me.
ally, Friday, May 17, 2002, 1:32:42 PM, you wrote: a> I'm very new to mysql and i really need all the help and advice from you a> pros. a> Well i'm trying to develop a site using chinese characters where my users a> can login. a> does mysql support chinese char ? if not wht shd i do... i can only use a> mysql. a> My Son nguyen can you please tell me how u did the magic of using viet char? Take a look at gbk, gb2312, big5 character sets. How to add new character sets you can read at: http://www.mysql.com/doc/C/h/Character_sets.html http://www.mysql.com/doc/M/u/Multi-byte_characters.html a> thank you very much for your help and comprehension. a> regards, a> ally -- 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: [Fwd: Bug Report]
hugh, Friday, May 17, 2002, 5:06:46 AM, you wrote: h> Description: /usr/libexec/mysqld: error while loading shared libraries: cannot open shared object file: cannot open shared object file: No such file or directory. h> How-To-Repeat: h> /usr/libexec/mysqld -u root h> /usr/bin/safe_mysqld h> Fix: h> What exactly shared library MySQL can't open? Please, show me the full error message and the output of the following: ldd /usr/libexec/mysqld -- 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