DATE TIME
Hello, i need to have the time in this output. in MySQL database phpmyadmin always puts -00-00 i need it to be like this 01-APR-2005 DD-MMM- the time needs to be like this 22:55 HH:MM can somebody help hans -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: DATE TIME
thanks for the hints date_format() solved my problem my select query in php is now the following: $query = SELECT id, calltt, date_format(calldate, '%d-%b-%Y') AS calldate2, date_format(calltime, '%H:%i') AS calltime2,area, problem, solution, assignto, status FROM ticketing ; hans Rhino wrote: - Original Message - From: Hans Bernard [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Wednesday, April 06, 2005 6:06 AM Subject: DATE TIME Hello, i need to have the time in this output. in MySQL database phpmyadmin always puts -00-00 i need it to be like this 01-APR-2005 DD-MMM- the time needs to be like this 22:55 HH:MM can somebody help I am 99% sure that you cannot actually store dates or times in the formats that you want. However, I am also 99% sure that you *can* retrieve them in those formats by reformatting them when you retrieve them. I think you will find all of the information you need under functions in the MySQL manual. Unfortunately, the server appears to be down at the moment so I can't give you a link to the appropriate page. Also, I suspect the reason that you are seeing dates of '-00-00' is that you are supplying the dates in the wrong format within your INSERT statements and that MySQL is storing '-00-00' as the default. If you supply the dates in the format MySQL is expecting, you should get back the dates that you actually stored. Rhino -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.9.3 - Release Date: 05/04/2005 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Comparing bug in 4.1.7
Hello Vlad, The reason is: If one or both arguments are NULL, the result of the comparison is NULL, except for the NULL-safe = equality comparison operator. Thereore, or NULL in your select statement will always returned NULL. You can find all the rules for comparaison at URL: http://dev.mysql.com/doc/mysql/en/Comparison_Operators.html Regards, Bernard On Thursday 02 December 2004 06:48, Vlad Shalnev wrote: Hi, All It's happen after upgrade from 3.23.46. Just look at this set of queries mysql select 1 or null; +---+ | 1 or null | +---+ | 1 | - Ok +---+ 1 row in set (0.00 sec) mysql create table a ( a int not null ); Query OK, 0 rows affected (0.00 sec) mysql select min( a ) is null from a; +--+ | min( a ) is null | +--+ |1 | - Ok +--+ 1 row in set (0.00 sec) mysql select min( a ) is null or null from a; +--+ | min( a ) is null or null | +--+ | NULL | - Why ??? +--+ 1 row in set (0.00 sec) It is very important for me to solve this problem. Thanks for any help Info from mysqlbug script Server version 4.1.7 Protocol version10 Connection Localhost via UNIX socket UNIX socket /tmp/.mysql.sock Uptime: 23 hours 43 min 34 sec Threads: 2 Questions: 53 Slow queries: 0 Opens: 20 Flush tables: 1 Open tables: 6 Queries per second avg: 0.001 C compiler:2.95.3 C++ compiler: 2.95.3 Environment: machine, os, target, libraries (multiple lines) System: SunOS asv 5.8 Generic_108529-23 i86pc i386 i86pc Architecture: i86pc Some paths: /usr/local/bin/perl /usr/ccs/bin/make /opt/sfw/bin/gmake /opt/sfw/bin/gcc /usr/local/bin/cc GCC: Reading specs from /opt/sfw/lib/gcc-lib/i386-pc-solaris2.8/2.95.3/specs gcc version 2.95.3 20010315 (release) Compilation info: CC='gcc' CFLAGS='' CXX='g++' CXXFLAGS='' LDFLAGS='' ASFLAGS='' LIBC: -rw-r--r-- 1 root bin 1608268 Jul 30 2003 /lib/libc.a lrwxrwxrwx 1 root root 11 Mar 3 2004 /lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 root bin 956112 Jul 30 2003 /lib/libc.so.1 -rw-r--r-- 1 root bin 1608268 Jul 30 2003 /usr/lib/libc.a lrwxrwxrwx 1 root root 11 Mar 3 2004 /usr/lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 root bin 956112 Jul 30 2003 /usr/lib/libc.so.1 Configure command: ./configure '--prefix=/usr/local/mysql-4.1.7' '--exec-prefix=/usr/local/mysql-4.1.7' '--libexecdir=/usr/local/mysql-4.1.7/bin' '--localstatedir=/main/MysqlDB' '--enable-thread-safe-client' '--with-unix-socket-path=/tmp/.mysql.sock' '--with-mysqld-user=mysql' '--without-debug' '--without-bench' '--with-charset=koi8r' Perl: This is perl, version 5.005_03 built for i86pc-solaris -- --- - Vlad A. Shalnev E-mail: [EMAIL PROTECTED] Gravity can't be blamed for someone falling in love ( Albert Einstein ) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Question on date calculation +
You will get your answers by reading carefully the Date Time Functions in the MySQL Reference Manual. Look at the URL: http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html Bernard On Wednesday 17 November 2004 16:40, Stuart Felenstein wrote: While I'm figuring this needs to be addressed via my scripting language wanted to ask here. Customers will buy a block of time to use my service. Time meaning number of days. 90, 45, 60, etc. Here are the fields relevant to this question: PostStart [Date] LenChoice [int] DaysLeft [int] When they register , the current date is input automagically into PostStart. LenChoice is chosen by the user and is the length of days they want this block. DaysLeft is where the calculation would be done to hold the difference between the current date, date posted and how many days were paid for. This is where I'm not entirely sure what to do. I'm probably inhaling gasoline or something but how would I get the field to the numbers of DaysLeft ? i.e. DaysLeft[today]= 3, DaysLeft[tomorrow]=2..etc Thank you , Stuart p.s. I'm on 4.0.22 , so no stored procedures. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Question on date calculation +
No, but it will tell you how to compute the field or, maybe, change your design! You definitely need an update statement, something like: update table name set DaysLeft=wathever your figure out from your reading. Now how to run this automatically? Well I do not know if you are using MS WIndows or Linux. For MS WIndows I cannot really help you! Probably using the at command. Under Linux you can use cron to automatically start mysql with your update statement. You can run it as often as you wish. The command might look like: mysql -uuser -ppassword -e update ... Bernard On Wednesday 17 November 2004 16:58, Stuart Felenstein wrote: --- Bernard Clement [EMAIL PROTECTED] wrote: You will get your answers by reading carefully the Date Time Functions in the MySQL Reference Manual. This will tell me how to automatically update the column in question ? Stuart -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: What's MYSQL equivalent to Oracle's TRUNC(date_time_var)?
Look at the DATE() fucntion you can find in the REF Manual of MySQL at URL: http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html Regards, Bernard On Friday 12 November 2004 12:14, sol beach wrote: In Oracle TRUNC(data_time_var) returns only the date portion of a date_time data type. What's the easiest way in MYSQL to accomplish the same thing? I tried to RTFM (Paul DuBios' MYSQL tome; 2nd Ed.), but no clean solution lept out at me. It is a GREAT book, but it did not help me in this case. TIA! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Adding DSN into Coldfusion Admin?
Did you tried without the : between web-server2 and 3306? i.e. put a space insted of : B On Thursday 14 October 2004 19:58, Steve Grosz wrote: I have tried telnet web-server2:3306 Didn't work Dwalu Z. Khasu wrote: On Thu, 14 Oct 2004, Steve Grosz wrote: =If that's the case, its not working, I type a telnet 192.168.x.x:3306 =and get a could not open a connection to the host even though =Mysql-nt shows as running on the Win2003 server. = =Steve = Try 'telnet host port'. - Dwalu .peace -- I am an important person in this world - Now is the most important time in my life - My mistakes are my best teachers - So I will be fearless. - Student Creed -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
how do I get the last time of replication
I have a webapp that runs from a slave (read-only) database. Sometimes the slave database is unable to connect to the master and the data becomes stale. Is there a way to query out the time of last replication (or the time elapsed since last replication) so that I can warn the user of the webapp that the data might be stale? Please CC: any replies to me directly. Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: (might be off list) MySQL AB
Hello MC, The following is extracted from URL: http://dev.mysql.com/doc/mysql/en/What_is_MySQL_AB.html which answers your questions. By the way, the ``AB'' part of the company name is the acronym for the Swedish ``aktiebolag,'' or ``stock company.'' It translates to ``MySQL, Inc.'' In fact, MySQL, Inc. and MySQL GmbH are examples of MySQL AB subsidiaries. They are located in the US and Germany, respectively. Bernard On Thursday 10 June 2004 05:03, mc wrote: Hi, I would like to know what does the 'AB' in MySQL AB stand for? Is it something like limited or incorporated? If yes, is this something related to the origin of MySQL? I am a subscriber from Hong Kong. Thanks. mc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Questions on index and 'order by'
I try to understand index usage for 'order by' but that's seemn hard to me. Here is what I have tried : 1_ About documentation I have read carefully related documentation (7.2.9 How MySQL Optimizes ORDER BY) but I don't understand it. - What is the difference betwween 'key1' and 'key_part1' ? - Why is it written ? : The following query will use the index to resolve the ORDER BY SELECT * FROM t1 WHERE key_part1=constant ORDER BY key_part2 The following query cannot use indexes to resolve the ORDER BY SELECT * FROM t1 WHERE key2=constant ORDER BY key_part2; 2_ I also tried a small example (table Test), with 2 fields and 2 (multiple) indexes create table Test(Name varchar(64), Adress varchar(128), \ index K0(Name(16), Adress(16)), \ index K1(Adress(16), Name(16)) ) type = INNOBASE ; What are the indexes needed for 'orber by' in the request select * from Test where Name='n1' order by Adress ; If I ask explain, I got 'Using filesort' in Extra column information mysql explain select * from Test where Name='n1' order by Adress ; +---+--+---+--+-+---+-- +-+ | table | type | possible_keys | key | key_len | ref | rows | Extra | +---+--+---+--+-+---+-- +-+ | Test | ref | K0| K0 | 17 | const |1 | Using where; Using filesort | +---+--+---+--+-+---+-- +-+ Thanks for any help - Bernard Chambon IN2P3 / CNRS [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Stupid Newbie Query Help with AND and OR logical operators
You need parenthesis around cond1 OR cond2 OR cond3 otherwise effectively you are going to get all records matching the following: last d AND choice1=2 + choice2=2 + choice3=2 Therefore, you select statement should be written: SELECT * FROM name WHERE last LIKE d AND (choice1=2 OR choice2=2 OR choice3=2); Bernard On Friday 07 May 2004 13:51, Bob Cohen wrote: Here's my question. I wrote this query: Select * FROM name WHERE last LIKE d AND choice1=2 OR choice2=2 OR choice3=2; What I'm looking for are records that satisfy the LIKE d condition But then, Only one of the three other conditions need be true: choice1=2 choice2=2 choice3=2 I want to cover the possibilities, e.g., choice1=2 choice2=1 choice3=1 choice1=1 choice2=2 choice3=whatever Or choice1=1 choice2=1 choice3=2 Does this make sense? The query I've written doesn't seem quite right. Because of the AND following the LIKE d condition, it seems like all the records will have to have choice2 equaling 2. Some help clarifying this issue would be appreciated. Thanks. Bob Cohen b.p.e.Creative http://www.bpecreative.com Design and production services for the web Put creative minds to work for you -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysqldump command error
Hello Joe, mysqldump is a seperate programto be execute at the system prompt. Therefore it is not to be run under the mysql prompt. Bernard On Friday 26 March 2004 06:09, joe collins wrote: I have read the documentation on the MySQLDump, but have been unable to launch a mysql dump. Is the dump performed while logged on to the database that you want to dump, or do you log onto the machine where the database is and specify which database you want to dump?. I have looked at and applied some of the sample mysqldump commands given in the documentation, but all have resulted in syntax errors. See below Any advice or pointers would be greatly appreciated. many thanks for your patience Joe nuatech_1 is the name of my database nuatech is my password set up for the root user I want to dump it to a file called dump1.txt My database is set up on localhost Opted to use the database upon which I want to perform mysqldump: mysql use nuatech_1 Database changed Tried a mysqldump: mysql mysqldump -u root -p nuatech nuatech_1 dump1.txt; ERROR 1064: You have an error in your SQL syntax. Check the manual that corresp onds to your MySQL server version for the right syntax to use near 'mysqldump -u root -p nuatech nuatech_1 dump.txt' at line 1 Tried again removing spaces before parameters mysql mysqldump -uroot -pnuatech nuatech_1 dump1.txt; ERROR 1064: You have an error in your SQL syntax. Check the manual that corresp onds to your MySQL server version for the right syntax to use near 'mysqldump -u root -pnuatech nuatech_1 dump1.txt' at line 1 logged out of mysql: mysql quit Bye Logged back in ( not to a particular database) C:\mysql\binmysql -u root -p mysql Enter password: *** Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3 to server version: 4.0.18-max-debug Type 'help;' or '\h' for help. Type '\c' to clear the buffer. Tried the mysqldump again: mysql mysqldump -uroot -pnuatech nuatech_1 dump1.txt; ERROR 1064: You have an error in your SQL syntax. Check the manual that corresp onds to your MySQL server version for the right syntax to use near 'mysqldump -u root -pnuatech nuatech_1 dump1.txt' at line 1 Tried again with spaces before the parameters: mysql mysqldump -u root -p nuatech nuatech_1 dump1.txt; ERROR 1064: You have an error in your SQL syntax. Check the manual that corresp onds to your MySQL server version for the right syntax to use near 'mysqldump -u root -p nuatech nuatech_1 dump1.txt' at line 1 mysql -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: installation de mysql
Bonjour, For the benefit of the group I will translate the French part of my text :-) Le tarball que vous avez telecharge est en fait le binaire executable de MySQL pas les sources. Donc vous n'avez pas a executer configure sur celui-ci. The tarball that you have downloaded is in fact the eexcutable binary of MySQL not the sources. Therefore, you do not have to execute configure on it. Si vous avez acces au CD de distribution de RedHat je vous recommanderais d'installer MySQL a partir du RPM. Si vous n'avez pas acces a ceux-ci telecharger le RPM pour RedHat 9. Il est en effet beaucoup plus facile d'installer MySQL a partir des RPM. If you have access to the distribution CDs of RedHat I recommend you to install MySQL from the RPM. If you do not have access to those, you should download the RPM for RedHat 9. In effect it is a lot more easier to install MySQL from the RPM. Salutations, Bernard On Wednesday 24 March 2004 05:01, sanaâ Aitouchen wrote: j'ai le red hat 9 et j'ai télécharger mysql-3.23.58-pc-linux-i686.tar.gz j'ai crée le repertoir /usr/local/src et j'ai fais gunzip mysql-3.23.58-pc-linux-i686.tar.gz tar xvf mysql-3.23.58-pc-linux-i686.tar.gz cd mysql-3.23.58-pc-linux-i686 ./configure --prefix=/usr/local/mysql mais ca donnée l'erreur suivante: NOTE: This is a MySQL binary distribution. It's ready to run, you don't need to configure it! To help you a bit, I am now going to create the needed MySQL databasesand start the MySQL server for you. If you run into any trouble, please consult the MySQL manual, that you can find in the Docs directory. Installing all prepared tables 040324 9:51:43 ./bin/mysqld: Shutdown Complete To start mysqld at boot time you have to copy support-files/mysql.serverto the right place for your system PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is done with: ./bin/mysqladmin -u root password 'new-password' ./bin/mysqladmin -u root -h iamintrusion password 'new-password' See the manual for more instructions. NOTE: If you are upgrading from a MySQL = 3.22.10 you should runthe ./bin/mysql_fix_privilege_tables. Otherwise you will not be able to use the new GRANT command! You can start the MySQL daemon with: cd . ; ./bin/safe_mysqld You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory: cd sql-bench ; run-all-tests Please report any problems with the ./bin/mysqlbug script! The latest information about MySQL is available on the web at http://www.mysql.com Support MySQL by buying support/licenses at https://order.mysql.com Starting the mysqld server. You can test that it is up and running with the command: ./bin/mysqladmin version [EMAIL PROTECTED] mysql-3.23.58-pc-linux-i686]# Starting mysqld daemon with databases from /usr/local/src/mysql-3.23.58-pc-linux-i686/data 040324 09:51:44 mysqld ended j'aimerais bien savoir ou se trouve l'erreur et comment je peux le régler merci d'avance _ MSN Messenger : discutez en direct avec vos amis ! http://www.msn.fr/msger/default.asp -- Bernard Clement Info-Electronics Systems Inc. Technical Director phone: 514-421-0767 ext: 231 fax: 514-421-0769 email: [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Commercial Licence
Dear Pierre, I would suggest you to contact directly MySQL AB for such a question at [EMAIL PROTECTED] My guess is that you will need to buy a license for the master and the slaves. Regards, Bernard On Wednesday 10 March 2004 03:19, Pierre Luguern wrote: I want to run a commercial product based on MySQL. I have one centralized server running MySQL in replication mode (master server). I have five clients running MySQL (each slave is running one MySQL daemon). Do I have to acquire only one commercial licence for my master server or do I have do get commercail licence for master and slave. Thanks in advance. mailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL C API license
To my knowledge it is GPL. Bernard On Friday 05 March 2004 17:52, Ronald J. Yacketta wrote: Folks, What license does the MySQL C API fall under? I am looking to add client support to a game that I am creating, but need to know the terms of the license etc. -Ron -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: The very first day of march :-) (select (curdate()-1);)
Your select works fine within the month to the exception of the first day because curdate()-1 is treated as a numeric field (see curdate in http://www.mysql.com/doc/en/Date_and_time_functions.html) The following seems to be what you want to do: mysql select date_format(curdate()- interval 1 day,'%Y%m%d'); +-+ | date_format(curdate()- interval 1 day,'%Y%m%d') | +-+ | 20040229| +-+ 1 row in set (0.00 sec) or, if you want the '-' mysql select date_format(curdate()- interval 1 day,'%Y-%m-%d'); +---+ | date_format(curdate()- interval 1 day,'%Y-%m-%d') | +---+ | 2004-02-29| +---+ 1 row in set (0.00 sec) Bernard On Monday 01 March 2004 05:15, Campanella Danilo wrote: Hi, Look at what happened today : mysql select curdate(); ++ | curdate() | ++ | 2004-03-01 | ++ 1 row in set (0.00 sec) mysql select (curdate()-1); +---+ | (curdate()-1) | +---+ | 20040300 | +---+ 1 row in set (0.00 sec) mysql Until yesterday select (curdate()-1); worked fine. I use MySQL version 4.0.12. Does anybody know something about? Ciao Danilo CONFIDENTIALITY NOTICE This message and its attachments are addressed solely to the persons above and may contain confidential information. If you have received the message in error, be informed that any use of the content hereof is prohibited. Please return it immediately to the sender and delete the message. Should you have any questions, please contact us by replying to [EMAIL PROTECTED] Thank you www.telecomitalia.it -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: API C
Hi Volnei, Under Linux you do not need the -lsocket. (If I recall correctly that is for SUN Solaris but I might be wrong) As for your run-time error, the DLL libmysqlclient.so is not in the library path. Either modify /etc/ld.so.conf to include where is that library (it seems to be /usr/local/mysql/lib/mysql from your gcc command line). In which case do not forget to run ldconfig -n OR Set the environment variable LD_LIBRARY_PATH to where the library is installed (again from your gcc command line it seems to be /usr/local/mysql/lib/mysql). Regards, Bernard On Wednesday 25 February 2004 09:37, Galbino wrote: Hello, I made a compilation test, to see how it works, and already the first beginner problems came. #include sys/time.h #include stdio.h #include mysql.h int main(int argc, char *argv[]){ MYSQL_RES *result; MYSQL_ROW row; MYSQL *connection, mysql; int state; /* Conectando com MySQL */ printf(Iniciando o MySQL!!!); mysql_init(mysql); connection = mysql_real_connect(mysql,localhost,root,mysql,banco,0,NULL,0); if (connection == NULL){ printf(Não conectado!!!); printf(mysql_error(mysql)); return 1; } /* Close connection */ mysql_close(connection); printf(\nSaindo! \n); } When I try to compile, with the command below, he says that cannot find the - lsocket. Is the command correct? Which the problem? [EMAIL PROTECTED] teste]# gcc -L/usr/local/mysql/lib/mysql -I/usr/local/mysql/include/mysql -o teste teste.c -lmysqlclient -lnsl -lsocket /usr/bin/ld: cannot find -lsocket collect2: ld returned 1 exit status [EMAIL PROTECTED] teste]# Removing the command - lsocket, the compilation is executed, however when I will execute, appears the message, as shown below. [EMAIL PROTECTED] teste]# gcc -L/usr/local/mysql/lib/mysql -I/usr/local/mysql/include/mysql -o teste teste.c -lmysqlclient -lnsl [EMAIL PROTECTED] teste]# [EMAIL PROTECTED] teste]# ./teste ./teste: error while loading shared libraries: libmysqlclient.so.14: cannot open shared object file: No such file or directory [EMAIL PROTECTED] teste]# what this happening? Volnei Galbino. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Did I mess up MySQL?
You also need to install the rpm for mysql-client. Bernard On Tuesday 24 February 2004 16:37, Database Administrator wrote: I had MySQL 3.23.52-3 installed on RH Linux 8.0 (default that comes with it). I decied to install 4.0 and used this command to install it: rpm -Uvh --nodeps MySQL-server-4.0.18-0.i386.rpm I didn't see any obvious errors thereafter. After rebooting noticed that looks like the mysql daemon is running: $ ps -ef|grep mysql root 1620 1 0 15:52 pts/000:00:00 /bin/sh /usr/bin/mysqld_safe --d mysql 1655 1620 0 15:52 pts/000:00:00 /usr/sbin/mysqld --basedir=/ --d However the file /usr/bin/mysql no longer exists so how do I actually get a command line interface to MySQL? Or is there something else I need to install that I have neglected? Or am I just hosed? :) Thanks, lk www.theNewAgeSite.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Newbie question
Dear Brad, Your problem is too much experiences not the lack of skills. I am in the same situation...it is very frustating. Regards, Bernard On Monday 23 February 2004 11:14, Brad Eacker wrote: Donny Simonton [EMAIL PROTECTED] writes: But as a manager, the first thing I do is ask for code examples, as well as table structures. I don't even need to see a resume once I look at somebody's code and table structures. Unfortunately I will have to disagree with you on this one. Having been searching for solid employment for the last year, I'm finding that the managers seek only to place someone who has done the exact job they are trying to fill. And this is with 22 years of relevant experience on my part. 8 years of web-back integration, 13 years inside the unix kernel, coupled with 9 years of RDBMS experience don't seem to hold much weight anymore. You mention examples, I have a pair I use having fully developed both sets http://www.misc.com/costumes/Dickens_0312/index.php http://66.134.203.2/~beacker/genbank/gbf_extract.cgi?LOCUS=AF158101 The first being a photographic PHP based mechanism that I use in at least a dozen pages without change. The second being a 30 million record data set I utilize for selecting GenBank info. I'm finding it very frustrating that my knowledge and capabilities are not found to be compelling. I have utilized C for over 21 years, and perl for 20 years. Yet these don't appear to be enough to get a position in Silicon Valley. Brad Eacker ([EMAIL PROTECTED]) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How To Write This SQL Statement
Assuming that the address field is of type char or varchar, Assuming that the address field has a NULL default value the following should do it select ... from ... wehre address is null; In case that the address field has no default value the following should do it: select ... from ... where address=''; If one or more of my assumptions are wrong PLS provide us with the structure of your table with describe tables ... Bernard On Tuesday 17 February 2004 14:16, Caroline Jen wrote: Please help. What is the syntax of idenfying those who do not have addresses (in the address field) in the database? __ Do you Yahoo!? Yahoo! Finance: Get your refund fast by filing online. http://taxes.yahoo.com/filing.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: WHERE Clause
You can use having instead of where with an alias. Bernard On Thursday 12 February 2004 14:46, Ian O'Rourke wrote: Is it possible to have a 'worked out value' in the WHERE clause. The problem I have is what I need to check for in the WHERE Clause is not a column: SELECT CONCAT_WS(-,DATE_FORMAT(EntryDate,'%c'),DATE_FORMAT(EntryDate,'%Y')) As mthyr From Blogs WHERE mthyr=1-2003 This does not work as it seems to want a valid column in the WHERE clause. Anyway around it? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: creating users
Hello Daniel, Try with: revoke show databases on mysql.* from [EMAIL PROTECTED]; If the user [EMAIL PROTECTED] issue show databases il will not see anymore the databases mysql. The revoke you were trying was not only on showing the database mysql but revoke all the privilege, is is really what you want to do? BTW, nex time also supply the error text. Regards, Bernard On Sunday 08 February 2004 08:49, Daniel Audette wrote: Hello I am new to mysql. What I want to do is give a user a right to create databases with all rights but I do not want them to see the mysql database I have tried the following GRANT ALL PRIVILEGES ON *.* TO [EMAIL PROTECTED] DENTIFIED BY 'some_pass' WITH GRANT OPTION; then tried to revoke revoke all privileges on mysql from [EMAIL PROTECTED]; just got an error. Any suggestions on how to do this. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: select on set yields exponential notation
If you are using 4.0.2 and above you can use cast. mysql select var1,cast(var2 as unsigned) from test1; +--++ | var1 | cast(var2 as unsigned) | +--++ |1 |562949953421312 | |1 | 1 | |1 | 32768 | +--++ 3 rows in set (0.00 sec) Note I add a row with 1 and another with 16. Bernard On Friday 06 February 2004 16:22, Greg Vines wrote: With sets if you select the set, you get a comma delimited list, but if you add zero, you get the number value of the entire set (which is what I want). The response is not always in exponential notation - just when a high order bit is set. This seems to be a problem with the output formatting. Do you know if there is a way to set the number of characters in a numeric response? On Fri, 2004-02-06 at 12:54, Michael Stassen wrote: Why are you adding 0? Try this: SELECT var1, var2 FROM test1; Michael Greg Vines wrote: I'm trying to select all the fields from a set but when the number is large, it is returned in exponential notation. Is there a way to keep the returned number an integer? Example: create simple table: create table test1( var1 int, var2 set(1,2,3,4,5,6,7,8,9,10, 11,12,13,14,15,16,17,18,19,20, 21,22,23,24,25,26,27,28,29,30, 31,32,33,34,35,36,37,38,39,30, 41,42,43,44,45,46,47,48,49,40, 51,52,53,54,55,56,57,58,59,60) ); Add a row: insert into test1 values (1, 40); Then select oops: select var1,var2+0 from test1; +--+-+ | var1 | var2+0 | +--+-+ |1 | 5.6294995342131e+14 | +--+-+ How can I get this output as an integer? I've tried both MySQL 3.23 and 4.0.17 with the same result. I'm running on linux (RHL 8.0) Thanks - Greg -- Greg Vines mailto:[EMAIL PROTECTED] Manzanita Systems http://www.manzanitasystems.com 14400 Midland Road Voice: (858) 679-8990 x104 Poway, CA 92064 Fax: (858) 679-8991 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: New to MySQL
Some answers within your message. I would suggest you to browse the reference manual. Bernard On Thursday 05 February 2004 17:27, /dev/null wrote: wow, nice product. Pretty easy to use and install - I like it. I know enough about SQL and databases to just about break any flavor of them I put my hand on ;-). A couple of pointers would be great. I'm creating a handfull of tables that will inter-depend on eachother, using it within php. I have three basic questions: 1. Some of the tables have a unique ID, each new record should get the next number available. Is there an easy data type that will do this for me, or do I need to get a record count myself and use record count + 1 when I insert a new row? You can use an AUTO_INCREMENT column See URL: http://www.mysql.com/doc/en/CREATE_TABLE.html for an explaination 2. Some of the tables will need a timestamp of the exact date/time the record was added. Does timestamp do this, or again do I need to get time( ) and use that value on the insert myself? I would suggest a DATETIME type and use now() when inserting new record. 3. Some of the IDs from one table are used in another table, for example I have an accounts table and a sites table. Each account can have several sites, and each site entry has an account field that has the account ID (from question 1) to tell who the account owner is. Isn't there a joint query that I can run that is like 'SELECT * FROM `sites` WHERE `AccountID` = ( SELECT `ID` FROM `accounts` WHERE `Name` = 'First Last' )'??? Or do I need to run the inner select and get the ID myself, then run the outer select? I admit, I know just enough SQL to wipe the database and drop all the tables ;-), so any help would be greatly apreciate. You want to establish a REFERENCE. Look at the same URL as above for information. Thanks! /dev/null -- Bernard Clement Info-Electronics Systems Inc. Technical Director phone: 514-421-0767 ext: 231 fax: 514-421-0769 email: [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: HELP! Select queries for tables that has fields with # characters
Hello Howell, See URL: http://www.mysql.com/doc/en/Legal_names.html for the solution. Basically enclose FILE# with `, e.g. where `FILE#` = 1332 Bernard On Thursday 29 January 2004 12:55, Howell, Scott wrote: I am trying to query a table that has field names with # characters in them. For example a table emp_earn has a field called FILE# I need to do a query where FILE# = 1332, but anything I try errors out. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: HELP! Select queries for tables that has fields with # characters
Which version of MySQL are you using? It works for me with version 4.0.15 as shown below: mysql select version(); +---+ | version() | +---+ | 4.0.15| +---+ 1 row in set (0.00 sec) mysql create table temp (`FILE#` integer); Query OK, 0 rows affected (0.00 sec) mysql select * from temp where `FILE#`=1332; Empty set (0.00 sec) Bernard On Thursday 29 January 2004 13:44, Howell, Scott wrote: select * from emp where `file#` = 1332; returns ERROR 1054: Unknown column 'file' in 'where clause' -Original Message- From: Bernard Clement [mailto:[EMAIL PROTECTED] Sent: Thursday, January 29, 2004 1:19 PM To: Howell, Scott; Mysql (E-mail) Subject: Re: HELP! Select queries for tables that has fields with # characters Hello Howell, See URL: http://www.mysql.com/doc/en/Legal_names.html for the solution. Basically enclose FILE# with `, e.g. where `FILE#` = 1332 Bernard On Thursday 29 January 2004 12:55, Howell, Scott wrote: I am trying to query a table that has field names with # characters in them. For example a table emp_earn has a field called FILE# I need to do a query where FILE# = 1332, but anything I try errors out. -- Bernard Clement Info-Electronics Systems Inc. Technical Director phone: 514-421-0767 ext: 231 fax: 514-421-0769 email: [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Application using mysql, perl, Excel
Hello, It might be possible to do what you want to do but...I think it will take too much time and, therefore, will be expensive. As stated by somebody else OpenOffice with ODBC is effectively an interesting solution. I have done it for fun and it works quite well (after the small nightmare of the installation). Therefore I would suggest that you take a look at the product MySQL Manager (URL: http://ems-hitech.com/mymanager/) It is a commercial product, although not too expensive, but one of the bundle seems to be your solution. There is also a 30 days trial version. Note that I never used the product myself but it seems to be a good part of your solution. Bernard PS I am not associated with the company making MySQL Manager, i.e. I am not paid for marketing or selling it. On Wednesday 28 January 2004 16:27, Annie Law wrote: Hi, I would appreciate help on the following. I would like to create a small application that would involve Excel XP on Windows 2000, and perl and mysql on RedHat linux 9.0 The front end of the application will be Excel since it has a lot of useful functions. Columns from the Excel sheet will be used to update the mysql database. Data from the mysql database will also be used to update the Excel sheet. I am trying to map things out and see if all of the parts in my application will fit together prior to doing too much developing. Basically my main concern now is to create the flow of information. There is the Excel workbook part and then there is the UNIX mysql database part. Writing a shell or perl script in the linux environment that will ftp files from an external source that will be used to update the mysql database. They will be flat files. I will use perl to parse the data. Then use perl DBI to insert to information Also using perl DBI to upload information from the Excel sheet (user's personal annotation) Into the database. The part that I'm not too sure about is how to send the information from the Excel sheet to the database And how to grab the information from the database and update the Excel sheet. On top of that I am using two different operating systems. Are there some tools in VBA or in perl that I could use to build this bridge? Is this a practical solution? Thanks for your help, - Post your free ad now! Yahoo! Canada Personals -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Require greater than 255 in varchar?
Either a BLOB or TEXT field should be your solution. See http://www.mysql.com/doc/en/BLOB.html for the description. Bernard On Tuesday 27 January 2004 22:29, Eve Atley wrote: I have a large chunk of text I've attempted to put into a varchar field, and it chopped off a chunk of it. If I need to enter text that is greater than the default 255, what choice should I use instead? Thanks, Eve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: SQL Query
My guess will be that the where clause is misplaced. Try SELECT * From articles WHERE SectionID=1 ORDER BY EntryDate DESC LIMIT 1,10 PLS read URL: http://www.mysql.com/doc/en/SELECT.html On that page it is stated that: All clauses used must be given in exactly the order shown in the syntax description. For example, a HAVING clause must come after any GROUP BY clause and before any ORDER BY clause. Bernard On Sunday 18 January 2004 06:21, Ian O'Rourke wrote: Any idea what is wrong with the following: SELECT * From articles ORDER BY EntryDate DESC LIMIT 1,10 WHERE SectionID=1 I want to return all articles with a particular SectionID, ordered by EntryDate and then I want to pick the start point and list the next 10 from that. Obviously in the final version the start point and the SectionID will be dynamic. I have tried removing the LIMIT part. I've tried changing the SectionID to a different field it always gives me an uninformative error? . -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Automatic conversion from `char` TO `varchar`
you seem to have mixed single and double quotes. this might be your problem - Original Message - From: Hassan Shaikh [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Saturday, January 10, 2004 7:06 AM Subject: Automatic conversion from `char` TO `varchar` Hi, It's really strange but when I execute the following statement, all my char(10) columns turn into varchar(10). My other tables are ok and I've tried create dummy table also. Problem seems to be associated with this table only. CREATE TABLE `offer` ( `SVID` int(11) NOT NULL auto_increment, `CUID` char(10) NOT NULL default '', # one double quote `OFTXT` text, # single - double quote mismatch `OFAMOUNT` decimal(12,2) NOT NULL default '0.00', # single - double quote mismatch `OFTYPE` char(1) NOT NULL default 'P', `OFSENTDT` datetime default NULL, # single - double quote mismatch `OFREPLYDT` datetime default NULL, # single - double quote mismatch `OFREPLYTXT` text, # single - double quote mismatch `OFRESULT` char(1) NOT NULL default 'X',# single - double quote mismatch `PID` char(10) NOT NULL default '', # one double quote PRIMARY KEY (`SVID`) ) TYPE=InnoDB ; Would appreciate if someone could provide some insight. Thanks. Hassan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Certification Question
Hello Aman, For instructions on taking the exam in India goto the URL: http://www.vue.com/mysql/ and click on test center of To register for exams in India, please contact the test center directly. This will bring you a window containing all the Pearson VUE Test Center in India. Good luck! Bernard On Friday 09 January 2004 22:29, Amanullah wrote: I'm also interested to take up the certification exam on Mysql, pl. guide me how to proceed to get certification on the same, I'm in India (chennai). -aman. Arjun Subramanian wrote: I took the MySQL core certification exam on the 2nd of January and Passed. I was just wondering when MySQL actually sends out the Certificate and other stuff they said they would send out? Does anyone here have any experience with this ? Thanks in advance. Arjun Subramanian Georgia Tech Station 32003 Atlanta GA 30332 Cell: +404.429.5513 http://www.arjunweb.com -Original Message- From: Amanullah [mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 10:03 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: New INstall of MySQL Hi, make sure the existing directories has been removed fully, then continue with new installation, after installation is over, pl. restart the system, if mysql daemon has not started, pl. go to ..\mysql\bin\ directory run winmysqladmin.exe. mysql service will be strated to work.. -Aman. Chris L. White wrote: Ok I have a question. This is the first time any of us here in our office have installed MySQL or for that fact worked with MySQL. So I got stuck with trying to figure it out. Ok here is the problem. I completely removed the previous MYSQL installation attempt. I started new to install MYSQL. I go to setup and run the setup and the status bar does not move much and the installation takes about 5 seconds and then it is done. I get to the finished installing screen, but there are no options to choose from like the test in the screen says there should. Also I have a my.cnf and ny.ini file in the proper places and I still have nothing going. I am confused and the manual I am finding is not clear enough on this. I included what the my.cnf and my.ini file looks like. And also included the error I am getting after installation. Also after MYSQL is installed should there not be some icons for things related to it, because I don't even have them. I am trying to install this on 2003 Server Standard Edition and have IIS 6 and TCP/IP installed. Please help. [mysqld] # set basedir to your installation path # basedir=C:/mysql # set datadir to the location of your data directory #datadir=C:/SQLData # Example mysql config file. # Copy this file to c:\my.cnf to set global options # # One can use all long options that the program supports. # Run the program with --help to get a list of available options # This will be passed to all mysql clients [client] #password=my_password port=3306 #socket=MySQL # Here is entries for some specific programs # The following values assume you have at least 32M ram # The MySQL server [mysqld] port=3306 #socket=MySQL skip-locking set-variable = key_buffer=16M set-variable = max_allowed_packet=1M set-variable = table_cache=64 set-variable = sort_buffer=512K set-variable = net_buffer_length=8K set-variable = myisam_sort_buffer_size=8M server-id = 1 # Uncomment the following if you want to log updates log-bin # Uncomment the following rows if you move the MySQL distribution to another # location basedir = c:/mysql/ datadir = c:/SQLData # Uncomment the following if you are NOT using BDB tables skip-bdb # Uncomment the following if you are using BDB tables #set-variable = bdb_cache_size=4M #set-variable = bdb_max_lock=1 # Uncomment the following if you are using Innobase tables #innodb_data_file_path = ibdata1:400M #innodb_data_home_dir = c:\ibdata #innodb_log_group_home_dir = c:\iblogs #innodb_log_arch_dir = c:\iblogs #set-variable = innodb_mirrored_log_groups=1 #set-variable = innodb_log_files_in_group=3 #set-variable = innodb_log_file_size=5M #set-variable = innodb_log_buffer_size=8M #innodb_flush_log_at_trx_commit=1 #innodb_log_archive=0 #set-variable = innodb_buffer_pool_size=16M #set-variable = innodb_additional_mem_pool_size=2M #set-variable = innodb_file_io_threads=4 #set-variable = innodb_lock_wait_timeout=50 [mysqldump] quick set-variable = max_allowed_packet=16M [mysql] no-auto-rehash # Remove the next comment character if you are not familiar with SQL #safe-updates [isamchk] set-variable = key_buffer=20M set-variable
Recommended Course
Hello marc, Look at the URL: www.mysql.com/training/courses/using_and_managing_mysql.html There are courses coming soon at Boston and another one in Washington DC which I think is fairly in the Northeast of the US. Regards, Bernard Marc Dver [EMAIL PROTECTED] wrote .. This might be a bit of a repeat, but I didn't get too many responses. Can someone recommend a course in the Northeast of the US that teaches the details of the use of mysql? Sincerely, Marc DVer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Countries, cities, states database
Hello Augusto, You might be able to use the list of weather stations available from WMO at URL: http://www.wmo.ch/index-en.html Among other thing it contains the country and station name (or city name). I know that NWS/NOAA also have that list but it seems that the list is not available right now. Good luck, Bernard On Thursday 18 December 2003 09:32, Augusto Cesar Castoldi wrote: Hi, I searching for a database, with the 'complete' world Countries, cities, states Just like http://www.datingplace.com/servlet/NewRegistration I need for an academic study. Thanks, Augusto -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL installation with SuSE Linux 9.0 and YaST
Hello Franz, On Sunday 07 December 2003 12:42, Franz Edler wrote: I do not have specific experiences with SuSE 9.0 (stiil waiting for it from my distributor) but I do with previous versions of SuSE (7.x and 8.x), I am not very experienced with Linux, but SuSE Linux 9.0 and YaST makes it very comfortable for me to install various SW-packages. Therefore I try to install also MySQL with YaST. There are MySQL packages (Version 4.0.15) included in SuSE Linux 9.0 distribution and I try to install the server and the client with YaST. But after installation of these packages with YaST - which is the easy part - one has to configure various parameters for MySQL to work properly e.g. create the database files, define group and user, grant access ... Unfortunately the MySQL-manual (which is a big document) does not give any guidelines for installing with YaST. Unfortunately you cannot use YaST to confiture MySQL. Although your may want the server to start at boot time and that is done in the System-Run Level Editor in YaST. After several times re- and de-installing mysql and also SuSE-Linux itself I still have troubles to get the server running. What kind of troubles? Probably this is the place this group can start to help you. Has anyone already done a MySQL-installation with SuSE Linux 9.0 and YaST? Is there any quick installation guide for this task? I think you have done all it could be done using YaST. You need now to jump into the documentation of MySQL. I will suggest that you read the tutorial in section 3 of MySQL's documentation. (URL: http://www.mysql.com/doc/en/Tutorial.html). I would be very happy to get some help. Hope I have been usefull. Franz Bernard -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Backup question.
rsynch will do the job correctly only and only if the mysql server on both sides are not running. Rsynch does not deal with files opened for writing and my guess is that MySQL is opening the database (i.e. files) for writing. As for LVM (AKA Logical Volume Manager) I really do not see how it could be used to take a snapshot in MySQL. However, I could be wrong here. Bernard On Tuesday 18 November 2003 05:12, Simon Green wrote: Has any one use LVM to take a snapshot in MySQL and use this to back up data? Simon -Original Message- From: Paco Martinez [mailto:[EMAIL PROTECTED] Sent: 18 November 2003 10:00 To: Christensen, Dave; 'Richard Reina'; [EMAIL PROTECTED] Subject: Re: Backup question. Is there any problem executing rsync /var/lib/mysql/data/ from one host to another host and therefore having same file in obth machines?? Is it unsafe this method ?? Could be crashed meanwhile transferring ?? Thanks !!! - Original Message - From: Christensen, Dave [EMAIL PROTECTED] To: 'Richard Reina' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 10:20 PM Subject: RE: Backup question. Yes, you can do it like this: Prompt mysqldump --add-drop-table --host=source.IP.addr.spec -uuser -ppassword databasename | mysql -uuser -ppassword I've found that it helps things if you add --no-data to the source side on the first pass, then remove that clause and run it again. Dave -Original Message- From: Richard Reina [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 3:54 PM To: [EMAIL PROTECTED] Subject: Backup question. I would like to backup databases from a linux MySQL server to another linux machine on the same private network but I don' see in the docs how I can do this with mysqlhotcopy or mysqldump. Is there any way to do this besides using ftp. Any help would be appreicated. Richard -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Backup question.
I think that it is more than backing up the database you want to do. If I am right you want to synchronize the 2 databases in which case the answer is replication. Replication is described in the reference manual of MySQL. Bernard On Tuesday 18 November 2003 04:59, Paco Martinez wrote: Is there any problem executing rsync /var/lib/mysql/data/ from one host to another host and therefore having same file in obth machines?? Is it unsafe this method ?? Could be crashed meanwhile transferring ?? Thanks !!! - Original Message - From: Christensen, Dave [EMAIL PROTECTED] To: 'Richard Reina' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 10:20 PM Subject: RE: Backup question. Yes, you can do it like this: Prompt mysqldump --add-drop-table --host=source.IP.addr.spec -uuser -ppassword databasename | mysql -uuser -ppassword I've found that it helps things if you add --no-data to the source side on the first pass, then remove that clause and run it again. Dave -Original Message- From: Richard Reina [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 3:54 PM To: [EMAIL PROTECTED] Subject: Backup question. I would like to backup databases from a linux MySQL server to another linux machine on the same private network but I don' see in the docs how I can do this with mysqlhotcopy or mysqldump. Is there any way to do this besides using ftp. Any help would be appreicated. Richard -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Saving a table to a text file
mysqldump is a program like mysql not a command within mysql. Bernard On Monday 17 November 2003 21:46, Lay Hoon Tan wrote: I keep on getting errors for saving table to an external file. I think there is something wrong with the syntax. Could someone help me to correct it ? mysql mysqldump -r database table1; Regards -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Cronjob / rights problem - 2:nd try.
Hello Anders, NOTE: I am actually using SuSE 8.2 Pro Edition. However, those CRON jobs seem to be at the same place irrelevant of the distro (RedHat or SuSE). Therefore, I doubt that SuSE Linux Standard Server 8 has changed that. If the problem occurs once a day then it is within the script /etc/cron.daily/logrotate That script is used to rotate the various log files in order that they do not fill up the hard disk. The script logrotate will activate all the scripts in /etc/logrotate.d and one of them is called mysql. You will find within that script the activation of mysqladmin that generate the error. I cannot really tell what you have to do to have mysqladmin to work correctly. Probably you will have to specify a user with some kind of root permission. I hope that I have been helpful. Regards, Bernard On Friday 07 November 2003 14:47, Anders Norrbring wrote: [Second try, the first one rendered a few hints that didn't help] I've set up a new MySQL server on a box with multiple IP addresses, and the SQL server only binds to ONE of these addresses. Also, I've been changing some user rights in the SQL setup, and now I get a cronjob error, related to user rights... My big problem is that I don't even know where I should start looking for it. The system and MySQL setup is in all other aspects the distributed versions from the SuSE Linux Standard Server 8 distribution, based on United Linux 1.0. The cronjob error mailed to me is the following: SCRIPT: clean_catman, OK. SCRIPT: clean_core, OK. SCRIPT: do_mandb, OK. SCRIPT: logrotate exited with RETURNCODE = 1. SCRIPT: ouput (stdout stderr) follows /usr/bin/mysqladmin: refresh failed; error: 'Access denied for user: '@localhost' (Using password: NO)' error running postrotate script Reload syslog service..done SCRIPT: logrotate --- END OF OUTPUT SCRIPT: slots, OK. SCRIPT: ouput (stdout stderr) follows psql: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket /tmp/.s.PGSQL.5432? SCRIPT: slots --- END OF OUTPUT Can somebody please help me out here? If the /usr/bin/mysqladmin tries to use a user from localhost (any) then it fails, because localhost doesn't have access to the SQL server... What user should be granted access (and from where) to make this job work correctly? Anders Norrbring Norrbring Consulting Halmvägen 42 SE-691 48 Karlskoga SWEDEN -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Cronjob / rights problem - 2:nd try.
Hello Anders, Sorry, I did not go through the end of your message. You also have a problem with psql which is, I think, the equivalent of mysql for PostgreSQL. Do you need PostgreSQL? If not, you should deactivate it. For your problem with mysqladmin, most probably specifying the switch --host with the hostname associated with your binding will fix the problem. Regards, Bernard On Friday 07 November 2003 15:15, Bernard Clement wrote: Hello Anders, NOTE: I am actually using SuSE 8.2 Pro Edition. However, those CRON jobs seem to be at the same place irrelevant of the distro (RedHat or SuSE). Therefore, I doubt that SuSE Linux Standard Server 8 has changed that. If the problem occurs once a day then it is within the script /etc/cron.daily/logrotate That script is used to rotate the various log files in order that they do not fill up the hard disk. The script logrotate will activate all the scripts in /etc/logrotate.d and one of them is called mysql. You will find within that script the activation of mysqladmin that generate the error. I cannot really tell what you have to do to have mysqladmin to work correctly. Probably you will have to specify a user with some kind of root permission. I hope that I have been helpful. Regards, Bernard On Friday 07 November 2003 14:47, Anders Norrbring wrote: [Second try, the first one rendered a few hints that didn't help] I've set up a new MySQL server on a box with multiple IP addresses, and the SQL server only binds to ONE of these addresses. Also, I've been changing some user rights in the SQL setup, and now I get a cronjob error, related to user rights... My big problem is that I don't even know where I should start looking for it. The system and MySQL setup is in all other aspects the distributed versions from the SuSE Linux Standard Server 8 distribution, based on United Linux 1.0. The cronjob error mailed to me is the following: SCRIPT: clean_catman, OK. SCRIPT: clean_core, OK. SCRIPT: do_mandb, OK. SCRIPT: logrotate exited with RETURNCODE = 1. SCRIPT: ouput (stdout stderr) follows /usr/bin/mysqladmin: refresh failed; error: 'Access denied for user: '@localhost' (Using password: NO)' error running postrotate script Reload syslog service..done SCRIPT: logrotate --- END OF OUTPUT SCRIPT: slots, OK. SCRIPT: ouput (stdout stderr) follows psql: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket /tmp/.s.PGSQL.5432? SCRIPT: slots --- END OF OUTPUT Can somebody please help me out here? If the /usr/bin/mysqladmin tries to use a user from localhost (any) then it fails, because localhost doesn't have access to the SQL server... What user should be granted access (and from where) to make this job work correctly? Anders Norrbring Norrbring Consulting Halmvägen 42 SE-691 48 Karlskoga SWEDEN -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: [jp] connection from MSSQL
Hi Jorge, Hum! you should use MySQL Control Center (AKA mysqlcc)? You will not have to worry about configuring (I do not think it is feasible) openrowset fo connect to MySQL. Regards, Bernard On Thursday 06 November 2003 13:43, Jorge Paiva (f2) wrote: Hi everybody.! can i use openrowset from MS-SQL SERVER to connect to mysql server ??? how can i doing it? pls. thank you. pta: my english is poor... sorry. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
SHOW TABLES and ORDER
Hi, I am using MySQL 3.23. I use SHOW TABLES to obtain a list of tables from my database and then put this list in an HTML select form on a web page. What I need to know, is there a way of obtaining this table list, using SHOW TABLES, in ascending or descending order the same way you would do using SELECT for a field in a specific table and then ORDER BY? Thank you for any help, Bernard __ Post your free ad now! http://personals.yahoo.ca - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: problem with max
hello in delphi the type for max(date) if tstring. the only problem is there is no CAST in mysql 3.23.49 bye - Original Message - From: Johnny Withers [EMAIL PROTECTED] To: 'Jean Bernard' [EMAIL PROTECTED] Sent: Thursday, April 25, 2002 2:46 PM Subject: RE: problem with max I'm looking at this right now on an InnoDB table.. Only problem is I really have no way to tell the type of what mysql is returning when I do a max(date). Since all the date functions work on strings as long as they are formatted as dates.. How are you telling which type is returned? - Johnny Withers [EMAIL PROTECTED] p. 601.853.0211 c. 601.209.4985 -Original Message- From: Jean Bernard [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 24, 2002 5:06 PM To: [EMAIL PROTECTED] Subject: problem with max i write a program using MyIsam,and i want uses Innodb. the query: select max(date_comp) as mdate from pieces on MyIsam mdate is a date. on InnoDB mdate is string. win2000 delphi6 zeosdbo it's normal? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
problem with max
i write a program using MyIsam,and i want uses Innodb. the query: select max(date_comp) as mdate from pieces on MyIsam mdate is a date. on InnoDB mdate is string. win2000 delphi6 zeosdbo it's normal? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
auto_increment and range or highest value
Hi, I'am using autoincrement field with innodb table. (Mysql 3.23.47-log on Linux ppc) Two questions 1_ how to set a range ? Is the only solution chosing betwwen tinyint, smallint, ..., bigint I over words : I want a range from 1 to 999 for example , how can I do ? 2_ What's happens when the highest value is reached I have made a try with : create table Generator (Sequence smallint(7) zerofill unique primary key not null auto_increment ) type=innodb ; insert into Generator values(null); update Generator set Sequence=LAST_INSERT_ID(Sequence+1) ; Everything works fine, ok now what happens for the highest value ? update Generator set Sequence=65535 ; select * from Generator ; +--+ | Sequence | +--+ | 0065535 | +--+ update Generator set Sequence=LAST_INSERT_ID(Sequence+1) ; select * from Generator ; +--+ | Sequence | +--+ | 0065535 | +--+ Here something doesn't work, or I probably not undestood ! Thank you for any help -- Bernard CHAMBON IN2P3 / CNRS (Centre de Calcul de LYON) Tél : 04 72 69 42 18 http://www.in2p3.fr/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
error with create table
Hi i have this error with create table (Innodb) Error: 1005 - Can't create table '.\pdx\factures.frm' (errno: 150) ? Thank's MySQL 3.23.47 win32 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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_use_result, out of sync, Mysql
Hello What do to if mysql_use_result return NULL ? I can't understand ? I have only one query by connection, of course. I talk about SELECT statement in my query (not INSERT or anything else) Mysql run on linux. From time to time mysql_use_result() return NULL. I throw and catch an exception, then I try to make another query an I got 'out of sync' As mentionned in documentation, I use mysql_free_result() (even on a NULL pointer) while cathing the exception but nothing change. I have also try another mysql_use_result(), mysql_fetch_row() and mysql_free_result() in a dummy function. (by dummy, i mean nusefull) but I still got 'out of sync' Perhaps, the solution is to close and open a new connection in such a case ?. But before that, I want to understand. Thank you for your help Regards. -- Bernard CHAMBON IN2P3 / CNRS (Centre de Calcul de LYON) Tél : 04 72 69 42 18 http://www.in2p3.fr/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
Re: Lost connection, C API
Heikki Tuuri wrote: Hi! Are you running mysqld under the safe_mysqld script, which automatically restarts mysqld after a crash? Yes, mysqld started with safe_mysqld script If yes, look at the 'hostname'.err file and send its contents to me. Nothing happens in the hostname.err (I started mysqld this morning at 11:45) 020107 11:45:08 mysqld started 020107 11:45:08 Warning: setrlimit couldn't increase number of open files to more than 1024 020107 11:45:08 Warning: Changed limits: max_connections: 512 table_cache: 251 020107 11:45:10 InnoDB: Started /opt/mysql/libexec/mysqld: ready for connections With ps ..., I confirm that mysqld processes have NOT restarted (running since 11:45) Or, if you run mysqld from the command prompt, capture what mysqld prints to the command prompt window. If mysqld does not crash, then the problem is probably some client/server issue. Regards, Heikki Has we got a network error yesterday, I have run another test this night with the following modifications : max_connect_errors=65535 skip-host-cache connection to 'localhost' (the client and the serveur run on the same machine) I have got errors like : MySQL server has gone away (12 occurences) Commands out of sync; You can't run this command now (85 occurences) Lost connection to MySQL server during query (only one occurence) The transaction overload is about : 200848 Insert 486205 Update 334945 Select for 8 hours Before restarting the 2nd test I restart mysqld (yesterday at 22:28) so here is the hotname.err --- 020107 11:45:08 mysqld started 020107 11:45:08 Warning: setrlimit couldn't increase number of open files to more than 1024 020107 11:45:08 Warning: Changed limits: max_connections: 512 table_cache: 251 020107 11:45:10 InnoDB: Started /opt/mysql/libexec/mysqld: ready for connections 020107 22:27:45 /opt/mysql/libexec/mysqld: Normal shutdown 020107 22:27:45 InnoDB: Starting shutdown... 020107 22:27:58 InnoDB: Shutdown completed 020107 22:27:58 /opt/mysql/libexec/mysqld: Shutdown Complete 020107 22:27:58 mysqld ended 020107 22:28:25 mysqld started 020107 22:28:26 Warning: setrlimit couldn't increase number of open files to more than 1024 020107 22:28:26 Warning: Changed limits: max_connections: 512 table_cache: 251 020107 22:28:27 InnoDB: Started /opt/mysql/libexec/mysqld: ready for connections Status information: Current dir: /opt/mysql/var/ Current locks: lock: 83f3ed0: lock: 8396308: lock: 8395a28: lock: 838cfa0: lock: 8390c00: lock: 838cf00: lock: 838ce60: lock: 838c588: lock: 837e8b8: lock: 837ee28: lock: 837ed90: lock: 83746e0: key_cache status: blocks used: 0 not flushed: 0 w_requests: 0 writes: 0 r_requests: 0 reads: 0 handler status: read_key: 5704 read_next:1706 read_rnd47 read_first:394 write:1447 delete 0 update:465 Table status: Opened tables: 26 Open tables: 20 Open files: 2 Open streams: 0 -- Bernard CHAMBON IN2P3 / CNRS (Centre de Calcul de LYON) Tél : 04 72 69 42 18 http://www.in2p3.fr/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
Mysql, innodb, linux problems
Hello, Hope it is a good place for the following question I use Mysql (3.23.39) and InnoDB tables on Linux (2.2.17-14smp) and I got deadlock (In suppose it is a deadlock) when I do intensive work. intensive work = one insert + one update + 2 selects (simultaneously, with 4 differents processes, on the same table) I got deadlock = My processes went down (after the timeout I had set) and if I try an interactive request on the table (like select count(*) from ... I never got the answer. If I do a 'mysqladmin processlist', I see about 10 threads of insert/update/select worst, if I do a 'mysqladmin kill ...' to kill some thread, nothing happens The only way to recover, is to kill the mysqld processes and restart mysql Thank you for your help -- Bernard CHAMBON IN2P3 / CNRS (Centre de Calcul de LYON) Tél : 04 72 69 42 18 http://www.in2p3.fr/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
error starting mysql
i have installed MySQL on W2000 my my.ini is : [mysqld] basedir=C:/MySQL #bind-address=192.168.0.1 datadir=C:/MySQL/data #language=C:/MySQL/share/your language directory #slow query log#= #tmpdir#= #port=3306 #set-variable=key_buffer=16M innodb_data_home_dir = c:/IbData innodb_data_file_path = ibdata1:200M set-variable = innodb_mirrored_log_groups=1 innodb_log_group_home_dir = c:/iblogs set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=30M set-variable = innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=1 innodb_log_arch_dir = c:/iblogs innodb_log_archive=0 set-variable = innodb_buffer_pool_size=30M set-variable = innodb_additional_mem_pool_size=10M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 when i run mysqld-max-nt --console i have the error message: InnoDB: operating system error number 5 in a file operation. InnoDB: operating system error number 5 in a file operation. InnoDB: Error in creating or opening c:\IbData\ibdata1 InnoDB: Could not open data files 011101 11:21:53 Can't init databases ??? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: error starting mysql
i log administrator i have created the directory c:\ibdata\ibdata1 same error.. Regards, Jean - Original Message - From: Heikki Tuuri [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, November 01, 2001 10:59 AM Subject: Re: error starting mysql Hi! I looked from the MS Developer Studio manual: Code Description Name 2 The system cannot find the file specified. ERROR_FILE_NOT_FOUND 3 The system cannot find the path specified. ERROR_PATH_NOT_FOUND 4 The system cannot open the file. ERROR_TOO_MANY_OPEN_FILES 5 Access is denied. ERROR_ACCESS_DENIED Maybe you should log in to your Win2000 computer as the Administrator? when i run mysqld-max-nt --consolei have the error message: InnoDB: operating system error number 5 in a file operation. InnoDB: operating system error number 5 in a file operation. InnoDB: Error in creating or opening c:\IbData\ibdata1 InnoDB: Could not open data files011101 11:21:53 Can't init databases Regards, Heikki http://www.innodb.com/ibman.html - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
INNOBASE, autocommit = 0, and C API ( mysql_real_query )
Hello, I am using Innobase with MySql version 3.23.39 under Linux and want to run WITHOUT autocommit mode (= autocommit=0 for using commit/roolback instructions) I have made a test whith 2 INTERACTIVE MySql sessions and this works fine. BUT, when I use the C API (mysql_real_query), it DOESN't work. I mean the autocommit=0 is NOT taken in account //-- My C code looks like : // set autocommit = 0 mysql_real_query(connection, set autocommit = 0, the_length ); // begin mysql_real_query(connection, begin, the_length ); // insert mysql_real_query(connection, insert into , the_length ); // NO commit is DONE, for test purpose //- END of My C code When I check the table, in an interaction session, my insertion is available! I mean a request like 'select... ' show the NEW insertion ! Why ? NO commit has been DONE! I have made several other try, like reading a config file (and a 'set-variable = autocommit=0' in it) But the probleme doesn't change Furthermore,the server has a global transaction-isolation option set to serializable. We tried to force the autocommit=0 through an init-file. The problem is still there ! The autocommit option seems to be an session command. Is there any way to set it for the whole server ? Thank you for your help Sincerely. -- Bernard CHAMBON IN2P3 / CNRS (Centre de Calcul de LYON) Tél : 04 72 69 42 18 http://www.in2p3.fr/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
limits to volume handled by MySQL
Hi there We are switching to a MySQL 3.23.38 on a PIII 933 MHz machine running with a FreeBSD and a web Apache server 1.3.19 . The hosting company has just argued MySQL cannot handle more than 1Go in database files opened per session. Is it true ? If so how to go over that 1Go limit ? ( :-) yes i know scratch the project .. seriously ?) Cheers Bernard Clist Bernard-Olivier Clist Administrateur du site Internet de l'OGE Site Web : http://www.geometre-expert.fr/ Mél : [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
Segmentation fault with mysql_install_db
Hello I am trying to install the lastest version of mysql on Linux (Suse, uname -r = 2.2.14), without success. I have downloaded both the 3.23.38 and 3.23.40 binary tar balls, they crash the same way (I have tried on several machines with the same configuration, and got the same result): ./scripts/mysql_install_db Installing all prepared tables ./scripts/mysql_install_db: line 1: 2821 Segmentation fault ./bin/mysqld --bootstrap --skip-grant-tables --basedir=. --datadir=./data --skip-innodb --skip-gemini --skip-bdb Installation of grant tables failed! A 3.22 version of mysql runs fine on these machines. Also, I tried to copy the whole data directory from my 3.22 version to the new 3.23, and I have been able to launch safe_mysqld, but it crashed a bit later with segmentation fault. I have noticed several people having the same kind of problem (for example: http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:67632) but could not get any solution. I hope one of you will able to give me a clue... Thanks a lot in advance! Bernard - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php