Re: there is no mysql/var directory
take a look at /var/mysql :) - Original Message - From: "Philip Mak" [EMAIL PROTECTED] To: "feldekis" [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, April 18, 2001 11:59 PM Subject: Re: there is no mysql/var directory On Wed, 18 Apr 2001, feldekis wrote: Hi everybody!! I've got a pb during the installation of the binary of mysql-3.22.32 (the same for 3.23.36 version): there is no mysql/var directory, so when i write: chown -R mysql /usr/local/mysql/var that doesn't work. And it's exactly the same for mysql/bin. So PLEASE!!! if someone can help me Thanks in advance Find the correct path for the mysql directory. I think it might be in /usr/bin/*mysql* and /var/lib/mysql. Try typing locate mysql, or find /usr -name "*mysql*" Then chown those files. -Philip Mak ([EMAIL PROTECTED]) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: root password
On Thu, 19 Apr 2001, feldekis wrote: ./bin/mysql -p -user=root Enter password: password ERROR 1045: Access denied for user: 'ser=root@localhost' (Using password: YES) ^ mysql -p -u root, not mysql -p -user=root pz -- Bartosz Sienkiewicz - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 restarting mysqld !!
Hello everyone! This is the first time I post here, so please bear with me. It all started when I deleted a whole table by mistake. So I try to recovered it by copying yesterday's backup. I had never done that before and it all worked wrong. I found out MySQL server had to be restarted in order to changes take effect. I kill mysqld daemon with a 'kill PID', but I didn't know how to restart it .I tried with a 'mysqld' but as soon as I close the Terminal Window, mysqld died. Then I tried with 'mysqld ' and it crashed after a while. Finally I found this nice little script below, I executed it but due to my ignorance I don't if what I did is right. Everything seems to be ok right now but I'm not sure if it's gonna crash in a while. Could you please take a look at it and tell me what you think. Thanks in advance Regards MySQL version: 3.22.32 OS: FreeBSD 4.2 *** Beginning of safe_mysqld #!/bin/sh # Copyright Abandoned 1996 TCX DataKonsult AB Monty Program KB Detron HB # This file is public domain and comes with NO WARRANTY of any kind # # scripts to start the MySQL daemon and restart it if it dies unexpectedly # # This should be executed in the MySQL base directory if you are using a # binary installation that has other paths than you are using. # # mysql.server works by first doing a cd to the base directory and from there # executing safe_mysqld trap '' 1 2 3 15 # we shouldn't let anyone kill us # Check if we are starting this relative (for the binary release) if test -d ./data/mysql -a -f ./share/mysql/english/errmsg.sys -a \ -x ./bin/mysqld then MY_BASEDIR_VERSION=`pwd` # Where bin, share and data are DATADIR=$MY_BASEDIR_VERSION/data # Where the databases are ledir=$MY_BASEDIR_VERSION/bin # Where mysqld is # Check if this is a 'moved install directory' elif test -f ./var/mysql/db.frm -a -f ./share/mysql/english/errmsg.sys -a \ -x ./libexec/mysqld then MY_BASEDIR_VERSION=`pwd` # Where libexec, share and var are DATADIR=$MY_BASEDIR_VERSION/var # Where the databases are ledir=$MY_BASEDIR_VERSION/libexec # Where mysqld is else MY_BASEDIR_VERSION=/usr/home/notodo/usr/local/mysql DATADIR=/usr/home/notodo/usr/local/mysql/var ledir=/usr/local/bin/ if test ! -x $ledir/mysqld then echo "The file $ledir/mysqld doesn't exist or is not executable" echo "Please do a cd to the mysql installation directory and restart" echo "this script from there as follows:" echo "./bin/safe_mysqld". exit 1; fi fi pid_file=$DATADIR/`/bin/hostname`.pid log=$DATADIR/`/bin/hostname`.log err_log=$DATADIR/`/bin/hostname`.err # Parse arguments to see if caller wants the pid_file somewhere else. for arg do case $arg in --pid-file=*) pid_file=`echo "$arg" | sed -e "s;--pid-file=;;"` ;; --datadir=*) DATADIR=`echo "$arg" | sed -e "s;--datadir=;;"` ;; esac done # # If there exists an old pid file, check if the daemon is already running # Note: The switches to 'ps' may depend on your operating system if test -f $pid_file then PID=`cat $pid_file` if /bin/kill -0 $PID then if /bin/ps p $PID | grep mysqld /dev/null then# The pid contains a mysqld process echo "A mysqld process already exists" echo "A mysqld process already exists at " `date` $err_log exit 1; fi fi rm -f $pid_file if test -f $pid_file then echo "Fatal error: Can't remove the pid file: $pid_file" echo "Fatal error: Can't remove the pid file: $pid_file at " `date` $err_log echo "Please remove it manually and start $0 again" echo "mysqld daemon not started" exit 1; fi fi # # Uncomment the following lines if you want all tables to be automaticly # checked and repaired at start # # echo "Checking tables in $DATADIR" # isamchk --silent --force $DATADIR/*.ISM echo "Starting mysqld daemon with databases from $DATADIR" #Default communication ports #MYSQL_TCP_PORT=3306 if test -z "$MYSQL_UNIX_PORT" then MYSQL_UNIX_PORT="/tmp/mysql.sock" export MYSQL_UNIX_PORT fi #export MYSQL_TCP_PORT # Does this work on all systems? #if type ulimit | grep "shell builtin" /dev/null #then # ulimit -n 256 /dev/null 21 # Fix for BSD and FreeBSD systems #fi echo "mysqld started on " `date` $err_log while true do rm -f $MYSQL_UNIX_PORT $pid_file # Some extra safety if test "$#" -eq 0 then nohup $ledir/mysqld --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR \ $err_log 21 else nohup $ledir/mysqld --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR \ "$@" $err_log 21 fi if test ! -f $pid_file # This is removed if normal shutdown then break; fi if false then # Test if one process was hanging. # This is only a fix for Linux (running as base 3 mysqld processes) # but should work for the rest of the servers. # The only thing is ps x = redhat 5 gives warnings when using ps -x. # kill -9 is used or
Re: Plase Let us know if there is a Racialism for Mysql product and quit
- Original Message - From: John Dean [EMAIL PROTECTED] To: Yusuf Incekara [EMAIL PROTECTED] Sent: Wednesday, April 18, 2001 10:39 PM Subject: Re: Plase Let us know if there is a Racialism for Mysql product and quit At 18:50 18/04/2001 +0300, you wrote: You said : Only those who don't read English too good. Being a native English speaker it is very clear to me. Correct and it is obvious to me that your English is very poor It is your humble opinion. I don't care. Could you please be more open and honest? I could not be more open or honest than what I said above. But just in case you don't understand I will say it again. Your English is poor It is your humble opinion. I don't care also. The problem is not in reading and understanding in English. Problem is in your mind. Let me try to explain. Question is about being open and honest. That means if you have an opinion you can easily defend this opinion in everywhere. And have to tell this in every platform as your opinion. If theese opinions are rude so you are rude. But this is you are. Act what you are and what you seems like. But don't try to hide them and don't act in different platform in different ways. It is obviously seen that i can easily read and write in English. Only you think so But if you disturbed that one Turk found your bug please let me know and quit . Personally I could not care less from which country you come from Let all your customers become from Mansfield, England, UK. Look what you said above. That sentence does not make sense. What do you mean, "Let all your customers become from Mansfield " You are not even a customer you are just an upset user who can not take the truth Well the truth is situation is not about my English or not about me to pay license fee. The problem is about you are harding to accept you fault. So i solved my problem. And just don't want others users to have same problem. That's all. I am not insisting that my English is perfect. But be sure that it is not necessary that being a native English speaker. I said that no matter but you are looking for a trouble ... Only you say that because you must have some kind of persecution complex or inferiority complex Well it must be a complex of yours and i think it can be named insufficient understanding complex , harding to accepting you fault complex , (thinking) faultless complex , individuality complex etc... If you read carefully followed instructions ( by using your perfect native English ) you 'll see the differences between Windows directory and System Directory. I am perfectly aware of the difference but it is obvious you don't what is meant by what is written in the manual. Windows-system-directory does not equal windows\system. The give away are the hyphens i.e '-' between the words windows, system and directory. Note it does not contain any backslashes i.e. '\' well it is more obvious that Windows-system-directory is not equal Windows directory. Any Windows programmer - as well as noticed in Microsoft References- knows that Windows Directory is a c:\Win95 or c:\WinNT and System Directory or Windows System Directory is a c:\Win95\System or c:\WinNT\System32 (or c:\WinNT\System or whatever). And this situation becomes more personal. That'y why i won't reply any mail. I hope this will be the last... If still there is some issues that your perfect English mind can not understand please mail me. I have no the consult you whatever on any issue concerning Windows or the Windows API If you say still i am native English. No one can knows better then me even Microsoft so there is nothing to say. I think you need to return to school since it is obvious you were not taught manners and while you are there perhaps you improve your poor Engliah Well i can easily understand what i read in English by using my poor English. But it is hard you to be success in your life with your poor personality. You should better go to a psychiatrist. If you undertand your mistake and wanna apologize please forget it. This I would never do especially to somebody as bad mannered as you Regards. Yusuf Incekara Avukatpro Limited Sirketi Izmit/Turkey (sorry for not being a native English but smart) No you not naive English nor are you smart Thanks god for not to be a native English (if they are all like you) and thanks also giving us a gift that does not exist on them ? (you will hard to understand this . answer : brain) What do Ineed this for. I have the complete API reference in hardcopy. Perhap you would do well to read it. That way you would not make such a fool of yourself GetSystemDirectory Reference : Microsoft Web site : http://msdn.microsoft.com/library/psdk/sysmgmt/sysinfo_1unt.htm The GetSystemDirectory function retrieves the path of the system directory. The system directory contains such files as dynamic-link libraries, drivers, and font files. UINT
Re: Help restarting mysqld !!
on my linux boxes this is: /etc/rc.d/init.d/mysql stop | start - Original Message - From: "Martin Cabrera Diaubalick" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, April 19, 2001 9:42 AM Subject: Help restarting mysqld !! Hello everyone! This is the first time I post here, so please bear with me. It all started when I deleted a whole table by mistake. So I try to recovered it by copying yesterday's backup. I had never done that before and it all worked wrong. I found out MySQL server had to be restarted in order to changes take effect. I kill mysqld daemon with a 'kill PID', but I didn't know how to restart it .I tried with a 'mysqld' but as soon as I close the Terminal Window, mysqld died. Then I tried with 'mysqld ' and it crashed after a while. Finally I found this nice little script below, I executed it but due to my ignorance I don't if what I did is right. Everything seems to be ok right now but I'm not sure if it's gonna crash in a while. Could you please take a look at it and tell me what you think. Thanks in advance Regards MySQL version: 3.22.32 OS: FreeBSD 4.2 *** Beginning of safe_mysqld #!/bin/sh # Copyright Abandoned 1996 TCX DataKonsult AB Monty Program KB Detron HB # This file is public domain and comes with NO WARRANTY of any kind # # scripts to start the MySQL daemon and restart it if it dies unexpectedly # # This should be executed in the MySQL base directory if you are using a # binary installation that has other paths than you are using. # # mysql.server works by first doing a cd to the base directory and from there # executing safe_mysqld trap '' 1 2 3 15 # we shouldn't let anyone kill us # Check if we are starting this relative (for the binary release) if test -d ./data/mysql -a -f ./share/mysql/english/errmsg.sys -a \ -x ./bin/mysqld then MY_BASEDIR_VERSION=`pwd` # Where bin, share and data are DATADIR=$MY_BASEDIR_VERSION/data # Where the databases are ledir=$MY_BASEDIR_VERSION/bin # Where mysqld is # Check if this is a 'moved install directory' elif test -f ./var/mysql/db.frm -a -f ./share/mysql/english/errmsg.sys -a \ -x ./libexec/mysqld then MY_BASEDIR_VERSION=`pwd` # Where libexec, share and var are DATADIR=$MY_BASEDIR_VERSION/var # Where the databases are ledir=$MY_BASEDIR_VERSION/libexec # Where mysqld is else MY_BASEDIR_VERSION=/usr/home/notodo/usr/local/mysql DATADIR=/usr/home/notodo/usr/local/mysql/var ledir=/usr/local/bin/ if test ! -x $ledir/mysqld then echo "The file $ledir/mysqld doesn't exist or is not executable" echo "Please do a cd to the mysql installation directory and restart" echo "this script from there as follows:" echo "./bin/safe_mysqld". exit 1; fi fi pid_file=$DATADIR/`/bin/hostname`.pid log=$DATADIR/`/bin/hostname`.log err_log=$DATADIR/`/bin/hostname`.err # Parse arguments to see if caller wants the pid_file somewhere else. for arg do case $arg in --pid-file=*) pid_file=`echo "$arg" | sed -e "s;--pid-file=;;"` ;; --datadir=*) DATADIR=`echo "$arg" | sed -e "s;--datadir=;;"` ;; esac done # # If there exists an old pid file, check if the daemon is already running # Note: The switches to 'ps' may depend on your operating system if test -f $pid_file then PID=`cat $pid_file` if /bin/kill -0 $PID then if /bin/ps p $PID | grep mysqld /dev/null then# The pid contains a mysqld process echo "A mysqld process already exists" echo "A mysqld process already exists at " `date` $err_log exit 1; fi fi rm -f $pid_file if test -f $pid_file then echo "Fatal error: Can't remove the pid file: $pid_file" echo "Fatal error: Can't remove the pid file: $pid_file at " `date` $err_log echo "Please remove it manually and start $0 again" echo "mysqld daemon not started" exit 1; fi fi # # Uncomment the following lines if you want all tables to be automaticly # checked and repaired at start # # echo "Checking tables in $DATADIR" # isamchk --silent --force $DATADIR/*.ISM echo "Starting mysqld daemon with databases from $DATADIR" #Default communication ports #MYSQL_TCP_PORT=3306 if test -z "$MYSQL_UNIX_PORT" then MYSQL_UNIX_PORT="/tmp/mysql.sock" export MYSQL_UNIX_PORT fi #export MYSQL_TCP_PORT # Does this work on all systems? #if type ulimit | grep "shell builtin" /dev/null #then # ulimit -n 256 /dev/null 21 # Fix for BSD and FreeBSD systems #fi echo "mysqld started on " `date` $err_log while true do rm -f $MYSQL_UNIX_PORT $pid_file # Some extra safety if test "$#" -eq 0 then nohup $ledir/mysqld --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR \ $err_log 21 else nohup $ledir/mysqld --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR \ "$@"
[Fwd: Replication non working with Innobase]
Hi, I'm using two Mysql 3.23.36 with Innobase tables on two machines running Redhat 7.0. I'm trying to use replication in a simple master/slave configuration, but while it works when I use MyIsam tables, if one of the two machines tries to use Innobase tables the replication doesn't work, both when they are configured to do it manually and when I manually start the slave and launch load table news from master; in this last case after some seconds the slave complains of a network error (although the master is alive and configured properly). Follows an excerpt from the log of the master, ?func: general: Host: www2.MIOSITO.it ip: 193.207.81.207 vio_keepalive: enter: sd=9, set_keep_alive=1 vio_is_blocking: exit: 0 vio_write: enter: sd=9, buf=0x82afad0, size=54*** HERE IT WRITES SUCCESSFULLY 54 BYTES ON SOCKET 9 vio_write: exit: 54 vio_is_blocking: exit: 0 vio_read: enter: sd=9, buf=0x82afad0, size=4 *HERE IT CAN'T READ 4 BYTES FROM THE SAME SOCKET vio_read: error: Got error 11 during read -1, 4294967295 vio_read: exit: -1 ?func: info: vio_read returned -1, errno: 11 thr_alarm: enter: thread: T@2051 sec: 5 thr_alarm: info: reschedule vio_is_blocking: exit: 0 So it seems the socket has been closed (maybe by the slave?). Does anyone have any suggestion? I'd also like to know if someone has Innobase replicating correctly, and if so what versions of c++ and libstdc++ he/she is using, I don't know if gcc is preferrable to egcs-g++. Thanks very much Nico - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
About Column's name Query!..
Please help me.! I want to Query column name to a string, But i don't know command that i should to use. Reguards. Mongkol - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Plase Let us know if there is a Racialism for Mysql product and quit
Yusuf, i don't understand why you are so angry and are trying to fight it out on this list. 1. Loads of computer-related things are vulnerable for different explanations. especially with software that is easily ported between platforms, it's also easy to have a manual that is not dedicated for one platform and thus now and then one makes mistakes in interpration. There will be thousands of other things to discuss about, but there is never reason to get angry 2. All people joining this list are volunteers. They answer just what they think, and i never discovered somebody being not honest. Maybe somebody is wrong, but we all make mistakes. Every sentence said is the author's personal knowledge and/or opinion. 3. Nobody ever blamed you for not being native english. Only thing said was: read carefully, and if it's not working, think twice about what's being said. 4. I'd love it if all software was that well documented as mysql, and that easy-to-use Last but not least: i hope you have a nice time programming and researching, which looks like a better thing to do for me than wasting your time blaming people for things nobody really did wrong. Let's discuss things technically, ok? regards, rene - Original Message - From: "Yusuf Incekara" [EMAIL PROTECTED] To: "John Dean" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, April 19, 2001 9:49 AM Subject: Re: Plase Let us know if there is a Racialism for Mysql product and quit - Original Message - From: John Dean [EMAIL PROTECTED] To: Yusuf Incekara [EMAIL PROTECTED] Sent: Wednesday, April 18, 2001 10:39 PM Subject: Re: Plase Let us know if there is a Racialism for Mysql product and quit At 18:50 18/04/2001 +0300, you wrote: You said : Only those who don't read English too good. Being a native English speaker it is very clear to me. Correct and it is obvious to me that your English is very poor It is your humble opinion. I don't care. Could you please be more open and honest? I could not be more open or honest than what I said above. But just in case you don't understand I will say it again. Your English is poor It is your humble opinion. I don't care also. The problem is not in reading and understanding in English. Problem is in your mind. Let me try to explain. Question is about being open and honest. That means if you have an opinion you can easily defend this opinion in everywhere. And have to tell this in every platform as your opinion. If theese opinions are rude so you are rude. But this is you are. Act what you are and what you seems like. But don't try to hide them and don't act in different platform in different ways. It is obviously seen that i can easily read and write in English. Only you think so But if you disturbed that one Turk found your bug please let me know and quit . Personally I could not care less from which country you come from Let all your customers become from Mansfield, England, UK. Look what you said above. That sentence does not make sense. What do you mean, "Let all your customers become from Mansfield " You are not even a customer you are just an upset user who can not take the truth Well the truth is situation is not about my English or not about me to pay license fee. The problem is about you are harding to accept you fault. So i solved my problem. And just don't want others users to have same problem. That's all. I am not insisting that my English is perfect. But be sure that it is not necessary that being a native English speaker. I said that no matter but you are looking for a trouble ... Only you say that because you must have some kind of persecution complex or inferiority complex Well it must be a complex of yours and i think it can be named insufficient understanding complex , harding to accepting you fault complex , (thinking) faultless complex , individuality complex etc... If you read carefully followed instructions ( by using your perfect native English ) you 'll see the differences between Windows directory and System Directory. I am perfectly aware of the difference but it is obvious you don't what is meant by what is written in the manual. Windows-system-directory does not equal windows\system. The give away are the hyphens i.e '-' between the words windows, system and directory. Note it does not contain any backslashes i.e. '\' well it is more obvious that Windows-system-directory is not equal Windows directory. Any Windows programmer - as well as noticed in Microsoft References- knows that Windows Directory is a c:\Win95 or c:\WinNT and System Directory or Windows System Directory is a c:\Win95\System or c:\WinNT\System32 (or c:\WinNT\System or whatever). And this situation becomes more personal. That'y why i won't reply any mail. I hope this will be the last... If still there is some issues that your perfect English mind can not
Can't create a new thread (errno 12).
After some hour my Database return this error message: Warning: MySQL Connection Failed: Can't create a new thread (errno 12). If you are not out of available memory, you can consult the manual for a possible OS-dependent bug in conn.php3 on line 7 At conn.php3 on line 7 there is connection command to DB. MySQL installed on server is server info:3.23.32-debug client info 3.23.22-beta What can I do for it? Thanks all
Re: Please assist me?
Are there any suitable training materials on your website? In particular, how can I best use the GUIs in WinMySQLAdmin? Try a few of the websites already mentioned in other postings.. I think www.devshed.com is a nice place to start.. But you can find plenty others in the manual.txt found in the sourcedir.. If you want ot use MySQL I can also recommend the book MySQL written by Paul DuBois.. Have fun.. B. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Ynt: Plase Let us know if there is a Racialism for Mysql product and quit
Dear Ren , First of all i apologize from all mysql list and all mysql team (except one :) ) I think this is a virtue that realizing when to stop and when to apologize. your product and your documentation works fine and i am not directly blaming anyone related to this product. The problem is not in documentation nor in product. well like i said in my last mail this situation is become too personal between two person. That's why i am stoping to write about this subject. you 're 100% right in your mail and again sorry for wasted time for all list members. Regards. Yusuf Incekara - Original Message - From: Ren Tegel [EMAIL PROTECTED] To: Yusuf Incekara [EMAIL PROTECTED]; John Dean [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, April 19, 2001 11:18 AM Subject: Re: Plase Let us know if there is a Racialism for Mysql product and quit Yusuf, i don't understand why you are so angry and are trying to fight it out on this list. 1. Loads of computer-related things are vulnerable for different explanations. especially with software that is easily ported between platforms, it's also easy to have a manual that is not dedicated for one platform and thus now and then one makes mistakes in interpration. There will be thousands of other things to discuss about, but there is never reason to get angry 2. All people joining this list are volunteers. They answer just what they think, and i never discovered somebody being not honest. Maybe somebody is wrong, but we all make mistakes. Every sentence said is the author's personal knowledge and/or opinion. 3. Nobody ever blamed you for not being native english. Only thing said was: read carefully, and if it's not working, think twice about what's being said. 4. I'd love it if all software was that well documented as mysql, and that easy-to-use Last but not least: i hope you have a nice time programming and researching, which looks like a better thing to do for me than wasting your time blaming people for things nobody really did wrong. Let's discuss things technically, ok? regards, rene - Original Message - From: "Yusuf Incekara" [EMAIL PROTECTED] To: "John Dean" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, April 19, 2001 9:49 AM Subject: Re: Plase Let us know if there is a Racialism for Mysql product and quit - Original Message - From: John Dean [EMAIL PROTECTED] To: Yusuf Incekara [EMAIL PROTECTED] Sent: Wednesday, April 18, 2001 10:39 PM Subject: Re: Plase Let us know if there is a Racialism for Mysql product and quit At 18:50 18/04/2001 +0300, you wrote: You said : Only those who don't read English too good. Being a native English speaker it is very clear to me. Correct and it is obvious to me that your English is very poor It is your humble opinion. I don't care. Could you please be more open and honest? I could not be more open or honest than what I said above. But just in case you don't understand I will say it again. Your English is poor It is your humble opinion. I don't care also. The problem is not in reading and understanding in English. Problem is in your mind. Let me try to explain. Question is about being open and honest. That means if you have an opinion you can easily defend this opinion in everywhere. And have to tell this in every platform as your opinion. If theese opinions are rude so you are rude. But this is you are. Act what you are and what you seems like. But don't try to hide them and don't act in different platform in different ways. It is obviously seen that i can easily read and write in English. Only you think so But if you disturbed that one Turk found your bug please let me know and quit . Personally I could not care less from which country you come from Let all your customers become from Mansfield, England, UK. Look what you said above. That sentence does not make sense. What do you mean, "Let all your customers become from Mansfield " You are not even a customer you are just an upset user who can not take the truth Well the truth is situation is not about my English or not about me to pay license fee. The problem is about you are harding to accept you fault. So i solved my problem. And just don't want others users to have same problem. That's all. I am not insisting that my English is perfect. But be sure that it is not necessary that being a native English speaker. I said that no matter but you are looking for a trouble ... Only you say that because you must have some kind of persecution complex or inferiority complex Well it must be a complex of yours and i think it can be named insufficient understanding complex , harding to accepting you fault complex , (thinking) faultless complex , individuality complex etc... If you read carefully followed
Newbie frequency question
Hi, I have a list of words entered into a search engine held in a database. I wish to be able to select the top 10 words held in the database. I've fiddled around with ORDER DESC, DISTINCT and LIMIT etc but I can't hit upon the SQL syntax to obtain the correct result. Can someone please shine a light on my dim brain? The words are held in the dtaabase column 'word'. I'm having a really 'dumb' day today :-( Thanks, Graham - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 me SQL 7.0
According to crash me the function randomization 'RAND' is supported by SQL 7.0 AND MYSQL. i AM USING SQL 7.0 and when i test the SQL the results are returned in the same order everytime. It seems that 'Rand' is recognized, but it isn't executed. Anybody else had this problem? Paul _ Get your FREE download of MSN Explorer at http://explorer.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Newbie frequency question
select word, count(word) as c from tablename group by word order by c desc On Thu, 19 Apr 2001, Graham Nichols wrote: Hi, I have a list of words entered into a search engine held in a database. I wish to be able to select the top 10 words held in the database. I've fiddled around with ORDER DESC, DISTINCT and LIMIT etc but I can't hit upon the SQL syntax to obtain the correct result. Can someone please shine a light on my dim brain? The words are held in the dtaabase column 'word'. I'm having a really 'dumb' day today :-( Thanks, Graham - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- --- Peter Skipworth Perl Developer/Unix Systems Administrator [EMAIL PROTECTED] +44 795 055 0029 --- 4c 61 20 6c 6f 79 52 75 62 20 73 41 20 65 52 61 20 45 65 62 4f 4c 47 6e 74 20 20 4f 53 75 00 0a - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: set column's default to a function
Hello, I have a rather easy question, but for some reason I can't figure it out. What I want is a column that will indicate when the record was added, but not when it was modified. I know a timestamp column will do the first half of the trick, but not the other half. The prefect solution would be to set the default of a datetime column to whatever NOW() returns, but that doesn't seem to work as when I try to set the default, it changes the string 'NOW()' to '-00-00 00:00:00'. Is it possible to set the column's default to a function ? A dirty solution would be to create 2 timestamp columns, so only the first one would get updated when the record gets modified, but I didn't get a chance to try that. Any thoughts, comments ? Thanks in advance Pawel P.S. just to make the filter happy: database,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
Newbie frequency question
Hi, I have a list of words entered into a search engine held in a database. I wish to be able to select the top 10 words held in the database. I've fiddled around with ORDER DESC, DISTINCT and LIMIT etc but I can't hit upon the SQL syntax to obtain the correct result. Can someone please shine a light on my dim brain? The words are held in the dtaabase column 'word'. I'm having a really 'dumb' day today :-( Thanks, Graham - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Corrupt tables after long queries (fwd)
Peter Skipworth writes: Hi all, Has anyone experienced anything like the following ? I have several queries which, admittedly, are quite complex and operate on several million rows of indexed data. The tables are naturally locked while the query occurs, which is fine, but what is *not* fine is that occasionally, completely unrelated tables end up needing a repair after the long query has completed. The only pattern I can see is that towards the end of the query, I see a hell of a lot of "Opening table" "Closing table" status messages in the processlist - as soon as I see this, I can assume that the mentioned tables will have become corrupted - see a sample processlist below. Any ideas ? Cheers, P 164804 | hot | localhost | hot | Query | 6| closing tables | select * from tbl_hotclients limit 0 | | 164805 | hot | localhost | hot | Query | 6| closing tables | select * from tbl_hotclients limit 0 | | 164808 | hot | localhost | hot | Query | 14 | closing tables | select job_id from tbl_job_events where session='98760270421222662058432' and event_type='view' and | | 164809 | hot | localhost | hot | Query | 14 | closing tables | select tbl_jobs.refresh_date, tbl_jobs.job_id, tbl_jobs.title, tbl_jobs.region_id, tbl_jobs.hl_regio | | 164811 | hot | localhost | hot | Query | 5| Opening tables | select * from tbl_homepage_crazyjobs limit 0 | | 164823 | hot | localhost | hot | Query | 12 | closing tables | select * from tbl_hours where job_hours_id = 7 | | 164824 | hot | localhost | hot | Query | 6| closing tables | select * from tbl_banner_server limit 0 | | 164825 | hot | localhost | hot | Query | 54 | Locked | insert into tbl_webevents_temp (processtime,event_time,cookie,parent,referer,duration,newuser,a,job_ | | 164832 | hot | localhost | hot | Query | 10 | closing tables | select * from tbl_applications limit 0 | | 164833 | hot | localhost | hot | Query | 5| Opening tables | select * from tbl_applications limit 0 | | 164834 | hot | localhost | hot | Query | 6| closing tables | select * from tbl_applications limit 0 | | 164841 | hot | localhost | hot | Query | 10 | closing tables | select * from tbl_application_emails limit 0 | | 164842 | hot | localhost | hot | Query | 5| Opening table | insert into tbl_job_events (job_id, session, event_type, user_type, recorded, event_time, uni_id) va | --- Peter Skipworth Perl Developer/Unix Systems Administrator [EMAIL PROTECTED] +44 795 055 0029 --- 4c 61 20 6c 6f 79 52 75 62 20 73 41 20 65 52 61 20 45 65 62 4f 4c 47 6e 74 20 20 4f 53 75 00 0a Hi! What we need is a repeatable test case, i.e. a set of tables and script that will always lead to table corruption. If you can come up with such a test case, forward it to [EMAIL PROTECTED] Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: sql_create_basic_N questions
Steve Newell writes: NOTE: I have cross-posted this to the plusplus mailing list as well. I am using sql_create_basic_N to generate structures that mirror my database tables. The problem I have is that some of the fields in my database are "blobs" that need to be escaped before insertion. Questions: 1. I am using a string to represent the data in the structure: sql_create_basic_2(StoryBody, 0, 0, INT32, StoryID, string, Body);// this is actually a blob Is there a better data structure for this? 2. The data that I am trying to store has nulls scattered throughout. When I create the insert string using the following code, it only puts in the data up to the first null. That's a side effect of the string, so I have tried escaping the string before I create the insert statement. That doesn't seem to work either. Apparently, MySql is ignoring the escaped characters. StoryBodysb; sb.StoryID = -1; string tmpS(blobSize, blob); sb.Body = tmpS; escape_string(sb.Body); Query q = m_dbconn-query(); stringstream strbuf; try { string tmpQS = "INSERT INTO STORYBODY (Body) VALUES('"; strbuf "INSERT INTO STORYBODY (Body) VALUES(" quote sb.Body ")"; q.exec(strbuf.str()); } catch(BadQuery e) { // handle error here } Any help would be greatly appreciated. Thanks, Steve Hi! No you should use sql_create_3. Please take a look at custum1.cc and custom3.cc examples. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
help MySQL
Hi, I have my data in MySQL DB on a Linux machine. And I want to load same data on a Windows 2000 server. On Linux I can easily do it using mysqldump and mysqlimport commands but on widows I am unable to load data (which I dumped from Linux in a .txt file) I tried LOAD DATA and mysqlimport commands for the same. But no success. Please help as its a bit urgent. Thanks, Anvita. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ODBC$B@\B3$GFCDj$NJ8;z$,(B$BF~NO$G$-$J$$(B
$B$3$s$K$A$O!"5W$7?6$j$NEj9F$H$J$j$^$9!#$?$1$&$A$G$9!#(B Access97 $B$G:n$C$?L>Jm%G!<%?$r!"(BMySQL $B>e$X%(%/%9%]!<%H$7$?$N$G$9$,(B $B!Vy`!W!V|b!W$NFCDjJ8;z$,F~NO$G$-$J$$LdBj$,H/@8$7$^$7$?!#(B $B$3$l$i$NJ8;z$O(B Linux $B$N%?!<%_%J%k>e$G$bF~NOIT2D$@$C$?$N$G!"$b$7$+(B $B$7$?$i(B EUC$B>e!J%U%)%s%H!)!K$KB8:_$7$J$$$N$G$7$g$&$+!)(B $B0J2<$N9=@.$G(B ODBC $B@\B3$7$F$$$^$9!#(B $B%5!<%P!'(BLinux MySQL(3.23.31) EUC $B%/%i%$%"%s%H!'(BWindows Access97(EUC$BHG(BODBC 2.50.29-jp) -- [EMAIL PROTECTED] $B$?$1$&$A(B - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 MySQL
pl reply at [EMAIL PROTECTED] Hi, I have my data in MySQL DB on a Linux machine. And I want to load same data on a Windows 2000 server. On Linux I can easily do it using mysqldump and mysqlimport commands but on widows I am unable to load data (which I dumped from Linux in a .txt file) I tried LOAD DATA and mysqlimport commands for the same. But no success. Please help as its a bit urgent. Thanks, Anvita. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ODBC$B@\B3$GFCDj$NJ8;z$,(B$BF~NO$G$-$J$$(B
$B$3$l$O1Q8l$N(BML$B$G$9!#F|K\8l$N(BML$B$r;H$C$F2$5$$!#!J$9$_$^$;$s$,!"F|K\8l$N(BMySQL$B$N(BML $B$O$I$3$K$"$k$N$,J,$j$^$;$s!#!K(B (This is an English mailing list. Please use a Japanese mailing list. Sorry, but I don't know where a Japanese MySQL mailing list is.) -Philip Mak ([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: assistance required
Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: database,sql,query If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. You have written the following: Hello, I am trying to download MYODBC and it give me the following error = message An error occurred while copying C:\windows\system\mfc30.dll. Restart windows and try installing again (before running any application that use ODBC I have restarted the pc and still get the same answer, can you help please Kind Regards Alan Alan Moughty Compaq Computer Europe, Middle East Africa Business Planning Support HQ Global Business Systems/ Baseline, SAP COE ReportingTel.: +49 / = 89 / 9392-2522 Support Mailbox:Support, TOPS (EMEA) (workdays 08.30 - 18.00hrs) Support Webpage:http://emea-inline.eur.compaq.com/im/tops/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: ODBC????
(Is this any help?)(sql) Hello, I become a contribution of doing it shake it for a long time. For the list of names data that I made with Access ninety-seven, I did fGfNfXf|[fg on MySQL " ?" " ?" A problem that a specific character can't input occurred. As it is non-possible, for these characters input on a terminal of Linux also ( ftfHf"fg ? if I did on EUC ) may you not exist ? I do ODBC connection with the following configuration. Server : Linux MySQL ( 3.23.31 ) EUC Client : Windows Access 97 ( EUC version ODBC 2.50.29 - jp ) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: An other little question
Try mysql -u root -p mysql feldekis wrote: Hi again... mysql daemon is running... i've wrote 1 time: /my/path/mysql/bin/mysqladmin -u root password 'new-password' nothing happened... after that, i've tried: mysql -p user=root mysql here it answers: ERROR 1045: Access denied for user: 'ser=root@localhost' (Using password: YES) If someone can help me Thanks very much Phelles - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
PROBLEMS UNDERSTANDING FLOAT/DOUBLE COLUMN TYPES
PROBLEMS UNDERSTANDING FLOAT/DOUBLE COLUMN TYPES First could you clarify the contradictions from the following extracts of the manual. 7.3 Column types The column types supported by MySQL are listed below. The following code letters are used in the descriptions: M Indicates the maximum display size. The maximum legal display size is 255. D Applies to floating-point types and indicates the number of digits following the decimal point. The maximum possible value is 30, but should be no greater than M-2. Square brackets (`[' and `]') indicate parts of type specifiers that are optional. Note that if you specify ZEROFILL for a column, MySQL will automatically add the UNSIGNED attribute to the column. FLOAT[(M,D)] [ZEROFILL] A small (single-precision) floating-point number. Cannot be unsigned. Allowable values are -3.402823466E+38 to -1.175494351E-38, 0 and 1.175494351E-38 to 3.402823466E+38. The M is the display width and D is the number of decimals. FLOAT without an argument or with an argument of = 24 stands for a single-precision floating point number. DOUBLE[(M,D)] [ZEROFILL] A normal-size (double-precision) floating-point number. Cannot be unsigned. Allowable values are -1.7976931348623157E+308 to -2.2250738585072014E-308, 0 and 2.2250738585072014E-308 to 1.7976931348623157E+308. The M is the display width and D is the number of decimals. DOUBLE without an argument or FLOAT(X) where 25 = X = 53 stands for a double-precision floating point number. 7.7 CREATE TABLE syntax DOUBLE[(length,decimals)] [UNSIGNED] [ZEROFILL] FLOAT[(length,decimals)] [UNSIGNED] [ZEROFILL] DECIMAL(length,decimals) [UNSIGNED] [ZEROFILL] NUMERIC(length,decimals) [UNSIGNED] [ZEROFILL] As you can see from the above the FLOAT/DOUBLE columns cannot be unsigned or can they?. Second problem what is "Allowable values are -3.402823466E+38 to -1.175494351E-38, 0 and 1.175494351E-38 to 3.402823466E+38 " in real numbers I.E. how many digits?. Thanking you in advance Keith Stokes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problems connecting to MySQL via PHP
I have MySQL running on our server with Apache and php4. If I try connecting to MySQL server via php I get the error: Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) in... The socket is there and is created when MySQL is restarted. When I run mysqladmin --socket=/var/lib/mysql/mysql.sock version this seems to indicate that the socket is working okay. Any suggestions gratefully appreciated. Thanks Craig Pickup - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
LIMIT
Hey all, I've been using the LIMIT feature for paginating in MySQL for a long time now. It's really nice and makes paginating extremely simple. Up until now I've been using a dictionary object to get the same effect out of Microsoft SQL Server. Do any of you know a LIMIT equivalent for SQL Server? I would much rather grab the number of records I need rather than grabbing a reference to all of the records and only displaying the ones that I need. It seems redundant and I really hate the fact that LIMIT is not supported. Any ideas? By the way, suggestions for SQL Server 6.5 or SQL Server 7.0 are both appreciated. Thanks, Toby
[Fwd: Replication non working with Innobase]
Nico, does the table you are trying to replicate contain rows with more than 8000 bytes of data? InnoDB (= Innobase) cannot store longer rows. Arbitrary length BLOB and TEXT fields are on the TODO list for June 2001. Does the slave hang also for other queries you try to do on the slave's InnoDB tables? Regards, Heikki Tuuri Innobase Oy Hi, I'm using two Mysql 3.23.36 with Innobase tables on two machines running Redhat 7.0.I'm trying to use replication in a simple master/slave configuration, but while it works when I use MyIsam tables, if one of the two machines tries to useInnobase tables the replication doesn't work, both when they are configured to do itmanually and when I manually start the slave and launchload table news from master; in this last case after some seconds the slave complains of a network error (although the masteris alive and configured properly). Follows an excerpt from the log of the master, ?func: general: Host: www2.MIOSITO.it ip: 193.207.81.207 vio_keepalive: enter: sd=9, set_keep_alive=1vio_is_blocking: exit: 0 vio_write: enter: sd=9, buf=0x82afad0, size=54*** HERE IT WRITES SUCCESSFULLY 54 BYTES ON SOCKET 9vio_write: exit: 54 vio_is_blocking: exit: 0vio_read: enter: sd=9, buf=0x82afad0, size=4 *HERE IT CAN'T READ 4 BYTES FROM THE SAME SOCKET vio_read: error: Got error 11 during read -1, 4294967295 vio_read: exit: -1?func: info: vio_read returned -1, errno: 11 thr_alarm: enter: thread: T@2051 sec: 5thr_alarm: info: reschedule vio_is_blocking: exit: 0 So it seems the socket has been closed (maybe by the slave?). Does anyone have any suggestion? I'd also like to know if someone has Innobase replicating correctly, and if so what versions of c++ and libstdc++ he/she is using, I don't know if gcc is preferrable to egcs-g++.Thanks very much Nico - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
[Fwd: Replication non working with Innobase]
Nico, it came to my mind that possibly 'load table from master' uses LOCK TABLES to speed up processing in the slave. In 3.23.36 there was a bug with LOCK TABLES in connection with InnoDB (named the Wisconsin bug). It might help if you download and compile the new 3.23.37 from the MySQL website. The Wisconsin bug and also other bugs in connection with signal handling and setting of thread priorities have been fixed there. Regards, Heikki Nico, does the table you are trying to replicate contain rows with more than 8000 bytes of data? InnoDB (= Innobase) cannot store longer rows. Arbitrary length BLOB and TEXT fields are on the TODO list for June 2001. Does the slave hang also for other queries you try to do on the slave's InnoDB tables? Regards, Heikki Tuuri Innobase Oy Hi, I'm using two Mysql 3.23.36 with Innobase tables on two machines running Redhat 7.0.I'm trying to use replication in a simple master/slave configuration, but while it works when I use MyIsam tables, if one of the two machines tries to useInnobase tables the replication doesn't work, both when they are configured to do itmanually and when I manually start the slave and launchload table news from master; in this last case after some seconds the slave complains of a network error (although the masteris alive and configured properly). Follows an excerpt from the log of the master, ?func: general: Host: www2.MIOSITO.it ip: 193.207.81.207 vio_keepalive: enter: sd=9, set_keep_alive=1vio_is_blocking: exit: 0 vio_write: enter: sd=9, buf=0x82afad0, size=54*** HERE IT WRITES SUCCESSFULLY 54 BYTES ON SOCKET 9vio_write: exit: 54 vio_is_blocking: exit: 0vio_read: enter: sd=9, buf=0x82afad0, size=4 *HERE IT CAN'T READ 4 BYTES FROM THE SAME SOCKET vio_read: error: Got error 11 during read -1, 4294967295 vio_read: exit: -1?func: info: vio_read returned -1, errno: 11 thr_alarm: enter: thread: T@2051 sec: 5thr_alarm: info: reschedule vio_is_blocking: exit: 0 So it seems the socket has been closed (maybe by the slave?). Does anyone have any suggestion? I'd also like to know if someone has Innobase replicating correctly, and if so what versions of c++ and libstdc++ he/she is using, I don't know if gcc is preferrable to egcs-g++.Thanks very much Nico - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Database Planning
"Sica, Bill" wrote: For instance, say the book price is $19.44. You also have a base cost of $18, and 8% tax. You can always write a query to find out the total cost of any book, and get rid of anything to do with the total cost in your tables. For all the people who've never designed long-term databases, it should be stated: If you sell a book or buy a book at a given price, nothing says that price will be the same the next day. books: id, name , price sales: id, date, customer soldbooks: book_id, sales_id, price - this is the price, copied from "books.price" at the time of creation of the new entry because the book price might change in the future, and then your sales history is wrong. -- Michael T. Babcock (PGP: 0xBE6C1895) http://www.fibrespeed.net/~mbabcock/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: LIMIT
SQL Server will allow you to limit a SELECT to the first n rows, but not (to my knowledge) to skip a number of rows before returning the desired rows. The mechanism used is SET ROWCOUNT (6.5 and 7.0) or TOP (7.0). The difference is that SET ROWCOUNT limits the output rows before applying an ORDER BY sort. TOP applies the ORDER BY before limiting output. --Greg Johnson -Original Message- From: Toby Miller [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 19, 2001 10:31 AM To: [EMAIL PROTECTED] Subject:LIMIT Hey all, I've been using the LIMIT feature for paginating in MySQL for a long time now. It's really nice and makes paginating extremely simple. Up until now I've been using a dictionary object to get the same effect out of Microsoft SQL Server. Do any of you know a LIMIT equivalent for SQL Server? I would much rather grab the number of records I need rather than grabbing a reference to all of the records and only displaying the ones that I need. It seems redundant and I really hate the fact that LIMIT is not supported. Any ideas? By the way, suggestions for SQL Server 6.5 or SQL Server 7.0 are both appreciated. Thanks, Toby - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Problems connecting to MySQL via PHP
Make sure the directory /var/lib/mysql is world readable and searchable. Craig Pickup wrote: I have MySQL running on our server with Apache and php4. If I try connecting to MySQL server via php I get the error: Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) in... The socket is there and is created when MySQL is restarted. When I run mysqladmin --socket=/var/lib/mysql/mysql.sock version this seems to indicate that the socket is working okay. Any suggestions gratefully appreciated. Thanks Craig Pickup - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
C API problem
Dear Sir : MySQL 3.22.32 on my linux 486 PC seems work so good. When I compile a simple C API program which catched from MySQL tutorial, it chokes at the end of compile process . The program is as follows: #include stdio.h #include mysql.h #define def_host_name NULL #define def_user_name NULL #define def_password NULL #define def_db_name NULL MYSQL *conn; int main(int argc,char *argv[]) { conn=mysql_init(NULL); mysql_real_connect( conn, def_host_name, def_user_name, def_password, def_db_name, 0, /*port defaut*/ NULL, /*socket default*/ 0);/*flag*/ mysql_close(conn); exit(0); } I compile as follows: gcc -o my_code my_code.c -I/home/MySQL/MySQL/include \ -L/home/MySQL/MySQL/lib \ -lmysqlclient Then I get : /home/MySQL/MySQL/lib/libmysqlclient.a(my_open.o)In function 'my_open': my_open.o(.text+0x14):undefined reference to 'open64' /home/MySQL/MySQL/lib/libmysqlclient.a(mf_format.o)In function 'fn_format': mf_format.o(.text+0x201):undefined reference to '__lxstat64' /home/MySQL/MySQL/lib/libmysqlclient.a(my_open.o)In function 'my_open': my_open.o(.text+0x21):undefined reference to 'fopen64' Nothing left to do with the situation, I beg your help. Anyway I'm a newcomer. Thank you very much. Please send message to [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
Newbie Linux 7 installation question
When I run safe_mysqld, it starts and ends immediatly. In the mysqld.log in /var/log it has the following: 010418 21:19:47 mysqld started 010418 21:19:47 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 010418 21:19:47 mysqld ended Below is the my.cnf file [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock [mysql.server] user=mysql basedir=/var/lib [safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid I ran mysql_install_db and it created database files in /var/lib/mysql/mysql. The file host.frm does exist in that directory. I tried copying those files /var/lib/mysql but it made no difference. I have no ethernet card in the machine and therefore it would be running as localhost. Any ideas??? 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
Re: LIMIT
seems redundant and I really hate the fact that LIMIT is not supported. Any ideas? By the way, suggestions for SQL Server 6.5 or SQL Server 7.0 are both appreciated. M$??.. thought this was about MySQL :-) I wouldn't know.. I do know you can find a few newsgroups somewhere at news.microsoft.com this question will fit nicely there.. Bye, B. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: C API problem
On Thu, Apr 19, 2001 at 11:12:23PM +0800, john1 wrote: /home/MySQL/MySQL/lib/libmysqlclient.a(my_open.o)In function 'my_open': my_open.o(.text+0x14):undefined reference to 'open64' /home/MySQL/MySQL/lib/libmysqlclient.a(mf_format.o)In function 'fn_format': mf_format.o(.text+0x201):undefined reference to '__lxstat64' /home/MySQL/MySQL/lib/libmysqlclient.a(my_open.o)In function 'my_open': my_open.o(.text+0x21):undefined reference to 'fopen64' looks like you have a version of libc that is too old -- Laurent Oget, Ph.D. [EMAIL PROTECTED]http://oget.net Senior Engineer Zvolve Systems Inc http://zvolve.com Chercheur Associ Liafa http://liafa.jussieu.fr - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Run time version of MySQL
Hi, We are planning to move on to MySQL. Could you send us your opinions about MtSQL. It will greatly help us to make decision and to use MySQL. Thanks. Regards, John Ding
Indizes abschalten.
Hallo Leute, in Oracle kann man Indizes in einer Abfrage abschalten(Full-Table-Scan). Mit +0 oder ||''. z.B.: SELECT * FROM tabelle WHERE eigenschaft||'' = 'text'; SELECT * FROM tabelle WHERE id+0 = 1; Geht das bei mySQL auch?
which is fastest connect or pconnect ?
We often get a message from MySQL that there are too many connections. What can we do ? Should we use connect rather than pconnect ? We use Php 4.04pl1, Linux, Apache 1.3.17 and MySQL 3.23.32 Regards Jacob - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Run time version of MySQL
Well it is exactly depends on who you are , what are you doing , on which platform , for which purposes etc... - Original Message - From: johnd [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, April 19, 2001 6:40 PM Subject: Run time version of MySQL Hi, We are planning to move on to MySQL. Could you send us your opinions about MtSQL. It will greatly help us to make decision and to use MySQL. Thanks. Regards, John Ding - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Newbie Linux 7 installation question
chown -R mysql /var/mysql Steve Tuckner wrote: When I run safe_mysqld, it starts and ends immediatly. In the mysqld.log in /var/log it has the following: 010418 21:19:47 mysqld started 010418 21:19:47 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 010418 21:19:47 mysqld ended Below is the my.cnf file [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock [mysql.server] user=mysql basedir=/var/lib [safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid I ran mysql_install_db and it created database files in /var/lib/mysql/mysql. The file host.frm does exist in that directory. I tried copying those files /var/lib/mysql but it made no difference. I have no ethernet card in the machine and therefore it would be running as localhost. Any ideas??? 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
Re: Run time version of MySQL
You're posting to the mysql list asking us how it is? Come on... that's like asking MS how good Windows 2000 is. MySQL ROCKS! At 11:40 AM 4/19/2001 -0400, johnd wrote: Hi, We are planning to move on to MySQL. Could you send us your opinions about MtSQL. It will greatly help us to make decision and to use MySQL. Thanks. Regards, John Ding - Scott Baker - Webster Internet - Network Technician 503.266.8253 - [EMAIL PROTECTED] "It has been said that the primary function of schools is to impart enough facts to make children stop asking questions. Some, with whom the schools do not succeed, become scientists." - Knut Schmidt-Nielson - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
problem running mysqladmin variables command
when I run the command, (in linux) it serves up the variables. But the variables seem to be much more than what is listed in Paul Dubois' book. So I am unable to view all of it in terminal. The less command doesnt work with it either so how can I view mysqladmin variable info? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: which is fastest connect or pconnect ?
We often get a message from MySQL that there are too many connections. What can we do ? Should we use connect rather than pconnect ? We use Php 4.04pl1, Linux, Apache 1.3.17 and MySQL 3.23.32 Yes, you should. That, or increade the amount of allowed connections, or decrease the amount of allowed apache processes. If you use pconnect, you should have more allowed connections than allowed apache processes. (MaxClients settings) -S - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Indizes abschalten.
I'll try to translate: in oracle one can turn off indexes within a query (full-table-scan) by using: +0 or ||''. for example: SELECT * FROM tabelle WHERE eigenschaft||'' = 'text'; SELECT * FROM tabelle WHERE id+0 = 1; can one do this with mysql? - Original Message - From: "Hagen Schmieder" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, April 19, 2001 5:41 PM Subject: Indizes abschalten. Hallo Leute, in Oracle kann man Indizes in einer Abfrage abschalten(Full-Table-Scan). Mit +0 oder ||''. z.B.: SELECT * FROM tabelle WHERE eigenschaft||'' = 'text'; SELECT * FROM tabelle WHERE id+0 = 1; Geht das bei mySQL auch? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Socket problem - unable to run app
Description: I cannot use the application because of socket problems. This problem occurs with both the binary and source versions. I get the following error: [localhost:/usr/local/mysql] root# ./bin/mysqladmin -u root -p password 'g7ioyhe' Enter password: ./bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)' Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists How-To-Repeat: This error occurs any time I try to use mysql. Fix: n/a Submitter-Id: Originator: System Administrator Organization: MySQL support:none Synopsis: Unable to use application - socket problems Severity: critical Priority: high Category: mysql Class:support Release: mysql-3.23.27-beta (Source distribution) Environment: System: Darwin localhost 1.3 Darwin Kernel Version 1.3: Thu Mar 1 06:56:40 PST 2001; root:xnu/xnu-123.5.obj~1/RELEASE_PPC Power Macintosh powerpc Some paths: /usr/bin/perl /usr/bin/make /usr/bin/cc Compilation info: CC='cc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxr-xr-x 1 root wheel 15 Mar 24 12:50 /usr/lib/libc.dylib - libSystem.dylib Configure command: ./configure - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Reference question and auto increment
I am trying to understand references in tables and using primary keys with auto increment option as a reference to all tables: What is the best way to reference other tables? I have three tables: menus, categories, and links. I also have an ID field in each table that uses the autoincrement option and is the primary key which is used to reference the other tables. This works great for referencing except when a record is deleted. When a record is deleted and you add another record the ID is not assigned the deleted records ID instead it skips the deleted record ID and uses the next ID when you would expect it to use the deleted ID which then causes problems with query to display all records from all tables. Maybe if I could use REPLACE to replace the deleted record that might work. I guess the solution is to create a new field common to all tables called record_id and not use the auto increment option and enter the record ID manually for each record I add. The problem with this is I have to remember what the previous record was if I want it to be in order. Is there a better way to do this. I like the auto increment option. I saw an example where three tables all contain a customerid which links all the tables together. Lets say I delete a customerid in one table but not the others. Does the database automatically delete the other cutomerids in the other tables that correspond to the customerid that was deleted or is it up to the programmer to delete the other two id's. -- This email was sent using w3mail. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Performance Moitor.
Hi, Sorry for worrying U'll. I want to know how can I get information about the Memory usage, can I get details about Database Usage (How much space have used In each database). Thanx. -- Dilkushan Karunaratne, # 50/1A, Sri Indrajothi Road, Ratmalana, Sri Lanka. Tel 94 1 715716
Re: Run time version of MySQL
My sugesstion is that you get yourself a decent old workstation, one that you would probably consider ready for retirement if it were to still be running MS something...Like say a p200ish machine with a couple of gig on the disk and say 32 but prefereably 64M of ram. Slap a cheap NIC, like the SMC1211tx, in it and get that thing up on the net. Now get fBSD loaded on it and install MySql from the ports. If you don't have a good inet connection then shell out the $30 dollars for the fBSD CD set, then you can have everything up and running in less than 3 hours, seriously. Now you are ready to give it a test drive and providing you've used old gear, I'd estimate you've spent a grand total of $50. You can now give pretty much all of the free DB's a try and decide for yourself. of course if you've a good inet connection you can download everything for free and you've spent a whaping $0. Cheers, Mikel johnd wrote: Hi, We are planning to move on to MySQL. Could you send us your opinions about MtSQL. It will greatly help us to make decision and to use MySQL. Thanks. Regards, John Ding - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 running mysqladmin variables command
Wade wrote: when I run the command, (in linux) it serves up the variables. But the variables seem to be much more than what is listed in Paul Dubois' book. So I am unable to view all of it in terminal. The less command doesnt work with it either so how can I view mysqladmin variable info? - Of course it does. mysqladmin variables | less - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 running mysqladmin variables command
problem is I have to use mysqladmin variables -u root -p PASSWORD:x I tried piping the less command at the end of -p but it didnt work Of course it does. mysqladmin variables | less - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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't connect to local MysqlServer through socket 'tmp/mysql.sock
I can't start mysqld . Can you help me? Error message:"Can't connect to local MysqlServer through socket 'tmp/mysql.sock"
SuSe 7.0 and glibc-2.2-9
Hi, I am using SuSe 7.0 with glibc-2.2-9 installed and installed mySql from SuSe's ftp server with yast. Contrarily to my normal experience this did not work: All errors I detect (by making mysql_install_db or by starting the daemon with mysqld --skip-grant ) come down to the following error message: error while loading shared libraries: libstdc++--libc6.2-2.so.3 Could not open shared object file: file or database missing ..which is correct, as in my case I only have libstdc++--libc6.(!)1(!)-2.so.3 I am using glibc-2.2-9 and I though only earlier versions cause problems with mySql Is there a way to tell the daemon to look for this .so (if he can use it as well) instead of the one he tries to look for ? Or do I have to get a new "glibc-2.2-9 ? Thank you in advance Stefan Geis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Run time version of MySQL
We are planning to move on to MySQL. Could you send us your opinions about MtSQL. It will greatly help us to make decision and to use MySQL. I love MySQL.. but there are others too. I think their are still some pros and cons.. given time I think the pros will increase.. Although other databases might have some appealing pros.. the question is how important they are to you.. and how bad are the cons.. Sorry, but I cannot answer that question. That's up to you.. Which database to choose does depend on your needs. If you want to let PHP interact with MySQL you'll find lots of code already written by others.. free to use.. many PHP functions.. How important it is.. well.. once again.. thats up to you to decide. Not much fun in talking about this.. if you search this lists archive you will find quite a few discussions.. and comparisons.. Remember every list will find it's "own" database the very very very best.. Bye, B. who sometimes like to play the devils advocate - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Correct syntax?
Thanks for help from this group I'm using "select word, count(word) as total from search_words group by word order by total desc limit 20" to locate the top 20 words in a database of website search engine words. The database had been altered to include an extra column, other than the 'word' column. This means that 'word' can now have a null entry sometimes. How can I modify the sql query above to exclude any row(s) in 'word' with 'NULL' please? regards, Graham l - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 running MySQL on AIX 4.3.3.0
I just loaded MySQL 3.23.37 binary on my IBM PowerPC based RS6000 computer running AIX 4.3.3.0. When I started MySQL server daemon by executing "safe_mysqld", I got following error message: mysqld started on Thu Apr 19 10:58:40 CDT 2001 exec(): 0509-036 Cannot load program /usr/local/mysql/libexec/mysqld because of the following errors: 0509-150 Dependent module /usr/local/lib/libz.a(shr.o) could not be loaded. 0509-152 Member shr.o is not found in archive mysqld ended on Thu Apr 19 10:58:40 CDT 2001 The Zlib's libz.a is version 1.3.2. Can anyone give me some clues? Thanks. Weining Weining Zhao - TNRCC 512-239-2593 [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: Socket problem - unable to run app
Well, Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists. Neil Mussett wrote: Description: I cannot use the application because of socket problems. This problem occurs with both the binary and source versions. I get the following error: [localhost:/usr/local/mysql] root# ./bin/mysqladmin -u root -p password 'g7ioyhe' Enter password: ./bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)' Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists How-To-Repeat: This error occurs any time I try to use mysql. Fix: n/a Submitter-Id: Originator: System Administrator Organization: MySQL support:none Synopsis: Unable to use application - socket problems Severity: critical Priority: high Category: mysql Class:support Release: mysql-3.23.27-beta (Source distribution) Environment: System: Darwin localhost 1.3 Darwin Kernel Version 1.3: Thu Mar 1 06:56:40 PST 2001; root:xnu/xnu-123.5.obj~1/RELEASE_PPC Power Macintosh powerpc Some paths: /usr/bin/perl /usr/bin/make /usr/bin/cc Compilation info: CC='cc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxr-xr-x 1 root wheel 15 Mar 24 12:50 /usr/lib/libc.dylib - libSystem.dylib Configure command: ./configure - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
You see I have written a small chat server is perl where when a user wants to chat he simply types the message it gets recorded into mysql and another program keeps reading the mysql databse and shows the messages. Now, the same is not yet deployed; but, I fear when I deploy it the program will collapse because everytime a person wants to chat the program will open a new connection; put the data and close connection and similarly for the frame in which the chat is displayed. It will open the conenction and close every 5 seconds. Now, is there any way in perl where in a connection can be opened up continously or something else. Any input would be highly appreciated. Amit - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Many to Many
Hello again here send al SQL to generate the database to test in MYSQL, for example in case that I Question in the query that a Productor TECUN (1) no cant be return, pepe(2), lolo(1) CEIS (2) no cant be return lolo(1) PCMAX (3) no cant be return pepe(2) A Numbres are the ID In the table cp the ID from Consumidor are IDC and whish Productor are IDP - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
max FULLTEXT index size?
Hi all, I'm creating a fulltext index on a 400MB table, and the creation process gets very slow. It's fast for the first 50MB of the index, and then it grinds to what seemed like a halt after days. My question is - is there anyone who's created fulltext indexes on this much data who can assure me that it's possible? Merge tables are not an option because you can't query a merge table on a fulltext index. thanks, Braxton - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Run time version of MySQL
Check out some testimonials at this web site http://netgraft.com/~mbac/research/mysqlmyths.html --- Ken Menzel ICQ# 9325188 www.icarz.com [EMAIL PROTECTED] - Original Message - From: "Scott Baker" [EMAIL PROTECTED] To: "johnd" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, April 19, 2001 12:18 PM Subject: Re: Run time version of MySQL You're posting to the mysql list asking us how it is? Come on... that's like asking MS how good Windows 2000 is. MySQL ROCKS! At 11:40 AM 4/19/2001 -0400, johnd wrote: Hi, We are planning to move on to MySQL. Could you send us your opinions about MtSQL. It will greatly help us to make decision and to use MySQL. Thanks. Regards, John Ding - Scott Baker - Webster Internet - Network Technician 503.266.8253 - [EMAIL PROTECTED] "It has been said that the primary function of schools is to impart enough facts to make children stop asking questions. Some, with whom the schools do not succeed, become scientists." - Knut Schmidt-Nielson - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Reference question and auto increment
Why would you want to re-use the deleted ID? That would be a poor design. When you insert a new record with an autoinvcrement, last_insert_id() will tell you what it is so you can insert it in dependent tables. Fates wrote: I am trying to understand references in tables and using primary keys with auto increment option as a reference to all tables: What is the best way to reference other tables? I have three tables: menus, categories, and links. I also have an ID field in each table that uses the autoincrement option and is the primary key which is used to reference the other tables. This works great for referencing except when a record is deleted. When a record is deleted and you add another record the ID is not assigned the deleted records ID instead it skips the deleted record ID and uses the next ID when you would expect it to use the deleted ID which then causes problems with query to display all records from all tables. Maybe if I could use REPLACE to replace the deleted record that might work. I guess the solution is to create a new field common to all tables called record_id and not use the auto increment option and enter the record ID manually for each record I add. The problem with this is I have to remember what the previous record was if I want it to be in order. Is there a better way to do this. I like the auto increment option. I saw an example where three tables all contain a customerid which links all the tables together. Lets say I delete a customerid in one table but not the others. Does the database automatically delete the other cutomerids in the other tables that correspond to the customerid that was deleted or is it up to the programmer to delete the other two id's. -- This email was sent using w3mail. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 installing on Solaris 8
Hello, When I am trying to install mySQL on a Solaris8 server I get the following error: # ./configure . . . checking return type of sprintf... configure: error: can not run test program while cross compiling Any idea what I need to do? I have tried to add the ac_cv_sys_restartable_syscalls=${ac_cv_sys_restartable_syscalls='no'} to the config.cache file, but no luck. I am using gcc 2.95.2 and the following packages are installed in the OS: perl-5.6.0 URI-1.11 MIME-Base64-2.12 HTML-Tagset-3.03 HTML-Parser-3.19 libnet-1.0703 Digest-MD5-2.12 libwww-perl-5.50 m4-1.4 autoconf-2.13 automake-1.4 bison-1.28 binutils-2.9 Best Regards, Magnus Larsson =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Magnus Larsson Phone: +1-804-592-6182 Fax:+1-804-592-5469 Mobile: +1-804-258-6182 e-mail: [EMAIL PROTECTED] Ericsson Inc. 1 Mountain View Road Lynchburg, VA 24502 USA =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: problem running mysqladmin variables command
The put the password immediately after the -p ( no space ). Wade wrote: problem is I have to use mysqladmin variables -u root -p PASSWORD:x I tried piping the less command at the end of -p but it didnt work Of course it does. mysqladmin variables | less - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
databases and operating systems
Hello, my name is Ben Garvey and I'm doing a research paper on whether operating systems should be rewritten to offer more support for databases. What type of operating system features could benefit database implementors? Thank you in advance. Ben Garvey American University 202-332-6218 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: LIMIT
Believe me, it's not my first choice I hate working with M$ as much as the next guy. Unfortunately, not every project leans in the direction I want it to. As far as the LIMIT function goes I think MySQL has spoiled me. The only easy way to do pagination in ASP is through the ADO Object. The problem is that I won half the battle by getting to use PHP, but I lost the MySQL battle so I'm left with this dilemma. I think using the TOP declaration that I'll be able to come up with some workarounds in Stored Procedures. Sorry for mentioning M$ here, but it seemed like a question that has most likely terrorized at least a few other people on the list so I figured it was worth a try. --Toby - Original Message - From: "B. van Ouwerkerk" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, April 19, 2001 11:31 AM Subject: Re: LIMIT seems redundant and I really hate the fact that LIMIT is not supported. Any ideas? By the way, suggestions for SQL Server 6.5 or SQL Server 7.0 are both appreciated. M$??.. thought this was about MySQL :-) I wouldn't know.. I do know you can find a few newsgroups somewhere at news.microsoft.com this question will fit nicely there.. Bye, B. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Correct syntax?
"select word, count(word) as total from search_words where word IS NOT NULL group by word order by total desc limit 20" John Barton Unix Systems Administrator Primary Networks, Inc. [EMAIL PROTECTED] On Thu, 19 Apr 2001, Graham Nichols wrote: Thanks for help from this group I'm using "select word, count(word) as total from search_words group by word order by total desc limit 20" to locate the top 20 words in a database of website search engine words. The database had been altered to include an extra column, other than the 'word' column. This means that 'word' can now have a null entry sometimes. How can I modify the sql query above to exclude any row(s) in 'word' with 'NULL' please? regards, Graham l - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Correct syntax?
select word, count(word) as total from search_words where word is not null group by word order by total desc limit 20 -Original Message- From: Graham Nichols [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 19, 2001 1:36 PM To: [EMAIL PROTECTED] Subject: Correct syntax? Thanks for help from this group I'm using "select word, count(word) as total from search_words group by word order by total desc limit 20" to locate the top 20 words in a database of website search engine words. The database had been altered to include an extra column, other than the 'word' column. This means that 'word' can now have a null entry sometimes. How can I modify the sql query above to exclude any row(s) in 'word' with 'NULL' please? regards, Graham l - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Can't connect to local MysqlServer through socket 'tmp/mysql.sock
it is in the FAQ. On Thu, 19 Apr 2001 20:23:39 +0300, Goksel Misirli wrote: I can't start mysqld . Can you help me? Error message:"Can't connect to local MysqlServer through socket 'tmp/mysql.sock" - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [Fwd: Replication non working with Innobase]
Sasha and Monty, Nico had a problem in replication with InnoDB tables. Luckily 3.23.37 seems to solve his problems. But, meanwhile I was studying 'load table from master' and noticed that it uses a function net_read_dump which is only defined for MyISAM tables. The following printout is from 3.23.34 on Win NT, where I was able to get replication working for InnoDB, but 'load table from master' failed. . Innobase: Started mysqld: ready for connections 010419 20:46:21 Slave thread initialized 010419 20:46:22 Slave: connected to master 'repl@localhost:3306', replication started in log 'omnibook-bin.008' at position 432 010419 20:47:09 create_table_from_dump::failed in handler::net_read_dump() 010419 20:47:09 fetch_nx_table: failed on create table .. An obvious workaround is to alter an InnoDB table to MyISAM (in master), do then 'load table from master' (in slave) and after that do ALTER TABLE back to InnoDB in master. The slave will repeat the ALTER TABLE and the end result is an InnoDB table which is identical on both systems. Another workaround is to make a 'binary' backup of the InnoDB database, as described in the InnoDB manual, of the master and copy the backup then to the slave. For 'load table from master' to work directly for InnoDB tables the MySQL developer responsible for replication should program an alternate method of transfer which uses SQL statements. Regards, Heikki Return-Path: [EMAIL PROTECTED] Sender: [EMAIL PROTECTED] Date: Thu, 19 Apr 2001 18:53:47 + From: Nicola Sabbi [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] X-Accept-Language: en To: Heikki Tuuri [EMAIL PROTECTED] Subject: Re: [Fwd: Replication non working with Innobase] References: 20010419143600.BZFW26396.fep06.tmt.tele.fi@omnibook Hello, I solved all problems using 2.23.37 with redhat 7.0 + gcc-g++ and relative libraries. Maybe it's a problem related to egcs* Thanks in advance. Heikki Tuuri wrote: Nico, does the table you are trying to replicate contain rows with more than 8000 bytes of data? InnoDB (= Innobase) cannot store longer rows. Arbitrary length BLOB and TEXT fields are on the TODO list for June 2001. Does the slave hang also for other queries you try to do on the slave's InnoDB tables? Regards, Heikki Tuuri Innobase Oy Hi, I'm using two Mysql 3.23.36 with Innobase tables on two machines running Redhat 7.0.I'm trying to use replication in a simple master/slave configuration, but while it works when I use MyIsam tables, if one of the two machines tries to useInnobase tables the replication doesn't work, both when they are configured to do itmanually and when I manually start the slave and launchload table news from master; in this last case after some seconds the slave complains of a network error (although the masteris alive and configured properly). Follows an excerpt from the log of the master, ?func: general: Host: www2.MIOSITO.it ip: 193.207.81.207 vio_keepalive: enter: sd=9, set_keep_alive=1vio_is_blocking: exit: 0 vio_write: enter: sd=9, buf=0x82afad0, size=54*** HERE IT WRITES SUCCESSFULLY 54 BYTES ON SOCKET 9vio_write: exit: 54 vio_is_blocking: exit: 0vio_read: enter: sd=9, buf=0x82afad0, size=4 *HERE IT CAN'T READ 4 BYTES FROM THE SAME SOCKET vio_read: error: Got error 11 during read -1, 4294967295 vio_read: exit: -1?func: info: vio_read returned -1, errno: 11 thr_alarm: enter: thread: T@2051 sec: 5thr_alarm: info: reschedule vio_is_blocking: exit: 0 So it seems the socket has been closed (maybe by the slave?). Does anyone have any suggestion? I'd also like to know if someone has Innobase replicating correctly, and if so what versions of c++ and libstdc++ he/she is using, I don't know if gcc is preferrable to egcs-g++.Thanks very much Nico - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Can anyone help me.. for install on a Freebsd 4.2 box..
Would anyone out there have the installation instruction for Mysql for a FreeBSD 4.2 box??? Larry P.S. Thanks in advance... - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
report some problems
Hi, Dear Sir or Madam, I like mySQL very much and today I tried to use mySQLGUI (win32 static binary 1.7.4-2), but I found edit table and create table in commands/tables menu have no functions. is there any problem? Sincerely Edwin Zhang
RE: Can't connect to local MysqlServer through socket 'tmp/mysql.sock
Are you running the version that came with Redhat 7.0? I had the same problem and just downloaded a newer version from mysql.com and installed it. That seemed to fix the problem. -Original Message- From: Goksel Misirli [SMTP:[EMAIL PROTECTED]] Sent: Thursday, April 19, 2001 10:24 AM To: [EMAIL PROTECTED] Subject: Can't connect to local MysqlServer through socket 'tmp/mysql.sock I can't start mysqld . Can you help me? Error message:"Can't connect to local MysqlServer through socket 'tmp/mysql.sock" - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Bug on Solaris 8
Hi there, I installed mysql 3.22.32 on Solaris 8 and everytime I am trying to run mysqld it gives me the following error ld.so.1: /usr/local/mysql/libexec/mysqld: fatal: libstdc++.so.2.10.0: open failed: No such file or directory Please Advise, My email address is [EMAIL PROTECTED] Thanks in advance, Arif
re: JAPANESE QUESTION: My Inept Translation Attempt
I'll try to translate this as best I can. The sender can likely understand the response in English, so fire away. If you send them English he'll probably try (and probably can use) English. If anyone on the list can do a better job of translating this, please feel free to correct me! Keep in mind that it is a while since I used a lot of Japanese. . . I'm sure I'm making some errors: SNIPLine-by-line == Good day!My name is Mr. Takeuchi. We have some Access 97 data in a database we made in Windows. We tried to export the Access 97 data into mySql but found it impossible to export the Chinese and Japanese characters correctly. We have a Linux terminal to which we are exporting the data (I THINK THIS IS WHAT THEY ARE SAYING!). They are exporting to EUC (and then they ask "Font?" ) and are using ODBC software to connect to MySQL. IN SHORT... In short if anyone knows how to export Access 97 data to mySql over ODBC (a Japanese version) so that the characters come out correctly they would like to hear from you. They seem to want to get the data from a Windows machine to a Linux machine using EUC. === Good luck! -Warren こんにちは、久し振りの投稿となります。たけうちです。 Access97 で作った名簿データを、MySQL 上へエクスポートしたのですが 「塚」「髙」の特定文字が入力できない問題が発生しました。 これらの文字は Linux のターミナル上でも入力不可だったので、もしか したら EUC上(フォント?)に存在しないのでしょうか? 以下の構成で ODBC 接続しています。 サーバ:Linux MySQL(3.23.31) EUC クライアント:Windows Access97(EUC版ODBC 2.50.29-jp) -- [EMAIL PROTECTED] たけうち - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL 3.23.37 released
"MW" == Michael Widenius [EMAIL PROTECTED] writes: MW We are just now building the first MySQL-Max binaries with support for MW Berkeley DB and InnoDB tables. The first one will be a Linux x86 RPM Does this imply that BDB tables are stable enough for production use, or is it still considered Beta as per http://www.mysql.com/doc/S/t/Stability.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
Re: Can anyone help me.. for install on a Freebsd 4.2 box..
cd /usr/ports/databases/mysql323-server make make install reboot - Ken Menzel ICQ# 9325188 www.icarz.com [EMAIL PROTECTED] - Original Message - From: "Larry Caragay" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, April 19, 2001 2:37 PM Subject: Can anyone help me.. for install on a Freebsd 4.2 box.. Would anyone out there have the installation instruction for Mysql for a FreeBSD 4.2 box??? Larry P.S. Thanks in advance... - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Translate
I need translate this SQL to any SQL that work in MYSQL SELECT * FROM cons WHERE NOT EXISTS (SELECT idc FROM cp where cons.id=cp.idc and cp.idp = 1); - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Can anyone help me.. for install on a Freebsd 4.2 box..
hi. the easiest way would be to use the port. otherwise ./configure (--with-some-options); make; make install and hope for the best... more realistically, do the commands one by one, and deal w/ the error messages as they pop up. is there specific information that is not on these pages ( http://www.mysql.com/doc/Q/u/Quick_install.html ) that you were looking for? hth. -ravi. -Original Message- From: Larry Caragay [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 19, 2001 2:37 PM To: [EMAIL PROTECTED] Subject: Can anyone help me.. for install on a Freebsd 4.2 box.. Would anyone out there have the installation instruction for Mysql for a FreeBSD 4.2 box??? Larry P.S. Thanks in advance... - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
User setup IP resolution
Request help getting myself setup with my website host. They offer mySQL but do not know very much about it and we seem to be stuck. the error I am getting is this: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) where "userid" is my userid and "xx.xxx.xxx.xxx" is my dynamic IP The webmaster I have tried setting my Hostname as "%" for mySQL to accept my login from anywhere, buy still not working. The webmaster also says it looks like the Reverse DNS is not working, however my local ISP does have a REVERSE DNS server and they do generally run a fairly standard operation, as does my web host is using Red Hat Linux. BTW, I am on a Win98 machine, trying to connect vie mySQLgui. I also get the same error msg connecting via myOBDC. Help appreciated. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MYSQL Bug on Solaris 8
Usually you need to set your environment variable LD_LIBRARY_PATH to include the libstdc++.so.2 location (/usr/local/lib maybe ?) when you start mysqld. Ping Lu Cable Wireless Global Network Tools and Analysis Group, USA W: +1-703-292-2359 E: [EMAIL PROTECTED] -Original Message- From: Arif Chowdhury [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 19, 2001 3:12 PM To: [EMAIL PROTECTED] Subject: MYSQL Bug on Solaris 8 Hi there, I installed mysql 3.22.32 on Solaris 8 and everytime I am trying to run mysqld it gives me the following error ld.so.1: /usr/local/mysql/libexec/mysqld: fatal: libstdc++.so.2.10.0: open failed: No such file or directory Please Advise, My email address is [EMAIL PROTECTED] Thanks in advance, Arif - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
building site search
Is the common way to index a site, then place that into a database? If so whats the best(easiest) way to index a site? 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 vs SQLServer vs PostgresSQL
I have heard mysql is the access for unix... i would like to hear about comparisons with Mysql SqlServer and PostgresSQL Kevin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Run time version of MySQL (Detail)
Hi, We will delevope web based applications to put the databases on MySQL instead of Oracle. We will have plateforms such as: 1). IBM desktop 400 mhz processor 256 MB RAM 6 GB plus 20 GB hard drives Win2000 Server installed; or 2). Digital UNIX 500 mhz Alpha processor 1 GB RAM 35 GB RAID 5 with UNIX 4.0f installed The cost is so good for MySQL. What about the performace during working load web application databases? Could you tell us about your opinions or any of your information? Thanks for your information. Regards, John Ding
RE: Can anyone help me.. for install on a Freebsd 4.2 box..
if you've downloaded the binary, then you don't need to configure, just like the error says... read this page, http://www.mysql.com/doc/I/n/Installing_binary.html then this one: http://www.mysql.com/doc/P/o/Post-installation.html hth. (and don't forget to cc replies to the list [[EMAIL PROTECTED]] for posterity) -ravi. -Original Message- From: Larry Caragay [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 19, 2001 5:02 PM To: Ravi Raman Subject: RE: Can anyone help me.. for install on a Freebsd 4.2 box.. Hi Ravi, The problem I get is after the ./configure --prefix=/usr/local/mysql There is a error at the "make" part.. it say: one# ./configure --prefix=/usr/local/mysql 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 databases and 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 To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is done with: ./bin/mysqladmin -u root -p password 'new-password' ./bin/mysqladmin -u root -h one.nasala.com -p password 'new-password' See the manual for more instructions. NOTE: If you are upgrading from a MySQL = 3.22.10 you should run the ./bin/mysql_fix_privilege_tables. Otherwise you will not be able to use the new GRANT command! You can start the MySQL daemon with: cd . ; ./bin/safe_mysqld You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory: cd sql-bench ; run-all-tests Please report any problems with the ./bin/mysqlbug script! The latest information about MySQL is available on the web at http://www.mysql.com Support MySQL by buying support/licenses at https://order.mysql.com Starting the mysqld server. You can test that it is up and running with the command: ./bin/mysqladmin version one# A mysqld process already exists make make: no target to make. Larry -Original Message- From: Ravi Raman [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 19, 2001 12:57 PM To: Larry Caragay; [EMAIL PROTECTED] Subject: RE: Can anyone help me.. for install on a Freebsd 4.2 box.. hi. the easiest way would be to use the port. otherwise ./configure (--with-some-options); make; make install and hope for the best... more realistically, do the commands one by one, and deal w/ the error messages as they pop up. is there specific information that is not on these pages ( http://www.mysql.com/doc/Q/u/Quick_install.html ) that you were looking for? hth. -ravi. -Original Message- From: Larry Caragay [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 19, 2001 2:37 PM To: [EMAIL PROTECTED] Subject: Can anyone help me.. for install on a Freebsd 4.2 box.. Would anyone out there have the installation instruction for Mysql for a FreeBSD 4.2 box??? Larry P.S. Thanks in advance... - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Run time version of MySQL (Detail)
John, I don't think anyone can say for sure which is 'better'. MySQL is used in a different kind of environment than Oracle. Oracle is designed for an enterprise environment, where many different applications are used simultaneously to add or retrieve data from a central data store. MySQL is designed more for web applications, where data is maintained and accessed through a smaller set of programs. Many people have set up very successful MySQL web applications. It is easier and cheaper to administer mysql, and it is faster, but less external software is designed for it. For example, if you might use an external business intelligence tool, it will work with Oracle, but it might not work with MySQL, even through ODBC. In my mind, the two main problems with MySQL are: 1) lack of derived tables 2) lack of subqueries I'm in the process of switching from Oracle to MySQL. The main reasons for doing this were: 1) price. 2) administration. I can do DBA stuff on Oracle, but it's much easier and faster to do it on MySQL. Things that take a long time and significant study on oracle don't even require you to think about them on mysql. 3) hardware. Given hardware can handle much more data much faster on MySQL. 4) support. Oracle has a vested interest in keeping discussion of its product hidden inside proprietary tech support databases. Thus problems in the product are not obvious until you hit them. I didn't want to buy oracle support (they told us it started at $10k). 5) focus. Where is Oracle heading? Towards selling services and other applications to enterprise customers. They don't want small customers, and they don't want to make the product easier to use. They sell the product to conservative managers who are willing to spend extra money to ensure they have something that will do what they want, and Oracle will do most things if you spend enough money on consultants and hardware. hope this helps. braxton -Original Message- From: johnd [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 19, 2001 5:02 PM To: [EMAIL PROTECTED] Subject: Run time version of MySQL (Detail) Hi, We will delevope web based applications to put the databases on MySQL instead of Oracle. We will have plateforms such as: 1). IBM desktop 400 mhz processor 256 MB RAM 6 GB plus 20 GB hard drives Win2000 Server installed; or 2). Digital UNIX 500 mhz Alpha processor 1 GB RAM 35 GB RAID 5 with UNIX 4.0f installed The cost is so good for MySQL. What about the performace during working load web application databases? Could you tell us about your opinions or any of your information? Thanks for your information. Regards, John Ding - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MyODBC Installation Troubleshooting
Hi, We have noticed that some MySQL users are having problems to install the MyODBC driver, receiving errors messages like this: An error occurred while copying C:\windows\system\mfc30.dll. Restart windows.. Generally this happens because the ODBC core stuff is ready installed and the MyODBC setup doesn't have the support to verify this and tries to re-write the files. The best work around for this problem is to copy the myodbc.dll on \windows\system ; \winnt\system32 and make its registry in the Windows system registry. To make the MyODBC registry you could use a batch file sent for us by Jim Michaels (see below) and take up the following steps: Create on the same directory which there is the myodbc.dll a batch file e.g: my.bat. Paste the command lines showing below and edit the lines with the Windows\system directory with the correct path of your machine environment. Run the bat. If the myodbc.dll already exists on the system directory, remove the line copy myodbc.dll C:\WINDOWS\SYSTEM. Put attention that every echo line should be not split. Regards, Miguel rem -Author: Jim Michaels rem -copy the drivers where all good little ODBC drivers go if errorlevel 1 goto bye copy myodbcd.dll C:\WINDOWS\SYSTEM if errorlevel 1 goto bye rem create a .REG file to make registry entries echo REGEDIT4myodbc.reg echo.myodbc.reg echo [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\MySQL]myodbc.reg echo "APILevel"="2"myodbc.reg echo "ConnectFunctions"="YYN"myodbc.reg echo "Driver"="C:\\WINDOWS\\SYSTEM\\myodbc.dll"myodbc.reg echo "DriverODBCVer"="02.50"myodbc.reg echo "FileExtns"="*.txt"myodbc.reg echo "FileUsage"="0"myodbc.reg echo "Setup"="C:\\WINDOWS\\SYSTEM\\myodbc.dll"myodbc.reg echo "SQLLevel"="1"myodbc.reg echo.myodbc.reg echo [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers]myodbc.reg echo "MySQL"="Installed"myodbc.reg echo.myodbc.reg rem -install the registry entries by executing the .REG file start /wait myodbc.reg rem clean up after we are done installing del myodbc.reg :bye __ ___ __ / |/ /_ __/ __/ __ \/ / http://www.mysql.com/ / /|_/ / // /\ \/ /_/ / /__ Miguel Solrzano [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ So Paulo, Brazil ___/ Development Team - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Dynamically changing Sort order
Given the following table: Name varchar(128), CodePageEncoding varchar(32) that a select like this could be done select Name, CodePageEncoding from table group by CodePageEncoding order by CODE_PAGE_SENSITIVE_FUNCTION(CodePageEncoding, Name); This would produce a report/resultset like the following: NameIn_Armenian_SortedInArmenian | CodePageEncoding NameIn_English_SortedInEnglish | CodePageEncoding NameIn_English_SortedInEnglish | CodePageEncoding NameIn_English_SortedInEnglish | CodePageEncoding NameIn_English_SortedInEnglish | CodePageEncoding NameIn_English_SortedInEnglish | CodePageEncoding NameIn_Russian_SortedInRussian | CodePageEncoding NameIn_Russian_SortedInRussian | CodePageEncoding NameIn_Russian_SortedInRussian | CodePageEncoding NameIn_Russian_SortedInRussian | CodePageEncoding NameIn_Russian_SortedInRussian | CodePageEncoding NameIn_Russian_SortedInRussian | CodePageEncoding NameIn_Russian_SortedInRussian | CodePageEncoding Anyone know how this can be done, or if it can be done in single SELECT in MySQL yet? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
weird indexing behavior in presense of LIMIT
I have a very large table, where one of the columns is color enum("red", "blue", "black") The distribution of values is 90% black, 8% blue, and 2% red. I want to be able to randomly select 10 rows matching a certain color from the table. Of course, select * from my_table where color = "black" order by rand() limit 10 is very slow because the huge table has to be sorted before the first 10 rows are selected. So what I did was create another column randomkey, wich is filled with random integers in the range [0 .. 10^6]. Then I added an index (column, randomkey). The following query usually works: select * from users where color = "black" and randomkey [random value] limit 10 However, the problem here is that only the first part of the index (column, randomkey) is used sometimes. So, if randomkey is 40, mysql basically looks through 40 rows before it finds randomkey 40. Would anybody have a clue about why this happens? I thought "limit" forced the use of all available indices. Thanks, Andrey - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Hangs on Installing all prepared tables
I'm sorry to write again, but I've gotten no response and I'm totally stuck. I'm trying to install the latest version of MySQL on a P3 running Redhat 6.2. When I run mysql_install_db, it hangs after it reports "Installing all prepared tables." I've tried setting different permissions and everything else I've found in the list archive, but nothing works. I've tried deleting everything, including the mysql user and re-making the user, and nothing. If anyone can tell me what's going on, or point me in the direction to a solution, I'd truly be grateful. I'm so frustrated. Thanks much, Ryan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: getting started...the hardest part
Hi Matthew, - Original Message - From: "Matthew P. Marino" [EMAIL PROTECTED] You've got a long way to go. "tar" is short for tape archive. It is an ancient unix utility that takes directory and file data and builds it into a contiguous data base file. This is for portability and manageability. You should have to get past "gzip" before you get to "tar". gzip is a gnu compression utility. The mysql tarball is tar'd and gzip'd so one normally has to; gzip -d mysql.tar.gz tar -xvf mysql.tar What's wrong with doing :- tar -zxvf mysql.tar.gz ?? Just about all the later tar's work fine like this, and it save doing the two step. ;) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Hmmm. Error message...
Hi Everybody! Anyone with any idea what to do I get this error message: ERROR 2002: Can't connect to local MySQL server through socket '/usr/local/common/mysql-3.23.33/data/mysql.sock' (13) H. Thanks for your time and advice. Simon __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.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 mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: building site search
At 3:29 PM -0500 4/19/01, Wade DeWerff wrote: Is the common way to index a site, then place that into a database? If so whats the best(easiest) way to index a site? Thanks Well, that's a LONG answer to a short question, but two common places to start are http://www.mnogosearch.ru/ Formerly called udmSearch, this can use MySQL as a backend; looks quite nice - Perl PHP frontends. http://www.htdig.org/ Not quite sure what it uses for its database, but I'm sure it could be hacked to use MySQL. Two other search engines are Glimpse/WebGlimpse and Swish-E, although I don't know a whole lot about them. You could also do a web search for 'text indexing', 'intranet search', or something. You have plenty of reading material then... -steve Database! Sql! Query! -- +-- KDVS 90.3fm Annual Fundraiser : 16 - 22 April 2001 --+ | Steve Edberg University of California, Davis | | [EMAIL PROTECTED] Computer Consultant | | http://aesric.ucdavis.edu/ http://pgfsun.ucdavis.edu/ | +- www.kdvs.org -+ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Newbie Linux 7 installation question
More like it has already started. Do "ps -ef | grep mysql" to find out. - Original Message - From: "Gerald Clark" [EMAIL PROTECTED] To: "Steve Tuckner" [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, April 20, 2001 0:21 Subject: Re: Newbie Linux 7 installation question chown -R mysql /var/mysql Steve Tuckner wrote: When I run safe_mysqld, it starts and ends immediatly. In the mysqld.log in /var/log it has the following: 010418 21:19:47 mysqld started 010418 21:19:47 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 010418 21:19:47 mysqld ended Below is the my.cnf file [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock [mysql.server] user=mysql basedir=/var/lib [safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid I ran mysql_install_db and it created database files in /var/lib/mysql/mysql. The file host.frm does exist in that directory. I tried copying those files /var/lib/mysql but it made no difference. I have no ethernet card in the machine and therefore it would be running as localhost. Any ideas??? 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Mysqld running as root.
The biggest help is from INSTALL-SOURCE in the source tarball. == The basic commands you must execute to install and use a *MySQL* binary distribution are: shell groupadd mysql shell useradd -g mysql mysql shell cd /usr/local shell gunzip /path/to/mysql-VERSION-OS.tar.gz | tar xvf - shell ln -s mysql-VERSION-OS mysql shell cd mysql shell scripts/mysql_install_db shell chown -R root /usr/local/mysql shell chown -R mysql /usr/local/mysql/var shell chgrp -R mysql /usr/local/mysql shell chown -R root /usr/local/mysql/bin/ shell bin/safe_mysqld --user=mysql == Ping Lu Cable Wireless Global Network Tools and Analysis Group, USA W: +1-703-292-2359 E: [EMAIL PROTECTED] -Original Message- From: Sean Strycker [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 19, 2001 7:20 PM To: MySQL Subject: Mysqld running as root. Hello, I'm a newbe to Linux and MySQL, but I'm finding it very interesting. I'll cut right to the chase - I've followed the directions in the manual for the binary install on Linux. but every time I start up the mysql daemon and do a pstree -laup, it's running as root. This is on a development / play machine so it's not that big a deal, but my system admin says that I have to run it as user=mysql. I've tried changing the mysql.server script, the my.cnf file, etc. I cant figure it out - how to make it start up and run as user=mysql!?! Anywho - any help would be appreciated. Thanks, Sean. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Indizes abschalten.
Hi. On Thu, Apr 19, 2001 at 05:41:54PM +0200, [EMAIL PROTECTED] wrote: Hallo Leute, in Oracle kann man Indizes in einer Abfrage abschalten(Full-Table-Scan). Mit +0 oder ||''. z.B.: SELECT * FROM tabelle WHERE eigenschaft||'' = 'text'; SELECT * FROM tabelle WHERE id+0 = 1; Geht das bei mySQL auch? You can answer that yourself. Compare the following: EXPLAIN SELECT * FROM tabelle WHERE id = 1; EXPLAIN SELECT * FROM tabelle WHERE id+0 = 1; and you will see that the second query, won't use the index. Bye, Benjamin. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: getting rows with max values.
Hi. On Thu, Apr 19, 2001 at 02:27:09PM -0700, [EMAIL PROTECTED] wrote: This may have been covered in the past; but, marc.theaimsgroup isn't responding so I can't run my normal search. This is even covered in the fine manual ;-) http://www.mysql.com/documentation/mysql/bychapter/manual_Tutorial.html#example-Maximum-column-group-row I'm trying to extract rows with max values within unique groups - NOT just the max values. In very watered down terms: [...] Bye, Benjamin. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Olympic style average?
Hey, Hopefully this isn't a newbie question. I'm currently using MySQL 3.23.35a and I'm looking how to get an "olympic" style average of values in a table where the top and bottom n scores are dropped from the average calculation. Example: table: opinions columns: id, score values: 19 19 19 11 110 27 28 27 26 27 The results would be: 19 27 Any ideas on how to write a select query to return the desired results? Hopefully there is an easy answer. Thanks in advance for your help. Phade. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL vs SQLServer vs PostgresSQL
Dear Kevin - (I can't resist the obvious quip.) Kevin Pratt writes: I have heard mysql is the access for unix... Yes, like emacs is the notepad for unix. Yours (in gentle jest) - Billy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php