Re: Fixed Connection Diagnostic Tool
Mike, much thanks and I have it fixed! The problem was that I screwed up setting the database permissions. I am really happy that I learned about "mysql -h" It will be a great help! Michel - Original Message - From: "Michael Dykman" To: "michel" Cc: Sent: Tuesday, July 06, 2010 7:15 PM Subject: Re: Fixed Connection Diagnostic Tool C3P0 connection does, indeed work well on remote machines.. In fact, I only deploy it locally on dev servers. My production systems all use c3p0 on remote servers. Again, if you can connect from the command line of your client machine to the server *via TCP* with the same credentials as your DataSource is using, then it will all just work fine. You appear to have specified a bind address which made local TCP connections impossible. Address that, and you sohuld have no trouble at all. - md On Tue, Jul 6, 2010 at 6:45 PM, michel wrote: Thank you all for the help and info! This error happened because I started MySQL with -bind-address=91.203.57.207; even if Softslate is given the proper IP address and port number is fails on connection pooling. I fixed the problem by setting the MySQL IP address to 127.0.0.1. I am thinking that the reason is that the C3P0 connection pooling cannot work on a 'remote' machine. Michel - Original Message - From: "Rob Wultsch" To: "michel" Cc: Sent: Tuesday, July 06, 2010 1:52 AM Subject: Re: Connection Diagnostic Tool On Mon, Jul 5, 2010 at 3:55 PM, michel wrote: I have been trying to figure this one out, but I don't have the skill sets here so I can use some help. I tried ' -h 127.0.0.1' in my bash shell and I get a command not found, so I am still really off-the-mark. Is there a place on the net I can look up what it does and how to run it? Thanks! I am pretty sure Michael that meant running the command line mysql client: mysql -uuser -ppass -h127.0.0.1 -e 'select "hello world!"' -- Rob Wultsch wult...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=compu...@videotron.ca -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=mdyk...@gmail.com -- - michael dykman - mdyk...@gmail.com May the Source be with you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=compu...@videotron.ca -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Fixed Connection Diagnostic Tool
Thank you all for the help and info! This error happened because I started MySQL with -bind-address=91.203.57.207; even if Softslate is given the proper IP address and port number is fails on connection pooling. I fixed the problem by setting the MySQL IP address to 127.0.0.1. I am thinking that the reason is that the C3P0 connection pooling cannot work on a 'remote' machine. Michel - Original Message - From: "Rob Wultsch" To: "michel" Cc: Sent: Tuesday, July 06, 2010 1:52 AM Subject: Re: Connection Diagnostic Tool On Mon, Jul 5, 2010 at 3:55 PM, michel wrote: I have been trying to figure this one out, but I don't have the skill sets here so I can use some help. I tried ' -h 127.0.0.1' in my bash shell and I get a command not found, so I am still really off-the-mark. Is there a place on the net I can look up what it does and how to run it? Thanks! I am pretty sure Michael that meant running the command line mysql client: mysql -uuser -ppass -h127.0.0.1 -e 'select "hello world!"' -- Rob Wultsch wult...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=compu...@videotron.ca -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
re: Connection Diagnostic Tool
I have been trying to figure this one out, but I don't have the skill sets here so I can use some help. I tried ' -h 127.0.0.1' in my bash shell and I get a command not found, so I am still really off-the-mark. Is there a place on the net I can look up what it does and how to run it? Thanks! - Original Message - From: "Michael Dykman" To: "michel" Sent: Saturday, July 03, 2010 11:37 PM Subject: Re: Connection Diagnostic Tool You are right.. Java never coonnects on that domain socket, it *always* used TCP. Check your credentials at the command line using -h 127.0.0.1 (or even the LAN ip, depending on how your JDBC connections are configured) which will force your client to connect via TCP, just as Java will. I expect that you will find that there are permission errors preventing the TCP connec which are not obvious when connecting via the domain socket. - michael On Sat, Jul 3, 2010 at 11:14 PM, michel wrote: Michael, I am able to connect using the socket, so MySQL is working fine. The problem is when 'SoftSlate Commerce' tries to connect as localhost. From what I have been reading I am using the 'mysql.sock', but it's not at the default '/tmp/mysql.sock', it's created in "/home/sgdev/mysql"; so it may bew that I need a way to specify to 'SoftSlate Commerce' where the socket is. Regards, Michel - Original Message - From: "Michael Dykman" To: "michel" Cc: Sent: Saturday, July 03, 2010 2:43 PM Subject: Re: Connection Diagnostic Tool I use c3p0 to manage MySQL connections in my JVM stack and have for years in many installations, I have never had to do anything special. If I can connect to the server through the console at the command line of the client machine using the same credentials, then the stack will just work. Are you using Tomcat's JNDI config? I have always found those to be a pain.. I manage my DataSource via Spring which I find to be much more portable. At the end of the day, if you are able to connect manually as described above but your Tomcat application cannot, it's is not a MySQL problem.. It's more likely a Tomcat/JNDI problem. If you can't connect via the command line (same client, same host, same credentials), then we have a MySQL issue we can address as such. - michael dykman On Sat, Jul 3, 2010 at 8:08 AM, michel wrote: I am setting up the Softslate web store package that uses Hibernate to connect to MySQL. Softslate fails to connect to MysQL on the c3p0 connection pooling. While I would love to solve this little problem it would be wiser if I learn to diagnose the problem. Is there a tool that can run on the Tomcat server that can help me replicate/diagnose the problem? Softslaste is running on the same box as MySQL. Thank you! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=mdyk...@gmail.com -- - michael dykman - mdyk...@gmail.com May the Source be with you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=compu...@videotron.ca -- - michael dykman - mdyk...@gmail.com May the Source be with you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Connection Diagnostic Tool
I am setting up the Softslate web store package that uses Hibernate to connect to MySQL. Softslate fails to connect to MysQL on the c3p0 connection pooling. While I would love to solve this little problem it would be wiser if I learn to diagnose the problem. Is there a tool that can run on the Tomcat server that can help me replicate/diagnose the problem? Softslaste is running on the same box as MySQL. Thank you! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Install mysql-workbench bug
I am installing mysql-workbench- oss-5.1.16. tar.gz on Linux and I hit this bug during "./configure" "cannot find install-sh or install.sh" I checked and the file install-sh is in the directory ... /mysql-workbench- oss-5.1.16. I have also installed a lot of other software in the server without running into this problem. Thanks!
Setting up host password on a shared server
I have MySQL set up and running, but I am under the impression that I am unable to password protect it properly because I can't protect it as root user. From what I've been reading I should be setting it up as mysqladmin -u root password _thepassword_ But with phpMyAdmin I can still log in as other users. Is there a way around this? I am under the impression that I could not. Much thanks for any help! Michael Katz
Re: Still going in cicrles
Simon, I am totally new to MySQL and followed some instructions from the internet. Here is the install script I put together that seems to work. cd /home/qsys gzip -cd /home/qsys/mysql-5.1.32.tar.gz | tar xf - mv /home/qsys/mysql-5.1.32 /home/qsys/mysql-5.1.32.source cd /home/qsys/mysql-5.1.32.source ./configure --help --verbose ./configure --prefix=/home/qsys/mysql-5.1.32 --with-unix-socket-path=/home/qsys/mysql-5.1.32/mysql.sock --with-tcp-port=3305 make make install cd /home/qsys/mysql-5.1.32 mkdir /home/qsys/mysql-5.1.32/var # create the directory to generate test file alpha.lower.test /home/qsys/mysql-5.1.32/bin/mysql_install_db /home/qsys/mysql-5.1.32/libexec/mysqld --general-log=Enable \ --log-output=FILE \ --general_log=/home/qsys/MySQL.log \ --log-error=/home/qsys/MySQL.log \ --bind-address=91.203.57.197 - Original Message - From: "Simon J Mudd" To: Sent: Sunday, May 10, 2009 8:03 AM Subject: Re: Still going in cicrles compu...@videotron.ca (michel) writes: I might have it fixed! I tried /home/qsys/mysql-5.1.32/libexec/mysqld and I would get /home/qsys/mysql-5.1.32/libexec/mysqld: Table 'mysql.plugin' doesn't exist 090510 0:19:54 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 090510 0:19:54 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist So you had built the binaries by didn't have an initial mysql database created? From reading around I tried running /home/qsys/mysql-5.1.32/bin/mysql_install_db /home/qsys/mysql-5.1.32/libexec/mysqld and now I get 090510 0:32:38 [Note] Event Scheduler: Loaded 0 events 090510 0:32:38 [Note] /home/qsys/mysql-5.1.32/libexec/mysqld: ready for connections. Version: '5.1.32' socket: '/home/qsys/mysql-5.1.32/mysql.sock' port: 3305 Source distribution This looks correct. I would suggest that the developers team might change the error messages. Indeed, I'll create a bug report for this. http://bugs.mysql.com/44765 Simon -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=compu...@videotron.ca -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Still going in cicrles
Simon, I might have it fixed! I tried /home/qsys/mysql-5.1.32/libexec/mysqld and I would get /home/qsys/mysql-5.1.32/libexec/mysqld: Table 'mysql.plugin' doesn't exist 090510 0:19:54 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 090510 0:19:54 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist From reading around I tried running /home/qsys/mysql-5.1.32/bin/mysql_install_db /home/qsys/mysql-5.1.32/libexec/mysqld and now I get 090510 0:32:38 [Note] Event Scheduler: Loaded 0 events 090510 0:32:38 [Note] /home/qsys/mysql-5.1.32/libexec/mysqld: ready for connections. Version: '5.1.32' socket: '/home/qsys/mysql-5.1.32/mysql.sock' port: 3305 Source distribution I would suggest that the developers team might change the error messages - Original Message - From: "Simon J Mudd" To: Sent: Sunday, May 10, 2009 5:20 AM Subject: Re: Still going in cicrles compu...@videotron.ca (michel) writes: I set up MySQL and when I try to start it it fails telling me that I need to run 'mysql_upgrade'. Show us the full error output and provide information on the version of MySQL you are using. When I run 'mysql_upgrade' it runs 'mysqlcheck' which is supposed to only be run when the server works ... No, mysql_upgrade does call mysqlcheck to see if things need adjusting. Look at the documentation http://dev.mysql.com/doc/refman/5.1/en/mysql-upgrade.html Look at http://dev.mysql.com/doc/refman/5.1/en/upgrade.html which gives information on upgrading MySQL. However be careful as IMO this documentation can be a bit confusing and is incomplete. Nevertheless it's a good starting point. If however you don't think you are upgrading then you need to provide more information on how you are installing MySQL so we can determine why MySQL thinks that it needs to do an upgrade. My guess would be that you have multiple mysql binaries on your server and are not running the version you expect. Simon -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=compu...@videotron.ca -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Still going in cicrles
I set up MySQL and when I try to start it it fails telling me that I need to run 'mysql_upgrade'. When I run 'mysql_upgrade' it runs 'mysqlcheck' which is supposed to only be run when the server works ...
my.cnf file
I set up mysql and can't start it because I need to hard code the IP address parameter (bind-address) into my.cnf ... but I have three of them in different sub directories of /mysql/mysql-test/suite Should there not be one basic one?
configure parameters
Is there a place on the net that has detailed documentation on the possible parameters? I am doing a quick google and can't find it. Thanks! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Fw: mysqlcheck: Got error 202: Can't connect to local MySQL server through socket '/home/qsys/mysql-5.1.32/temp/mysql.sock'
Sorry for the bad end of lines in the first message! I am trying to set up MySQL on a GNU/Linux box with this script:cd /home/qsys gzip -cd /home/qsys/mysql-5.1.32.tar.gz | tar xf - mv /home/qsys/mysql-5.1.32 /home/qsys/mysql-5.1.32.source cd /home/qsys/mysql-5.1.32.source ./configure --prefix=/home/qsys/mysql-5.1.32 \ --with-unix-socket-path=/home/qsys/mysql-5.1.32/tmp/mysql.sock make make install mkdir /home/qsys/mysql-5.1.32/var /home/qsys/mysql-5.1.32/bin/mysql_upgrade at this point I get mysqlcheck: Got error 202: Can't connect to local MySQL server through socket '/home/qsys/mysql-5.1.32/temp/mysql.sock' I have tried: 1- adding this to configure --with-mit-threads=no and the parameter is not recognized as valid. 2 - 'make clean NATIVE_THREADS=yes' and 'make install clean # NATIVE_THREADS=YES' without it working either ... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
mysqlcheck: Got error 202: Can't connect to local MySQL server through socket '/home/qsys/mysql-5.1.32/temp/mysql.sock'
I am trying to set up MySQL on a GNU/Linux box with this script:cd /home/qsys gzip -cd /home/qsys/mysql-5.1.32.tar.gz | tar xf - mv /home/qsys/mysql-5.1.32 /home/qsys/mysql-5.1.32.source cd /home/qsys/mysql-5.1.32.source ./configure --prefix=/home/qsys/mysql-5.1.32 \ --with-unix-socket-path=/home/qsys/mysql-5.1.32/tmp/mysql.sock make make install mkdir /home/qsys/mysql-5.1.32/var /home/qsys/mysql-5.1.32/bin/mysql_upgradeat this point I get mysqlcheck: Got error 202: Can't connect to local MySQL server through socket '/home/qsys/mysql-5.1.32/temp/mysql.sock'I have tried:1- adding this to configure --with-mit-threads=no and the parameter is not recognized as valid.2 - 'make clean NATIVE_THREADS=yes' and 'make install clean # NATIVE_THREADS=YES' withouit it working either ...
Re: avoiding use of NullsA
It seems that someone got bitten very hard in a soft area by a Null one day. On a more practical level, Oracle recommended to design the table with the field where NULLs are to be expected at the end of the table, that saves a little space and two, as the use of indexes is invalidated in case of nulls its is better to place the important indexed fields toward the beginning of the table. michel --- avast! Antivirus: Outbound message clean. Virus Database (VPS): 090313-0, 03/13/2009 Tested on: 3/14/2009 10:23:29 AM avast! - copyright (c) 1988-2009 ALWIL Software. http://www.avast.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Installing MySQL from source
>From the different documentation I was reading that after going to the root >directory I should execute /.configure; but there is no configure file in the >root source directory, just configure.in
INSERT queries hang on amd64
Problem: INSERT queries hang on amd64. This looks a lot like Don MacAskill's bugreport in http://bugs.mysql.com/bug.php?id=3483 I've just upgraded from 4.1.9 to 4.1.10 on a dual opteron with 8G ram, running Debian 3.1. Also tried 4.0.23 last week, but that had the same problems. Kernels I've tried are 2.6.11-rc1-mm1 and 2.6.11-rc2. I'm running 2 boxes in a replication setup, using the amd64 as the master (or standalone) gave me pretty much what Don describes in bug 3483, insert queries start hanging after a while with no way to kill them except kill -9 from the OS, which is a bit drastic. ;-) The master or standalone setup required quite a bit of poking to get it to happen in a test environment, or just a couple of short hours running as a production server. I haven't been able to narrow it down to a specific thing, but it appears to have something to do with indexes. I hacked up a test script that's throwing a random selection of selects and inserts at it at random intervals between 0 and 2 seconds, from 20 concurrent threads. I could trigger it by running a "repair table" on it while the test script was running. The repair thread would wait for its turn, then lock everything else out, and when it was done the first insert after that would hang indefinitely. (Left it hanging over the weekend, nothing.) Adding "skip-concurrent-insert" fixes the problem, but cripples the performance so that's not really an option. Then tried to run one of the amd64 boxes as a slave off of a xeon box: Same problem, the replication thread hangs within seconds of starting the server, and again won't budge for anything except kill -9. This is on a server without _any_ other connections except for a processlist. I've run out of things to try, so I hope someone here can help... my.cnf: [mysqld] user=mysql socket=/tmp/mysql.sock skip-locking set-variable= key_buffer=2G set-variable= table_cache=1024 set-variable= sort_buffer=16M set-variable= read_buffer=16M set-variable= max_allowed_packet=10M set-variable= thread_cache=64 set-variable= tmp_table_size=16M set-variable= interactive_timeout=600 set-variable= wait_timeout=600 set-variable= max_connections=1024 set-variable = query_cache_type=2 set-variable = query_cache_size=100M set-variable= join_buffer_size=8M set-variable = thread_concurrency=4 set-variable= myisam_sort_buffer_size=64M skip-innodb -- Michel Buijsmantty.nl -- 2dehands.nl -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: [MySQL General] INSERT queries hang on amd64
On Wed, Feb 16, 2005 at 12:41:04PM +0100, Michel Buijsman wrote: > My problem: INSERT queries hang on amd64. Sorry about the multiple mails, mysql.com's mailinglist software does annoying things with the wrong adresses... -- Michel Buijsmantty.nl -- 2dehands.nl -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
INSERT queries hang on amd64
Problem: INSERT queries hang on amd64. This looks a lot like Don MacAskill's bugreport in http://bugs.mysql.com/bug.php?id=3483 I've just upgraded from 4.1.9 to 4.1.10 on a dual opteron with 8G ram, running Debian 3.1. Also tried 4.0.23 last week, but that had the same problems. Kernels I've tried are 2.6.11-rc1-mm1 and 2.6.11-rc2. I'm running 2 boxes in a replication setup, using the amd64 as the master (or standalone) gave me pretty much what Don describes in bug 3483, insert queries start hanging after a while with no way to kill them except kill -9 from the OS, which is a bit drastic. ;-) The master or standalone setup required quite a bit of poking to get it to happen in a test environment, or just a couple of short hours running as a production server. I haven't been able to narrow it down to a specific thing, but it appears to have something to do with indexes. I hacked up a test script that's throwing a random selection of selects and inserts at it at random intervals between 0 and 2 seconds, from 20 concurrent threads. I could trigger it by running a "repair table" on it while the test script was running. The repair thread would wait for its turn, then lock everything else out, and when it was done the first insert after that would hang indefinitely. (Left it hanging over the weekend, nothing.) Adding "skip-concurrent-insert" fixes the problem, but cripples the performance so that's not really an option. Then tried to run one of the amd64 boxes as a slave off of a xeon box: Same problem, the replication thread hangs within seconds of starting the server, and again won't budge for anything except kill -9. This is on a server without _any_ other connections except for a processlist. I've run out of things to try, so I hope someone here can help... my.cnf: [mysqld] user=mysql socket=/tmp/mysql.sock skip-locking set-variable= key_buffer=2G set-variable= table_cache=1024 set-variable= sort_buffer=16M set-variable= read_buffer=16M set-variable= max_allowed_packet=10M set-variable= thread_cache=64 set-variable= tmp_table_size=16M set-variable= interactive_timeout=600 set-variable= wait_timeout=600 set-variable= max_connections=1024 set-variable = query_cache_type=2 set-variable = query_cache_size=100M set-variable= join_buffer_size=8M set-variable = thread_concurrency=4 set-variable= myisam_sort_buffer_size=64M skip-innodb -- Michel Buijsmantty.nl -- 2dehands.nl -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
INSERT queries hang on amd64
My problem: INSERT queries hang on amd64. This looks a lot like Don MacAskill's bugreport in http://bugs.mysql.com/bug.php?id=3483 Which is listed as closed, but the bug is apparently still there so maybe it should be reopened... I've just upgraded from 4.1.9 to 4.1.10 (binary) on a dual opteron with 8G ram, running Debian 3.1 pure64 gcc-3.4. Also tried 4.0.23 last week, but that had the same problems. Kernels I've tried are 2.6.11-rc1-mm1 and 2.6.11-rc2. I'm running 2 boxes in a replication setup, using the amd64 as the master (or standalone) gave me pretty much what Don describes in bug 3483, insert queries start hanging after a while with no way to kill them except kill -9 from the OS, which is a bit rough. ;-) The master or standalone setup required quite a bit of poking to get it to hang in a test environment, or just a few short hours running as a production server. I haven't been able to narrow it down to one specific thing, but it appears to have something to do with indexes, because it ran fine after dropping all of them. I hacked up a test script that's throwing a random selection of selects and inserts at it at random intervals between 0 and 2 seconds, from 20 concurrent threads. I could trigger it by running a "repair table" on it while the test script was running. The repair thread would wait for its turn, then lock everything else out and do its thing, and when it was done the first insert after that would hang indefinitely. (Left it hanging over the weekend, nothing.) Adding "skip-concurrent-insert" fixes the problem, but cripples the performance so that's not really an option. Then tried to run one of the amd64 boxes as a slave off of a xeon box: Same problem, the replication thread hangs within seconds of starting the server, and again won't budge for anything except kill -9. This is on a server without _any_ other connections except for a processlist. I've run out of things to try, so I hope someone here can help... my.cnf: [mysqld] user=mysql socket=/tmp/mysql.sock skip-locking set-variable= key_buffer=2G set-variable= table_cache=1024 set-variable= sort_buffer=16M set-variable= read_buffer=16M set-variable= max_allowed_packet=10M set-variable= thread_cache=64 set-variable= thread_stack=512K set-variable= tmp_table_size=16M set-variable= interactive_timeout=600 set-variable= wait_timeout=600 set-variable= max_connections=1024 set-variable= query_cache_type=2 set-variable= query_cache_size=100M set-variable= join_buffer_size=8M set-variable= thread_concurrency=4 set-variable= myisam_sort_buffer_size=64M skip-innodb -- Michel Buijsmantty.nl -- 2dehands.nl -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
importing datas
Hi, Here is my problem : I want to copy datas from an existing website to my local website. The website is a collection of images with thumbnails. With phpMyAdmin, i made an export of the image table and i have a 16 MB file 'image.sql' containing sql orders to create table and insert values. With phpMyAdmin of local website, I tried to execute that sql file but got errors related to memory allowed to php (2 MB max). I tried to modify 'memory_limit', 'upload_max_filesize' in "/etc/php.ini" but still got errors. So I tried with mysql tools. with "source /path/image.sql;" the table is created but i got the following error : ERROR 1153: Got a packet bigger than 'max_allowed_packet' I've seen threads in this list about same error, but I feel i'm in a wrong way... What would be a "good" way of doing that export/import of datas ? What to do if I want to upload bigger datas on the existing website ? (I only have a phpMyAdmin access) Sorry if the answer is obvious, but I'm new to MySQL, phpMyAdmin. My local config is PowerMac G4, Mac OS X 10.3.5, MySQL 4.0.21 Thanks in advance Michel RENON -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Terminology question
I've read it now a few times around here and was curious what "innodb" means. Is it a table-type for MySQL or a completely different DBMS? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Problem with ADO, MyOLEDB and BigInt columns
Hi, I am trying to access a third party MySQL table containing a BigInt field, using ADO with a MyOLEDB driver. The problem is that all this field ever returns are 0's. I tried using ODBC with the Convert BigInt to Int option but then the numbers get truncated. Is there a way around this? Thanks in advance, Andre M. Descombes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 compiling MySQLGUI source rev 1.7.5
Hello I have a compilation problem with MySQLGUI. I have downloaded ans installed MySQL using the following version mysql-3.23.52 Msql-Mysql-modules-1.2219 DBI-1.18 Data-Dumper-2.101 MySQL pass all the tests and work OK. then MYSQLGUI using the following version fltk-1.0.9 mysql++-1.7.9 fl_editor-0.4 mysqlgui-src-1.7.5 In mysqlgui-src-1.7.5, I have updated the Makefile to use the correct version of mysql++ When I compile MySQLGUI, I get the following error message when compiling the file main.cc : g++ -O3 -g -pipe -fforce-mem -fforce-addr -I. -I../mysql++-1.7.9/sqlplusint -I/usr/local/include/mysql -c main.cc main.cc: In function `void if_conn()': main.cc:464: no matching function for call to `MysqlConnection::clinet_info ()' main.cc:529: no matching function for call to `MysqlConnection::clinet_info ()' make: *** [main.o] Error 1 The others files compile OK. I have spend several days on this and I have not found the error, Is it a known bug ? and have you a solution to this problem. Many thanks for your answer Michel DROZ [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: Copying data from one table to another.
I think what you are looking for is the Insert...Select statement http://www.mysql.com/doc/I/N/INSERT_SELECT.html Sheridan Saint-Michel Website Administrator FoxJet, an ITW Company www.foxjet.com - Original Message - From: "Eric Spletzer" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, September 10, 2001 4:38 PM Subject: Copying data from one table to another. > Hello, I'm a newbie, so pardon my lack of wherewithal with MySQL, and thanks > for the help in advance. > > I have two table and I want to copy info from one table to another. I can > pull the correct information out with a select statement that looks > something like this > > Select x1 from tbl1, tbl2 where y1 = y2 > > (numbers correspond to different tables) > > This returns a table of the info I want to use. Logically, what I would > like to do is: > > Update tbl1 set x1 = x2 where y1 = y2; > > But this won't work because x1 and x2 are from different tables, as are y1 > and y2. However, I've tried including tbl2 in the update parts, and that > doesn't work either. I'm at a loss. > > Thanks for any help. > > -eric spletzer > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > 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
Seemingly Strange Variable Behavior
I ran into this and was hoping someone on this list can explain this behavior to me. Lets say I have the table "table" which has id and name, and five rows of data. I am using the query select table.*,if(@count,@count:=@count+1,@count:=1) as count, from table; What I get is id, name, and five rows of 1's under count. Now If I do set @count=NULL; select table.*,if(@count,@count:=@count+1,@count:=1) as count, from table; the count column has 1,2,3,4,5 When I do select @count immediately upon opening MySQL it returns NULL. So why do I get the expected result when I do set @count=NULL; but an entire column of 1's when I don't... even though @count returns NULL? Sheridan Saint-Michel Website Administrator FoxJet, an ITW Company www.foxjet.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
AW: Setup own DB for each user?
> > > Or you can add > > safe_show_database > > to your my.cnf, or call safe_mysqld with the added option " > --safe_show_database" do you have to compile mysql with some special parameter? My version (3.23.37, SuSE rpm) fails with a "unrecognized command" error when I try to start it after having inserted "safe_show_databases" or "skip_show_databases" into my.cnf - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Setup own DB for each user?
Hi all, I am running a webhosting server using SuSE 7.2 /mysql 3.23 /php 4. We are hosting a small amount of virtual servers, allowing our customers to user php and mysql. My problem is that every user sees every other users databases. Is there a way to setup mysql so that every local user has his own empty database? Please tell me how this has to be set up. Thanks Ulv - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: deleing exactly the same rows from a table?
> Hi, I am curious if there is a way to delete exactly the same rows from a > table with one query? > Or must I do select and delete one query at a time? > I accidentally parse an html file twice, and I want to keep the rows that > are distinct. bonjour, use: deletewhere some-matching-pattern limit 1; jean-michel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: I blew it big time... locked myself out of mysql
> simrad_4# safe_mysqld --skip-grant-tables & > [1] 57953 > simrad_4# Starting mysqld daemon with databases from /var/db/mysql > simrad_4# mysql > Welcome to the MySQL monitor. Commands end with ; or \g. > Your MySQL connection id is 1 to server version: 3.23.38 > Type 'help;' or '\h' for help. Type '\c' to clear the buffer > mysql> grant all privileges on *.* to root@localhost identified by 'xx'; > ERROR 1047: Unknown command bonjour, I get this error once. My root was'nt really root so couldn't use GRANT command. That is the same for a bash command you're not allowed to use as normal user. You need add a root password: [shell]mysql -u root mysql mysql> update user set Password=password('x') wher User='root'; jean-michel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 -- Error codes
> Hi, > > I'm new to mysql. I've installed an RPM undr Linux PPC and after running mysql >server as root and trying to use a sample database from Paul Dubois book MySql, I ' >ve got the error 13, can't create directory/file ./samp_db/president.xxx. > > The thing is I'm using an example DB, any help ? Where I can find out what the codes >mean ? > > Regards, > > Rick bonjour, did you ran mysql_install_db script ? jean-michel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Inserting rows in MySQL using PHP
> > When i try to insert records into a mysql table through a php script, it > > is not inserting all the records. eg, i tried to insert 100 records, it is > > inserting only 94 records... > > plese help me in sorting out this problem bonjour, trying to insert duplicate rows in a unique field can do this kind of non-inserting problem. query, database jean-michel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Pattern matching queries
> (REGEXP). > > I have a text field that contains some plain text intermingled with html > tags. In querying the database, if the keyword I'm searching for falls > within the plain text, that record should be returned. However, if the > keyword falls within an html tag, it should not be returned. Could somebody > assit me in putting such a regular expression query together? > > Any assistance would be greatly appreciated... thanx! > database, query bonjour, SELECT fields from my_table WHERE my_field not regexp '^.*\<.+\>.*$'; ^ for searching at beginning of string \< for searching < .* searches anything or nothing .+ searches one carachter at least \> searches > $ means end of string or simply: ...not regexp '\<.+\>'; it depends of the importance of the html tags's position in your query. if you mean html tag = and if i do understand what you mean with my poor english... jean-michel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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/php
> I am trying to use php to print my results. This is my code (I have checked > to see if fields are correct with regards to spelling and so on): > > printf("Genus: %s\n", mysql_result($result,0,"genus")); > > and I get the error message: > > Warning: Supplied argument is not a valid MySQL result resource in > /home/sites/site197/web/practice/phpmysqlpract.php on line 26 > Genus: Bonjour, mysql_result's syntax seems to be OK. check code for $result jean-michel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: GRANT ANNOYANCE REVISITED
> >Thank you all for your original suggestions, but I'm still having problems. > >I copied this verbatim from the MySQL docs and tried it on two seperate > >servers: > > > >mysql> GRANT ALL PRIVILEGES ON *.* TO monty@"%" > > ->IDENTIFIED BY 'some_pass' WITH GRANT OPTION; > >ERROR 1047: Unknown command Bonjour, Are root privileges really established? I had that error message once a day. If root password is not set, in extenso there is no root, you cannot use GRANT statement. Have a look in mysql.user table to see check for root password. jean-michel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: install problem
> Installing mysql on solaris 6 sun4u sparc SUNW,Ultra-5_10 > release: > > -- mysql-3.23.38.tar.gz > > via > ./configure --prefix=/dir --with-low-memory Is that really what you type: --prefix=/dir ? strange name for a DIRectory? Can be a reserved word. > make > make install > > I get to: > > yacc -d sql_yacc.yy && mv y.tab.c sql_yacc.cc > "sql_yacc.yy", line 71: fatal: invalid escape, or illegal reserved word: > pure_parser > make[2]: *** [sql_yacc.cc] Error 1 > make[2]: Leaving directory `/home/smith/solaris.6/mysql/sql' > make[1]: *** [install-recursive] Error 1 > make[1]: Leaving directory `/home/smith/solaris.6/mysql/sql' > make: *** [install-recursive] Error 1 > > Any ideas? > > 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 > jean-michel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Once again, this doesn't do anything.
> echo("You must review the site"); } else { > if (!isset($anegative)) { > echo("You must review the site"); } else { > connectdb(); > mysql_select_db(xtopsites); ^^ quotes > $sql = "insert into sitesats set areview='$areview', apositive='$apositive', >anegative='$anegative', arate='$arate' where id='$id'"; > $query = mysql_query($sql); > $sql = "update sitesats set validated='2' where id='$id'"; > $query = mysql_query($sql); > > echo("Review stored successfully."); > > } } } > ?> > > > > It gives me the success message but the db remains untouched. What have I done this >time? :) > > Thanks in advance. > Bonjour, mysql_select_db(string db_name); So try : mysql_select_db("xtopsites"); jean-michel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Problem -- Please help
> When I run test.php I get this: > > Warning: Supplied argument is not a valid MySQL result resource in common.php on >line 27 > 0 > > Here are lines 25-27: > 25: $sql = "select urate, arate, inhits from sitestats where id = $id"; > 26: $r = mysql_query($sql); > 27: $row = mysql_fetch_array($r); > > I thought using the result identifier returned by mysql_query in mysql_fetch_array >was perfectly legal. bonjour, Try: ...where id = '$id'"; on line 25 jean-michel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Compiling an PHP 4.0 module with MySQL
> >The Linux kernel is 2.2.13 and has been installed from a Mandrake > >distribution. This is also the source of Apache, PHP 3 and MySQL. The > >distribution puts files in non-standard places so I am wondering if the > >solution to my problem is to find the right base directory to use in the > > > >--with-mysql=/path/ syntax, and/or the "header" files are in the wrong > >place. I have searched and tried many option but with no success. Bonjour, I have a Mandrake 7.1 (2.2.15 kernel)distribution too and get problems compiling php with gd and pdf because it seems that the linker searches header files in very particular directories. So I had to mkdir /usr/local/lib/gd (and same thing with pdf) putting in .so and .h files and compilation works fine. Could it be something similar in your case? Can't you try with-mysql=/usr/local/mysql? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: problem with Grant
Have you tried 'flush privileges' after having set root password? jean-michel On Thu, 31 May 2001, Damnish wrote: > I am using MySql on linux. > I can start mysqld by "safe_mysqld --user=mysql --skip-grant-tables & > But when i try to start it withour --skip-grant-tables, it said Access > Denied @localhost. I have updated the mysql.user table and mysql.host > table, still i can't connect it . > Any help in this matter will be appriciated. > Thanks in advance. > Damnish - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Problem
On Mon, 28 May 2001, Lefebvre, Cedric wrote: > > I have a problem adapting a multiple select to MySQL. > Can someone help me ? > > Here is my request (Oracle format) > > SELECT Tactic.teamCode FROM Tactic WHERE > Tactic.teamCode NOT IN (SELECT Game.teamCode1 FROM Game, Turn WHERE > Game.gameTurn = Turn.code) > AND Tactic.teamCode NOT IN (SELECT Game.teamCode2 FROM Game, Turn WHERE > Game.gameTurn = Turn.code); > > I could use the following one, if it's easier to translate to MySQL > SELECT Tactic.teamCode FROM Tactic WHERE > Tactic.teamCode NOT IN (SELECT Game.teamCode1 FROM Game, Turn WHERE > Game.gameTurn = 3) > AND Tactic.teamCode NOT IN (SELECT Game.teamCode2 FROM Game, Turn WHERE > Game.gameTurn = 3); > bonjour, You can't use subselect. -- jean-michel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: installing mysql(password??)
On Sun, 27 May 2001, David Loszewski wrote: > > when you first install mysql server does it assign a default password > becuase it tells me to enter these in to make a password for my server, > but I don't know what the heck to do with them, but when I try them it > says access denied > > /usr/bin/mysqladmin -u root -p password 'new-password' > /usr/bin/mysqladmin -u root -h Precious -p password 'new-password' > > > Dave Bonjour, You can set a root-password starting the server with safe_mysqld --skip-grant-tables & then connect to mysql:mysql -u root then: mysql> update user set password=password(the-password-I-want) where user = 'root'; You use the password() function to set a new password. -- jean-michel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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/php problem.
On Fri, 25 May 2001, Stephanie Deville wrote: > I'm running FreeBSD 3.4, Apache 1.3.9 w/ php4 and mysql 3.22.32. The > problem I'm having is that my php scripts work fine, mysql works fine. When > I run a php script, everthing in the script works up to the point were I try > mysql_connect. I get no error, but the script just hangs. It never > connects to the database. I've looked through all my logs, and there are no > errors listed anywhere. Any ideas? > > Stephanie DeVille bonjour, Can you give us an idea of your script? -- jean-michel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 and PHP4
On Fri, 25 May 2001, Andrey Kotrekhov wrote: > I don't agree. > If mysql install in other directory then /usr/local > you need use --with-mysql=mysqldir > and sometimes --with-mysql-include and --with-mysql-lib > options. > > > Do you need to specify a directory? I just did --with-mysql > > > > At 01:14 PM 5/24/2001 -0400, Bill Tangren wrote: > > >When I compile PHP4 (4.04pl1) with the option --with-mysql=mysqldir... > > > > > >I get the error > > > > > >'cannot find mysqlclient library under mysqldir' > > > > > >I did a search through the mysqsl (3.23.38) source code after I compiled > > >it, and I don't find that library anywhere? What am I doing wrong? bonjour, I compiled mysql with --prefix=/usr/local/mysql and then php: CPPFLAGS=-I/usr/local/mysql/include/mysql ./configure --with-mysql=/usr/local/mysql -- jean-michel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Password security
On Sun, 29 Apr 2001, Philippe Louis Houze wrote: > Date: Sun, 29 Apr 2001 10:56:52 -0400 > From: Philippe Louis Houze <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Subject: Re: Password security > > Hi, > > How do you keep MySQL password out of view of "visitors" when needed in PHP to >access the db. The password is in plain english in all the php files, and can be >easily downloaded by anyone. > > Philippe > > ex: > > mysql_select_db("database"); > ?> and in variables.php3 file and protect include-directory with .htaccess -- jean-michel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: File Not Found Error
On Wed, 25 Apr 2001, newsgroups wrote: > Date: Wed, 25 Apr 2001 20:15:07 -0400 > From: newsgroups <[EMAIL PROTECTED]> > To: MySQL-Group <[EMAIL PROTECTED]> > Subject: File Not Found Error > > Sorry to be such an everything newbie. Perhaps this a unix error and not > MySQL but a simple Describe statement reports that a *.frm file is missing, > yet that file exists in the same folder. What could be wrong? Sorry about > the long LS. TIA, John ... > > # mysql -p mysql > > Didn't find any fields in table 'adminedit' > Didn't find any fields in table 'levelone' > Didn't find any fields in table 'members' > > mysql> show tables; > +-+ > | Tables_in_mysql | > +-+ > | adminedit | > | columns_priv| > | db | > | func| > | host| > | levelone| > | members | > | tables_priv | > | user| > +-+ > 9 rows in set (0.00 sec) > Bonjour, It sometimes happens to me with mysql 3.22.32 (rpm) on mandrake 7.1. Somes files become uid/gid root/root instead of mysql/mysql. So I need to change file permissions. May be someone get an answer? I apologize for my poor english... -- jean-michel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ERROR 1046: No Database Selected
On Fri, 20 Apr 2001, Siomara Pantarotto wrote: > Date: Fri, 20 Apr 2001 19:35:52 -0300 > From: Siomara Pantarotto <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED] > Subject: ERROR 1046: No Database Selected > > Hi all, > > I am getting this error > > mysql> create table Product ( > -> productID numeric(10), > -> name varchar(30), > -> primary key(productID) > -> ); > ERROR 1046: No Database Selected > mysql> > > How do I fix that please??? > > siomara mysql>use the-database-y-created-before; -- jean-michel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: relationship/field design
On Thu, 12 Apr 2001, Dennis Gearon wrote: > Date: Thu, 12 Apr 2001 15:16:42 -0700 > From: Dennis Gearon <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Subject: relationship/field design > > I have a table design question, looking for tips, not the exact sql to > create the tables. > > I have tried several solutions, and as yet, I don't like what I am > coming up with. So if someone could help me, I would be grateful. > > Assumptions: > > 's have several types, defined by a separate table: > home > work > personal business > website_admin > mobile > emergency > other > A must have 1 of any type, for account creation > and messages. > > > A may have many , only one of each type, as > desired/needed > A may use an , already being used, for account > creation, > but must use different login name/password. Message emails will > have to > be > viewed online/downloaded after a login). > (for multiple accounts off of one email address, especially for > children) > > The biggest problem seems to be structuring the tables to force the > requirement for at least ONE email address, but not having to create > lots of empty fields. > > > Sincerely, > > Dennis Gearon. Bonjour, Would it help you to have 3 tables like: 1.email_adress_type 2.email_adress_account: user_id, email_adress, adress_type,password, login 3.sub_email_adress_account: email_adress, sub_password, sub_login -- jean-michel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: client problems
On Tue, 10 Apr 2001, Erik Kabo wrote: > Date: Tue, 10 Apr 2001 18:37:17 -0400 > From: Erik Kabo <[EMAIL PROTECTED]> > Reply-To: Erik Kabo <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Subject: client problems > > Hi, > > I installed MySQL version 3.23 in RedHat 7.0 using gnorpm. After I installed > it, the server appears to be working fine, but there is no client software. > I try running "mysql" at the command prompt, but I get a command not found > error. I tried the GUI on your download page, but it just stalls at the > splash screen when I try to run it. Can you tell me where to get a client > that works? > > Thanks, > Erik > [EMAIL PROTECTED] > I needed to install MySQL rpm AND MySQL-client rpm in Mandrake 7.1 jean-michel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Pb with configure
>Description: checking return type of sprintf... configure: error: can not run test program while cross compiling >How-To-Repeat: just launch ./configure >Fix: ? >Submitter-Id: >Originator:[EMAIL PROTECTED] >Organization: ATCHIK >MySQL support: none >Synopsis: checking return type of sprintf... configure: error: can not run test program while cross compiling >Severity: critical >Priority: high >Category: mysql >Class: >Release: mysql-3.23.36 (Source distribution) >Environment: System: SunOS Solstice 5.6 Generic_105181-26 sun4u sparc SUNW,Ultra-5_10 Architecture: sun4 Some paths: /usr/local/bin/perl /usr/local/bin/make /usr/local/bin/gcc GCC: Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.6/2.95.3/specs gcc version 2.95.3 20010315 (release) Compilation info: CC='gcc' CFLAGS='' CXX='gcc' CXXFLAGS='' LDFLAGS='' LIBC: -rw-r--r-- 1 bin bin 1610172 Mar 31 08:09 /lib/libc.a lrwxrwxrwx 1 root root 11 Apr 10 08:33 /lib/libc.so -> ./libc.so.1 -rwxr-xr-x 1 bin bin 1015768 Mar 31 08:09 /lib/libc.so.1 -rw-r--r-- 1 bin bin 1610172 Mar 31 08:09 /usr/lib/libc.a lrwxrwxrwx 1 root root 11 Apr 10 08:33 /usr/lib/libc.so -> ./libc.so.1 -rwxr-xr-x 1 bin bin 1015768 Mar 31 08:09 /usr/lib/libc.so.1 Configure command: ./configure --with-unix-socket-path=/var/tmp/mysql.sock --with-low-memory - -with-mit-threads=yes --without-perl --enable-thread-safe-client --with-berk eley-db --with-innobase Perl: This is perl, version 5.005_03 built for sun4-solaris Michel AVERSENG 05 31 34 77 05 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: rpm with php
On Fri, 6 Apr 2001, Kenneth wrote: > Date: Fri, 6 Apr 2001 10:22:29 +0800 > From: Kenneth <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Subject: rpm with php > > Hello All, > > I'm trying to install MySQL RPM with php. > Should I use: > > --with-mysql or > > --with-mysql=/usr/bin or > > --with-mysql=/path/to/mysql ? > > Thanks for any suggestion/comment in advance! > > bonjour, --with-mysql=path/to/mysql is a configure option when compiling php from sources. Use only rpm -ivh mysql-rpm -- jean-michel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Duplicate of Everything in Table
On Fri, 6 Apr 2001, Vigile wrote: > Date: Fri, 6 Apr 2001 01:26:05 -0400 > From: Vigile <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Subject: Duplicate of Everything in Table > > I have a table, that DOES NOT have a primary key, but is setup like this: > > Field Type Attributes Null Default Extra Action > PageID int(11)No 0Change Drop Primary Index Unique > ArticleID int(11)No 0Change Drop Primary Index Unique > PageTitle textNo Change Drop Primary Index Unique > Text textNo Change Drop Primary Index Unique > > > However, for some reason (I think I know why, but its not important) I have two of >every entry. Such as this: > > 169words words > 269words words more > 369words words most > 169words words > 269words words more > 369words words most > > So, when I am calling info from this database, I get doubles of each result. How >can I delete just one of each entry, so I am left with just: > > 169words words > 269words words more > 369words words most > > I can't do the delete that I was thinking about: > > Delete FROM Pages Where Pageid=1 and articleid=69 because that would delete BOTH of >them. Doh! Any help? > > > Ryan Shrout > Production Manager > Athlonmb.com > http://www.athlonmb.com > [EMAIL PROTECTED] > > > bonjour, is: delete from Pages where PageId='1' enough? jean-michel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Foreign Keys
On Thu, 5 Apr 2001, Dennis Gearon wrote: > Date: Thu, 05 Apr 2001 14:24:25 -0700 > From: Dennis Gearon <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Subject: Foreign Keys > > Are people using Mysql using foreign keys and how are they using them? > It seems that the way to use them is with the scripting language used to > access the database. bonjour, neither foreign keys nor need for foreign keys using mysql. Use WHERE clause. -- jean-michel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: NEW "MAKE" BUG? sigcontext.h
On Mon, 2 Apr 2001, Derek Sivers wrote: > Date: Mon, 02 Apr 2001 19:42:18 -0700 > From: Derek Sivers <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Subject: NEW "MAKE" BUG? sigcontext.h > > Doing a "make" on the newest MySQL stable 3.23.36 source tarball - on a > stock Cobalt RaQ3 (Linux 386) which I've installed MySQL on many times before. > > Got this strange error: > > > gcc -DUNDEF_THREADS_HACK -DHAVE_CONFIG_H -I./../include -I./.. -I..-O6 > -DDBUG_OFF -c readline.c > > In file included from /usr/include/signal.h:300, > from readline.c:50: > > /usr/include/bits/sigcontext.h:28: asm/sigcontext.h: No such file or directory > > > > Anyone know what it means? How would you debug this? > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > Bonjour, 1st possibility /usr/include/linux/ and /usr/include/asm/ must be linked to /usr/src/linux/include/linux/ and /usr/src/linux/include/asm/ 2nd possibility if sigcontext.h really exists, this file is not in /usr/include/bits/ where make is searching for it. ah + jm oltra - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 MySQL server...
Hi List, Whem I will go start the MySQL in Linux, receive a error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock`(111) What I do? Thanks Edgard Arthur Michel [EMAIL PROTECTED] Brazil
Problem on Installing a MySQL 3.23.32 Source Distribution on Sun Solaris 2.6 ???
I have done the source installation of MySQL 3.23.31 on Sun Solaris 2.6. I execute tests found in .../mysql-test directory using 'force' option to continue after aborted tests ( ./mysql-test-run --force). How can I do with those aborted cases, known that I have to install master-slave replication??? Can somebody help me ? here below, the log of mysql-test-run: Installing Test Databases Removing Stale Files Installing Master Databases Installing Slave Databases Starting MySQL daemon Loading Standard Test Databases Starting Tests TEST USER SYSTEM ELAPSEDRESULT alter_table 0.02 0.01 0.30 [ pass ] analyse 0.01 0.01 0.03 [ pass ] auto_increment0.01 0.02 0.16 [ pass ] bdb [ fail ] Ending Tests Shutting-down MySQL daemon Starting MySQL daemon Resuming Tests bigint0.00 0.02 0.03 [ pass ] binary0.00 0.02 0.05 [ pass ] case 0.00 0.02 0.03 [ pass ] comments 0.01 0.00 0.02 [ pass ] compare 0.01 0.01 0.03 [ pass ] . . . having0.00 0.02 0.03 [ pass ] heap 0.00 0.03 0.14 [ pass ] innobase [ fail ] Ending Tests Shutting-down MySQL daemon Starting MySQL daemon Resuming Tests ins01 0.01 0.01 0.04 [ pass ] insert0.01 0.01 0.04 [ pass ] . . . outfile 0.01 0.01 0.02 [ pass ] raid [ fail ] Ending Tests Shutting-down MySQL daemon Starting MySQL daemon Resuming Tests range 0.02 0.02 0.10 [ pass ] rename0.00 0.02 0.09 [ pass ] replace [ fail ] Ending Tests Shutting-down MySQL daemon Starting MySQL daemon Resuming Tests rollback 0.01 0.01 0.03 [ pass ] rpl01 [ fail ] Ending Tests Shutting-down MySQL daemon Starting MySQL daemon Resuming Tests rpl02 0.00 0.03 2.04 [ pass ] . . . rpl13 0.00 0.01 4.46 [ pass ] rpl14 [ fail ] Ending Tests Shutting-down MySQL daemon Starting MySQL daemon Resuming Tests rpl15 [ fail ] Ending Tests Shutting-down MySQL daemon
Is there any probleme with datatype DATE ??
I have just install the source distrib. 3.23.30g of MySQL. I have this (while I am testing ) : mysql> CREATE TABLE t1 ( datum DATE ); Query OK, 0 rows affected (0.00 sec) mysql> INSERT INTO t1 VALUES ( "2000-1-1" ); Query OK, 1 row affected (0.00 sec) mysql> INSERT INTO t1 VALUES ( "2000-1-2" ); Query OK, 1 row affected (0.00 sec) mysql> INSERT INTO t1 VALUES ( "2000-1-3" ); Query OK, 1 row affected (0.00 sec) mysql> INSERT INTO t1 VALUES ( "2000-1-4" ); Query OK, 1 row affected (0.00 sec) mysql> INSERT INTO t1 VALUES ( "2000-1-5" ); Query OK, 1 row affected (0.00 sec) mysql> SELECT * FROM t1 WHERE datum BETWEEN "2000-1-2" AND "2000-1-4"; ERROR 2013: Lost connection to MySQL server during query mysql> 010119 16:17:41 mysqld restarted When I repalce DATE by DATETIME, I have OK: mysql> drop table t1; Query OK, 0 rows affected (0.00 sec) mysql> CREATE TABLE t1 ( datum DATETIME ); ERROR 1050: Table 't1' already exists mysql> INSERT INTO t1 VALUES ( "2000-1-1" ); Query OK, 1 row affected (0.00 sec) mysql> INSERT INTO t1 VALUES ( "2000-1-2" ); Query OK, 1 row affected (0.00 sec) mysql> INSERT INTO t1 VALUES ( "2000-1-3" ); Query OK, 1 row affected (0.00 sec) mysql> INSERT INTO t1 VALUES ( "2000-1-4" ); Query OK, 1 row affected (0.00 sec) mysql> INSERT INTO t1 VALUES ( "2000-1-5" ); Query OK, 1 row affected (0.00 sec) mysql> SELECT * FROM t1 WHERE datum BETWEEN "2000-1-2" AND "2000-1-4"; +-+ | datum | +-+ | 2000-01-02 00:00:00 | | 2000-01-03 00:00:00 | | 2000-01-04 00:00:00 | | 2000-01-02 00:00:00 | | 2000-01-03 00:00:00 | | 2000-01-04 00:00:00 | +-+ 6 rows in set (0.00 sec) Can somebody tell me the reason ? Michel TIGNYEMB FTeB 01 46 12 69 45
Problem when I want to set password to root user
Here is the command : mysqladmin -u root -p password 'mysql' Enter password: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: YES)' here is mysql.trace file: .. get_charsets_dir: info: charsets dir='/opt/Pmysql/3.23.30g/share/mysql/charsets/' get_charsets_dir: info: charsets dir='/opt/Pmysql/3.23.30g/share/mysql/charsets/' server_init: general: IP Socket is 3306 server_init: general: UNIX Socket is /opt/Pmysql/3.23.30g/tmp/mysql.sock server_init: info: server started init_io_cache: info: init_io_cache: cachesize = 8192 open_table: info: inserting table 233110 into the cache open_table: info: inserting table 233d20 into the cache open_table: info: inserting table 102362b8 into the cache mi_get_status: info: key_file: 1024 data_file: 0 mi_get_status: info: key_file: 2048 data_file: 428 mi_get_status: info: key_file: 3072 data_file: 302 init_read_record: info: using rr_sequential init_io_cache: info: init_io_cache: cachesize = 16384 init_read_record: info: using rr_sequential init_io_cache: info: init_io_cache: cachesize = 16384 init_read_record: info: using rr_sequential init_io_cache: info: init_io_cache: cachesize = 16384 close_thread_tables: info: thd->open_tables=102362b8 ~THD(): info: freeing host open_table: info: inserting table 1023c710 into the cache open_table: info: inserting table 233c68 into the cache mi_get_status: info: key_file: 1024 data_file: 0 mi_get_status: info: key_file: 1024 data_file: 0 mi_rnext: error: Got error: -1, errno: 137 close_thread_tables: info: thd->open_tables=233c68 ~THD(): info: freeing host open_table: info: inserting table 1023c818 into the cache init_read_record: info: using rr_sequential init_io_cache: info: init_io_cache: cachesize = 8192 close_thread_tables: info: thd->open_tables=1023c818 ~THD(): info: freeing host handle_connections_sockets: general: Waiting for connections. create_new_thread: info: creating thread 1 create_new_thread: info: Thread 1 created ?func: info: handle_one_connection called by thread 1 ?func: info: check_connections called by thread 1 ?func: general: New connection received on socket (8) ?func: general: Host: localhost vio_read: error: Got error 11 during read ?func: info: vio_read returned -1, errno: 11 thr_alarm: info: reschedule process_alarm: info: sig: 14 active alarms: 1 ?func: general: Capabilities: 9357 packet_length: 0 Host: 'localhost' User: 'root' Using password: no Access: 16383 db: '*none*' mysql_change_db: general: Use database: mysql vio_read: error: Got error 11 during read do_command: info: vio_read returned -1, errno: 11 thr_alarm: info: reschedule process_alarm: info: sig: 14 active alarms: 1 do_command: general: Command on socket (8) = 1 (Quit) ~THD(): info: freeing host end_thread: info: Adding thread to cache create_new_thread: info: Thread 2 created ?func: info: check_connections called by thread 2 ?func: general: New connection received on socket (8) ?func: general: Host: localhost vio_read: error: Got error 11 during read ?func: info: vio_read returned -1, errno: 11 thr_alarm: info: reschedule process_alarm: info: sig: 14 active alarms: 1 ?func: general: Capabilities: 8325 packet_length: 0 Host: 'localhost' User: 'root' Using password: yes Access: 32768 db: '*none*' ~THD(): info: freeing host end_thread: info: Adding thread to cache process_alarm: info: sig: 14 active alarms: 0 ~ Michel TIGNYEMB FTeB 01 46 12 69 45