RE: Warnings when loading a file
So is there a place where MySQL stores all warning messages which occured during LOAD DATA ? -Arnis Hi This is not a response to Malcolm, but rather a query.. if the CSV file to be imported into a MySQL table using LOAD DATA command had ASCII char(13) and/or ASCII char(10) in it, would this interfere with the usual behavior of LOAD DATA? If so, is there a workaround for this problem? (In Oracle, using the same command, it's a problem getting this to work...) Thanks in advance and please CC in your replies. Noor On Fri, 26 Jan 2001, Malcolm Edwards wrote: I'm loading a large csv file and get the following result: mysql LOAD DATA LOCAL INFILE "kanji_all.csv" INTO TABLE kanji_all - FIELDS TERMINATED BY "," ENCLOSED BY "\"" IGNORE 1 LINES; Query OK, 6355 rows affected (1.27 sec) Records: 6355 Deleted: 0 Skipped: 0 Warnings: 49821 The resulting table looks fine (hard to tell), but I'd like to know what all the warnings are. I've looked though the manual, book, tried logs etc. but I can't find their content. (mysql Ver 10.8 Distrib 3.23.22-beta, for redhat-linux-gnu (i386)) Thanks in advance, Malcolm - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
select from HEAP table failing with error 124
Hi! "David" == David Mechner [EMAIL PROTECTED] writes: David Hi, David My license number is 7697. I don't know what the expiration date is. I'm running 3.23.28-gamma msqld-opt under w2k. David I'm trying to use a HEAP table to speed up data access, but every select I do which references an indexed column gives me: David ERROR 1030: Got error 124 from table handler Thanks for uploading your table. I did a test with this with MySQL 3.23.32 on NT and this worked perfectly for me. Could you try to upgrade and check if this helps? If this doesn't help, then Miguel will try to repeat this on his w2k computer. Regards, Monty - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
how do i store complex data in the most efficient way?
hi, i have a query that i hope someone can help me with.
i have a monitoring system that tracks the number of times that person clicks on a
particular adbanner on our site or in one of our newsletters. i member can choose
have a maximum of 16 interests selected.
so for example, i can say i'm interested in carbuying, the stockmarket and action
movies. at the moment i store the 16 interests as a bit bitfield,which gets decoded
on the server.
this system has worked very well for me, but now i have a few new requirements.
- the total number of possible interests that can be selected is now 150
- and i need store the users click rate and the number of times we have sent them a
newsletter relating to an interest or the number of times we have displayed an
adbanner related to their interest.
the long ineffient way would be
- to store 150 enum ("y", "n") fields to say that a user has selected a particular
interest
- then another 150 tinyint fields to store the response rate
- and another 150 tinyint fields to store the the count of times we have sent a
newsletter to them
this already results in 450 fields per record!
the best way i came up with was to store a number like "2_7" to represent 3 things,
the fact that a user has selected that interest, that the user has responded to 2 of
our 7 newsletters.
but this is still 150 fields per record.
we have about 250,000 members at the moment - this could get really out of hand very
quicky.
has anyone got any ideas on the best way to store this information ??
thanks for your help.
anna
What causes table corruption? (isamchk -r required)
3 times in the last few days I've had tables that have become corrupted and needed isamchk -r to repair them. I'm becoming concerned: what can cause such errors? (and what can I do to avoid them?) I'm running 3.22.32 on Solaris 5.6 on a sparc ultra-1, and have processes updating the tables concerned continuously, via REPLACE INTO, INSERT INTO or UPDATE statements. TIA regards, -- John Stumbles [EMAIL PROTECTED] I.T. Services Centre, University of Reading http://www.rdg.ac.uk/~visstmbl +-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+ never generalise - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: setting autoincrement value help needed (Second post)
I would suggest you issue an ALTER TABLE command to change your AUTO_INCREMENT to unsigned. The concept of AUTO_INCREMENT negates the use of negative numbers. If you are using the change from positive to negative to flag for deletion or some other process, try adding a column for this purpose and not messing with the AUTO_INCREMENT column. ALTER TABLE can be executed on a production database. I hope this helps... Pat... - Original Message - From: "Enea Mansutti" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, January 29, 2001 2:44 AM Subject: setting autoincrement value help needed (Second post) First of all MySQL rocks!!! -- Now for my problem... Unfortunately, before I knew how autoincrement worked, I have setup a database with a signed autoincrement column in a production environment. When I insert columns, I usually pass NULL as the column value for the INSERT statement to correctly insert the next autoincrement value. Occasionally (for maintenance reasons) I have to MANUALLY insert values with negative numbers, this corrupts the autoincrement value (autoincrement seems to be unsigned) so i have to run myisamchk -A to fix it. I wanted to know if there is an sql command i can execute which has the same effect of myisamchk -A. I have tried to use SET INSERT_ID=# but it seems to set the autoincrement value only for the current connection and for the first insert only. Another question, is it safe to run myisamchk -A without shutting down the mysql in a production environment? regards, Enea -- P.Review srl +39 02 29061035 [EMAIL PROTECTED] www.presstoday.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
same file size after DELETE
Hello, I have just deleted thousands of records but the file is still the same size as before. How do I make the file compact? i.e. how do I get rid of all the "empty spaces" in the table? Tim Samshuijzen - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: same file size after DELETE
On Mon, Jan 29, 2001 at 01:30:57PM +0100, Tim Samshuijzen wrote: Hello, I have just deleted thousands of records but the file is still the same size as before. How do I make the file compact? i.e. how do I get rid of all the "empty spaces" in the table? Look at the MySQL manual. Reference DELETE explicitly mentions OPTIMIZE TABLE for such cases. G'luck, Peter -- I am the thought you are now thinking. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 first tutorial example
Patrick Vogel writes:
HI
I am trying to install mysql++.
I did automake, autoconf ./configure, make and make install.
When I add this row in kdevelopp / C++
#include sqlplus.hh
this message appears:
"In file inclued from /usr/local/include/sqlplus.hh:9,
from main.cpp:24:
/usr/local/include/defs:5: mysql.h: No folder or directory in this type"
What can I do???
Thanks a lot
Patrick
Hi!
All you have to do is add a path to MySQL C API includes and libs.
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, 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: Warnings when loading a file
Arnis Shinka Jr writes:
So is there a place where MySQL stores all warning messages which occured
during LOAD DATA ?
-Arnis
No , there is not.
There is an item on our TODO for 4.* to optionally produce a table
with description of warnings. It is however not very high on TODO
list.
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, 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: Copying Database
Try copying your databasefiles (mysqlhome/data), tar'ed or untar'ed, to the mysql/data location. According to specs this should do it regards - Original Message - From: "Sam Wong" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, January 29, 2001 1:47 PM Subject: Copying Database I know this question may not be mysql related, sorry. I would like to know what's the faster way to duplicate all database to another machine. I've over 10 tables in each three database, it's very slow to use cp, and very slow to when untar (over 3 hours!) Do you have any solution? Thx 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
Re: Using MySQL for web authentication and others..
There is an apache module called mod_auth_mysql that will allow you to do this. You can download it from the mysql site at http://www.mysql.com/downloads/contrib.html I'm not sure if it's still maintained or anything because I can no longer to the site at http://bourbon.netvision.net.il/mod_auth_mysql/ - Original Message - From: "--==[bMan]==--" [EMAIL PROTECTED] To: "MySQL List" [EMAIL PROTECTED] Sent: Sunday, January 28, 2001 8:05 PM Subject: Using MySQL for web authentication and others.. I just want to ask a quick question which is probably only indirectly related to this group. Where can I find some useful info on how to integrate MySQL into Apache authentication scheme? Basically, I want to use MySQL database to store users' ids and passwords rather than .htpasswd file generated by Apache's htpasswd program. Thanks. -- Bolek, URL: http://www.bolek.com URL: http://slash.bolek.com e-mail: [EMAIL PROTECTED] ICQ: 4086197, Address: 402905326 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Copying Database
It's quite fast for tar, just around 10-20 minutes. But it's unacceptable slow when untar, more than 3 hours! I just want to know if there's any efficient way to do that... - Original Message - From: "Lars Schioler" [EMAIL PROTECTED] To: "Sam Wong" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, January 29, 2001 9:13 PM Subject: Re: Copying Database Try copying your databasefiles (mysqlhome/data), tar'ed or untar'ed, to the mysql/data location. According to specs this should do it regards - Original Message - From: "Sam Wong" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, January 29, 2001 1:47 PM Subject: Copying Database I know this question may not be mysql related, sorry. I would like to know what's the faster way to duplicate all database to another machine. I've over 10 tables in each three database, it's very slow to use cp, and very slow to when untar (over 3 hours!) Do you have any solution? Thx 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: Copying Database
1) It's on a RAID, the seq test (just using a perl script to write files coninuously) reach 50MBytes/sec 2) Sorry I don't understand 3) I've no idea. I've tried on UFS (on FreeBSD 3.2 3.4 3.5 4.1.1 and 4.2) and ext2 (on newest Debian release) 4) It's on Dual xeon P2 400 1MB Cache, with 1G ram on board It's slow because it contains many files. i.e. Reading a big files is always faster than reading many small files - Original Message - From: "Artem Koutchine" [EMAIL PROTECTED] To: "Sam Wong" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, January 29, 2001 9:58 PM Subject: Re: Copying Database This is totally weird! Untar should be faster then tar on a any normal computer under normal os with normal hdds. So, your problem could be: 1) Your hdds are way too slow 2) Incorrect HDD interface setup 3) Your FS setup is terrible (like no write chaching at all) 4) The machine which you are untarring on has a very weak CPU - Original Message - From: "Sam Wong" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, January 29, 2001 4:20 PM Subject: Re: Copying Database It's quite fast for tar, just around 10-20 minutes. But it's unacceptable slow when untar, more than 3 hours! I just want to know if there's any efficient way to do that... - Original Message - From: "Lars Schioler" [EMAIL PROTECTED] To: "Sam Wong" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, January 29, 2001 9:13 PM Subject: Re: Copying Database Try copying your databasefiles (mysqlhome/data), tar'ed or untar'ed, to the mysql/data location. According to specs this should do it regards - Original Message - From: "Sam Wong" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, January 29, 2001 1:47 PM Subject: Copying Database I know this question may not be mysql related, sorry. I would like to know what's the faster way to duplicate all database to another machine. I've over 10 tables in each three database, it's very slow to use cp, and very slow to when untar (over 3 hours!) Do you have any solution? Thx 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
row to column conversion
Hi there! Macromedia Generator needs a cloumn as query result to create a chart from given data (e.g. temperature lows). My data is stored in records (rows). Does anybody know a SQL syntax to return one column as query result containing the information from one row. Any help is greatly appreciated! Thanks in advance. Leo - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Very slow to connect
I don't know if any of you people have ever had this trouble, but it's been a messy one here. Whenever a website of ours get lots of traffic, MySQL gets too slow to connect. Whenever it connects, the queries are fast. Since lots of our scripts relies on database connections, it has become a big problem to our website and we've been unable to answer to our costumers what is going on. a mysqladmin status shows the following: Uptime: 441237 Threads: 29 Questions: 23849146 Slow queries: 11390 Opens: 90355 Flush tables: 8 Open tables: 128 Queries per second avg: 54.051 We know that 54 queries per second should be a lot, but it's not. We've already had more traffic than that. A show processlist rarely shows more than 30 processes. The machine is a Linux SMP with 2 CPUs PIII 800MHz and 1G of RAM. What could possibly be wrong? Also, our setup for file-max is big enough to support lots of connections. We, of course, do lots of concurrent updates and selects in some (not all) tables. For the MySQL specialists out there, these are the variables returned by a show variables. Are there any values that could be changed so that the connection wouldn't be so slow? Are there people with the same problems out there? I'm waiting for a shout from the wild... :) Thanks. -- Leonardo Dias Catho Online WebDevelopper http://www.catho.com.br/ Variable_name Value ansi_mode OFF back_log100 basedir /usr/local/mysql/ binlog_cache_size 32768 character_set latin1 character_sets latin1 big5 czech euc_kr gb2312 gbk sjis tis620 ujis dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia hungarian koi8_ukr win1251ukr greek win1250 croat cp1257 latin5 concurrent_insert ON connect_timeout 5 datadir /usr/local/mysql/data/ delay_key_write ON delayed_insert_limit100 delayed_insert_timeout 300 delayed_queue_size 1000 flush OFF flush_time 0 have_bdbNO have_gemini NO have_innobase NO have_isam YES have_raid NO have_sslNO init_file interactive_timeout 28800 join_buffer_size1929216 key_buffer_size 134213632 language/usr/local/mysql/share/mysql/english/ large_files_support ON locked_in_memoryOFF log ON log_update OFF log_bin OFF log_slave_updates OFF long_query_time 10 low_priority_updatesOFF lower_case_table_names 0 max_allowed_packet 9048064 max_binlog_cache_size 4294967295 max_connections 500 max_connect_errors 10 max_delayed_threads 20 max_heap_table_size 16777216 max_join_size 4294967295 max_sort_length 1024 max_tmp_tables 32 max_write_lock_count4294967295 myisam_recover_options OFF myisam_sort_buffer_size 8388608 net_buffer_length 16384 net_read_timeout30 net_retry_count 10 net_write_timeout 60 open_files_limit0 pid_file/usr/local/mysql/data/mysql.pid port3306 protocol_version10 record_buffer 1531904 query_buffer_size 0 safe_show_database OFF server_id 0 skip_lockingON skip_networking OFF skip_show_database OFF slow_launch_time2 socket /tmp/mysql.sock sort_buffer 4194296 table_cache 128 table_type MYISAM thread_cache_size 0 thread_stack65536 timezoneUTC tmp_table_size 9048568 tmpdir /tmp/ version 3.23.30-gamma-log wait_timeout28800 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Very slow to connect
increase the number of connections allowed, that might be it On Mon, 29 Jan 2001, Leonardo Dias wrote: I don't know if any of you people have ever had this trouble, but it's been a messy one here. Whenever a website of ours get lots of traffic, MySQL gets too slow to connect. Whenever it connects, the queries are fast. Since lots of our scripts relies on database connections, it has become a big problem to our website and we've been unable to answer to our costumers what is going on. a mysqladmin status shows the following: Uptime: 441237 Threads: 29 Questions: 23849146 Slow queries: 11390 Opens: 90355 Flush tables: 8 Open tables: 128 Queries per second avg: 54.051 We know that 54 queries per second should be a lot, but it's not. We've already had more traffic than that. A show processlist rarely shows more than 30 processes. The machine is a Linux SMP with 2 CPUs PIII 800MHz and 1G of RAM. What could possibly be wrong? Also, our setup for file-max is big enough to support lots of connections. We, of course, do lots of concurrent updates and selects in some (not all) tables. For the MySQL specialists out there, these are the variables returned by a show variables. Are there any values that could be changed so that the connection wouldn't be so slow? Are there people with the same problems out there? I'm waiting for a shout from the wild... :) Thanks. -- -Spinlock EmpireQuest Creator http://www.empirequest.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
empty user.MYD
Hi, everybody, I have trouble, installing mysql on a Linux-machine running SuSE-Linux 6.3. I managed to compile it from source (3.23.32) and I managed to install everything, but I am unable to create the initial databases and to start the mysqld. Here is, what I did, and what happened: I configured mysql with this command: root@quark:/usr/src/mysql-3.23.32 # ./configure \ --with-mysqld-user=mysql \ --prefix=/opt/mysql make make install Everything seems to run smooth until I try to install the databases. When running the mysql_install_db-script I get this: root@quark:/usr/src/mysql-3.23.32 # scripts/mysql_install_db Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables ERROR: 1030 Got error -1 from table handler ERROR: 1030 Got error -1 from table handler ERROR: 1030 Got error -1 from table handler ERROR: 1030 Got error -1 from table handler ERROR: 1030 Got error -1 from table handler ERROR: 1030 Got error -1 from table handler ERROR: 1030 Got error -1 from table handler ERROR: 1030 Got error -1 from table handler Ignoring these messages and changing ownership and group of the /opt/mysql-directory to mysql.mysql, this is, what my /opt/mysql/var/mysql-directory looks like: -rw-rw 1 mysqlmysql 0 Jan 29 13:36 columns_priv.MYD -rw-rw 1 mysqlmysql1024 Jan 29 13:36 columns_priv.MYI -rw-rw 1 mysqlmysql8778 Jan 29 13:36 columns_priv.frm -rw-rw 1 mysqlmysql 0 Jan 29 13:36 db.MYD -rw-rw 1 mysqlmysql1024 Jan 29 13:36 db.MYI -rw-rw 1 mysqlmysql8982 Jan 29 13:36 db.frm -rw-rw 1 mysqlmysql 0 Jan 29 13:36 func.MYD -rw-rw 1 mysqlmysql1024 Jan 29 13:36 func.MYI -rw-rw 1 mysqlmysql8641 Jan 29 13:36 func.frm -rw-rw 1 mysqlmysql 0 Jan 29 13:36 host.MYD -rw-rw 1 mysqlmysql1024 Jan 29 13:36 host.MYI -rw-rw 1 mysqlmysql8958 Jan 29 13:36 host.frm -rw-rw 1 mysqlmysql 0 Jan 29 13:36 tables_priv.MYD -rw-rw 1 mysqlmysql1024 Jan 29 13:36 tables_priv.MYI -rw-rw 1 mysqlmysql8877 Jan 29 13:36 tables_priv.frm -rw-rw 1 mysqlmysql 0 Jan 29 13:36 user.MYD -rw-rw 1 mysqlmysql1024 Jan 29 13:36 user.MYI -rw-rw 1 mysqlmysql9148 Jan 29 13:36 user.frm Of course, when trying to start the mysqld with this command: root@quark:/opt/mysql # bin/safe_mysqld --user=mysql Starting mysqld daemon with databases from /opt/mysql/var 010129 14:33:01 mysqld ended it stops immediately, complaining about being unable to open the user.MYD: root@quark:/opt/mysql # tail var/quark.err 010129 14:39:07 mysqld started 010129 14:39:07 /opt/mysql/libexec/mysqld: Can't open file: 'user.MYD'. (errno: 126) 010129 14:39:07 010129 14:39:07 mysqld ended Did anybody encounter this problem before? Does anybody have a clue what I can do about it? Thanks in advance, Wolfgang By the way: The user 'mysql' exists as a member of the 'mysql'-group. I compiled using gcc2.95.2 root@quark:/usr/src/mysql-3.23.32 # gcc --version 2.95.2 my glibc's version is: root@quark:/usr/src/mysql-3.23.32 # strings /lib/libc* | grep "release version" GNU C Library stable release version 2.1.2, by Roland McGrath et al. Wolfgang Arendt Vodafone TeleCommerce GmbH SW Test Config. Management Wolfgang Arendt Daniel-Goldbach-Str. 17-19 40880 Ratingen Tel. +49 (0) 21 02 / 97 2492 Fax +49 (0) 21 02 / 97 2453 mailto:[EMAIL PROTECTED] www.vodafone-telecommerce.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Database
Aha! Many files you say. Well, the try: -noatime, -async options for filesystem (it quadrupled perfomance for me) or use SoftUpdates (when on FreeBSD 4.2-stable only, before than SoftUpdates were unstable). - Original Message - From: "Sam Wong" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, January 29, 2001 5:05 PM Subject: Re: Copying Database 1) It's on a RAID, the seq test (just using a perl script to write files coninuously) reach 50MBytes/sec 2) Sorry I don't understand 3) I've no idea. I've tried on UFS (on FreeBSD 3.2 3.4 3.5 4.1.1 and 4.2) and ext2 (on newest Debian release) 4) It's on Dual xeon P2 400 1MB Cache, with 1G ram on board It's slow because it contains many files. i.e. Reading a big files is always faster than reading many small files - Original Message - From: "Artem Koutchine" [EMAIL PROTECTED] To: "Sam Wong" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, January 29, 2001 9:58 PM Subject: Re: Copying Database This is totally weird! Untar should be faster then tar on a any normal computer under normal os with normal hdds. So, your problem could be: 1) Your hdds are way too slow 2) Incorrect HDD interface setup 3) Your FS setup is terrible (like no write chaching at all) 4) The machine which you are untarring on has a very weak CPU - Original Message - From: "Sam Wong" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, January 29, 2001 4:20 PM Subject: Re: Copying Database It's quite fast for tar, just around 10-20 minutes. But it's unacceptable slow when untar, more than 3 hours! I just want to know if there's any efficient way to do that... - Original Message - From: "Lars Schioler" [EMAIL PROTECTED] To: "Sam Wong" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, January 29, 2001 9:13 PM Subject: Re: Copying Database Try copying your databasefiles (mysqlhome/data), tar'ed or untar'ed, to the mysql/data location. According to specs this should do it regards - Original Message - From: "Sam Wong" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, January 29, 2001 1:47 PM Subject: Copying Database I know this question may not be mysql related, sorry. I would like to know what's the faster way to duplicate all database to another machine. I've over 10 tables in each three database, it's very slow to use cp, and very slow to when untar (over 3 hours!) Do you have any solution? Thx 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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:
RE: Very slow to connect
Is this perhaps related to the 'slow thread creation' 'feature' of some linux kernels? http://lists.mysql.com/php/search.php?ps=10q=fast+thread+creation+ps=20m= and -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Leonardo Dias Sent: 29 January 2001 15:41 To: [EMAIL PROTECTED] Subject: Very slow to connect I don't know if any of you people have ever had this trouble, but it's been a messy one here. Whenever a website of ours get lots of traffic, MySQL gets too slow to connect. Whenever it connects, the queries are fast. Since lots of our scripts relies on database connections, it has become a big problem to our website and we've been unable to answer to our costumers what is going on. a mysqladmin status shows the following: Uptime: 441237 Threads: 29 Questions: 23849146 Slow queries: 11390 Opens: 90355 Flush tables: 8 Open tables: 128 Queries per second avg: 54.051 We know that 54 queries per second should be a lot, but it's not. We've already had more traffic than that. A show processlist rarely shows more than 30 processes. The machine is a Linux SMP with 2 CPUs PIII 800MHz and 1G of RAM. What could possibly be wrong? Also, our setup for file-max is big enough to support lots of connections. We, of course, do lots of concurrent updates and selects in some (not all) tables. For the MySQL specialists out there, these are the variables returned by a show variables. Are there any values that could be changed so that the connection wouldn't be so slow? Are there people with the same problems out there? I'm waiting for a shout from the wild... :) Thanks. -- Leonardo Dias Catho Online WebDevelopper http://www.catho.com.br/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: strip
Marcelo wrote: Can someone tell me how i can get(or can someone send me) the strip command for SCO Open Server 5.0.5? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Go to sco.com and look in the downloads. The Skunkworks binutils sholuld contain strip. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Test
There's been some problems with the list. Testing if it works... -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Very slow to connect
I bet your webserver and database server are seperate machine. Make sure the hostname of web and db are in the /etc/hosts on both machine, it's very slow to use DNS to resolve everything That doesn't matter. We use IP to connect, not hostnames. It might be a problem with the slow pthread_create() thingy I've been reading. Although there was a lot of discussion, they didn't come up with a fix that could deal with this cleanly. And we DO need some solution here. Does anyone have any other ideas? Increasing the max_connections number to more than 500 won't do it. The kernel we're using is 2.2.17. I believe that upgrading it to 2.4 won't help either. Am I right or totally wrong? -- Leonardo Dias Catho Online WebDevelopper http://www.catho.com.br/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Date for Gemini project
Hi, Does anyone have an idea of the date when the developments of Gemini project will be integrated into MySQL ? Will it be integrated in the MySQL 4.0 version ? Will it be integrated in the standard MySQL sources without changing the license agreement ? I read that this project resulted in the integration of the kernel of a successful commercial databas. Could we already have some idea about performance against MyISAM tables ? Thanks Patrick Fiche - Prologue Software (France) Software Engineer Email: [EMAIL PROTECTED] Internet : http://www.prologue-software.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: Very slow to connect
Leonardo Dias wrote: I bet your webserver and database server are seperate machine. Make sure the hostname of web and db are in the /etc/hosts on both machine, it's very slow to use DNS to resolve everything That doesn't matter. We use IP to connect, not hostnames. But if you use IP the mysql server may still try to resolve the host name to for access checks. So make sure you have the IP in the /etc/hosts of the server for the machine you are connecting from . - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: What causes table corruption? (isamchk -r required)
"jds" == j d stumbles [EMAIL PROTECTED] writes: jds I'm running 3.22.32 on Solaris 5.6 on a sparc ultra-1, and have processes jds updating the tables concerned continuously, via REPLACE INTO, INSERT INTO jds or UPDATE statements. I've never had table corruption on a Solaris box, even with older MySQL versions. We don't use REPLACE INTO since I find it to be quite useless, really. Anyhow, here are some stats. These are using binary versions of MySQL from the www.mysql.com site. mysqladmin Ver 7.8 Distrib 3.22.14-gamma, for sun-solaris2.6 on sparc TCX Datakonsult AB, by Monty Server version 3.22.14-gamma Protocol version10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 108 days 6 hours 38 min 40 sec Threads: 7 Questions: 12566861 Slow queries: 65925 Opens: 120 Flush tables: 1 Open tables: 116 [prod-rtm]% uname -a SunOS prod-rtm.xxx.xxx 5.6 Generic_105181-17 sun4u sparc SUNW,Ultra-250 and another box: mysqladmin Ver 7.8 Distrib 3.22.20a, for sun-solaris2.6 on sparc TCX Datakonsult AB, by Monty Server version 3.22.20a Protocol version10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 217 days 7 hours 16 min 26 sec Threads: 1 Questions: 43556764 Slow queries: 10224 Opens: 967 Flush tables: 1 Open tables: 255 [prod-rtm2]% uname -a SunOS prod-rtm2.xxx.xxx 5.6 Generic_105181-20 sun4u sparc SUNW,Ultra-250 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Install trouble on FreeBSD4.2
I'm seeing this error when installing mysql-server-3.23.32 on FreeBSD4.2. I understand the name resolution issue, however I don't believe this has anything to do with the grant tables failing. This is a binary install from ftp.freebsd.org. Should I consider "rolling my own" from a tar-ball? Would it make any difference? Any help would be great, Thanks! ---SNIP extract: /usr/local/share/mysql/swedish/errmsg.txt extract: execute '/usr/local/bin/mysql_install_db' /usr/libexec/ld-elf.so.1: Shared object "libc_r.so.5" not found WARNING: The host 'noc1' could not be looked up with resolveip. This probably means that your libc libraries are not 100 % compatible with this binary MySQL version. The MySQL deamon, mysqld, should work normally with the exception that host name resolving will not work. This means that you should use IP addresses instead of hostnames when specifying MySQL privileges ! Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables /usr/libexec/ld-elf.so.1: Shared object "libc_r.so.5" not found Installation of grant tables failed! ---SNIP -- Jeff Neuffer Jr. Data Services Technician North State Telephone This mail was processed by Mail essentials for Exchange/SMTP, the email security management gateway. Mail essentials adds content checking, email encryption, anti spam, anti virus, attachment compression, personalised auto responders, archiving and more to your Microsoft Exchange Server or SMTP mail server. For more information visit http://www.mailessentials.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
Problem with the UPDATE
Hi , im having a strange problem with the update in mysql i have a table named "notices" with the following fields: id :prymary, int, auto_increment. title :varchar (255). priority:int. inside this table i have 5 registers like this : id title priority 1 a 1 2 b 2 3 c 3 4 d 4 5 e 5 now... to explain exactly what im doing y will write the exact querys im giving o the database. DELETE FROM notices where id=1 UPDATE notices SET priority=priority-1 WHERE priority 1 The result for this should be the following: id title priority 2 b 1 3 c 2 4 d 3 5 e 4 The result im getting is : id title priority 2 b 1 3 c 1 4 d 2 5 e 3 i have tryed everything, i foud that there was a problem with the update using the "WHERE priority1" and they recommended using "WHERE priority+0 1" i also try that without having good results. the part that is even more strange is that if i run this querys from the console of the phpMyadmin the result comes out rigth. i really dont know what to do. i am running on a NT 4.0 platform but i also try it on a REDHAT 6.2 platform having the same wrong result. if anybody could help please let me know. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Install trouble on FreeBSD4.2
"JN" == Jeff Neuffer [EMAIL PROTECTED] writes: JN I'm seeing this error when installing mysql-server-3.23.32 on FreeBSD4.2. Use /usr/ports on FreeBSD, and make sure you have the C++ compiler fixes from mid-january (ie, update FreeBSD to 4.2-STABLE). -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Very slow to connect
[1 text/plain; us-ascii (7bit)] I don't know if any of you people have ever had this trouble, but it's been a messy one here. Whenever a website of ours get lots of traffic, MySQL gets too slow to connect. Whenever it connects, the queries are fast. Since lots of our scripts relies on database connections, it has become a big problem to our website and we've been unable to answer to our costumers what is going on. Use connection caching, e.g. mod_perl with Apache::DBI. Based on you idea and what I have found in the MySQL manual, I decided to use the thread_cache_size. I put it up to 20. I also increased the thread_stack to 128K. Now we have solved our problems with slow connections and found a new one: slow queries. They have increased a lot now that our users are able to connect to the database and do their favorite concurrent inserts, concurrent updates and concurrent selects. Solved a problem. Found a new one. -- Leonardo Dias Catho Online WebDevelopper http://www.catho.com.br/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 the UPDATE
"Guridi, Tomas" wrote: Hi , im having a strange problem with the update in mysql i have a table named "notices" with the following fields: id :prymary, int, auto_increment. title :varchar (255). priority:int. inside this table i have 5 registers like this : id title priority 1 a 1 2 b 2 3 c 3 4 d 4 5 e 5 now... to explain exactly what im doing y will write the exact querys im giving o the database. DELETE FROM notices where id=1 UPDATE notices SET priority=priority-1 WHERE priority 1 The result for this should be the following: id title priority 2 b 1 3 c 2 4 d 3 5 e 4 The result im getting is : id title priority 2 b 1 3 c 1 4 d 2 5 e 3 i have tryed everything, i foud that there was a problem with the update using the "WHERE priority1" and they recommended using "WHERE priority+0 1" i also try that without having good results. the part that is even more strange is that if i run this querys from the console of the phpMyadmin the result comes out rigth. i really dont know what to do. i am running on a NT 4.0 platform but i also try it on a REDHAT 6.2 platform having the same wrong result. if anybody could help please let me know. You do not say what version you are running. Older versions did not allow updating the primary key field in that manner. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 build mysql under solaris 7
Trying to build mysql-3.23.32 under solaris 7 with gcc version 2.95.2 19991024 (release) got error message : gcc -DDEFAULT_CHARSET_HOME=\"/usr/local\" -DDATADIR=\"/usr/local/var\" -DSHAREDIR=\"/usr/local/share/mysql\" -DUNDEF_THREADS_HACK -I./../include -I../include -I ./.. -I.. -I.. -O6 -DDBUG_OFF -DHAVE_CURSES_H -I/export/home/iav/mysql-3.23.32/include -DHAVE_RWLOCK_T -c libmysql.c -fPIC -DPIC -o .libs/libmysql.lo In file included from ../include/global.h:151, from libmysql.c:23: /usr/local/lib/gcc-lib/sparc-sun-solaris2.7/2.95.2/include/math.h:5: math.h: No such file or directory make[2]: *** [libmysql.lo] Error 1 what does it mean? What is than math.h, it cann't find? I ried to find it myself - and fail: # find / -name math.h /usr/local/lib/gcc-lib/sparc-sun-solaris2.7/2.95.2/include/math.h /export/home/iav/mysql-3.23.32/mit-pthreads/include/math.h What I do incorrect? best regards, Igor - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 the UPDATE
-Mensaje original- De: Gerald L. Clark [mailto:[EMAIL PROTECTED]] Enviado el: lunes 29 de enero de 2001 12:53 Para: Guridi, Tomas Cc: '[EMAIL PROTECTED]' Asunto: Re: Problem with the UPDATE "Guridi, Tomas" wrote: Hi , im having a strange problem with the update in mysql i have a table named "notices" with the following fields: id :prymary, int, auto_increment. title :varchar (255). priority:int. inside this table i have 5 registers like this : id title priority 1 a 1 2 b 2 3 c 3 4 d 4 5 e 5 now... to explain exactly what im doing y will write the exact querys im giving o the database. DELETE FROM notices where id=1 UPDATE notices SET priority=priority-1 WHERE priority 1 The result for this should be the following: id title priority 2 b 1 3 c 2 4 d 3 5 e 4 The result im getting is : id title priority 2 b 1 3 c 1 4 d 2 5 e 3 i have tryed everything, i foud that there was a problem with the update using the "WHERE priority1" and they recommended using "WHERE priority+0 1" i also try that without having good results. the part that is even more strange is that if i run this querys from the console of the phpMyadmin the result comes out rigth. i really dont know what to do. i am running on a NT 4.0 platform but i also try it on a REDHAT 6.2 platform having the same wrong result. if anybody could help please let me know. You do not say what version you are running. Older versions did not allow updating the primary key field in that manner. i am running version 3.23.32 of mysql in which that problem is supposed to be fixed but any way the field that im updating is not the prymary key, the prymary key is the field (id) and im updating the field priority. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Very slow to connect
[1 text/plain; us-ascii (7bit)] I don't know if any of you people have ever had this trouble, but it's been a messy one here. Whenever a website of ours get lots of traffic, MySQL gets too slow to connect. Whenever it connects, the queries are fast. Since lots of our scripts relies on database connections, it has become a big problem to our website and we've been unable to answer to our costumers what is going on. Use connection caching, e.g. mod_perl with Apache::DBI. Based on you idea and what I have found in the MySQL manual, I decided to use the thread_cache_size. I put it up to 20. I also increased the thread_stack to 128K. Now we have solved our problems with slow connections and found a new one: slow queries. They have increased a lot now that our users are able to connect to the database and do their favorite concurrent inserts, concurrent updates and concurrent selects. Solved a problem. Found a new one. Concurrent updates and mysql aren't the best of friends, yet. (Perhaps DBD and/or that new geminii stuff can fix some of your problems? Although geminii will probably cost you...) A lot of the slow queries can be solved by making better tables, sometimes even de-normalizing them if that can prevent a join, by sticking the numeric data into seperate tables (variable length stuff kills performance), etc. Standard procedure :) But in the end, if you have tons of concurrent updates then you might want to consider alternatives to MySQL. (postgres, frontbase, etc.) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 the UPDATE
"GLC" == Gerald L Clark [EMAIL PROTECTED] writes: GLC You do not say what version you are running. GLC Older versions did not allow updating the primary key field in that GLC manner. he's not updating the primary key field. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Very slow to connect
Concurrent updates and mysql aren't the best of friends, yet. (Perhaps DBD and/or that new geminii stuff can fix some of your problems? Although geminii will probably cost you...) A lot of the slow queries can be solved by making better tables, sometimes even de-normalizing them if that can prevent a join, by sticking the numeric data into seperate tables (variable length stuff kills performance), etc. Standard procedure :) We know. We've been through this. The problem with MySQL is that concurrent updates can't use row locking, but table locking. That means that the whole table will be locked until the updates are finished. This isn't good. Row locking based on the primary key would be A LOT faster. But in the end, if you have tons of concurrent updates then you might want to consider alternatives to MySQL. (postgres, frontbase, etc.) Indeed. We might give it a try someday. Although they don't have LIMIT (which provides a nice "paging" system). We use LIMIT everywhere here. It's a nice functionality if you're doing searches all the time. -- Leonardo Dias Catho Online WebDevelopper http://www.catho.com.br/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Install of mysql on AIX fails due to missing module libz.a
From: NELSON, GLEN Sent: Monday, January 29, 2001 11:15 AM To: Mysql (E-mail) Subject: Install of mysql on AIX fails due to missing module libz.a -Original Message- From: NELSON, GLEN Sent: Monday, January 29, 2001 10:28 AM To: '[EMAIL PROTECTED]' Subject: Install of mysql on AIX fails due to missing module libz.a From: t199k01 To: [EMAIL PROTECTED] Subject: [50 character or so descriptive subject here (for reference)] Install of mysql on AIX fails due to missing module libz.a Description: The following errors occurs when I try a binary install of mysql on AIX 4.3.3.0. Should I try to do a source code installation? exec(): 0509-036 Cannot load program ./bin/my_print_defaults because of the following errors: 0509-150 Dependent module libz.a(shr.o) could not be loaded. 0509-022 Cannot load module libz.a(shr.o). 0509-026 System error: A file or directory in the path name does not exist. WARNING: The host 'ddcux6' could not be looked up with resolveip. This probably means that your libc libraries are not 100 % compatible with this binary MySQL version. The MySQL deamon, mysqld, should work normally with the exception that host name resolving will not work. This means that you should use IP addresses instead of hostnames when specifying MySQL privileges ! Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables exec(): 0509-036 Cannot load program ./bin/mysqld because of the following errors: 0509-150 Dependent module libz.a(shr.o) could not be loaded. 0509-022 Cannot load module libz.a(shr.o). 0509-026 System error: A file or directory in the path name does not exist. Installation of grant tables failed! How-To-Repeat: run mysql_install_db Fix: unknown Submitter-Id:[EMAIL PROTECTED] Originator: Glen Nelson Organization: FMC Corporation MySQL support: none Synopsis: Install of mysql on AIX fails due to missing module libz.a Severity:non-critical Priority:medium Category:mysql Class:sw-bug Release:mysql-3.23.31 (Official MySQL binary) Environment: System: AIX ddcux6 3 4 000D36AD4C00 AIX version 4.3.3.0 Some paths: /usr/bin/perl /usr/bin/make Compilation info: CC='gcc' CFLAGS='-O3 -mcpu=powerpc -Wa,-many -fomit-frame-pointer' CXX='c++' CXXFLAGS='-O3 -mcpu=powerpc -Wa,-many -fomit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' LIBC: lrwxrwxrwx 1 bin bin 19 Sep 14 17:04 /lib/libc.a - /usr/ccs/lib/libc.a lrwxrwxrwx 1 bin bin 19 Sep 14 17:04 /usr/lib/libc.a - /usr/ccs/lib/libc.a Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --disable-shared Perl: This is perl, version 5.005_03 built for aix - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Very slow to connect
You don't seem to have mentioned how much memory you have. On 29 Jan 2001, at 14:52, Leonardo Dias wrote: [1 text/plain; us-ascii (7bit)] I don't know if any of you people have ever had this trouble, but it's been a messy one here. Whenever a website of ours get lots of traffic, MySQL gets too slow to connect. Whenever it connects, the queries are fast. Since lots of our scripts relies on database connections, it has become a big problem to our website and we've been unable to answer to our costumers what is going on. Use connection caching, e.g. mod_perl with Apache::DBI. Based on you idea and what I have found in the MySQL manual, I decided to use the thread_cache_size. I put it up to 20. I also increased the thread_stack to 128K. Now we have solved our problems with slow connections and found a new one: slow queries. They have increased a lot now that our users are able to connect to the database and do their favorite concurrent inserts, concurrent updates and concurrent selects. Solved a problem. Found a new one. -- Leonardo Dias Catho Online WebDevelopper http://www.catho.com.br/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php John Jensen 520 Goshawk Court Bakersfield, CA 93309 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
questions on BACKUP/RESTORE commands
The manual section on BACKUP does not state what locking behavior the command has. Does it lock all the tables at once that you backup in one statement or does it lock them one at a time? I.e. if I run: BACKUP foo.bar, foo.baz, foo.blah TO '/tmp/mysqlbackups/' Will it lock all three tables and then dump them? I need this kind of behavior. If it locks them one at a time and dumps them one at a time then I'll have to use something else. Additionally, can you RESTORE a backed-up table to a different database. I.e. suppose I did the BACKUP line above, can I do this: RESTORE foo_backup.bar, foo_backup.baz, foo_backup.blah FROM '/tmp/mysqlbackups/' ??? Best, Kyle -- Kyle Hayes Quicknet Technologies t: +1 415 864 5225 520 Townsend St. Suite D f: +1 415 864 8388 San Francisco, CA 94103 w: http://www.quicknet.net USA "HEAR THE DIFFERENCE" with a live MICROTELCO demo at: INTERNET TELEPHONY EXPO, Feb 7-9, Miami, FL MicroTelco is a revolutionary service that brings multiple Internet Telephony Service Providers (ITSPs) together in a convenient, simple to use account center for greater reliability and flexibility. For more information visit: http://www.microtelco.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
Repairing a table?
I'm running mysql v3.22.32 and encountered a corrupt key file for a table. I searched the documentation on the site, but it doesn't seem to pertain to this version of mysql any longer. I'm hesitant to upgrade to 3.23.32 until I can figure out what it might break. Does anyone have the steps that will allow me to repair a db table for 3.22.32? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
zombie socket
Hi All, Summary: sockets opened by mysql-clients are not closed properly after the client process has been terminated. I'm using mysql-3.23.8-alpha (server running on irix 6.5), the clients run on RadHat Linux 7. When I establish a connection from the client (linux) to the server via the standard mysql-client (that comes with the mysql code), a sockets gets occupied on the client machine. I list the used sockets via the 'socklist' perlscript that comes with RadHat linux (don't know how to list sockets otherwise). After I've exited the mysql-client the socket that was used by mysql on the client site is still there and remains several minutes, without beeing associated with a process (the process has already gone away). I guess the problem may be quite deep inside the client library because I get the same problem when using perl-DBI. This causes some problems on our site, because 50 linux clients talk to a master server (the clients are in a privat network) which runs a redir demon that redirects all traffic to the mysql-server that sites in a different network. The master server keeps quite alot of sockets open, and very often there no more sockets left for new connection (because the old ones are noit closed quick enough). I just wonder whether someone came across this problem before or whether the developers are interested in this problem (I can provide more details if requested). I'd like to see whether there are zombie sockets on the server machine as well but I don't know how to monitor socket usage on an irix machine. thanks for ideas, Arne - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Wierd mysqlgui problem
I have tried that with no avail. The GUI asks for my password when I
connect, and I am able to run select queries from the GUI, but all of the
things on the Commands menu that involve changing data don't work. Thanks,
Dave W.
-Original Message-
From: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]]
Sent: Sunday, January 28, 2001 5:55 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject:Re: Wierd mysqlgui problem
David Wilde writes:
Hello All,
I am new to MySQL and I am sure you have all heard this question a
million
times, so I appologize in advance. My question is, I have installed
MySQL
on a slackware 7.1 box, as well as a SuSE 7.0 box, and both seem to be
running fine with one minor exception. When using mysqlgui from a
windows
machine I get the error "Error in database function: Access Denied for
user:
'[EMAIL PROTECTED]" (Using password: YES)" I have added the username to
the mysql database using the command "GRANT ALL ON *.* TO user@"%"
IDENTIFIED BY "password" WITH GRANT OPTION" and have also added the
[EMAIL PROTECTED] and removed all of the anonymous entries (just in
case).
Since I am new to this I am not sure what I am doing wrong. The user can
create databases and tables using the mysql command on the linux box.
Thanks in advance for the help.
Hi!
As you have a password set for that user, you should enable "Ask for
password" button in Options page, so that you can enter password.
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, 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
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
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: Very slow to connect
[1 text/plain; us-ascii (7bit)] I don't know if any of you people have ever had this trouble, but it's been a messy one here. Whenever a website of ours get lots of traffic, MySQL gets too slow to connect. Whenever it connects, the queries are fast. Since lots of our scripts relies on database connections, it has become a big problem to our website and we've been unable to answer to our costumers what is going on. You don't seem to have mentioned how much memory you have. 1Gb. -- Leonardo Dias Catho Online WebDevelopper http://www.catho.com.br/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: questions on BACKUP/RESTORE commands
Nevermind. I see that the manual online has this information. Sigh. It doesn't do what I want unfortunately. Best, Kyle On Monday 29 January 2001 09:32, Kyle Hayes wrote: The manual section on BACKUP does not state what locking behavior the command has. Does it lock all the tables at once that you backup in one statement or does it lock them one at a time? I.e. if I run: BACKUP foo.bar, foo.baz, foo.blah TO '/tmp/mysqlbackups/' Will it lock all three tables and then dump them? I need this kind of behavior. If it locks them one at a time and dumps them one at a time then I'll have to use something else. Additionally, can you RESTORE a backed-up table to a different database. I.e. suppose I did the BACKUP line above, can I do this: RESTORE foo_backup.bar, foo_backup.baz, foo_backup.blah FROM '/tmp/mysqlbackups/' ??? Best, Kyle -- Kyle Hayes Quicknet Technologies t: +1 415 864 5225 520 Townsend St. Suite D f: +1 415 864 8388 San Francisco, CA 94103 w: http://www.quicknet.net USA "HEAR THE DIFFERENCE" with a live MICROTELCO demo at: INTERNET TELEPHONY EXPO, Feb 7-9, Miami, FL MicroTelco is a revolutionary service that brings multiple Internet Telephony Service Providers (ITSPs) together in a convenient, simple to use account center for greater reliability and flexibility. For more information visit: http://www.microtelco.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: Repairing a table?
I'm running mysql v3.22.32 and encountered a corrupt key file for a table. I searched the documentation on the site, but it doesn't seem to pertain to this version of mysql any longer. I'm hesitant to upgrade to 3.23.32 until I can figure out what it might break. Does anyone have the steps that will allow me to repair a db table for 3.22.32? The documentation that you should use when you have an older version of mysql is the documentation that came with your copy. You should do this to replair a table shutdown the mysqld daemon isamchk -r tablename.ISM make sure everything is repaird according to isamchk ouput start the mysqld daemon. my problem with the docs on the site was that they said myisamchk and the rpms for 3.22 had isamchk, so of course that command doesn't work, heheh. Thanks. The table is repaired and working once again. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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-starting safe_mysqld after the server re-starts
Hello All: I have developed a MySQL/PHP web application that is hosted on a shared server. I have noticed that when the server is re-started, mysqld is not automatically re-started. I have been informed that I need to write a program to be executed by cron when the server is re-started that runs safe_mysqld. I would assume that many of you have implemented a like solution to this problem. I would appreciate any advice, information, or actual programs that I could use to solve this problem. Thank you all in advance! -luke Luke Muszkiewicz Pure Development, LLC http://puredev.com 3946 Neelon Dr S Salem, OR 97302 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: re-starting safe_mysqld after the server re-starts
Hi, Depending on your platform, there will be a set of directories somewhere that contain a number of scripts that are run at various times during reboot. On Solaris, the main repository for the scripts is /etc/init.d, and scripts in /etc/rc1.d are run when entering run level 1, /etc/rc2.d for level 2 etc. up to rc6.d. In your support scripts for mysql, there should be one called "mysql.server". Your should be able to put this in to your version of /etc/init.d, link it to /etc/rc2.d with a name like S99mysql (the S means start, the 99 gives the sequence that the scripts in the directory are run). You may need to edit mysql.server after copying it to suit your mysql set up. mysql.server works out what parameters to give to safe_mysqld, and then calls it, making sure that mysqld is re-started automatically each time the server is rebooted. 'cron' is slightly different - it contains a list of programs that are run at regular intervals based on clock time, and isn't able to do anything particularly special for a re-boot (unless the server is always re-booted at the same time :-)). Check your system for "init.d", and go from there. Hope this helps Quentin -Original Message- From: Luke Muszkiewicz [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 30 January 2001 08:35 To: [EMAIL PROTECTED] Subject: re-starting safe_mysqld after the server re-starts Hello All: I have developed a MySQL/PHP web application that is hosted on a shared server. I have noticed that when the server is re-started, mysqld is not automatically re-started. I have been informed that I need to write a program to be executed by cron when the server is re-started that runs safe_mysqld. I would assume that many of you have implemented a like solution to this problem. I would appreciate any advice, information, or actual programs that I could use to solve this problem. Thank you all in advance! -luke Luke Muszkiewicz Pure Development, LLC http://puredev.com 3946 Neelon Dr S Salem, OR 97302 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is 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
Error during make...
Hello, We're installing Mysql source mysql-3.23.8-alpha on AIX 4.3.3.0. We were able to run configure without a problem but have problem once make is run, we receive the following errors: "net.c", line 109.9: 1506-045 (S) Undeclared Identifier net. "net.c", line 114.18: 1506-045 (S) Undeclared Identifier nettype. "net.c", line 118.11: 1506-045 (S) Undeclared Identifier fd. make: The error code from the last command is 1. Stop. make: The error code from the last command is 1. Stop. make: The error code fromt the last command is 2. Stop. Kindly assist us with this at your earliest convenience, we would like to proceed with the installation ASAP. Thank you for your help in advance. Sanam Azeem (212) 678-5636 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 start server : Bind on unix socket: Permission denied
I am trying to bring up my third mysql server. This one is MySQL-3.23.32-1.i386.rpm..rpm on a redhat 6.2 base. I was successful in installing both the server and the host. Look around and every thing looked cool! Piece of Cake! Then I decided to set up the mysqladmin user and setup privelidges, etc. The other two servers are run as root with no security. Every thing has gone down hill. All I get is this message: 'Can't start server : Bind on unix socket: Permission denied' whenever I try to start mysql.I've even rebooted the unix a few times, rebuilt the initial data base, etc.Tried every command I could find in the doc, but it won't budge. Only trying to get mysql to startup as root. I am about ready to start from scratch ... but reformat the drives and re-installing redhat seems too drastic. Please help. The hardware is IBM 6000R Netfinity with 1.5 g memory, dual 700 mh pentium processors, 200 g scsi raid set up as 1E. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Install of mysql on AIX fails due to missing module libz.a
From: NELSON, GLEN Sent: Monday, January 29, 2001 11:19 AM To: Mysql2 (E-mail) Subject: Install of mysql on AIX fails due to missing module libz.a From: t199k01 To: [EMAIL PROTECTED] Subject: [50 character or so descriptive subject here (for reference)] Install of mysql on AIX fails due to missing module libz.a Description: The following errors occurs when I try a binary install of mysql on AIX 4.3.3.0. Should I try to do a source code installation? exec(): 0509-036 Cannot load program ./bin/my_print_defaults because of the following errors: 0509-150 Dependent module libz.a(shr.o) could not be loaded. 0509-022 Cannot load module libz.a(shr.o). 0509-026 System error: A file or directory in the path name does not exist. WARNING: The host 'ddcux6' could not be looked up with resolveip. This probably means that your libc libraries are not 100 % compatible with this binary MySQL version. The MySQL deamon, mysqld, should work normally with the exception that host name resolving will not work. This means that you should use IP addresses instead of hostnames when specifying MySQL privileges ! Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables exec(): 0509-036 Cannot load program ./bin/mysqld because of the following errors: 0509-150 Dependent module libz.a(shr.o) could not be loaded. 0509-022 Cannot load module libz.a(shr.o). 0509-026 System error: A file or directory in the path name does not exist. Installation of grant tables failed! How-To-Repeat: run mysql_install_db Fix: unknown Submitter-Id:[EMAIL PROTECTED] Originator: Glen Nelson Organization: FMC Corporation MySQL support: none Synopsis: Install of mysql on AIX fails due to missing module libz.a Severity:non-critical Priority:medium Category:mysql Class:sw-bug Release:mysql-3.23.31 (Official MySQL binary) Environment: System: AIX ddcux6 3 4 000D36AD4C00 AIX version 4.3.3.0 Some paths: /usr/bin/perl /usr/bin/make Compilation info: CC='gcc' CFLAGS='-O3 -mcpu=powerpc -Wa,-many -fomit-frame-pointer' CXX='c++' CXXFLAGS='-O3 -mcpu=powerpc -Wa,-many -fomit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' LIBC: lrwxrwxrwx 1 bin bin 19 Sep 14 17:04 /lib/libc.a - /usr/ccs/lib/libc.a lrwxrwxrwx 1 bin bin 19 Sep 14 17:04 /usr/lib/libc.a - /usr/ccs/lib/libc.a Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --disable-shared Perl: This is perl, version 5.005_03 built for aix - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How can I create one more table with existing table structure
From: Subba Reddy M Date: Fri, 26 Jan 2001 14:52:29 +0530 Hello MySQL guru, Please advise me, on creating new table with existing table structure. I have tried, how MySQL documentation referred, but unable to get success. create table newtable select * from oldtable; This works on 3.23.x check doc for version. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
When create table ?
Hello, I'm student in Thailand. I learning about MySQL. I have questions to ask to you. I use MySQL version 3.22 have not SHOW TABLE STATUS Syntax . How I know when table was created (date and time). Please contract to me, Thank you. Mr. Damrong Khamdee __ 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: New way to learn Mysql?
Very nice. Recommend to go there, could come a awfull lot of tricks things to know there, in a entertaining way. - Original Message - From: "Jeff Cordova" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, January 29, 2001 6:54 PM Subject: New way to learn Mysql? I've spent the last couple of years building well-known e-commerce sites using Open Source code. Turns out that a fair amount of my time was spent teaching the "Open Source way" to jr. programmers. Well, I got so tired of going through the training ritual with each new engineer, that I put together a website www.codecity.com to help me out. I thought I would tell this group about it as you may find it useful too. I've just got the site started, so the MySQL quiz database isn't too deep yet. If you could submit a quiz or two that would be highly appreciated. Any feedback would also be welcome. Thankyou, Jeff C. www.codecity.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problem for localhost connection.....
Dear all, i m running mysql on freebsd webserver and using our own DNS server. Everything run fine with database and web serving. However, i m trying to change the DNS ip addresses to our isp's DNS server instead of ours on this webserver. Then i got the following error: st 'localhost.isp.net' is not allowed to connect to this MySQL server at /usr/local/stronghold/cgi-bin/xxx.cgi line 30 [Mon Jan 29 12:11:06 2001] [error] Died at /usr/local/stronghold/cgi-bin/xxx.cgi line xx. = Does anyone have any idea to solve this problem? i really appreciated. Thanks Derrick - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 and client server
Does Mysql can be used in client server envorinment. Hammad Nasim New Core Networks 1032 Castro Street Mountain View, CA 94040 P 650-691-1400 F 650-938-1730 http://www.newcorenet.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
how to use count to compare number?
From: Liu Danyu Date: Thu, 18 Jan 2001 18:08:37 +0800 I would do the query as select maker, pc.id from table1 where pc.id 2 order by maker; dear all: I need some help from you. The dataset is as following maker pc.id a1 a2 a3 b4 b5 I need to retrieve the maker which include at least 2 pc.id. I try to write in this form, but it is error! select maker from table1 where count(pc.id) 2 group by maker. thank you Danyu - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 for localhost connection.....
did you edit /etc/resolv.conf? dyu wrote: Dear all, i m running mysql on freebsd webserver and using our own DNS server. Everything run fine with database and web serving. However, i m trying to change the DNS ip addresses to our isp's DNS server instead of ours on this webserver. Then i got the following error: st 'localhost.isp.net' is not allowed to connect to this MySQL server at /usr/local/stronghold/cgi-bin/xxx.cgi line 30 [Mon Jan 29 12:11:06 2001] [error] Died at /usr/local/stronghold/cgi-bin/xxx.cgi line xx. = Does anyone have any idea to solve this problem? i really appreciated. Thanks Derrick - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How can I create one more table with existing table structure
create table newtable select * from oldtable where 10; This will solve your problem. Best regards, Fábio Ottolini - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, January 29, 2001 7:06 PM Subject: How can I create one more table with existing table structure From: Subba Reddy M Date: Fri, 26 Jan 2001 14:52:29 +0530 Hello MySQL guru, Please advise me, on creating new table with existing table structure. I have tried, how MySQL documentation referred, but unable to get success. create table newtable select * from oldtable; This works on 3.23.x check doc for version. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql jdbc drivers
hi i am trying to use mysql database for my application , which is being developed in java. where can i find jdbc drivers for mysql , and how to install them, i am using win nt as developement platform. Its not for any commercial application. thanks Vijay - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Hi, I managed to install the database but where can i find "mysql" in which directory. I am not being able to find this executable. Did I mess on the installation process. An early reply will highly appreciated. Thanks. Sanjeev Kabra.
Overloaded DB
I have a 6000user DB that has just moved to a new machine. The database starts up and runs fine for about 2 minutes. mysqld starts to hit heavy on the CPU bringing IDLE CPU usage down to 0.0 continuesly. Is there any way to find out what exactly is dragging the database down. I am sure there is an error log, but I am new to MySQL. Are there other logs that would be more specific? max_connections it set to 600, we then took it back to 475 still acts the same way. JM - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: how to delete records older than 14 days
DELETE FROM news WHERE newsdate=DATE_ADD(CURRENT_DATE, INTERVAL -14 DAY) Above is the code that I would use to do that job. Hope this helps. -Angela Thomas Katsampes wrote: Hello, I'm trying to figure out the correct syntax for requesting the database to remove all records older than 14 days. The mysql query that I am using (from within php4) is: //---update news so only last two weeks of news are available---// $sql2 = "delete from news where newsdate DATE_SUB(NOW(), INTERVAL 14 DAY)"; $result2 = mysql_db_query($dbname,$sql); But it doesn't seem to be working. Here is the the definition of the "news" table: mysql describe news; +--+--+--+-+-++ | Field| Type | Null | Key | Default | Extra | +--+--+--+-+-++ | id | int(3) | | PRI | 0 | auto_increment | | hub | char(3) | YES | | NULL || | newsdate | date | YES | | NULL || | headline | varchar(100) | YES | | NULL || | article | longtext | YES | | NULL || +--+--+--+-+-++ 5 rows in set (0.05 sec) Basically this is for a news page, and items get pushed down the "list" (what the viewer sees) and then eventually are supposed to be deleted. Any suggestions on how to do this more efficiently would be welcome as well. Please email me directly (hit reply to the message). Thanks- Thomas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
'USE_RAID' in mysql-3.22.32?
In pawing though the source for mysql-3.22.32 (our current version in production), I noticed in acconfig.h, a macro 'USE_RAID', which in term seems to set up the use of include/raid.h. But, I can't find any documentation for this, and the configure program doesn't seem to set it one way or another. What is the state of that code? For that version of MySQL, it it useful/meaningful to activate it, if I intend to make use of a RAID array? -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: 3 million+ records problems.
On Sat, Jan 27, 2001 at 09:32:56PM +0300, Artem Koutchine wrote: Hmm.. So ID is not PRIMARY KEY (not UNIQUE index).. That makes it harder. A lot harder. A lot depends now on how many records per ID you have there on average. If you you have only, say, 50 ids then you'll be slower. Basically the query you do MUST BE A SLOW QUERY. What you can do is set arguments for your mysqld -O key_buffer=64Mb -O sort_buffer=4MB Not without adding more physical RAM! He only has 64MB. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: 'USE_RAID' in mysql-3.22.32?
In the create table documenttation, it explains the USE_RAID, and a few other options pertaining to it. Gregg - Original Message - From: Brian Reichert [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, January 29, 2001 4:22 PM Subject: 'USE_RAID' in mysql-3.22.32? In pawing though the source for mysql-3.22.32 (our current version in production), I noticed in acconfig.h, a macro 'USE_RAID', which in term seems to set up the use of include/raid.h. But, I can't find any documentation for this, and the configure program doesn't seem to set it one way or another. What is the state of that code? For that version of MySQL, it it useful/meaningful to activate it, if I intend to make use of a RAID array? -- Brian 'you Bastard' Reichert [EMAIL PROTECTED] 37 Crystal Ave. #303 Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Multi-lingual support
I'm wondering if anyone has any experience in setting up MySQL as a backend to a website with multi-lingual support? What I'm trying to do is have a web site with a main "gateway" page that allows a user to choose their language. This will bring them to the actual content, but in the language of their choice. The problem is, most of the data is dynamically generated via servlets connecting to a MySQL database. Since sorting does take place on that data, I'm assuming that the charset in use becomes important to MySQL. Is it possible (or necessary) to specify a charset on the fly, or at table creation time (ie, per table charset)? Anyone have experience with this? Thanks in advance, -Brian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: 'USE_RAID' in mysql-3.22.32?
On Mon, 29 Jan 2001, Brian Reichert wrote: In pawing though the source for mysql-3.22.32 (our current version in production), I noticed in acconfig.h, a macro 'USE_RAID', which in term seems to set up the use of include/raid.h. But, I can't find any documentation for this, and the configure program doesn't seem to set it one way or another. What is the state of that code? For that version of MySQL, it it useful/meaningful to activate it, if I intend to make use of a RAID array? This is impossible. RAID was introduced in 3.23.x series. Also documentation have evreything about it. Tonu - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: backup and restore mysql
Sorry if this is a little late- but at Abriasoft we are currently developing a tool that can be used for automated backup of your MySQL databases from one or more servers with the ability to restore from the backups in the event that you need to. Our tool uses a C daemon and a php web interface (thus requiring php with MySQL support). While the product isn't 100% finished yet, if this is something you would be interested in beta testing for us- please send us a note! You can request to beta test the product at [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Please do not reply to the list, use the e-mail address above, and let us know if you are interested in x86 linux or Windows. On Thursday, January 4, 2001, at 12:43 PM, Ashish Shah wrote: Hi all, How do I backup/restore mysql? Any help would be appriciated. Thanks. = Ashish Toronto, Canada __ Do You Yahoo!? Yahoo! Photos - Share your holiday photos online! http://photos.yahoo.com/ -- - Please check "http://www.mysql.com/documentation/manual.php" before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to: [EMAIL PROTECTED] If you have a broken mail client that cannot send a message to the above address (Microsoft Outlook), you can use: http://lists.mysql.com/php/unsubscribe.php -=-=-=-=-=-=-=-=-=-=-=-=-=-=- Michael A. Peters Abriasoft Senior Developer http://www.abriasoft.com/ (510) 623-9726x357 Fax: (510) 249-9125 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Verification
Hello, I just want to make sure that I can do this but would this scenario work properly. I build an sql database and perl interface at site www.siteX.com. A person on www.siteY.com is going to utilize this tool The perl interface running on www.siteY.com makes a call to the database from www.siteX.com. As long as www.siteY.com is granted access to the database, it should be able to access the database right? Just wanted to check? 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
where to get the Mysql++ API class docuementation.?
hi: Do you know where to get the class and their methods documentation of Mysql++ API, Regards Hensen - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
gemini
Where can we find more information about gemini and when it will be done exactly (date)? -- -Spinlock EmpireQuest Creator http://www.empirequest.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How to avoid ERROR :1045
maybe root password is not set... check root password or login as root without password.. From: "Artem Koutchine" [EMAIL PROTECTED] To: "Velamarthy Murthy" [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: How to avoid ERROR :1045 Date: Sun, 28 Jan 2001 15:13:23 +0300 i don't know exactly, but based on the message it seems to be a permission problem in the mysql rights. So, RTFM on the mysql permission model and commands. - Original Message - From: "Velamarthy Murthy" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, January 28, 2001 3:08 PM Subject: How to avoid ERROR :1045 Dear Sir, Hello, We have installed MySql in Windows NT Server. MysqlAdmin services are doing fine and but when we try to enter the prompt of mysql.we are getting the follwing error ERROR :1045 Access denied for user 'odbc@localhost )using password yes port is:3306 and user is :root How to rectify this. Anticipating promptly, Thanking you, __ 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 [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 _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.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: Verification
I'm going to have to answer Yes, and No. Yes, they can access it. No, it won't be the best situation. The internet is not very trustworthy, and having DB's seperated over such large distances accessing instantly is probably not the best choice. Not to mention that if you have large record sets, it can really slow down. A better choice IMHO would be to replicate pieces of the DB on the client's machine, and have an automated batch process setup every night or so to update the tables. - Original Message - From: "Carlos Corzo" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, January 29, 2001 3:06 PM Subject: Verification Hello, I just want to make sure that I can do this but would this scenario work properly. I build an sql database and perl interface at site www.siteX.com. A person on www.siteY.com is going to utilize this tool The perl interface running on www.siteY.com makes a call to the database from www.siteX.com. As long as www.siteY.com is granted access to the database, it should be able to access the database right? Just wanted to check? Thanks. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: OK, I'll bite
On Sun, Jan 28, 2001 at 11:26:29AM -0500, Lee Jenkins wrote: Very, very cool. What will happen to the licensing and/or price for this version? According to the Press Release, Spring 2001. And I believe it will be GPL'd. But I could be mistaken. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Question regarding portability and licence
I am an independent web developer working on a web based application that I plan on giving to companies to use to track certain activities. I am currently developing this application using ASP and VB and integrating it into an MS SQL server. I have some companies using MS SQL, some using ORACLE and some with nothing. For my Clients with nothing, I was wondering how hard it would be to port my application to mySQL while maintaining the same functionality as ORACLE and MS SQL? Furthermore, what License, if any, would the company need to run mySQL? They would use it on their web server only (some on Apache some on NT/2000.) Thanks in advance for your help and your responses Waldo B.
Does this list support replication questions??
Hi everyone, I have twice posted a problem with replication and have since seen 2 or 3 others post with similar replication questions and problems. However I have yet to see ANYONE respond to any of those posts. I dont understand, it feels like we're being totally ignored. Can no one offer any help in this area? Thanks Ricardo - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 jdbc drivers
This site provide the JDBC driver and all the tutorial : http://www.worldserver.com/mm.mysql/ --Andy-- -Original Message- From: Vijay Chandra [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 30, 2001 4:55 AM To: '[EMAIL PROTECTED]' Subject: mysql jdbc drivers hi i am trying to use mysql database for my application , which is being developed in java. where can i find jdbc drivers for mysql , and how to install them, i am using win nt as developement platform. Its not for any commercial application. thanks Vijay - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Does this list support replication questions??
nope sorry On Mon, 29 Jan 2001, Ricardo Kleemann wrote: Hi everyone, I have twice posted a problem with replication and have since seen 2 or 3 others post with similar replication questions and problems. However I have yet to see ANYONE respond to any of those posts. I dont understand, it feels like we're being totally ignored. Can no one offer any help in this area? Thanks Ricardo - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- -Spinlock EmpireQuest Creator http://www.empirequest.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL Perl DBI/DBD
I have followed the instructions at http://www.symbolstone.org/cgi/dbi/moduledump?module=Msql-Mysql-modules to install MySQL Perl DBI/DBD which are: First of all you need to fetch the archives from any CPAN mirror, for example ftp://ftp.funet.fi/pub/languages/perl/CPAN/modules/by-module The following archives are required (version numbers may have changed, I choose those which are current as of this writing): DBI/DBI-1.13.tar.gz Data/Data-ShowTable-3.3.tar.gz DBD/Msql-Mysql-modules-1.2217.tar.gz Then enter the following commands: gzip -cd DBI-1.13.tar.gz | tar xf - cd DBI-1.13 perl Makefile.PL make make test make install cd .. gzip -cd Data-ShowTable-3.3.tar.gz | tar xf - cd Data-ShowTable-3.3 perl Makefile.PL make make install # Don't try make test, the test suite is broken cd .. gzip -cd Msql-Mysql-modules-1.2217.tar.gz | tar xf - cd Msql-Mysql-modules-1.2217 perl Makefile.PL make make test make install During "perl Makefile.PL" you will be prompted some questions. In particular you have to choose the installed drivers (MySQL, mSQL2 and/or mSQL1). The MySQL driver will be called DBD::mysql, a single mSQL driver will be called DBD::mSQL. If you want to support both mSQL1 and mSQL2, they former will be DBD::mSQL1. I can't find 2217 anywhere so I used 2215. Everything seemed fine, but when I run a simple Perl test script as follows: #!/usr/local/bin/perl -w use DBI; I get: Can't locate DBI.pm in @INC (@INC contains: /usr/local/lib/perl5/5.6.0/i586-linux ... at ./test line 3 Can someone take a moment to get me on the right track here? Thanks Don Hargroves - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 with Query Syntax?
Hi all. I'm having a little trouble with this query. **Table 1 (Orders) ** OrderID SmallInt OrderStatus VarChar(20) CustomerPhone VarChar(10) SalesRepIDSmallInt(11) **Table 2 (Customers)** CustomerFirst VarChar(20) CustomerLastVarChar(20) CustomerPhone VarChar(10) **Table 3 (SalesReps)** SalesRepID SmallInt(11) SalesRepFirst VarChar(20) SalesRepLast VarChar(20) I'm trying to retrieve all ORDERS with the CustomerFirst and CustomerLast and the SalesRepFirst and SalesRepLast from these respective tables. There are other fields and they are listed in the SQL statement below. The ODBC driver informs me that there is a problem with the JOINS. I'm very new to MySQL syntax. Can you join more than one table? SELECT DISTINCT deliverycustomers.CustomerFirst, deliverycustomers.CustomerLast, deliverycustomers.CustomerAddress1, deliverycustomers.HouseNumber, orders.OrderID, servers.ServerFirst, servers.ServerLast, deliverycustomers.CustomerPhone, orders.OrderTime FROM servers INNER JOIN deliverycustomers INNER JOIN orders ON deliverycustomers.CustomerPhone = orders.CustomerPhone ON servers.ServerID = orders.DriverID GROUP BY deliverycustomers.CustomerFirst, deliverycustomers.CustomerLast, deliverycustomers.CustomerAddress1, deliverycustomers.HouseNumber, orders.OrderID, servers.ServerFirst, servers.ServerLast, deliverycustomers.CustomerPhone, orders.OrderTime WHERE Orders.OrderType = 'Delivery' AND (Orders.OrderStatus = 'Open' OR Orders.OrderStatus = 'PreAuth') ORDER BY OrderTime; Any help would be greatly appreciated. Lee Jenkins - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Help with Query Syntax?
Hmmm... Looks like you over did the query to me. This should work. SELECT o.OrderID, c.CustomerFirst, c.CustomerLast, s.SalesRepFirst, s.SalesRepLast FROM Orders as o, Customers as C, SalesReps as s WHERE O.CustomerPhone=c.CustomerPhone AND o.SalesRepID=s.SalesRepID of course you don't need the o.OrderID but I usually like selecting the ID from the main table being queried. - Original Message - From: "Lee Jenkins" [EMAIL PROTECTED] To: "MySQL Mail list" [EMAIL PROTECTED] Sent: Monday, January 29, 2001 10:18 PM Subject: Help with Query Syntax? Hi all. I'm having a little trouble with this query. **Table 1 (Orders) ** OrderID SmallInt OrderStatus VarChar(20) CustomerPhone VarChar(10) SalesRepID SmallInt(11) **Table 2 (Customers)** CustomerFirst VarChar(20) CustomerLastVarChar(20) CustomerPhone VarChar(10) **Table 3 (SalesReps)** SalesRepID SmallInt(11) SalesRepFirst VarChar(20) SalesRepLast VarChar(20) I'm trying to retrieve all ORDERS with the CustomerFirst and CustomerLast and the SalesRepFirst and SalesRepLast from these respective tables. There are other fields and they are listed in the SQL statement below. The ODBC driver informs me that there is a problem with the JOINS. I'm very new to MySQL syntax. Can you join more than one table? SELECT DISTINCT deliverycustomers.CustomerFirst, deliverycustomers.CustomerLast, deliverycustomers.CustomerAddress1, deliverycustomers.HouseNumber, orders.OrderID, servers.ServerFirst, servers.ServerLast, deliverycustomers.CustomerPhone, orders.OrderTime FROM servers INNER JOIN deliverycustomers INNER JOIN orders ON deliverycustomers.CustomerPhone = orders.CustomerPhone ON servers.ServerID = orders.DriverID GROUP BY deliverycustomers.CustomerFirst, deliverycustomers.CustomerLast, deliverycustomers.CustomerAddress1, deliverycustomers.HouseNumber, orders.OrderID, servers.ServerFirst, servers.ServerLast, deliverycustomers.CustomerPhone, orders.OrderTime WHERE Orders.OrderType = 'Delivery' AND (Orders.OrderStatus = 'Open' OR Orders.OrderStatus = 'PreAuth') ORDER BY OrderTime; Any help would be greatly appreciated. Lee Jenkins - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Apache cannot run thru socket
This is hopefully a simple problem. I have just upgraded my server from RH 6.2 to RH 7.0 and have upgraded the MySql as well. Having sorted out the missing Perl modules I have finally arrived at the point where the following error is returned by Perl to the browser: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) at /var/www/cgi-perl/lannet_login.pl line 30. When I try to run the same script on the server as: perl -d /var/www/cgi-perl/lannet_login.pl It runs OK and completes, so the problem looks to be between Apache and MySQL. The socket does exist, is 777 and is UID=mysql. Apache is running as UID=apache and in the perl script the MySQL user is LANNet. Where should I be starting to look for the problem. I am even flicked as to what documentation I should be looking at. -- Howard. LANNet Computing Associates http://lannetlinux.com "...well, it worked before _you_ touched it!" - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Access Ports
Aftab Rashid wrote: Hi, A friend has told me that there is port on which mysql allows anyone to access mysql without authentication, is that right? If yes, what is the port number ? Regards, -- Aftab Rashid Manager Systems Beaconet 164 P, Gulberg II, Lahore, Pakistan +92-42-11122 http://www.beaconet.net Aftab: To my knowledge, such a port doesn't exist. Why would anyone want such access without authentication? Just curious. Van -- = Linux rocks!!! http://www.dedserius.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
Access Ports
Hi, A friend has told me that there is port on which mysql allows anyone to access mysql without authentication, is that right? If yes, what is the port number ? Regards, -- Aftab Rashid Manager Systems Beaconet 164 P, Gulberg II, Lahore, Pakistan +92-42-11122 http://www.beaconet.net
Re: Does this list support replication questions??
On Mon, Jan 29, 2001 at 04:40:53PM -0800, Ricardo Kleemann wrote: Hi everyone, I have twice posted a problem with replication and have since seen 2 or 3 others post with similar replication questions and problems. You've certainly been on the list long enough to witness the volume of mail it gets. It doesn't all get answered right away. However I have yet to see ANYONE respond to any of those posts. We're all volunteers here. (Well, most of us...) I dont understand, it feels like we're being totally ignored. Can no one offer any help in this area? The questions which seem to almost always get answers fall into two groups: (1) Easy questions. They're almost always in the manual, so we can refer someone there. (2) Well documented harder problems where it is clear that the person asking has taken some initiative on their end (checked the manual, tried several obvious things). I don't know if your problem falls into either of those groups. Maybe it does. Other questions often get answers to, but not always. Maybe someone knows the answer and just hasn't had the free time to answer it. Maybe nobody knows the answer. It's difficult to say. If you really need answers without significant delay, you can always buy a support contract from MySQL. On this list you're dealing with folks who answer questions in their free time (with no obligation to do so) and who pick and choose those they want to answer. Perhaps you can give it a day or so yet and try re-posting. Maybe putting "2nd request for replication help" in the subject will help. Good luck, Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Creating of database with userid and password
Hi, How do I Create a Database with Userid and Passwords. Eg. CREATE DATABASE USER. Such that I am able to login and access the database using this userid and password. Thanks Richard
ERROR 1170: BLOB column 'Url' used in key specification without a key length
I have no idea what this error is trying to tell me... I have a table called "Headlines" which contains a VARCHAR(255) field called "Url". I need to store larger values in the "Url" column, so I want to convert it to TINYTEXT. ---snip--- mysql alter table Headlines modify Url TINYTEXT NOT NULL; ERROR 1170: BLOB column 'Url' used in key specification without a key length ---snip--- There is currently a unique index on the Url column. The manual states that one can have an index on a BLOB column: http://www.mysql.com/doc/B/L/BLOB.html So I don't see the problem. A search of the mail archives has turned up nothing. A search of google also turned up nothing helpful. Any ideas? This is MySQL 3.23.29. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQLGUI
from the MySQL site is MySQLGUI. will this run on OS X pb? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 1170: BLOB column 'Url' used in key specification without a key length
On Mon, Jan 29, 2001 at 10:07:55PM -0800, Jeremy D. Zawodny wrote: ---snip--- mysql alter table Headlines modify Url TINYTEXT NOT NULL; ERROR 1170: BLOB column 'Url' used in key specification without a key length Oh, okay. Now I understand. The max key length is 256, so I'd need to specify a number = 256 in the index for that column. Hmm. It'd be really nice if the 256-character max key length wasn't a compile-time directive, but a run-time directive instead. Back to the drawing board a bit... Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 1170: BLOB column 'Url' used in key specification without a key length
Personally speaking, if the index 256, it will lost the meaning of indexing... - Original Message - From: "Jeremy D. Zawodny" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, January 30, 2001 3:06 PM Subject: Re: ERROR 1170: BLOB column 'Url' used in key specification without a key length On Mon, Jan 29, 2001 at 10:07:55PM -0800, Jeremy D. Zawodny wrote: ---snip--- mysql alter table Headlines modify Url TINYTEXT NOT NULL; ERROR 1170: BLOB column 'Url' used in key specification without a key length Oh, okay. Now I understand. The max key length is 256, so I'd need to specify a number = 256 in the index for that column. Hmm. It'd be really nice if the 256-character max key length wasn't a compile-time directive, but a run-time directive instead. Back to the drawing board a bit... Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Dual servers on one NetApp
On Sun, Jan 28, 2001 at 10:47:21PM -0800, Bob Cottrell wrote: Hello there, We have a number of Sun sparcs connected to 2 NetApp file servers, and are currently using 1 sparc running mysql with the databases residing on one of the NetApps. I would like to run a 2nd sparc mysql server, also serving the same databases (read-only) from the same NetApp. Is this possible using replication without duplicating the databases in seperate directories (ie. /usr/local/mysql/hostname/var/*)? You can do it with replication, but that does result in each server having it's own copy of the data. Or you can tell the servers to use the same data and use external locking. See `--enable-locking' http://www.mysql.com/doc/C/o/Command-line_options.html to try the second option... Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 start mysqld
On Tue, Jan 30, 2001 at 01:09:14AM +0100, [EMAIL PROTECTED] wrote: Description: Can't start mysqld. In /var/mysql/hostname.err, there is a line saying "getpwnam: Undefined error: 0" How-To-Repeat: /usr/local/bin/safe_mysqld Hm. What user have you configured MySQL to run as? Does that user exist? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 - Long varchar
Hi, we are testing out MySQL, too se if it might meet our needs. We are currently having problems returning Text fields from the database through ODBC. System: Win NT 4.0 Visual Basic 6.0 Ent. RDO (Remote data objekts, must use!) MySQL servers both on W32 and Linux The first record in the result contains the correct content of the Text field, but the rest returns NULL. Is there any setting that might fix this problem? Another thing: show fields from #tablename# returns 1 record more in a Linux MySQL server than in the W32. Is there a way to control how much info that is returned? Regards ystein Selbekk, Visbook AS - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Creating of database with userid and password
How do I Create a Database with Userid and Passwords. Eg. CREATE DATABASE USER. Such that I am able to login and access the database using this userid and password. Check out the manual. Search for MYSQLADMIN and GRANT. Much other info can be found at www.devshed.com 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
