AW: Finally found mysql-nt service error 1061 1067
That's a least what I found out - other new users have the same problem too. The ptoblem resides on WinNT/2K only (at least what I read), so probably you are right, it might be a WinNT/2K specific problem. Anyway, MySQL is a good product - that's what all say. For me, I am happy to be able to use MySQL as a service :-) So long A:lex -Ursprungliche Nachricht- Von: Gerald R. Jensen [mailto:[EMAIL PROTECTED]] Gesendet: Dienstag, 19. Marz 2002 03:02 An: '[EMAIL PROTECTED]'; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; '[EMAIL PROTECTED]' Betreff: RE: Finally found mysql-nt service error 1061 1067 Alex: I doubt this issue is a 'general mysql-nt problem'. In truth, MySQL is a very well-designed, well-behaved service. I have installed about 80 MySQL servers on customer-owned WinNT/2K servers. If this were a 'general mysql-nt problem', I would have had to set a login account in the SCM for each one. To the best of my recollection, I have only had to do it twice in a little more than two years. I tend to think it has something to do with permissions on the machine or perhaps a general configuration setting in WinNT/2K, but I can't prove/disprove that. Miguel Solorzano is a MySQL full-timer with a good deal of experience in this area ... he reads the list, and may be able to offer some insight here. Gerald Jensen -Original Message- From: Alexander Hampel [SMTP:[EMAIL PROTECTED]] Sent: Monday, March 18, 2002 9:05 AM To:[EMAIL PROTECTED] Cc:Gerald Jensen; [EMAIL PROTECTED] Subject: Finally found mysql-nt service error 1061 1067 Hi Gerald, The 'System-Account' did not work BUT the 'Admin' user account did! You were right :-) How comes? That's what I always do: (1) Install a service on 'System Account' and than (2) change it to an user account of my choice After 2 days wasting time trying to get the installation run, I ask myself how things like this can happen? Seems to be a 'general mysql-nt problem' if I take a look at how many questions arise to this specific issue. Anyway - thanks to all of you helping me by giving me advices :-) Special thanks to you Gerald, so long A:lex -Ursprungliche Nachricht- Von: Gerald Jensen [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 18. Marz 2002 15:13 An: [EMAIL PROTECTED] Betreff: Re: NT service problem Then you may have a problem with services running under the System Account on this machine. Try this: - Go into the Control Panel's Service Control Manager - Click on the MySQL service - Click on the 'Startup' button - Make sure 'Automatic' is selected - Select 'This Account' (instead of 'System Account') - Choose an Admin-level user and set the correct password - Click 'OK' then click 'Start' Gerald Jensen - Original Message - From: Alexander Hampel [EMAIL PROTECTED] To: Gerald R. Jensen [EMAIL PROTECTED] Sent: Monday, March 18, 2002 7:45 AM Subject: AW: NT service problem Thanks - my.ini is used. Tried to use come of your parameters - but nothing changed. The interesting part: the standalone run is fine, the service part is wrong - so it has something todo with the service ?!? So long A:lex -Ursprungliche Nachricht- Von: Gerald R. Jensen [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 18. Marz 2002 13:40 An: [EMAIL PROTECTED]; [EMAIL PROTECTED] Betreff: Re: NT service problem Check the location of the configuration file (should be either c:\my.cnf ~ OR ~ c:\winnt\my.ini), then edit the contents of that file. Here is a sample: [client] #password=my_password port=3306 #socket=MYSQL # [mysqld] port=3306 #socket=MYSQL skip-locking #enable-locking set-variable = key_buffer=16M set-variable = max_allowed_packet=1M set-variable = thread_stack=128K set-variable = flush_time=1800 log=C:/mysql/mysql.log basedir = C:/MYSQL/ # [mysqldump] quick set-variable = max_allowed_packet=16M # [MYSQL] no-auto-rehash # [isamchk] set-variable= KEY=16M # [client_fltk] help_file= C:\\MYSQL\guiclient\MYSQL.help client_file= C:\\MYSQL\mysql.opt history_length=20 database = goetznet queries_root= C:\\MYSQL\queries last_database_file= C:\\MYSQL\lastdb - Original Message - From: Alexander Hampel [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, March 18, 2002 1:37 AM Subject: NT service problem Hi Pierre, Thanks, for your help. That's what I exaclty do and this is for '--standalone' fine. But the point ist, I want to start mysqld-nt as NT service - and this is the problem - it wouldn't let me start it as service: C:\net start mysql System error 1069 Could not start service The service is an important issue. Lets you run a programm under different user rights. Probably I'll find some other solution. Thanks, A:lex -Ursprungliche Nachricht- Von: Pierre du Parte [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 18. Marz 2002 08:04 An: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Betreff: Re: New to MySQL - can't start server
mysqldump and foreign keys
Hi, I just installed the MySQL max 4.0.1 and created a database with two INNODB and FOREIGN KEY tables as described in the Docs. When I run the mysqldump -a -B -c test I don't get the foreign key information. Any hint? Adib. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Can i use rsync instead of Replication
Hello all, Can i use rsync instead of replicating two servers for mysql( particular database db). If yes Then just clear off my doubt whether it will lead to any data loss as while doing rsync. Thanx in advance. Regards, Charitha. C. -- Regards, CC - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 mysql db from a bash script?
Hi Is that possible to query the database from a bash script? I need some informations from a table, and it looks the easiest way. How can I connect, use a database, and query a table? Thanks in advance! Regards; Istvan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 fatal error in mysql-opt.exe
Hi! cut I'm trying to run MySQL ver 3.23.49 on Win98 with Apache, PHP Perl. Apache reports that PHP Perl are running OK. When I try to start MySQL, or let it start on boot, or try to use the WinMySqladmin program, I get a Windows error from MYSQLD-OPT.exe, with the usual Win98 close and details and the console screen for that program reads: c:\serve\MySql\bin\mysql-opt.exe: Fatal error: Can't find messagefile 'C: erve\MySql\share\english\errmsg.sys' It seems the program is looking in C:/ erve when in fact the relevant errmsg.sys file is in the C:/serve folder into which everything was installed, along with the complete MySQL installation. There is no C:/ erve folder. I can't get MySql to run. Fix: Change in your my.ini file: c:\serve to c:/serve or c:\\serve (The problem is that the MySQL configure files uses \ as a escape symbol) Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Question
To Dear Sirs 19/03/02 I am pankaj from Bombay India I have downloaded Version mysql -3.23.49,my question is why dosent mysql support Transactions (Rollback ,Commit) lie Oracle or Ms Sql Server Etc From Pankaj - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 mysql db from a bash script?
Takacs, I think you can use mysql --execute=select * from whatever databasename you should be able to execute mysql command thru bash that way. chad On Tue, 19 Mar 2002 10:20:08 +0100 Takacs Istvan [EMAIL PROTECTED] wrote: Hi Is that possible to query the database from a bash script? I need some informations from a table, and it looks the easiest way. How can I connect, use a database, and query a table? Thanks in advance! Regards; Istvan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Question
I hope what I am going to say does not appear short or rude. It is not meant to be. Having said that - Why do you think MySQL doesn't support transactions? Have you read the documentation? You really should read all of the available documentation before posting a question like that. You have misconceptions that the current publicly available documentation would clear up. MySQL (via an external db) does support transactions. Charles Q. At 03:23 PM 3/19/2002 +0530, you wrote: To Dear Sirs 19/03/02 I am pankaj from Bombay India I have downloaded Version mysql -3.23.49,my question is why dosent mysql support Transactions (Rollback ,Commit) lie Oracle or Ms Sql Server Etc From Pankaj - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Question
Hi Pankaj, It does support transactions...download MySQL Max: http://www.mysql.com/downloads/mysql-max-3.23.html You have the option of either innodb or BDB based tables for transactions..support for both of these is compiled into MySQL max. regards, Simon On 19 Mar 2002 at 15:23, pankaj wrote: To Dear Sirs 19/03/02 I am pankaj from Bombay India I have downloaded Version mysql -3.23.49,my question is why dosent mysql support Transactions (Rollback ,Commit) lie Oracle or Ms Sql Server Etc From Pankaj - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Simon Weller [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: InnoDB: Assertion failure in thread 10 in file btr0btr.c line 574
Alex, the assertion means that when InnoDB looks for a father node pointer to a page in the B-tree, it ends up on a pointer which does not point to the child page. In other words, the B-tree is corrupt. I see that the lsn of your database is rather small. Did you do anything special before the crash? You can try addding the following code on line 572 of btr0btr.c so that we see what index in what table is corrupt and how. That can give a clue what might be the bug: if (btr_node_ptr_get_child_page_no(node_ptr) != buf_frame_get_page_no(page)) { printf(Table %s, index %s, father ptr page no %lu, child page no %lu\n, (UT_LIST_GET_FIRST(tree-tree_indexes))-table_name, (UT_LIST_GET_FIRST(tree-tree_indexes))-name, btr_node_ptr_get_child_page_no(node_ptr), buf_frame_get_page_no(page)); page_rec_print(page_rec_get_next(page_get_infimum_rec(page))); page_rec_print(node_ptr); } I have added the above code now to 3.23.50. When you have printed the above info, you may want to recover your database. Look in section 6.1 of http://www.innodb.com/ibman.html about forcing recovery. Regards, Heikki Tuuri Innobase Oy -Original Message- From: BAUMEISTER Alexandre [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED]; Michael Widenius [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Tuesday, March 19, 2002 11:51 AM Subject: InnoDB: Assertion failure in thread 10 in file btr0btr.c line 574 Bonjour, We have Mysql continually crashing with this assertion failure in InnoDB. Mysql-3.23.49 configured with by : === = ./configure --prefix=/usr/local/mysql--without-bench --enable-thread-safe-client --with-innodb --without-debug --without-berkeley-db --without-raid --enable-local-infile === = Here are the logs : === = 020319 10:43:13 mysqld restarted 020319 10:43:16 InnoDB: Database was not shut down normally. InnoDB: Starting recovery from log files... InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 722513183 InnoDB: Doing recovery: scanned up to log sequence number 0 722514672 020319 10:43:16 InnoDB: Starting an apply batch of log records to the database... InnoDB: Progress in percents: 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 InnoDB: Apply batch completed 020319 10:43:18 InnoDB: Flushing modified pages from the buffer pool... 020319 10:43:18 InnoDB: Started /usr/local/mysql/libexec/mysqld: ready for connections 020319 10:43:18 Warning: Checking table: './popup/campagne' 020319 10:43:24 Warning: Checking table: './boursoscan/abonnes' InnoDB: Assertion failure in thread 10 in file btr0btr.c line 574 InnoDB: We intentionally generate a memory trap. InnoDB: Send a detailed bug report to [EMAIL PROTECTED] mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked agaist is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail key_buffer_size=134213632 record_buffer=1044480 sort_buffer=2097144 max_used_connections=82 max_connections=650 threads_connected=32 It is possible that mysqld could use up to key_buffer_size + (record_buffer + sort_buffer)*max_connections = 2125262 K bytes of memory Hope that's ok, if not, decrease some variables in the equation === = And here are the config options : === = [mysqld] port= 3306 socket = /tmp/mysql.sock skip-locking skip-name-resolve local-infile set-variable= max_connections=650 set-variable= key_buffer=128M set-variable= max_allowed_packet=5M set-variable= table_cache=512 set-variable= sort_buffer=2M set-variable= record_buffer=1M set-variable= myisam_sort_buffer_size=64M set-variable= thread_cache=8 set-variable= thread_concurrency=8 # Try number of CPU's*2 myisam-recover = BACKUP,FORCE innodb_data_home_dir = /usr/local/mysql/innobase_var/innobase_data/ innodb_data_file_path = ibdata1:2000M set-variable = innodb_mirrored_log_groups=1 innodb_log_group_home_dir = /usr/local/mysql/innobase_var/innobase_logs/ set-variable = innodb_log_files_in_group=5 set-variable =
[Fwd: Re: query mysql db from a bash script?]
Hi, If you can't read that output, try the select * from mytable INTO OUTFILE absolutepath/myfile.txt FIELDS TERMINATED BY , LINES TERMINATED BY \r\n statement. I do somthing with this :-) Adib. chad kellerman wrote: Takacs, I think you can use mysql --execute=select * from whatever databasename you should be able to execute mysql command thru bash that way. chad On Tue, 19 Mar 2002 10:20:08 +0100 Takacs Istvan [EMAIL PROTECTED] wrote: Hi Is that possible to query the database from a bash script? I need some informations from a table, and it looks the easiest way. How can I connect, use a database, and query a table? Thanks in advance! Regards; Istvan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 -- WIGE DATA GmbH Wiesenring 11, D-04159 Leipzig, Germany Adib Taraben Electronic Engineer PHONE +49 (0)341 - 46 21 100 FAX +49 (0)341 - 46 21 400 E-MAIL [EMAIL PROTECTED] INTERNETwww.wige-data.de A company of WIGE MEDIA AG - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: InnoDB: Assertion failure in thread 10 in file btr0btr.c line 574
Alex, since you are French, I assume you have accent characters in the strings you have stored into your database. The ordering of accent characters changed in 3.23.44! You must dump and reimport your tables to 3.23.49 so that the index trees are sorted in the right order. Regards, Heikki Innobase Oy -Original Message- From: BAUMEISTER Alexandre [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED]; Michael Widenius [EMAIL PROTECTED] Date: Tuesday, March 19, 2002 12:18 PM Subject: Re: InnoDB: Assertion failure in thread 10 in file btr0btr.c line 574 Bonjour, BA We have Mysql continually crashing with this assertion failure in BA InnoDB. I have attached to this email and extract from the error log which starts at the origin of the problem. First lines are : 020318 18:24:42 mysqld started InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 020318 18:24:45 InnoDB: Started /usr/local/mysql/libexec/mysqld: ready for connections InnoDB: error in sec index entry update in InnoDB: index log table popup/popup InnoDB: tuple 0: len 20; hex 616e647265747469202020202020202020202020; asc andretti;; 1: len 6; hex 0004364d; asc 6M;; InnoDB: record RECORD: info bits 0 0: len 20; hex 616e6472e9737069202020202020202020202020; asc andr.spi;; 1: len 6; hex 000313f0; asc .. ;; InnoDB: Make a detailed bug report and send it InnoDB: to [EMAIL PROTECTED] TRANSACTION 0 11033371, OS thread id 46058 updating or deleting, active, runs or sleeps, has 600 lock struct(s), undo log entries 1920 MySQL thread id 437808, query id 1064058 localhost root Sending data replace into popup select '9',p.log,'1' from compte.portefeuilles p, compte.contenus_portefeuilles c InnoDB: error in sec index entry update in InnoDB: index log table popup/popup InnoDB: tuple 0: len 20; hex 70736f7564e92020202020202020202020202020; asc psoud. ;; 1: len 6; hex 0004aadd; asc ª.;; InnoDB: record RECORD: info bits 0 0: len 20; hex 70736f7564652020202020202020202020202020; asc psoude ;; 1: len 6; hex 0003c357; asc .. ...W;; As you can see, I did an upgrade of Mysql on this server yesterday. From 3.23.41 to 3.23.49 . Please see attached file for complete logs. As this server is no more usable we had to stop it, delete all InnoDB files (data+log). We are currently restarting it and recreating databases. Regards, Alex. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
what makes mysql table corrupt?
Patrick, Tuesday, March 19, 2002, 5:33:31 AM, you wrote: PH When I periodically do myisamchk -s *.MYI, PH it sometimes complains that some tables are corrupt. PH Is there any way to keep mysql tables healthy? What are the reasons to PH cause the table corruption? There are different causes of table corruption. You can find some of them if you look at: http://www.mysql.com/doc/C/o/Corrupted_MyISAM_tables.html Please, check also the following link; it will be useful for you too. You can find info about database backups, restoring and checking tables at: http://www.mysql.com/doc/D/i/Disaster_Prevention.html PH Thanks. -- For technical support contracts, goto https://order.mysql.com/ 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
differences
RBRoa, Tuesday, March 19, 2002, 1:22:22 AM, you wrote: R Everyone, R What's the differences with MySQLD and MySQL-max? MySQL-max is the MySQL server that support InnoDB and BDB table types. You can read about mysqld-max in the manual: http://www.mysql.com/doc/m/y/mysqld-max.html R R.B.Roa -- For technical support contracts, goto https://order.mysql.com/ 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
Question
pankaj, Tuesday, March 19, 2002, 11:53:33 AM, you wrote: p I am pankaj from Bombay India p I have downloaded Version mysql -3.23.49,my question is why dosent mysql p support Transactions (Rollback ,Commit) lie Oracle or Ms Sql Server Etc MySQL supports transactions in InnoDB and BDB tables. If you check the following links you can find info about InnoDB and BDB tables: http://www.mysql.com/doc/T/a/Table_types.html http://www.mysql.com/doc/I/n/InnoDB_transaction_model.html http://www.mysql.com/doc/B/D/BDB.html You can also read about COMMIT/ROLLBACK in the manual: http://www.mysql.com/doc/C/O/COMMIT.html How to set transaction isolation level look at: http://www.mysql.com/doc/S/E/SET_TRANSACTION.html From Pankaj -- For technical support contracts, goto https://order.mysql.com/ 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
Jobs by email
Hello, I would like to know how the 'jobs by email' service provided by employment sites works and whether it is simple to develop or better to buy the software. I need to set up scheduled automated email to users detailing news headlines based on the email addresses and associated interests, held in mySQL tables. Functions must allow for: bulk contact (100k + user lists) batch sending (because of above numbers) automated contact i.e. set-up an email template and automatically populate the particular fields and include search results in the message body scheduled contact (to run late at night) adhoc contact Ideally I'd prefer a client side (windows) application, also with online access for remote administration. My site will be hosted by a third party using mySql and php. I have found applications that do some of these tasks but none that do them all. Is this because I need separate applications to fulfil this i.e. emailer and a scheduler? Many thanks, Joe - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
remove nobody
Hello, I've got one last issue removing user accounts. I notice I have a usera number nobody. However when I look at the grants I get an error; mysql show grants for nobody@localhost; ERROR 1141: There is no such grant defined for user 'nobody' on host 'localhost' mysql show grants for ' '@localhost; ERROR 1141: There is no such grant defined for user ' ' on host 'localhost' They are also no entries for the nobody user in the user table in the mysql database; mysql select * from user where user='nobody'; Empty set (0.00 sec) I am thinking perhaps the error for exists because the show grants will not work for a blank user the nobody user is perhaps not a standard user account ?? Is this correct ?? How do I remove these unwanted user accounts ? or is there a reason I should keep them (like bad things will happen to sql) ? With Thanks Steve. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
OSX and Virtual Hosting set-up?
Hello all, I am new to the list and have a quick question (I'm sure it won't be my last). I am running Mac OSX and I have PHP and MySQL running. My question is this. I provide web hosting, and I want to offer my clients access to MySQL. How do I set up Mysql so that every virtual host has their own set of databases (or tables) that only they can access? I don't want one client able to access another client's records. Let's just say we have 3 domains. How would they be setup using mysql? domain1, domain2 and domain 3 Is mysql just one big database and everyone on the server uses it? Forgive me I am new and just trying to wrap my head around all this. Thanks to anyone that can give me some direction. -- Mike Yrabedra [EMAIL PROTECTED] http://www.macsurfshop.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: Question
Hi pankaj.. You can compile mysql with innodb option..then you can have all the transactions you ever want to have. regards Kannan pankaj [EMAIL PROTECTED] on 03/19/2002 03:23:33 PM To: [EMAIL PROTECTED] cc: (bcc: Kannan R/Satyam) Subject Question : To Dear Sirs 19/03/02 I am pankaj from Bombay India I have downloaded Version mysql -3.23.49,my question is why dosent mysql support Transactions (Rollback ,Commit) lie Oracle or Ms Sql Server Etc From Pankaj - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: mysqldump and foreign keys
hi, I am also using the Innodb table type for my database. when I am using the mysqldump for dumping the tables it really doesn't shows the foreign key in the table structure. but if after deleting my previous database I again create my database using the same dumped file and executes the mysqldesc tablename (at mysql command prompt) it shows the foreign keys.. am i right..?? Actually, I also wanted to know !! I am telling u what i have done and seen. Please, u also try for the same and see if it works fine. please, tell me also regarding this... Thanks and regards, Chetan Lavti - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Leap seconds
matt, Tuesday, March 19, 2002, 8:31:08 AM, you wrote: Try to install the official MySQL binary distribution (3.23.49a) from www.mysql.com and check timestamp there. There was some bugs about timezones in old version of MySQL/glibc. mDescription: m A timestamp value selected back is 38 seconds later than what m was inserted. mHow-To-Repeat: m ln -s /usr/share/zoneinfo/right/US/Pacific /etc/localtime m mysql test m mysql create table teststamps (stamp timestamp); m mysql insert teststamps values (2002010100); m mysql select * from teststamps; m ++ m | stamp | m ++ m | 2002010138 | m ++ m 1 row in set (0.00 sec) mFix: m Please tell me. -- For technical support contracts, goto https://order.mysql.com/ 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
mysqladmin - access denied
Vernon, Tuesday, March 19, 2002, 3:19:35 AM, you wrote: V I'm having trouble with Apache dying after log rotation and have tracked V it down to the mssqladmin. When I try the: V /usr/sbin/logrotate -f /etc/logrotate.conf V I get the following error: V /usr/bin/mysqladmin: connect to server at 'localhost' failed V error: 'Access denied for user: 'root@localhost' (Using password: NO)' V /usr/bin/mysqladmin: connect to server at 'localhost' failed V error: 'Access denied for user: 'root@localhost' (Using password: NO)' V What does MySQL have to do with log rotation? How do I get this to stop V causing Apache to die? Did you install Apache with some modules that uses MySQL? Does your Apache keep logs through MySQL or Apache autorization makes using MySQL ? V Thanks -- For technical support contracts, goto https://order.mysql.com/ 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
Cannot execute binary file error
Amrita, Monday, March 18, 2002, 9:19:33 PM, you wrote: AB Hi, AB I wanted to know what the error poosibly could be. AB I am using RedHat 6.0 Kernel 2.2.20 on i686 and AB installed mysql 3.23.47-sgi-irix6.5. I m running sh AB ./bin/safe_mysqld from the root directory and am AB getting the error : cannot execute binary file. You have installed a wrong binary version. sgi-irix is a build for SGI computers running IRIX, and you need Red Hat RPMs from http://www.mysql.com/ AB Thanks so much, AB Amrita -- For technical support contracts, goto https://order.mysql.com/ 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
Unicode
vthang, Tuesday, March 19, 2002, 7:50:52 AM, you wrote: v I'm a new MySQL user. v Does MySQL database support Unicode (UTF-8)? MySQL doesn't currently support Unicode. It will be supported in 4.1 version of MySQL. You can read about it at: http://www.mysql.com/doc/T/O/TODO_MySQL_4.1.html v Thanks. -- For technical support contracts, goto https://order.mysql.com/ 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
Fresh RedHat 7.2 install
Hello, This is a newbie question for a reason...I am. I've installed the lastest RPM for mysql on a brand new redhat 7.2 installation. When I try to run mysqladmin to set my new password (or for any reason actually, even to see the version number) I get the following error. I am not able to update the database either. As this is a fresh install, I'm thinking somebody probably has a quick-fix for me (maybe something about the OS pops into your head). I haven't seen this addressed in the manual pages. mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)' Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists! Thank You, Corey Baldwin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: AIX binary distribution bug
Mike Gahan writes: Description: mysql binaries from AIX binary distribution will not run. 1 % cd /tmp/mysql/bin 2 % ./mysql Could not load program ./mysql: Dependent module /usr/lib/libz.a(shr.o) could not be loaded. Member shr.o is not found in archive Hi! This is a known problem and will be fixed in 3.23.50 which should be out in two weeks. -- 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: OSX and Virtual Hosting set-up?
hello mike, i've got a similar set-up on my g4 - only i'm not quite at the hosting point yet. the way i think i would go about it is create a database per domain and use phpmyadmin (saves using the command line!) to grant 'user' permissions to each domain name. this 'user' would be able to do a full range of tasks with the database. i'd then also set-up 'web' permissions so that hosts connecting in can select, insert, delete and update rows in the tables - that way the php scripts can talk to the database. hope this helps! cheers, jake p.s. phpmyadmin is excellent! i use it all the time - it at: http://www.phpwizard.net/projects/phpMyAdmin/ on 19/3/02 11:28, Mike Yrabedra at [EMAIL PROTECTED] wrote: Hello all, I am new to the list and have a quick question (I'm sure it won't be my last). I am running Mac OSX and I have PHP and MySQL running. My question is this. I provide web hosting, and I want to offer my clients access to MySQL. How do I set up Mysql so that every virtual host has their own set of databases (or tables) that only they can access? I don't want one client able to access another client's records. Let's just say we have 3 domains. How would they be setup using mysql? domain1, domain2 and domain 3 Is mysql just one big database and everyone on the server uses it? Forgive me I am new and just trying to wrap my head around all this. Thanks to anyone that can give me some direction. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
all databases deneid
I typed SELECT SYSTEM_USER() ..The output is ++ | system_user() | ++ | ODBC@localhost | ++ 1 row in set (0.00 sec) I then tried mysql -h localhost -u ODBC Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 19 to server version: 3.23.44-nt Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql use mysql ERROR 1044: Access denied for user: 'localhost' to database 'mysql' mysql mysql show databases; +-+ | Database| +-+ | Meet_a_Geek | | database05 | | db001 | | db002 | | mrbs| | mysql | | sample_db | | shopcart| | test| +-+ 9 rows in set (0.00 sec) == I try to use USE command for different datbases indicated by SHOW DATABASES; All are denied access. mysql use Meet_aGeek; ERROR 1044: Access denied for user: 'localhost' to database 'Meet_aGeek' mysql use database05; ERROR 1044: Access denied for user: 'localhost' to database 'database05' mysql use db001; ERROR 1044: Access denied for user: 'localhost' to database 'db001' mysql use db002; ERROR 1044: Access denied for user: 'localhost' to database 'db002' mysql Introduction to MYSQL at your recommendation is confusing because it includes UNIX and Windows. I am using Windows XP. == shell mysql -h host -u user -p Enter password:
Re: MYSQL: converting MysqlColData to char
Rick Runowski writes: All, I am having difficulty converting the results of a query to a character. Here is A snippit of code. You can not get chars from [] operator. You have to first convert ColData to string, e.g. like this : string xx(row[j]), or use row_data() method (cgi_image.cc). -- 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
Slightly OT: How to create a datetime compatible value in Perlfor mySQL?
Hello list, I need to write a small perl skript to insert a record (email, timestamp) into a table. Two problems: 1. Since email is unique I don't want to get the duplicate record message. If email already exist, the perl program should continue silent. 2. How do I create a datetime-compatible entry in Perl? TIA, Martin P.S. Yeah, I'm a Perl newbie... :-( * sql, query * - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re[2]: InnoDB: Assertion failure in thread 10 in file btr0btr.c line 574
Heikki, HT since you are French, I assume you have accent characters in the strings you HT have stored into your database. HT The ordering of accent characters changed in 3.23.44! No accents. InnoDB tables on this server are mainly used for statistics, counters etc ... HT You must dump and reimport your tables to 3.23.49 so that the index trees HT are sorted in the right order. Since the crash we re-created everything so ... :) But I have still something strange with this server. I have two tables with the same create : create table popup( campagne int(11) unsigned not null, log char(20) not null, cpt int(11), unique(campagne,log), index(log) )type=InnoDB; and create table popup2 ... (same create). Table popup is not empty and is selected/updated from web pages (counting popup screened). I'm inserting some data in table popup2 : mysql insert into popup2 select '9',p.log,'1' from compte.portefeuilles p, compte.contenus_portefeuilles c where c.idport=p.idport and c.symbole='1rPEAD'; Query OK, 41495 rows affected (27.06 sec) Records: 52454 Duplicates: 10959 Warnings: 0 And then trying to insert into table popup all what is in table popup2 : mysql insert into popup select * from popup2; ERROR 1213: Deadlock found when trying to get lock; Try restarting transaction mysql replace into popup select * from popup2; ERROR 1213: Deadlock found when trying to get lock; Try restarting transaction I don't see why this deadlock ... Regards, Alex. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Crash when loading data from file
Hendrik, Monday, March 18, 2002, 10:04:44 AM, you wrote: HN We have problem with moving data to new server. We dumped HN database with mysqldump on old server and used HN mysql dbname db.sql syntax for database import. HN When mysql imports one of our biggest table, then the import fails and HN after some minutes gives an error message: HN ERROR 1030 at line 244654: Got error 28 from table handler [greta@esther greta]$ perror 28 Error code 28: No space left on device HN What might be the problem? HN MySQL version on new server is 3.23.49a-log. Server have RedHat HN 7.2 installed, RAID disks, 512MB RAM, CPU is Intel PIII. HN If the problem is caused with RAID, then, how to set the have_raid HN variable to ON (I hasn't find this operation from manual). MySQL RAID support has no relation to Linux's RAID support and Linux's RAID support has no connections to hardware RAIDs. So which RAID do you mean? If MySQL one, you can read about it at: http://www.mysql.com/doc/C/R/CREATE_TABLE.html have_raid is not a variable you can set. It's a variable that is used to check if MySQL is compiled with a various options like InnoDB, BDB, RAID and so on. HN Hendrik -- For technical support contracts, goto https://order.mysql.com/ 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: all databases deneid
Hi, I don't about your special problem ... I also run MySQL on Win32 (WIN2000). It seems to me that someone made a GRANT and denied everyone from localhost to your database. You can try from an other PC or use GRANT to give everyone from localhost access to the database. Adib. alan4100 wrote: I typed SELECT SYSTEM_USER() ..The output is ++ | system_user() | ++ | ODBC@localhost | ++ 1 row in set (0.00 sec) I then tried mysql -h localhost -u ODBC Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 19 to server version: 3.23.44-nt Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql use mysql ERROR 1044: Access denied for user: '@localhost' to database 'mysql' mysql mysql show databases; +-+ | Database| +-+ | Meet_a_Geek | | database05 | | db001 | | db002 | | mrbs| | mysql | | sample_db | | shopcart| | test| +-+ 9 rows in set (0.00 sec) == I try to use USE command for different datbases indicated by SHOW DATABASES; All are denied access. mysql use Meet_aGeek; ERROR 1044: Access denied for user: '@localhost' to database 'Meet_aGeek' mysql use database05; ERROR 1044: Access denied for user: '@localhost' to database 'database05' mysql use db001; ERROR 1044: Access denied for user: '@localhost' to database 'db001' mysql use db002; ERROR 1044: Access denied for user: '@localhost' to database 'db002' mysql Introduction to MYSQL at your recommendation is confusing because it includes UNIX and Windows. I am using Windows XP. == shell mysql -h host -u user -p Enter password: - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
The folowing is a query I tried to do, to view reports that were between two dates, the problem is that the reports that are made on the second date, are not being display, if anyone can help me, please reply. thanks select ticket.t_id, t_summary, t_category, e_status, t_department, e_assignedto, t_priority, t_timestamp_openend from ticket, events, tmpeid where ticket.t_id = events.t_id and events.e_id = tmpeid.e_id and t_timestamp_opened between '-mm-dd' and '-mm-dd'; 2,000,000,000 Web Pages--you only need 1. Save time with My Lycos. http://my.lycos.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[2]: InnoDB: Assertion failure in thread 10 in file btr0btr.c line 574
Alex, 616e647265747469 andretti 616e6472e9737069 andr.spi there is a character e9 in your string. It is not an ordinary character and can cause an error in the sorting order between InnoDB-.41 and InnoDB-.49. -Original Message- From: BAUMEISTER Alexandre [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED] Cc: Michael Widenius [EMAIL PROTECTED]; [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Tuesday, March 19, 2002 3:27 PM Subject: Re[2]: InnoDB: Assertion failure in thread 10 in file btr0btr.c line 574 Heikki, HT since you are French, I assume you have accent characters in the strings you HT have stored into your database. HT The ordering of accent characters changed in 3.23.44! No accents. InnoDB tables on this server are mainly used for statistics, counters etc ... HT You must dump and reimport your tables to 3.23.49 so that the index trees HT are sorted in the right order. Since the crash we re-created everything so ... :) But I have still something strange with this server. I have two tables with the same create : create table popup( campagne int(11) unsigned not null, log char(20) not null, cpt int(11), unique(campagne,log), index(log) )type=InnoDB; and create table popup2 ... (same create). Table popup is not empty and is selected/updated from web pages (counting popup screened). I'm inserting some data in table popup2 : mysql insert into popup2 select '9',p.log,'1' from compte.portefeuilles p, compte.contenus_portefeuilles c where c.idport=p.idport and c.symbole='1rPEAD'; Query OK, 41495 rows affected (27.06 sec) Records: 52454 Duplicates: 10959 Warnings: 0 And then trying to insert into table popup all what is in table popup2 : mysql insert into popup select * from popup2; ERROR 1213: Deadlock found when trying to get lock; Try restarting transaction mysql replace into popup select * from popup2; ERROR 1213: Deadlock found when trying to get lock; Try restarting transaction I don't see why this deadlock ... MySQL binlogging requires that INSERT INTO ... SELECT ... sets shared locks on the SELECT table. To avoid the shared locks, use SELECT INTO OUTFILE and LOAD DATA INFILE. Regards, Alex. Regards, Heikki Innobase Oy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
On Tue, 19 Mar 2002, Horacio Lam wrote: The folowing is a query I tried to do, to view reports that were between two dates, the problem is that the reports that are made on the second date, are not being display, if anyone can help me, please reply. thanks select ticket.t_id, t_summary, t_category, e_status, t_department, e_assignedto, t_priority, t_timestamp_openend from ticket, events, tmpeid where ticket.t_id = events.t_id and events.e_id = tmpeid.e_id and t_timestamp_opened http://www.mysql.com/manual.php (the manual) Check the manual, but I think '-mm-dd' means '-mm-dd 00:00:00' change the final clause of the between to be '-mm-dd 23:59:59'. hope this helps, Nigel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Table RAID
I have a very large mysql table (1.5G) and so will need to implement the table RAID option soon. How do I pick the CHUNKSIZE and number of chunks values? Howard - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Optimization And Memory Size
You have written the following: I have a mysql database table that is currently 1.5G in size with well over a million records. It is running on a twin pentium 3 1G processor machine with SuSE Linux version 1.4. Recently inserts have become VERY slow (several seconds). As I am adding around 7K new fields a day, this is becoming a big problem. I recently increased the machine memory from 512K to 2G at some expense! It made no difference. I am using the HUGE version of my.cnf as shipped. Anybody got any ideas how to speed things up. Why did the memory increase not help at all??? Howard - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Leap seconds
Correct me if I'm wrong, but a timestamp field is not meant to be human updateable (ie. it's solely to record the last change to the record). -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 19, 2002 1:31 AM To: [EMAIL PROTECTED] Subject: Leap seconds Description: A timestamp value selected back is 38 seconds later than what was inserted. How-To-Repeat: ln -s /usr/share/zoneinfo/right/US/Pacific /etc/localtime mysql test mysql create table teststamps (stamp timestamp); mysql insert teststamps values (2002010100); mysql select * from teststamps; ++ | stamp | ++ | 2002010138 | ++ 1 row in set (0.00 sec) Fix: Please tell me. Submitter-Id: Originator:matt Organization: MySQL support: none Severity: non-critical Priority: low Category: mysql Class: sw-bug Release: mysql-3.23.41 (Source distribution) Environment: lrwxrwxrwx1 root root 36 Mar 14 00:06 /etc/localtime - /usr/share/zoneinfo/right/US/Pacific System: Linux alice.xork.org 2.4.16 #1 Sat Dec 8 18:43:34 PST 2001 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-81) Compilation info: CC='gcc' CFLAGS='-O3' CXX='gcc' CXXFLAGS='-O3 -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Aug 22 2001 /lib/libc.so.6 - libc-2.2.2.so -rwxr-xr-x1 root root 1236396 Apr 6 2001 /lib/libc-2.2.2.so -rw-r--r--1 root root 26350254 Apr 6 2001 /usr/lib/libc.a -rw-r--r--1 root root 178 Apr 6 2001 /usr/lib/libc.so lrwxrwxrwx1 root root 10 Aug 22 2001 /usr/lib/libc-client.a - c-client.a Configure command: ./configure --prefix=/usr/local/mysql --enable-assembler --with-mysqld-ldflags=-all-static - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
cannot enter german umlauts in mysql
I just installed mysql fresh out of the box on a fresh SuSE linux 7.1. mysql does not let me enter german umlauts, though. I tried to start it with mysql --default-character-set=latin_de, but it complained about the character sets not being installed. Then I installed the mysql server, which in turn installs the character sets. latin_de is not included, though. I tried it with mysql --default-character-set=german1 instead. No luck. This is not a general problem of my system's configuration. Umlauts work from the console, in xterm and konsole and all other editors and programs - except mysql. Does anyone know why? I did not have this problem with earlier mysql installations and do not have it on other machines. s.m. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: HELP !
I need help from the administrator of this MySQL list. I am receiving multiple(about 8-13) same mails from the same issue on the list. I successfully unsubscribed to MySQL list but the mails still coming in. I tried to unsubscribe a second time but it says that I am not a subscriber. Can the person in charge unsubscribe me for good? I will then subscribe again after this multiple emails have been sorted out. What else can I do? I was receiving emails from the list regularly without any problem until issue 1772. 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
all databases deneid
alan4100, Tuesday, March 19, 2002, 3:15:39 PM, you wrote: a I typed SELECT SYSTEM_USER() ..The output is a ++ a | system_user() | a ++ a | ODBC@localhost | a ++ a 1 row in set (0.00 sec) a I then tried mysql -h localhost -u ODBC a Welcome to the MySQL monitor. Commands end with ; or \g. a Your MySQL connection id is 19 to server version: 3.23.44-nt a Type 'help;' or '\h' for help. Type '\c' to clear the buffer. a mysql use mysql a ERROR 1044: Access denied for user: '@localhost' to database 'mysql' a mysql a mysql show databases; a +-+ a | Database| a +-+ a | Meet_a_Geek | a | database05 | a | db001 | a | db002 | a | mrbs| a | mysql | a | sample_db | a | shopcart| a | test| a +-+ a 9 rows in set (0.00 sec) a == a I try to use USE command for different datbases indicated by SHOW DATABASES; a All are denied access. Have you tried to use database 'test'? a mysql use Meet_aGeek; a ERROR 1044: Access denied for user: '@localhost' to database 'Meet_aGeek' a mysql use database05; a ERROR 1044: Access denied for user: '@localhost' to database 'database05' a mysql use db001; a ERROR 1044: Access denied for user: '@localhost' to database 'db001' a mysql use db002; a ERROR 1044: Access denied for user: '@localhost' to database 'db002' a Introduction to MYSQL at your recommendation is confusing because a it includes UNIX and Windows. I am using Windows XP. a == a shell mysql -h host -u user -p a Enter password: Does your user 'ODBC' have permissions on those databases? -- For technical support contracts, goto https://order.mysql.com/ 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[4]: InnoDB: Assertion failure in thread 10 in file btr0btr.c line 574
HT 616e647265747469 andretti HT 616e6472e9737069 andr.spi HT there is a character e9 in your string. It is not an ordinary character and HT can cause an error in the sorting order between InnoDB-.41 and InnoDB-.49. ok :) mysql insert into popup select * from popup2; ERROR 1213: Deadlock found when trying to get lock; Try restarting HT transaction mysql replace into popup select * from popup2; ERROR 1213: Deadlock found when trying to get lock; Try restarting HT transaction I don't see why this deadlock ... HT MySQL binlogging requires that INSERT INTO ... SELECT ... sets shared locks HT on the SELECT table. HT To avoid the shared locks, use SELECT INTO OUTFILE and LOAD DATA INFILE. ? MySQL binlogging ? I don't have option log-bin in my.cnf. Is it what you are talking about ? I don't understand, INSERT INTO ... SELECT ... used to work with InnoDB tables. Is it because there are to much selects and updates on the table and so while doing insert InnoDB reaches a lock limit ? Regards, Alex. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
HELP. Duplicate emails
I need help from the administrator of this MySQL list. I am receiving multiple(about 8-13) same mails from the same issue on the list. I successfully unsubscribed to MySQL list but the mails still coming in. I tried to unsubscribe a second time but it says that I am not a subscriber. Can the person in charge unsubscribe me for good? I will then subscribe again after this multiple emails have been sorted out. What else can I do? I was receiving emails from the list regularly without any problem until issue 1772. 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
Re: Table RAID
mysql, Tuesday, March 19, 2002, 4:27:40 PM, you wrote: mmlu I have a very large mysql table (1.5G) and so will need to implement the mmlu table mmlu RAID option soon. mmlu How do I pick the CHUNKSIZE and number of chunks values? You can read about RAID_TYPE option, RAID_CHUNKSIZE and RAID_CHUNKS in MySQL documentation in the chapter 6.5.3 CREATE TABLE Syntax at: http://www.mysql.com/doc/C/R/CREATE_TABLE.html mmlu Howard -- For technical support contracts, goto https://order.mysql.com/ 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: Sorting Data
Uma, Tuesday, March 19, 2002, 4:06:41 AM, you wrote: VRUma, VRMonday, March 18, 2002, 11:34:07 AM, you wrote: VR VRUSTTo get German sorting order, you should start mysqld with VRUST--default-character-set=latin_de. This will give you the following VRUSTcharacteristics. VR VRUST To get Tamil sorting order , i have started the mysqld with VRUST --default-character-set=latin1.But it is displaying the sorting order in a VRUST wrong way... VR VRUST Is any other setting to be made for this. VRUST If anybody know this please guide me.. VR VRWhat is the difference between Tamil scripting and latin1 sorting VRorder? What's wrong in your ordering? UST If i sort the data's it is checking the first 7 bits from the right and it UST is omiting the last bit.It is sorting by taking the 7 bits.If it is UST sorted like this then the result obtained is not correct. MySQL doesn't look at bits when sorting data and MySQL doesn't support Tamila scripting. -- For technical support contracts, goto https://order.mysql.com/ 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[4]: InnoDB: Assertion failure in thread 10 in file btr0btr.c line 574
Alex, -Original Message- From: BAUMEISTER Alexandre [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED] Cc: Michael Widenius [EMAIL PROTECTED]; [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Tuesday, March 19, 2002 5:14 PM Subject: Re[4]: InnoDB: Assertion failure in thread 10 in file btr0btr.c line 574 HT 616e647265747469 andretti HT 616e6472e9737069 andr.spi HT there is a character e9 in your string. It is not an ordinary character and HT can cause an error in the sorting order between InnoDB-.41 and InnoDB-.49. ok :) mysql insert into popup select * from popup2; ERROR 1213: Deadlock found when trying to get lock; Try restarting HT transaction mysql replace into popup select * from popup2; ERROR 1213: Deadlock found when trying to get lock; Try restarting HT transaction I don't see why this deadlock ... HT MySQL binlogging requires that INSERT INTO ... SELECT ... sets shared locks HT on the SELECT table. HT To avoid the shared locks, use SELECT INTO OUTFILE and LOAD DATA INFILE. ? MySQL binlogging ? I don't have option log-bin in my.cnf. Is it what you are talking about ? I don't understand, INSERT INTO ... SELECT ... used to work with InnoDB tables. Is it because there are to much selects and updates on the table and so while doing insert InnoDB reaches a lock limit ? no, there are no lock limits in InnoDB. Maybe the updates you are running on popup cause a deadlock with the mass insert? Also in this case the OUTFILE INFILE trick solves the problem because then every insert is run as a separate transaction (I assume you have autocommít=1), and the probability of a deadlock is smaller. Regards, Alex. Regards, Heikki Innobase Oy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: select speed
Hey, you know what? You're right! I'm an idiot. Thanks. :) BD wrote: Gabriel, I have a sneaky suspicion your primary key is a CHAR or VARCHAR, right? If so, your select statement is using an integer which means it has to convert it for each record. If you put quotes around the 30460203 it will run faster as in: select IndexField1,Field1,Field2 from table1 where IndexField1 = 30460203; Brent At 12:23 PM 3/18/2002, you wrote: BD wrote: At 10:39 AM 3/18/2002, you wrote: [snip] Field1 and Field2 are both unsigned integers IndexField1 is an unsigned integer and is the primary key select Field1,Field2 from table1 where IndexField1 = 345232; [snip] Gabriel, The select you described should take very little time, like around 0.01 seconds. But 9 seconds on a primary key? It appears that it wasn't using the index. You may want to try the Explain select Field1,Field2 from table1 where IndexField1 = 345232; to see if the index was used. Also you may want to rebuild the index by dropping it and creating it again in case the index was corrupted. You can also run myisamchk --analyze pathtodatabase/table to see if the Explain changes on the query. Brent Ok, so I dropped the index (primary) and re-added it. I ran the myisamchk --analyze on the table also. After doing so it does not seem to be affected at all. I modified the query to select only the IndexField1 field and EXPLAIN showed that query to be using the index as it should: mysql explain select IndexField1 from table1 where IndexField1 = 345232; +--+---+---+-+-+--+---+-+ | table| type | possible_keys | key | key_len | ref | rows | Extra | +--+---+---+-+-+--+---+-+ | table1 | index | PRIMARY | PRIMARY | 16 | NULL | 70029 | where used; Using index | +--+---+---+-+-+--+---+-+ Now, from what I understand, if I use the IndexField1 in the where clause (being the only part of the clause especially) it should use that index to find the correct record? But for some reason it only does that if the IndexField1 is the field I am selecting. If I added the Field1 and Field1 fields to the select query as show below, it still did not use the index: mysql explain select IndexField1,Field1,Field2 from table1 where IndexField1 = 30460203; +--+--+---+--+-+--+---++ | table| type | possible_keys | key | key_len | ref | rows | Extra | +--+--+---+--+-+--+---++ | table1 | ALL | PRIMARY | NULL |NULL | NULL | 70029 | where used | +--+--+---+--+-+--+---++ Interestingly enough, using LIMIT 1 in the query did speed it up, so it only took 0.01 seconds, however, using EXPLAIN with that query showed that it wasn't using the index at all. That really confuses me... - Gabriel Ricard _ 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
MySQL on netware
Hi! We are ineterested in the possibility of using MySQL on Netware plataform. After visit MySQL website, we've found that you are interested in someone to do this port. Our questions are: What are the requeriments to do this? You need someone to compile the source in a netware platform? Universitat Autònoma de Barcelona - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Unicode in 4.1
Hello, I need some details on the EXACT type of Unicode that MySQL will use 4.1. Ideally I'm looking for information on which type of Unicode MySQL will use internally, and which type it will return data to the user in; and is the MySQL Unicode implementation going to be phased in or with v4.1 will Unicode suddenly arrive? I need to know if MySQL will use UTF-8, UCS or whatever both for use internally and externally. Some (VERY) technical documentation on this subject would be appreciated. Thanks lots David Ayliffe ICQ# 125646758 Query, table - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Minimum client.
Thank you for the reply. However, unfortunately the documentation that you refer to -- while instructive in respect to DBI usage -- does not answer my question, which is simply: Must I install MySQL on a client workstation/PC in order to run perl/DBI scripts that query a local MySQL server? I know I do need to install DBI, DBD:MySQL, however, I'm not sure what, if anything else I need to install on the client? Any help would be greatly appreciated. Richard John Eacrett wrote: Richard, I found some information at the URL below that I think you will find interesting. I think if you utilize this API, you will not need to install MySQL. I am just guessing however, as I have no knowledge of Perl. Good Luck. Regards, John http://mysql.turbolift.com/mysql/DBD_3.21.X.php3 - Original Message - From: Richard Reina [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, March 18, 2002 1:03 PM Subject: Minimum client. In order to run perl scripts that use DBI ( from a cleint machine ) to query a MySQL server on the LAN Do I need to install MySQL on the client machine or do I just need DBI? Both machines are running Red Hat 7.2. Any help would be appreciated. Richard - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
log queries in FIFO
Hi ! Is it possible to log mysql queries into a fifo created by : # mkfifo -m660 queries.log I've search with google but i found only one thread of one email where somebody is getting an error 29. That's my case too. Thanks a lot ! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Minimum client.
Must I install MySQL on a client workstation/PC in order to run perl/DBI scripts that query a local MySQL server? I know I do need to install DBI, DBD:MySQL, however, I'm not sure what, if anything else I need to install on the client? You only need the DBI and DBD modules AFAIK :) cheers Jamie... -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= *** This message was transmitted on 100% recycled electrons *** =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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.sock
Art, Monday, March 18, 2002, 5:51:46 PM, you wrote: AF I done the chown, now using MySQL Navigator, I get Access denied for user: AF afore@localhost (using passowrd: YES). I get the same for user mysql and AF root using both my password and root password. Is your MySQL server running? Looks like you have some difficulties with mysql privileges. If you get 'access denied' error when you connect to the server, it may seem that you are using a wrong password. Causes of access denied errors are covered at: http://www.mysql.com/doc/A/c/Access_denied.html If you forgot password for the 'root' user you can reset it. A tips how to reset password you can read in the manual: http://www.mysql.com/doc/R/e/Resetting_permissions.html AF mysql is a group as shown in Yast2 login manager also. Permissions now shows AF drwxr-xr-x mysqlmysql. AF -Original Message- AF From: Egor Egorov [mailto:[EMAIL PROTECTED]] AF Sent: Monday, March 18, 2002 4:04 AM AF To: [EMAIL PROTECTED] AF Subject: RE: mysql.sock AF Art, AF Monday, March 18, 2002, 3:50:19 AM, you wrote: AF I get AF drwxr-xr-x 4 mysqldaemon 540 Mar 17 17:44 mysql AF MySQL datadir should belong to user 'mysql'. AF chown -R mysql.mysql /var/lib/mysql AF Art AF From: Dan Vande More [mailto:[EMAIL PROTECTED]] AF That's because you get this: AF '020317 16:48:10 mysqld ended.' AF It means there was an error, and the database server is no longer AF running. AF Check your mysql log files to find out why. AF Does the user, 'mysql' have permissions to write into the directory AF mysql is AF using, normally /var/lib/mysql AF Who is the owner, and group for that directory? And what are the AF permissions? AF Do an 'ls -la /var/lib/' AF You should have something like: AF 'drwxrwxr-x 25 mysqlroot 3072 Mar 16 23:00 mysql' AF or even AF 'drwxrwxr-x 25 rootmysql 3072 Mar 16 23:00 mysql' -- For technical support contracts, goto https://order.mysql.com/ 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
MySQL query parsing
Rykov, Monday, March 18, 2002, 4:54:50 PM, you wrote: R My question is - are the MySQL query parsing source codes available? For sure! Take the source code distribution and go with it. R Vladimir Rykov -- For technical support contracts, goto https://order.mysql.com/ 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: Sorting Data
At 16:32 2002-03-19, Victoria Reznichenko wrote: MySQL doesn't look at bits when sorting data and MySQL doesn't support Tamila scripting. Then what does MySQL look at? Are you aware Tamil is a human language? How would MySQL support Tamil - is there a character set that supports it for MySQL? -- Marjolein Katsma HomeSite Help - http://hshelp.com/ - Extensions, Tips and Tools The Bookstore - http://books.hshelp.com/ - Books for webmasters and webrookies - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 netware
Adolfo Amo writes: Hi! We are ineterested in the possibility of using MySQL on Netware plataform. After visit MySQL website, we've found that you are interested in someone to do this port. Our questions are: What are the requeriments to do this? You need someone to compile the source in a netware platform? Universitat Autònoma de Barcelona No, unfortunately, it would take much more then that. That would require complete porting to Netware platform. If you think that you can do it, start with our client API. You should be quite cognizant of the NetWare thread library, if there is such a thing at all. Also, please use our 4.0.* tree for porting. If you encounter problems, please write to [EMAIL PROTECTED] -- 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
mysql -u root DENIED
I just rmdir/s the old mysql and downloaded from Wisconsin mirror site... Then I tried C:\mysql\binmysql -u root ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO) Any idea? I know that I have mysql in NU-SPHERE directory from previous installation about a month ago... It should not interfere with the current MYSQL installation. Should I delete this NU-SPHERE directory as well.
JBuilder6 and mm.mysql-2.0.11
Is this the correct file to have in your class path? addpath /home/launi/JBuilder6/lib/mm.mysql-2.0.11/mm.mysql-2.0.11-bin.jar -- Lonnie Wormley [EMAIL PROTECTED] [Linux and Java] [EMAIL PROTECTED] [Window$ and graphics] http://www.launi.com http://www.zaramyth.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: Table RAID
Hi, Thanks I DID read the documentation. BUT there documentation gives no information about how to choose values for these settings. There are no clues at all. What are good values, and/or what is the effect on performance etc. of the values? Howard Egor Egorov writes: mysql, Tuesday, March 19, 2002, 4:27:40 PM, you wrote: mmlu I have a very large mysql table (1.5G) and so will need to implement the mmlu table mmlu RAID option soon. mmlu How do I pick the CHUNKSIZE and number of chunks values? You can read about RAID_TYPE option, RAID_CHUNKSIZE and RAID_CHUNKS in MySQL documentation in the chapter 6.5.3 CREATE TABLE Syntax at: http://www.mysql.com/doc/C/R/CREATE_TABLE.html mmlu Howard -- For technical support contracts, goto https://order.mysql.com/ 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ssl question part 2
I asked this the other day but didn't get any responses. Is there anyone out there with experience running mysql 4 with ssl connections?. I would like to get this setup but can't find any good documentation on how to do it. In particular, it seems that one has to specify a key and certificate to the server. I have yet to find details on this in the mysql docs or in the list archives. I would be extremely grateful for any help. 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
mysql 3.22.32 table checking
i am running mysql version 3.22.32. yes i am planning an upgrade. in the meantime, i need to check (and possibly) repair my tables without bringing down the mysql daemon. thanks, Shon Stephens 540.942.7292 office 540.649.3508 mobile shon8work aim - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: BerkeleyDB or InnoDB?
On Mon, 18 Mar 2002, Aaron D. Turner wrote: I've read the docs on mysql.com about the BDB and InnoDB table formats, as well as their pro's con's and I was wondering if anyone could give their opinion on the matter. I don't need row-level locking or other fancy features other than transaction support. My tables are about 1-5 thousand rows for the forseeable future. It's also not a heavly loaded DB (about 1-5 users at a time). I'm mostly concerned about stability and reliability. I do nightly backups, but even loosing a few hours worth of work would be 'bad'. With this in mind, suggestions anyone? Thanks. I have to agree with Walt on this. BDB tables seemed solid but slow when we evaluated them. InnoDB tables weren't quite as mature at that time, (3.23.28 or so, if I remember correctly), but they've improved enough since then that I don't see much of a benefit to BDB over InnoDB now, unless you want to keep each table in a seperate file. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Unicode in 4.1
On Tue, 2002-03-19 at 10:02, David Ayliffe wrote: Hello, I need some details on the EXACT type of Unicode that MySQL will use 4.1. Ideally I'm looking for information on which type of Unicode MySQL will use internally, and which type it will return data to the user in; and is the MySQL Unicode implementation going to be phased in or with v4.1 will Unicode suddenly arrive? I need to know if MySQL will use UTF-8, UCS or whatever both for use internally and externally. Hi, Unicode in 4.1 will use UTF-8 and UCS2 with a possibility to recode between them (as well as between any supported character sets). Some (VERY) technical documentation on this subject would be appreciated. Sorry, this will not appear until the 4.1 branch is released -- and even then it will just be the end-user documentation that tells how to use the feature(s). If you would like some sort of a in-depth whitepaper, then you could hire some consulting services from our developers to write this for you. Please contact [EMAIL PROTECTED] if you are interested. Matt -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Matt Wagner [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Coordinator of Development /_/ /_/\_, /___/\___\_\___/ Hopkins, Minnesota USA ___/ www.mysql.com M: +1 952 250 5434 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: INSERT ... SELECT not supported?
UPDATE sequence_table SET sequence = LAST_INSERT_ID(sequence + 1) Further calls to LAST_INSERT_ID on the same connection will return the value sequence + 1. It's connection specific, so multiple connections can update your sequence table without interfering with each other. There's a great example of this in Paul DuBois' book MySQL from New Riders. --jeff - Original Message - From: Allon Bendavid [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, March 18, 2002 7:57 PM Subject: INSERT ... SELECT not supported? Hello All- I just read that an Insert ... Select naming the same table is not supported in MySQL. What is the alternative? What we need to do is simply insert the max of a column + 1 to create essentially a counter in a situation where an auto_increment counter would not work. Anyone? -Allon -- -- Allon Bendavid Imacination Software [EMAIL PROTECTED] http://www.imacination.com/ 805-650-8153 -- -- Visit Imacination and start selling on the Web today with Ch-Ching! -- -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Benchmark
Hello all its me again Does any one now of any database benchmarking utility that I can use on mysql database??? Kathy Reyes Live Technology International 2975 Westchester Avenue Suite 103 Purchase, NY 10577 Tel: (914) 490-7096 [EMAIL PROTECTED] www.LiveTechnology.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: Benchmark
Have you looked at: http://www.mysql.com/information/benchmarks.html On Tuesday 19 March 2002 11:50 am, Kathy Reyes wrote: Hello all its me again Does any one now of any database benchmarking utility that I can use on mysql database??? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Benchmark
http://www.mysql.com/doc/M/y/MySQL_Benchmarks.html Duncan -- Duncan Salada | Titan | www.titan.com/testeval Email: [EMAIL PROTECTED] | Voice: 301-925-3222x375 | Fax: 301-925-3216 -Original Message- From: Kathy Reyes [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 19, 2002 1:51 PM To: mysql Subject: Benchmark Hello all its me again Does any one now of any database benchmarking utility that I can use on mysql database??? Kathy Reyes Live Technology International 2975 Westchester Avenue Suite 103 Purchase, NY 10577 Tel: (914) 490-7096 [EMAIL PROTECTED] www.LiveTechnology.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
Tech Reviewer for a MySQL Book
Howdy, I'm about to put together a book on MySQL (in Peachpit Press' Visual QuickStart Guide series) and am looking for a tech reviewer. The book itself will be a step by step beginner's text to the world's best open source database. Running about 300 pages it will not be as comprehensive or professionally-oriented as, for example, Paul DuBois' most excellent book, MySQL (just so you can get a sense of the scope of the project and the target audience). The tech reviewer's responsibility is to go over what I have written, correct any technical errors, and make suggestions of what else to discuss. It is a paid position (amount to be determined by you and the publisher) and the reviewer receives free copies of the published book along with an honorable mention, normally. The process will take approximately 4 months--your ability to review chapters quickly is important--and it's all done via email. If you might be interested in this position, please email me with a quick synopsis of your skills (MySQL naturally, Perl, Java, PHP, etc), what version of MySQL you are running, and what operating systems you have access to for testing purposes. Also let me know if you have any questions or concerns. Thanks to everyone for their consideration! Larry - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: cannot enter german umlauts in mysql
Hi Sasha, I assume it not a mistake (as you typed 'mysql' twice), but mysql is the name of the client program, you must start the server program (safe_mysqld) with the --default-character-set=latin_de. First use mysqladmin to shutdown the server, then restart it with safe_mysqld. Also I would recommend that you create a '/etc/my.cnf' file and place your options in that file. You can find examples in the 'support-files' directory of the mysql source code. Ich hoffe daß ich dir geholfen habe. Ken - Original Message - From: sascha mantscheff [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, March 19, 2002 9:46 AM Subject: cannot enter german umlauts in mysql I just installed mysql fresh out of the box on a fresh SuSE linux 7.1. mysql does not let me enter german umlauts, though. I tried to start it with mysql --default-character-set=latin_de, but it complained about the character sets not being installed. Then I installed the mysql server, which in turn installs the character sets. latin_de is not included, though. I tried it with mysql --default-character-set=german1 instead. No luck. This is not a general problem of my system's configuration. Umlauts work from the console, in xterm and konsole and all other editors and programs - except mysql. Does anyone know why? I did not have this problem with earlier mysql installations and do not have it on other machines. s.m. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: cannot enter german umlauts in mysql
hello ken, thanks for the reply, but when I typed mysql I meant it without the d. I'm using the client for lots of batch i/o, little utilities and quick maintenance. I'm using it on quite a couple of systems (linux in all flavors and FreeBSD), but only on one of this systems it shows this misbehaviour with not accepting umlauts. s.m. Am Dienstag, 19. März 2002 21:02 schrieben Sie: Hi Sasha, I assume it not a mistake (as you typed 'mysql' twice), but mysql is the name of the client program, you must start the server program (safe_mysqld) with the --default-character-set=latin_de. First use mysqladmin to shutdown the server, then restart it with safe_mysqld. Also I would recommend that you create a '/etc/my.cnf' file and place your options in that file. You can find examples in the 'support-files' directory of the mysql source code. Ich hoffe daß ich dir geholfen habe. Ken - Original Message - From: sascha mantscheff [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, March 19, 2002 9:46 AM Subject: cannot enter german umlauts in mysql I just installed mysql fresh out of the box on a fresh SuSE linux 7.1. mysql does not let me enter german umlauts, though. I tried to start it with mysql --default-character-set=latin_de, but it complained about the character sets not being installed. Then I installed the mysql server, which in turn installs the character sets. latin_de is not included, though. I tried it with mysql --default-character-set=german1 instead. No luck. This is not a general problem of my system's configuration. Umlauts work from the console, in xterm and konsole and all other editors and programs - except mysql. Does anyone know why? I did not have this problem with earlier mysql installations and do not have it on other machines. s.m. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Optimization And Memory Size
Hi Howard, I am trying to think of ideas. I have several databases with tables over 1.4G and rows still add quickly. How about available descriptors, what are these values: | Open_tables | 2738 | | Open_files | 5013 | | Open_streams | 0 | | Opened_tables| 81542 | | Questions| 31719361 | | this is a problem, I have 81542 opened tables, this sever needs more file descriptors. (I will look at this right away!, but my server is still running pretty well.) Maybe you could include the output from show variables and show status? How fast is your SCSI drive subsystem, I assume you are using 7200 RPM SCSI drives at least? Cordially, Ken - Original Message - From: mysql mailing list user [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, March 19, 2002 9:29 AM Subject: Re: Optimization And Memory Size You have written the following: I have a mysql database table that is currently 1.5G in size with well over a million records. It is running on a twin pentium 3 1G processor machine with SuSE Linux version 1.4. Recently inserts have become VERY slow (several seconds). As I am adding around 7K new fields a day, this is becoming a big problem. I recently increased the machine memory from 512K to 2G at some expense! It made no difference. I am using the HUGE version of my.cnf as shipped. Anybody got any ideas how to speed things up. Why did the memory increase not help at all??? Howard - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Application security
Just a quick question, if I am going to make a database using MYSQL and have front end applications, is it better to give each user a username/pass and have them enter it into the front end to be passed to the server, or should I give the app a password, hardcode it into the app for database connections, and have a user/pass table which the app uses to authenticate users? I would like the users to not be able to connect directly to the server, as different, competing client's data is stored on the same table, and the app has to make sure they cannot see eachother's data. 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
Re: cannot enter german umlauts in mysql
thanks for the reply, but when I typed mysql I meant it without the d. Yes, I understand, and I see that it is in the help, but it was my understanding the the character set (at this time) MUST be selected on the server and cannot be selected on the client, but perhaps I am wrong. This is confusing as 'mysql --help' does show it as a valid option! Perhaps a developer can comment. Ken I'm using the client for lots of batch i/o, little utilities and quick maintenance. I'm using it on quite a couple of systems (linux in all flavors and FreeBSD), but only on one of this systems it shows this misbehaviour with not accepting umlauts. s.m. Am Dienstag, 19. März 2002 21:02 schrieben Sie: Hi Sasha, I assume it not a mistake (as you typed 'mysql' twice), but mysql is the name of the client program, you must start the server program (safe_mysqld) with the --default-character-set=latin_de. First use mysqladmin to shutdown the server, then restart it with safe_mysqld. Also I would recommend that you create a '/etc/my.cnf' file and place your options in that file. You can find examples in the 'support-files' directory of the mysql source code. Ich hoffe daß ich dir geholfen habe. Ken - Original Message - From: sascha mantscheff [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, March 19, 2002 9:46 AM Subject: cannot enter german umlauts in mysql I just installed mysql fresh out of the box on a fresh SuSE linux 7.1. mysql does not let me enter german umlauts, though. I tried to start it with mysql --default-character-set=latin_de, but it complained about the character sets not being installed. Then I installed the mysql server, which in turn installs the character sets. latin_de is not included, though. I tried it with mysql --default-character-set=german1 instead. No luck. This is not a general problem of my system's configuration. Umlauts work from the console, in xterm and konsole and all other editors and programs - except mysql. Does anyone know why? I did not have this problem with earlier mysql installations and do not have it on other machines. s.m. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Finally found mysql-nt service error 1061 1067
At 20:02 18/03/02 -0600, Gerald R. Jensen wrote: Hi, For to avoid the install of the service in local account I will add code for to verify if the user that is making the install process has administrator rights and display the error message if he/she doesn't have. Regards, Miguel Alex: I doubt this issue is a 'general mysql-nt problem'. In truth, MySQL is a very well-designed, well-behaved service. I have installed about 80 MySQL servers on customer-owned WinNT/2K servers. If this were a 'general mysql-nt problem', I would have had to set a login account in the SCM for each one. To the best of my recollection, I have only had to do it twice in a little more than two years. I tend to think it has something to do with permissions on the machine or perhaps a general configuration setting in WinNT/2K, but I can't prove/disprove that. Miguel Solorzano is a MySQL full-timer with a good deal of experience in this area ... he reads the list, and may be able to offer some insight here. Gerald Jensen -Original Message- From: Alexander Hampel [SMTP:[EMAIL PROTECTED]] Sent: Monday, March 18, 2002 9:05 AM To: [EMAIL PROTECTED] Cc: Gerald Jensen; [EMAIL PROTECTED] Subject:Finally found mysql-nt service error 1061 1067 Hi Gerald, The 'System-Account' did not work BUT the 'Admin' user account did! You were right :-) How comes? That's what I always do: (1) Install a service on 'System Account' and than (2) change it to an user account of my choice After 2 days wasting time trying to get the installation run, I ask myself how things like this can happen? Seems to be a 'general mysql-nt problem' if I take a look at how many questions arise to this specific issue. Anyway - thanks to all of you helping me by giving me advices :-) Special thanks to you Gerald, so long A:lex -Ursprungliche Nachricht- Von: Gerald Jensen [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 18. Marz 2002 15:13 An: [EMAIL PROTECTED] Betreff: Re: NT service problem Then you may have a problem with services running under the System Account on this machine. Try this: - Go into the Control Panel's Service Control Manager - Click on the MySQL service - Click on the 'Startup' button - Make sure 'Automatic' is selected - Select 'This Account' (instead of 'System Account') - Choose an Admin-level user and set the correct password - Click 'OK' then click 'Start' Gerald Jensen - Original Message - From: Alexander Hampel [EMAIL PROTECTED] To: Gerald R. Jensen [EMAIL PROTECTED] Sent: Monday, March 18, 2002 7:45 AM Subject: AW: NT service problem Thanks - my.ini is used. Tried to use come of your parameters - but nothing changed. The interesting part: the standalone run is fine, the service part is wrong - so it has something todo with the service ?!? So long A:lex -Ursprungliche Nachricht- Von: Gerald R. Jensen [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 18. Marz 2002 13:40 An: [EMAIL PROTECTED]; [EMAIL PROTECTED] Betreff: Re: NT service problem Check the location of the configuration file (should be either c:\my.cnf ~ OR ~ c:\winnt\my.ini), then edit the contents of that file. Here is a sample: [client] #password=my_password port=3306 #socket=MYSQL # [mysqld] port=3306 #socket=MYSQL skip-locking #enable-locking set-variable = key_buffer=16M set-variable = max_allowed_packet=1M set-variable = thread_stack=128K set-variable = flush_time=1800 log=C:/mysql/mysql.log basedir = C:/MYSQL/ # [mysqldump] quick set-variable = max_allowed_packet=16M # [MYSQL] no-auto-rehash # [isamchk] set-variable= KEY=16M # [client_fltk] help_file= C:\\MYSQL\guiclient\MYSQL.help client_file= C:\\MYSQL\mysql.opt history_length=20 database = goetznet queries_root= C:\\MYSQL\queries last_database_file= C:\\MYSQL\lastdb - Original Message - From: Alexander Hampel [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, March 18, 2002 1:37 AM Subject: NT service problem Hi Pierre, Thanks, for your help. That's what I exaclty do and this is for '--standalone' fine. But the point ist, I want to start mysqld-nt as NT service - and this is the problem - it wouldn't let me start it as service: C:\net start mysql System error 1069 Could not start service The service is an important issue. Lets you run a programm under different user rights. Probably I'll find some other solution. Thanks, A:lex -Ursprungliche Nachricht- Von: Pierre du Parte [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 18. Marz 2002 08:04 An: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Betreff: Re: New to MySQL - can't start server :-( Hi Alexander, I use the PHPDEV compilation for local PHP/mySQL development work (http://www.firepages.com.au/devindex.htm for a no-brainer approach to getting PHP/mySQL/Apache up and
Re: all databases deneid
Try mysql -uODBC -p (-p assuming you have a password on the account) the formula is -optVAL alan4100 wrote: I typed SELECT SYSTEM_USER() ..The output is ++ | system_user() | ++ | ODBC@localhost | ++ 1 row in set (0.00 sec) I then tried mysql -h localhost -u ODBC Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 19 to server version: 3.23.44-nt Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql use mysql ERROR 1044: Access denied for user: '@localhost' to database 'mysql' mysql mysql show databases; +-+ | Database| +-+ | Meet_a_Geek | | database05 | | db001 | | db002 | | mrbs| | mysql | | sample_db | | shopcart| | test| +-+ 9 rows in set (0.00 sec) == I try to use USE command for different datbases indicated by SHOW DATABASES; All are denied access. mysql use Meet_aGeek; ERROR 1044: Access denied for user: '@localhost' to database 'Meet_aGeek' mysql use database05; ERROR 1044: Access denied for user: '@localhost' to database 'database05' mysql use db001; ERROR 1044: Access denied for user: '@localhost' to database 'db001' mysql use db002; ERROR 1044: Access denied for user: '@localhost' to database 'db002' mysql Introduction to MYSQL at your recommendation is confusing because it includes UNIX and Windows. I am using Windows XP. == shell mysql -h host -u user -p Enter password: -- Colin Faber (303) 859-1491 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
MySQL, FreeBSD problem
Hello all. I have an application that does a lot of table creation and writing for a FreeBSD 4.4 SMP machine. Over time, I begin to see the following errors. DBD::mysql::db tables failed: Can't read dir of './p0_samt_trans/' (Errcode: 2) at /var/SAMT/code/SAMTlib/SAMTdb.pm line 2552, FILE chunk 138. DBD::mysql::db do failed: Table 'p3_samt_trans.p3_int_sender_2_12_0' doesn't exist at /var/SAMT/code/SAMTlib/SAMTdb.pm line 2301, FILE chunk 138. These errors seem to happen for no reason. If I issue a select, do or anything else 2 seconds later, I get no errors. The table in question above does in fact exist, although MySQL claims that it does not. The machine (or mysql for that matter) is not under particularly heavy load. It simply occassionally just cant read a database directory for some reason or another. A fraction of a second later, the same command will work fine. Now, I am using the 3.23.47 Free BSD binary from the MySQL site on this machine. I notice that the problem continues to get worse as time goes on. If I restart mysqld however, the problem seems to go away for a bit. But after 2-3 days, the problem comes back. Any ideas? thoughts? Any assistance with this problem would be welcomed. 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
URGENT: Update Error with MySQL++
All, I can't seem to perform an update on my database with MySQL++. The execution of the query always throws an exception. Here's a snippet of what I did. Query query(conn); query update employee set children = 3 where id = 9; query.execute(); The above code throws an exception everytime. What am I doing wrong? Thanks. Thi - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 netware
I'll bet there are several people in Provo, Utah that could be convinced to do the port. Curtis Sinisa Milivojevic said: Adolfo Amo writes: Hi! We are ineterested in the possibility of using MySQL on Netware plataform. After visit MySQL website, we've found that you are interested in someone to do this port. Our questions are: What are the requeriments to do this? You need someone to compile the source in a netware platform? Universitat Autònoma de Barcelona No, unfortunately, it would take much more then that. That would require complete porting to Netware platform. If you think that you can do it, start with our client API. You should be quite cognizant of the NetWare thread library, if there is such a thing at all. Also, please use our 4.0.* tree for porting. If you encounter problems, please write to [EMAIL PROTECTED] -- 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Cannot access the Database on same Machine
Hi, When i try to access the database which is on my Linux machine i get the following error: ERROR 2002; Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) There is nothing in this file, although i dont know how to edit it. I have gone through the Manual pages and the lists, all the searches for this type of ERROR, but to no avail. I have used the database before and have tables in there but for some reason i cannot get in. I don't want to reinstall it as i have tables that i need, I am really stuck so any help will be very much appreciated, Thanks Colin __ Do You Yahoo!? Yahoo! Sports - live college hoops coverage http://sports.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
setting up replication woes
Hi all: I am having a huge problem setting up replication between 2 mysql databases on the same server. The reason for doing this is to use the slave database for backups thus avoiding the need to down the master database. I am consistently getting Error 1200: The server is not configured as a slave, fix in config or with CHANGE MASTER TO. I have (I think) followed the documentation but despite what I do, I continue to get errors. I am using mysqld_multi to kick off both databases correctly, and both ports respond to telnet. The sockets are being created correctly and remove correctly when I use mysqld_multi. Has anyone seen this error before? Am I trying to do something that is known not to work? Can anyone help in debugging this problem. Below is more specific data for my configuration: MySQL version: 3.23.49a Running on Linux RedHat 7.2 /etc/my.cnf: [mysqld_multi] mysqld = /usr/local/mysql/bin/mysqld mysqladmin = /usr/local/mysql/bin/mysqladmin user = root password = snip # The MySQL servers # mysqld1 is the master server # mysqld2 is the slave server [mysqld1] socket = /tmp/mysql.sock port = 3306 pid-file = /usr/local/mysql/data/master.pid datadir= /usr/local/mysql/data language = /usr/local/mysql/share/mysql/english user = root [mysqld2] socket = /tmp/mysql_slave.sock port = 3307 pid-file = /opt/src/mysql/data/slave.pid datadir= /opt/src/mysql/data language = /opt/src/mysql/share/mysql/english user = root /usr/local/mysql/my.cnf: [client] port = 3306 socket = /tmp/mysql.sock # The MySQL server [mysqld] port= 3306 socket = /tmp/mysql.sock skip-locking set-variable= max_connections=2048 set-variable= key_buffer=512M set-variable= max_allowed_packet=16M set-variable= table_cache=512 set-variable= sort_buffer=128M set-variable= record_buffer=16M set-variable= thread_cache=16 set-variable= thread_concurrency=8 set-variable= myisam_sort_buffer_size=256M log-bin server-id = 1 replicate-do-db = tivo_vb1 log-slow-queries=/var/lib/mysql/slowqueries [mysqldump] quick set-variable= max_allowed_packet=16M [mysql] no-auto-rehash [isamchk] set-variable= key_buffer=256M set-variable= sort_buffer=256M set-variable= read_buffer=2M set-variable= write_buffer=2M [myisamchk] set-variable= key_buffer=256M set-variable= sort_buffer=256M set-variable= read_buffer=2M set-variable= write_buffer=2M [mysqlhotcopy] interactive-timeout /opt/src/mysql/my.cnf: [client] port= 3307 socket = /tmp/mysql_slave.sock # The MySQL server [mysqld] socket = /tmp/mysql_slave.sock port= 3307 # Setup Replication master-host = sjavs master-user = root master-password = snip master-port = 3306 server-id = 2 replicate-do-db = tivo_vb1 log-slow-queries=/var/lib/mysql/slowqueries - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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, FreeBSD problem
With out knowing your system configuration it sounds to me like you've got some problems with locking. I suggest looking into that. Brad Phinney wrote: Hello all. I have an application that does a lot of table creation and writing for a FreeBSD 4.4 SMP machine. Over time, I begin to see the following errors. DBD::mysql::db tables failed: Can't read dir of './p0_samt_trans/' (Errcode: 2) at /var/SAMT/code/SAMTlib/SAMTdb.pm line 2552, FILE chunk 138. DBD::mysql::db do failed: Table 'p3_samt_trans.p3_int_sender_2_12_0' doesn't exist at /var/SAMT/code/SAMTlib/SAMTdb.pm line 2301, FILE chunk 138. These errors seem to happen for no reason. If I issue a select, do or anything else 2 seconds later, I get no errors. The table in question above does in fact exist, although MySQL claims that it does not. The machine (or mysql for that matter) is not under particularly heavy load. It simply occassionally just cant read a database directory for some reason or another. A fraction of a second later, the same command will work fine. Now, I am using the 3.23.47 Free BSD binary from the MySQL site on this machine. I notice that the problem continues to get worse as time goes on. If I restart mysqld however, the problem seems to go away for a bit. But after 2-3 days, the problem comes back. Any ideas? thoughts? Any assistance with this problem would be welcomed. 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 -- Colin Faber (303) 859-1491 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
RE: Cannot access the Database on same Machine
this file is created when MYSQL starts check the directory to ensure it has the correct read-write permissions check the list archives; this question has been asked almost every day -Original Message- From: colin o [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 19, 2002 3:05 PM To: mysql Subject: Cannot access the Database on same Machine Hi, When i try to access the database which is on my Linux machine i get the following error: ERROR 2002; Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) There is nothing in this file, although i dont know how to edit it. I have gone through the Manual pages and the lists, all the searches for this type of ERROR, but to no avail. I have used the database before and have tables in there but for some reason i cannot get in. I don't want to reinstall it as i have tables that i need, I am really stuck so any help will be very much appreciated, Thanks Colin __ Do You Yahoo!? Yahoo! Sports - live college hoops coverage http://sports.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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Cannot access the Database on same Machine
probably something wrong with the permissions in the mysql database. as a workaround, try to connect not via the local socket, but via a tcp/ip-connection: # mysql -h 127.0.0.1 -u my-user -p my-database or insert the real ip of the machine instead of the loopback address. check if there is an entry in the mysql.user table with host=localhost and user=. this would preclude any local user to log into the database. s.m. Am Dienstag, 19. März 2002 22:04 schrieben Sie: Hi, When i try to access the database which is on my Linux machine i get the following error: ERROR 2002; Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) There is nothing in this file, although i dont know how to edit it. I have gone through the Manual pages and the lists, all the searches for this type of ERROR, but to no avail. I have used the database before and have tables in there but for some reason i cannot get in. I don't want to reinstall it as i have tables that i need, I am really stuck so any help will be very much appreciated, Thanks Colin __ Do You Yahoo!? Yahoo! Sports - live college hoops coverage http://sports.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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MYSQL DATABASE BACKUP
I am trying to backup a table in mysql without locking my tables it this posible - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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, FreeBSD problem
Hi Brad, You are running out of file descriptors, type this: kes# sysctl -a | grep files kern.maxfiles: 2 kern.maxfilesperproc: 18000 kern.openfiles: 5230 kes# limit -h cputime unlimited filesizeunlimited datasize1048576 kbytes stacksize 262144 kbytes coredumpsizeunlimited memoryuse unlimited descriptors 18000 memorylockedunlimited maxproc 4115 You probably increased the number of tables in my.cnf and did not allocate enough descriptors for the process. use sysctl to increase the number of available descriptors. Ken - Original Message - From: Brad Phinney [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, March 19, 2002 3:47 PM Subject: MySQL, FreeBSD problem Hello all. I have an application that does a lot of table creation and writing for a FreeBSD 4.4 SMP machine. Over time, I begin to see the following errors. DBD::mysql::db tables failed: Can't read dir of './p0_samt_trans/' (Errcode: 2) at /var/SAMT/code/SAMTlib/SAMTdb.pm line 2552, FILE chunk 138. DBD::mysql::db do failed: Table 'p3_samt_trans.p3_int_sender_2_12_0' doesn't exist at /var/SAMT/code/SAMTlib/SAMTdb.pm line 2301, FILE chunk 138. These errors seem to happen for no reason. If I issue a select, do or anything else 2 seconds later, I get no errors. The table in question above does in fact exist, although MySQL claims that it does not. The machine (or mysql for that matter) is not under particularly heavy load. It simply occassionally just cant read a database directory for some reason or another. A fraction of a second later, the same command will work fine. Now, I am using the 3.23.47 Free BSD binary from the MySQL site on this machine. I notice that the problem continues to get worse as time goes on. If I restart mysqld however, the problem seems to go away for a bit. But after 2-3 days, the problem comes back. Any ideas? thoughts? Any assistance with this problem would be welcomed. 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Unicode in 4.1
So how (forgive me if this is a simpleton's question), how will UTF-8 and UCS2 be used? Can you elaborate a bit. DA Hi, Unicode in 4.1 will use UTF-8 and UCS2 with a possibility to recode between them (as well as between any supported character sets). Some (VERY) technical documentation on this subject would be appreciated. Sorry, this will not appear until the 4.1 branch is released -- and even then it will just be the end-user documentation that tells how to use the feature(s). If you would like some sort of a in-depth whitepaper, then you could hire some consulting services from our developers to write this for you. Please contact [EMAIL PROTECTED] if you are interested. Matt - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 netware
NetWare recently (relatively) has added some support for C code running on the servfer. You should, however, evaluate the NetWare environment carefully, and take advantage of porting it native to NetWare. I am sure that you can acquire evaluation software from Novell for NetWare 5.1 and 6, the only versions you should consider porting to. Whether the SDK is freely available from them I do not know. If you need a contact at Novell, ask me. I may not know who you need to speak to, but I do know someone at Novell that does. As an example, look at the Apache port, and the old NetScape Enterprise Web Server ports. These were very reliable, and worked well. Other SQL vendors such as Gupt (Now Centura?) and Sybase have used NetWare for years. Oracle rcently chose not to, but earlier versions were very stable. While NetWare isn't so popular, it offers a very stable kernel, excellent directory services, security, and clustering. Frankly, I bet the people at Novell admire Linux more than they let on. They use it as a tool more than I ever thought they would... Rick - Original Message - From: Curtis Maurand [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, March 19, 2002 4:01 PM Subject: Re: MySQL on netware I'll bet there are several people in Provo, Utah that could be convinced to do the port. Curtis Sinisa Milivojevic said: Adolfo Amo writes: Hi! We are ineterested in the possibility of using MySQL on Netware plataform. After visit MySQL website, we've found that you are interested in someone to do this port. Our questions are: What are the requeriments to do this? You need someone to compile the source in a netware platform? Universitat Autònoma de Barcelona No, unfortunately, it would take much more then that. That would require complete porting to Netware platform. If you think that you can do it, start with our client API. You should be quite cognizant of the NetWare thread library, if there is such a thing at all. Also, please use our 4.0.* tree for porting. If you encounter problems, please write to [EMAIL PROTECTED] -- 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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, FreeBSD problem
In the last episode (Mar 19), Brad Phinney said: Hello all. I have an application that does a lot of table creation and writing for a FreeBSD 4.4 SMP machine. Over time, I begin to see the following errors. DBD::mysql::db tables failed: Can't read dir of './p0_samt_trans/' (Errcode: 2) at /var/SAMT/code/SAMTlib/SAMTdb.pm line 2552, FILE chunk 138. DBD::mysql::db do failed: Table 'p3_samt_trans.p3_int_sender_2_12_0' doesn't exist at /var/SAMT/code/SAMTlib/SAMTdb.pm line 2301, FILE chunk 138. Error 2 is 'No such file or directory'. Are you also seeing file table full messages on your console, or something similar? I think I remember someone else having the same problem, and either their kernel file table was too small, their per-user resource limits were too low, or they didn't have the mysql table_cache variable set high enough. What do the following commands print? sysctl kern.maxfiles kern.openfiles limits -n mysql -e show variables like 'table_cache' mysql -e show status like 'Open_tables' -- 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: MYSQL DATABASE BACKUP
Yes. Setup replication and peform the backup on the slave. Provided this is your only purpose for having a slave, and there are no queries running on the slave, the specs can be a lot lower than your master/production machine. -Original Message- From: Kathy Reyes [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 19, 2002 1:37 PM To: mysql Subject: MYSQL DATABASE BACKUP I am trying to backup a table in mysql without locking my tables it this posible - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Access denied for user
I dont know what I have done now but I have locked myself out of mysql. When I type mysql I get an access violation. At first I thought it might have been something on my end since I am a remote user. But when I attempt to enter mysql from linux box. I get the same access violation... Please someone help me. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 DATABASE BACKUP
not quite sure what you mean by locking. each table will be locked during readout for the dump automaticly for the time the select runs and delivers data to the dumping program. it is not needed to lock the tables (more than one) in advance for a dump, but that, might better for dataintegrety. Lars Kathy Reyes wrote: I am trying to backup a table in mysql without locking my tables it this posible - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
4.0.x memory bug on FreeBSD...?
Running the latest build from bitkeeper (as of Saturday or so) on my 4.0.x slave (FreeBSD 4.3), after several hours, I start getting these messages when apps try to connect to the server: ERROR 1041: Out of memory; Check if mysqld or some other process uses all available memory. If not you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space However, I've verified that the ulimit is unlimited. There is over 1.4GB of available memory on the machine, and there is a lot of disk space. Here's the relevant entry from the error log, repeated over and over: 020319 15:57:33 /home/mysql-4-bk/libexec/mysqld: Out of memory at line 100, 'net_serv.cc' 020319 15:57:33 /home/mysql-4-bk/libexec/mysqld: needed 16391 byte (17k), memory in use: 535192717 bytes (522650k) It now has the CPU at 100% but isn't doing any real work. The binary log is no longer updating. I can kill mysqld and restart and it'll run fine for a day or so. I know because this happened yesterday too. What can I do to debug this further? Give it a kill -6 and backtrace on the core? Other ideas? FYI, this was build with gcc 2.95.3 using the standard compile-pentium-debug script. Thanks, Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 40 days, processed 1,192,195,107 queries (341/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Backtrace for (Re: 4.0.x memory bug on FreeBSD...?)
On Tue, Mar 19, 2002 at 04:02:46PM -0800, Jeremy Zawodny wrote: [snip] Here's the relevant entry from the error log, repeated over and over: 020319 15:57:33 /home/mysql-4-bk/libexec/mysqld: Out of memory at line 100, 'net_serv.cc' 020319 15:57:33 /home/mysql-4-bk/libexec/mysqld: needed 16391 byte (17k), memory in use: 535192717 bytes (522650k) It now has the CPU at 100% but isn't doing any real work. The binary log is no longer updating. I can kill mysqld and restart and it'll run fine for a day or so. I know because this happened yesterday too. What can I do to debug this further? Give it a kill -6 and backtrace on the core? Just for kicks, here's the backtrace: #0 0x8242ab9 in _checkchunk (pRec=0x82f6fa0, sFile=0xa8 Address 0xa8 out of bounds, uLine=2678966856) at safemalloc.c:429 #1 0x8242080 in _mymalloc (uSize=49152, sFile=0x82f6fa0 mf_iocache.c, uLine=168, MyFlags=32) at safemalloc.c:131 #2 0x823ff9d in init_io_cache (info=0x203c1130, file=31, cachesize=0, type=WRITE_CACHE, seek_offset=109881604, use_async_io=1 '\001', cache_myflags=32) at mf_iocache.c:165 #3 0x8215b67 in mi_extra (info=0x203c1018, function=HA_EXTRA_WRITE_CACHE) at mi_extra.c:139 #4 0x80ce82f in ha_myisam::extra (this=0x203b3490, operation=HA_EXTRA_WRITE_CACHE) at ha_myisam.cc:932 #5 0x80a799a in mysql_insert (thd=0x203b9018, table_list=0x20c82050, fields=@0x203b92e8, values_list=@0x203b9308, duplic=DUP_ERROR, lock_type=TL_WRITE_CONCURRENT_INSERT) at sql_insert.cc:200 #6 0x807e7da in mysql_execute_command () at sql_parse.cc:1789 #7 0x8080f3e in mysql_parse (thd=0x203b9018, inBuf=0x2070601c INSERT INTO\n\t\t\t LinkLog\n\t\t\t VALUES\n\t\t\t ('G-020319.djus', 'http://biz.yahoo.com/djus/020319/200203190609000237_1.html', 'Link', 'fnews child 3/3Add(G-020319.djus I-ne I-djus G-020319.I..., length=912) at sql_parse.cc:2718 #8 0x80b6177 in Query_log_event::exec_event (this=0x20c52418, rli=0x8305e2c) at log_event.cc:1608 #9 0x80f557c in exec_relay_log_event (thd=0x203b9018, rli=0x8305e2c) at slave.cc:1569 #10 0x80f646d in handle_slave_sql (arg=0x8305ae0) at slave.cc:1887 #11 0x2837403b in _thread_start () from /usr/lib/libc_r.so.4 #12 0x0 in ?? () Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 40 days, processed 1,192,550,993 queries (341/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Fresh RedHat 7.2 install
If you are running RH7.2, start your GUI and go to System / Service Manager. Locate mysqld, and make sure it is checked to automatically start on bootup, then save your settings, and click the start button. - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, March 19, 2002 6:28 AM Subject: Fresh RedHat 7.2 install Hello, This is a newbie question for a reason...I am. I've installed the lastest RPM for mysql on a brand new redhat 7.2 installation. When I try to run mysqladmin to set my new password (or for any reason actually, even to see the version number) I get the following error. I am not able to update the database either. As this is a fresh install, I'm thinking somebody probably has a quick-fix for me (maybe something about the OS pops into your head). I haven't seen this addressed in the manual pages. mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)' Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists! Thank You, Corey Baldwin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 needs help with install
I'm installing MySQLto a Corel /Debian platform, following directions in the book Beginning PHP4. Successfully did ./configure, make, make install, and mysql_install_db as described on page 387. The book says I'll now need to start and stop the Mysql server using two sample scripts, to wit: [sample startmysqld script] #! /bin/bash /usr/bin/safe_mysqld [sample stopmysqld script] #!/bin/bash kill 'cat /usr/var/$HOSTNAME.pid' Looks easy enough except that I don't have a clue where these scripts are supposed to reside on my system. And/or whether I'm supposed to execute these manually from a console prompt or have them run automatically at boot and shutdown. Thanks in advance for your help. Ron Swanson - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
No support for multiple statements via JDBC?
Hi All- We are using the mm driver for MySQL and multiple statements in one connection do not seem to be supported: I.e. SELECT @a:=MAX(Number) FROM Orders;insert into orders (Number) values (@a+1) The driver throws a syntax error. You can do either one of these statements on their own, and you can have a semicolon in the statement, but you cannot combine the statements. Are we missing something? How would you do a transaction or table lock without multi statement support? -Allon Allon Bendavid Imacination Software [EMAIL PROTECTED]http://www.imacination.com/ 805-650-8153 Visit Imacination and start selling on the Web today with Ch-Ching! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Searching on multiple indexed columns
Hi All, My apologies for asking what may be a very newbie question. I'm having trouble getting my head around searching multiple indexed columns. I have read the MySQL docs 5.4.3, 5.4.4, 5.4.5 and 6.8 full text and have scoured Paul's book but haven't been able to find an answer. We have a table of news stories which includes columns for Writer, Heading, Caption, Section, Publication and the Story_Content (usually 500-1000 words). Story_Content is of type 'text' and has a fulltext index - all other columns are indexed varchar() types. We'd like to be able to write a single select statement which combines a MATCH statement for the Story_Content column with a LIKE %param% statement for the Writer, Heading, Section and Publication columns. Is it possible to mix these types of selects in a single statement? I'm using OSX, mysql 3.23.39 and a php web interface and I expect the table to grow to several hundred thousand rows. Many thanks (from a real mysql novice) kim mysql, query, sql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Writing an SQL Parser and Optimizer
I'm taking a database implementation course, and my professor has flipped his lid this semester and assigned one of the labs to be an SQL parser and optimizer (using equivalence rules, etc.). Given an SQL statement and a database schema (with some statistical metadata on the contents), I am to parse the statement and fully optimize it, outputting the relational algebra equivalent to the SQL statement. I have about a week to write this. My only saving grace is that we are allowed to use any tools that are freely available over the Internet. I was thinking about using bison and RUBY to implement it. However, since I noticed that MySQL is nice and open source, I might be able to significantly reduce the amount of time and effort that I will need to put into this lab by using the source for MySQL as a reference point. Any suggestions as to where to start? Thanks, 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
Fulltext Retrieval in big!??? Databases
Hello, I have to plan a content retrieval system and am thinking of using mysql cause it's always been very reliable and convenient for my needs. Now, I do not have any experiences with databases of this size. The situation is as follows: We have round about 15gig of user documents (mainly MS Office documents such as doc or ppt). These documents needs to be indexed (stored in fulltext fields?) for retrieval in an Intranet (100Mbit I think) with 50 clients. My question is: can this be done with MySQL? What hardware (server) would be needed to get the results in a time anywhere near resonable? And, do the clients need to be tweaked or would it be acceptable to use a Browser for it (php on an Apache)? Any recommendations are very much appreciated. TIA, Andreas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php