SUPPORT PLEASE - Error while running mysql_install_db
From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: SUPPORT PLEASE - Error while running mysql_install_db >Description: After installing successfully mysql in my sun solaris - sparc machine, while i am trying to run the script "mysql_install_db" system has given the following error message ld.so.1: ./bin/my_print_defaults: fatal: libz.so.1: open failed: No such file or directory WARNING: The host 'inatp12wks99' 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 ld.so.1: ./bin/mysqld: fatal: libpthread.so.1: version `SUNW_1.2' not found (required by file ./bin/mysqld) Killed Installation of grant tables failed! Examine the logs in ./data for more information. You can also try to start the mysqld daemon with: ./bin/mysqld --skip-grant & You can use the command line tool ./bin/mysql to connect to the mysql database and look at the grant tables: shell> ./bin/mysql -u root mysql mysql> show tables Try 'mysqld --help' if you have problems with paths. Using --log gives you a log in ./data that may be helpful. The latest information about MySQL is available on the web at http://www.mysql.com Please consult the MySQL manual section: 'Problems running mysql_install_db', and the manual section that describes problems on your OS. Another information source is the MySQL email archive. Please check all of the above before mailing us! And if you do mail us, you MUST use the ./bin/mysqlbug script! >Submitter-Id: Ramnarayanan >Originator: Super-User >Organization: iNautix Technologies India Pvt Ltd., TN, Chennai >MySQL support : none >Synopsis: Error while running mysql_install_db >Severity: critical >Priority: high >Category: mysql >Class:support >Release: mysql-3.23.49 (Official MySQL binary) >Environment: System: SunOS inatp12wks99 5.6 Generic_105181-26 sun4u sparc SUNW,Ultra-5_10 Architecture: sun4 Some paths: /usr/local/bin/perl /usr/local/bin/make /usr/local/bin/gmake /usr/local/bin/gcc /opt/SUNWspro/bin/cc GCC: Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.6/2.95.2/specs gcc version 2.95.2 19991024 (release) Compilation info: CC='gcc' CFLAGS='-O3 -fno-omit-frame-pointer' CXX='gcc' CXXFLAGS='-O3 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' LIBC: -rw-r--r-- 1 bin bin 1623052 Apr 27 2001 /lib/libc.a lrwxrwxrwx 1 root root 11 Aug 29 2001 /lib/libc.so -> ./libc.so.1 -rwxr-xr-x 1 bin bin 1024620 Apr 27 2001 /lib/libc.so.1 -rw-r--r-- 1 bin bin 1623052 Apr 27 2001 /usr/lib/libc.a lrwxrwxrwx 1 root root 11 Aug 29 2001 /usr/lib/libc.so -> ./libc.so.1 -rwxr-xr-x 1 bin bin 1024620 Apr 27 2001 /usr/lib/libc.so.1 Configure command: ./configure --prefix=/usr/local/mysql ' --with-comment=Official MySQL binary' --with-extra-charsets=complex --with-server-suffix= --enable-thread-safe-client --enable-local-infile --enable-assembler --disable-shared - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Maximum number of rows in the table
I don't think there is a limit. Just as long as your harddisk can contain the data there should be no problem. Remco - Original Message - From: "chandra shekar" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, May 07, 2002 5:21 AM Subject: Maximum number of rows in the table > Hi MySql gurus, > > We are using MySql for our database support in our project. It is > a multiserver environment. We are using a single table to store > info abt objects of each server. We want to know what is the > maximum number of rows that the MySql supports for a table. > In our case when the number of rows exceeds 1500 the server > crashes. Is it the max number of rows ? > > with regards, > Chandrashekar B.N. > > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > 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: quota on mysql
Thanks Alexander, It is really a good solution. But a small problem again. When I drop a user1_db database, mysql does not allow me to drop it and throw a error [root@myserver mysql]# mysqladmin drop user1_db -u root -p Enter password: Dropping the database is potentially a very bad thing to do. Any data stored in the database will be destroyed. Do you really want to drop the 'user1_db' database [y/N] y mysqladmin: DROP DATABASE user1_db failed; error: 'Error dropping database (can't rmdir './user1_db', errno: 20)' Thanks & Regards Praful - Original Message - From: "Alexander Keremidarski" <[EMAIL PROTECTED]> To: "Praful Saijare" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, May 06, 2002 19:31 Subject: Re: quota on mysql > HI, > Praful Saijare wrote: > > >Hi all, > > How do I go about applying user quota on mysql databases, so that I = > >can keep track of the disk space used by all the databases users. > > > >I am using RH linux 7.0 =20 > >Mysql 3.23.40 installed on /var/lib/mysql/ > >quota-2.00pre3-7 applied on /home partation > > > >Thanks in advance > >Praful > > > Place user databases in their home dirs with some conventional names and > make symlinks into mysql datadirs. > > Example: > > mkdir /home/user1/mysql_db > chmod 700 /home/user1/mysql_db > chown mysql home/user1/mysql_db > ln -s /home/user1/mysql_db /var/lib/mysql/user1_db > > > -- > Best regards > -- > For technical support contracts, visit https://order.mysql.com/ >__ ___ ___ __ > / |/ /_ __/ __/ __ \/ /Mr. Alexander Keremidarski <[EMAIL PROTECTED]> > / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer > /_/ /_/\_, /___/\___\_\___/ Sofia, Bulgaria ><___/ www.mysql.com M: +359 88 231668 > > > > > > > "Incoming mail has been certified virus free by Cyquator using fully automated antivirus protection powered by McAfee." > > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
join & group problem
Hello, i have 2 tables, one: ++---+ | id | descr | ++---+ | 1 | fir | | 2 | two | | 3 | fre | | 4 | fou | ++---+ two: ++--+ | id | data | ++--+ | 1 | a| | 1 | b| | 1 | c| | 1 | d| ++--+ SELECT one.descr, COUNT(two.id) xxx FROM one LEFT JOIN two USING(id) GROUP BY two.id ORDER BY one.id; i got: +---+-+ | descr | xxx | +---+-+ | fir | 4 | | two | 0 | +---+-+ 2nd row is what(mysql Ver 11.15 Distrib 3.23.43, for pc-linux-gnu (i686)) ??? I tested it home and i got only one row (tested on mysql 4.0.1 on win). but i need this result: descr count -- fir 4 two 0 fre 0 fou 0 it's possible to get this result in one guery ?? i need that goup by will affect only join, no whole query. Thank you for help. Regards, Michal Dvoracek [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: JDBC connection to MySQL
Just a guess, but how about an ampersand?
Connection c =
DriverManager.getConnection("jdbc:mysql://localhost/dbName?user=username&pas
sword=password");
George
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, May 07, 2002 5:11 AM
Subject: JDBC connection to MySQL
> Hello,
> I've been struggling with this for two weeks, I can't seem to find the
answer
> wherever I look whether in the core mysql book or the documentation on
what
> variables, if any go between parameters(user and password) as in:
> Connection c =
> DriverManager.getConnection("jdbc:mysql://localhost/dbName?user=username,
> password=password");
> what goes between the user parameter and the password parameter( a comma?
a
> space? no space?).
> I presume since the mm.mysql driver (org.gjt.) is under the servlet
> directory and the servlets are working I don't need to set the classpath
to
> the driver(i.e already set to the parent, servlet directory). Thanks in
> advance.
> Patrick
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>http://lists.mysql.com/ (the list archive)
>
> 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: display days between two dates?
Hello, I think Mr. Carlson requires to output all the dates between two given dates. This can be done with defined variables and an auxiliary table, the requirement being that it should have at least as many rows as there are days between the dates and to directly give the number of days between the dates in the limit clause. (Hope in the future mysql will accept variables in the limit clause and also in IN clause). Select @stdate := '2002-02-07'; Select @stdate := @stdate + interval 1 day from tablename limit 5; Anvar. At 03:56 PM 06/05/2002 +0300, you wrote: >Hello, >Tim Carlson wrote: > >>Hello, >> >>Newbie SQL person here. I am hoping to be able to do the >>following. Given two dates, I would like to display all of the days >>between them. >> >>So if I had the dates 2002-02-08 and 2002-02-12, I would like to have >>MySQL spit back >> >>2002-02-08 >>2002-02-09 >>2002-02-10 >>2002-02-11 >>2002-02-12 >> >>Any way I can do this directly in MySQL without constructing a table? I've >>looked through the date maniplulation routines in the manual, but nothing >>jumps out at me. Any pointers would be appreciated. >Suppose you have some table with column called date_col DATE. i.e. >containing dates as above >Now if your question is: >How to select all rows where is true that date_col is between dates >2002-02-08 and 2002-02-12? > >You can use almost same spelling. (SQL is written to be close to natural >english) > >mysql> SELECT date_col FROM your_table WHERE date_col BETWEEN '2002-02-08' >AND '2002-02-12'; > >will be valid statement :) > >-- >Best regards >-- >For technical support contracts, visit https://order.mysql.com/ > __ ___ ___ __ > / |/ /_ __/ __/ __ \/ /Mr. Alexander Keremidarski > <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer >/_/ /_/\_, /___/\___\_\___/ Sofia, Bulgaria > <___/ www.mysql.com M: +359 88 231668 > > > > > >- >Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > >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
JDBC connection to MySQL
Hello,
I've been struggling with this for two weeks, I can't seem to find the answer
wherever I look whether in the core mysql book or the documentation on what
variables, if any go between parameters(user and password) as in:
Connection c =
DriverManager.getConnection("jdbc:mysql://localhost/dbName?user=username,
password=password");
what goes between the user parameter and the password parameter( a comma? a
space? no space?).
I presume since the mm.mysql driver (org.gjt.) is under the servlet
directory and the servlets are working I don't need to set the classpath to
the driver(i.e already set to the parent, servlet directory). Thanks in
advance.
Patrick
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
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 set a password
Oh forgot to ask in the last post, how are you setting the password in the first place? Are you using a grant statement or inserting values into the table. I reckon the former is better (and safer) but if you're doing the later the you need to "flush privliges" after any changes so that mysql rereads the grant tables. If you can give us the exact line(s) you're putting in then that could help us see the problem (change/mask the password of course). cheers, noel On Tuesday, May 07, 2002 1:44 PM, Noel Clarkson [SMTP:[EMAIL PROTECTED]] wrote: > See that line that says accept any user (%) from any host (%) with password > null. There's your answer. It's a default entry that should be removed (I > think there's stuff in the securing mysql section of the manual about > this). > > cheers > > noel > > On Tuesday, May 07, 2002 1:28 PM, Brandon Metcalf > [SMTP:[EMAIL PROTECTED]] wrote: > > Okay, I'm obviously missing something here. Even though the > > submit_write user has a password set according to the SELECT output > > below, I can't use that password or any password to login as this user. > > Only a null password is accepted. The first attempt I enter the correct > > password; no go. The second attempt I don't enter a password; I'm in. > > > > What gives? > > > > > > mysql> select host,user,password from user mysql; > > +---+--+--+ > > | host | user | password | > > +---+--+--+ > > | localhost | root | 0d7d2b5f41747747 | > > | mccrae| root | 0d7d2b5f41747747 | > > | localhost | | | > > | mccrae| | | > > | % | %| | > > | % | submit_write | 65f6943414e7dad9 | > > | localhost | %| | > > +---+--+--+ > > 7 rows in set (0.01 sec) > > > > mysql> quit > > Bye > > root@mccrae mysql # bin/mysql --user=submit_write --password > > Enter password: > > ERROR 1045: Access denied for user: 'submit_write@localhost' (Using > > password: YES) > > root@mccrae mysql # bin/mysql --user=submit_write --password > > Enter password: > > Welcome to the MySQL monitor. Commands end with ; or \g. > > Your MySQL connection id is 76 to server version: 3.23.48 > > > > Type 'help;' or '\h' for help. Type '\c' to clear the buffer. > > > > mysql> > > > > > > > > Brandon > > -- > > Beware the fury of a patient man. > >--John Dryden > > > > > > - > > Before posting, please check: > >http://www.mysql.com/manual.php (the manual) > >http://lists.mysql.com/ (the list archive) > > > > 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
newbie question:count() and display details
Hi I have a (probably fairly simple newbie question: Using a select statement (via DBI) I get some details from a table and at the same time have a row count of how many rows are returned (to be displayed at the website). A query like select count(nation) AS nation, name, nation from memberscopy where nation = "Austrian" order by course; results in the following error: ERROR: Query failed (Mixing of GROUP columns (MIN(),MAX(),COUNT()...) with no GROUP columns is illegal if there is no GROUP BY clause) If I use : select count(*) AS nation, name, nation from memberscopy where nation = "German" group by surname order by course ; I get those details | nation | name| nation | | 1 | Christian | Austrian | | 1 | Christian | Austrian | | 1 | Maximilian | Austrian | | 1 | Edgar Alexander | Austrian | | 1 | Erik| Austrian | | 1 | Maria | Austrian | Is there any way that I can get a line count of the result set and the details with onl one query? Thanks for your help! Sven - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
strmov
hi, Which header file or library i need to include for strmov ? i have mysql v3 and i have included mysqlclient library. But it still tells undefined reference. Thanx in advance Chirag - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
More appropriate way to join tables?
I am guessing this is a pretty basic question... There must be a better way for me to do this, but I'm still too new at this to know what it is. I've gone through some JOIN tutorials and the documentation, but I don't think I'm quite getting it. (Using MySQL v3.23.38) I have three tables: my_clients, my_users, my_projects TABLE my_company: +---+ | company_id | company_name | +---+ | 1 | SuperCo| | 2 | Mega Inc. | +---+ TABLE my_users: +--+ | user_id | company_id | user_name | +--+ |1| 1 | Bob | |2| 1 | Jane| |3| 2 | Steve | +--+ TABLE my_projects: +--+ | project_id | user_id | company_id | project_name | +--+ | 1 |1| 1 | Put on socks | | 2 |2| 1 | Eat lunch| | 3 |3| 2 | Sing songs | +--+ I know the company_id and I want to see a list of all projects for that company. I can only image that there should be a way that I can make this work without having to create a company_id column in my_projects, but I can't get the query to work. I would like to just get a list of all users with company_id=1 and then show all projects for that company_id, in the end returning a list of project_name/user_name. I can get rid of the company_id if I'm performing a full join, but then I wind up with duplicates of the project_name (Project1/User1, Project1/User2, ...). Here is the query I am using with the tables as they are: SELECT my_projects.project_name, my_users.user_name FROM my_projects LEFT JOIN my_users ON (my_projects.user_id=my_users.user_id) WHERE my_projects.company_id = '$company_id' ORDER BY my_projects.user_id; This seems to give me a list of unique project names with the associated user's name. But if anyone has any corrections/pointers, they would be most appreciated. Thanks for any help. Wesley - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 set a password
See that line that says accept any user (%) from any host (%) with password null. There's your answer. It's a default entry that should be removed (I think there's stuff in the securing mysql section of the manual about this). cheers noel On Tuesday, May 07, 2002 1:28 PM, Brandon Metcalf [SMTP:[EMAIL PROTECTED]] wrote: > Okay, I'm obviously missing something here. Even though the > submit_write user has a password set according to the SELECT output > below, I can't use that password or any password to login as this user. > Only a null password is accepted. The first attempt I enter the correct > password; no go. The second attempt I don't enter a password; I'm in. > > What gives? > > > mysql> select host,user,password from user mysql; > +---+--+--+ > | host | user | password | > +---+--+--+ > | localhost | root | 0d7d2b5f41747747 | > | mccrae| root | 0d7d2b5f41747747 | > | localhost | | | > | mccrae| | | > | % | %| | > | % | submit_write | 65f6943414e7dad9 | > | localhost | %| | > +---+--+--+ > 7 rows in set (0.01 sec) > > mysql> quit > Bye > root@mccrae mysql # bin/mysql --user=submit_write --password > Enter password: > ERROR 1045: Access denied for user: 'submit_write@localhost' (Using > password: YES) > root@mccrae mysql # bin/mysql --user=submit_write --password > Enter password: > Welcome to the MySQL monitor. Commands end with ; or \g. > Your MySQL connection id is 76 to server version: 3.23.48 > > Type 'help;' or '\h' for help. Type '\c' to clear the buffer. > > mysql> > > > > Brandon > -- > Beware the fury of a patient man. >--John Dryden > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > 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: SpamAssassin tags messages from the list as spam (was: [fwd] *****SPAM***** Re: Problems with Time field (from: dump_pj@rediffmail.com))
On Mon, May 06, 2002 at 07:56:10AM +, Alexander Skwar wrote: > Hi! > > As you can see below, SpamAssassin tags messages from the MySQL list as > spam. The main reason that this happens, is: > > SPAM: Hit! (3.5 points) URI: URL of page called "unsubscribe" Well, you can add local rules to override SA. Or you could whitelist the mailing list. If you can get it added to the non-spam corpus that the SA developers run the GA against, that would help too. Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 88 days, processed 2,290,098,452 queries (299/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
can't set a password
Okay, I'm obviously missing something here. Even though the submit_write user has a password set according to the SELECT output below, I can't use that password or any password to login as this user. Only a null password is accepted. The first attempt I enter the correct password; no go. The second attempt I don't enter a password; I'm in. What gives? mysql> select host,user,password from user mysql; +---+--+--+ | host | user | password | +---+--+--+ | localhost | root | 0d7d2b5f41747747 | | mccrae| root | 0d7d2b5f41747747 | | localhost | | | | mccrae| | | | % | %| | | % | submit_write | 65f6943414e7dad9 | | localhost | %| | +---+--+--+ 7 rows in set (0.01 sec) mysql> quit Bye root@mccrae mysql # bin/mysql --user=submit_write --password Enter password: ERROR 1045: Access denied for user: 'submit_write@localhost' (Using password: YES) root@mccrae mysql # bin/mysql --user=submit_write --password Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 76 to server version: 3.23.48 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> Brandon -- Beware the fury of a patient man. --John Dryden - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Maximum number of rows in the table
Hi MySql gurus, We are using MySql for our database support in our project. It is a multiserver environment. We are using a single table to store info abt objects of each server. We want to know what is the maximum number of rows that the MySql supports for a table. In our case when the number of rows exceeds 1500 the server crashes. Is it the max number of rows ? with regards, Chandrashekar B.N. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
slow queries/ db performance
Under normal operating conditions our v3.23.47 MySql db server handles about 60 queries per second using 50 threads or less. The host is a dual processor 700MHz Intel machine running the 2.2.14-5.0smp Linux kernel with 256M of RAM. Here's the problem: during spikes of activity where about 90-100 queries/sec are being processed, the number of slow queries ties up an ever-increasing number of threads until our max connection limit is reached. This eventually will cause clients to wait for an inactive thread which effectively freezes our application. The slow query SQL statements are optimized - usually they take < .5 sec (~10-20K rows being examined), but when the server is in this state execution time ranges from 10-120 seconds. Questions: 1. Are an abundance of slow queries symptomatic of an overloaded DB server? (or are they simply a contributing factor?) 2. Is there a way to examine the state of a slow query besides the slow-query log? I.e. is there a way to tell exactly why a query is running slow? Running "explain" shows our SQL to be as optimized as it can get. 1. I've read threads in this group about similar server configurations handling > 200 queries/sec. What are the most effective ways of benchmarking a server against an application? I've included the MySql setting below. Any help would be greatly appreciated. mysql> show variables; +-+- --+ | Variable_name | Value | +-+- --+ | back_log| 50 | | basedir | /opt/mysql-3.23.47/ | | binlog_cache_size | 32768 | | character_set | latin1 | | character_sets | latin1 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 | /opt/mysql-3.23.47/var/ | | delay_key_write | ON | | delayed_insert_limit| 100 | | delayed_insert_timeout | 300 | | delayed_queue_size | 1000 | | flush | OFF | | flush_time | 0 | | have_bdb| NO | | have_gemini | NO | | have_innodb | NO | | have_isam | YES | | have_raid | NO | | have_openssl| NO | | init_file | | | interactive_timeout | 28800 | | join_buffer_size| 131072 | | key_buffer_size | 8388600 | | language| /opt/mysql-3.23.47/share/mysql/english/ | | large_files_support | ON | | locked_in_memory| OFF | | log | OFF | | log_update | OFF | | log_bin | ON | | log_slave_updates | OFF | | log_long_queries| ON | | long_query_time | 10 | | low_priority_updates| OFF | | lower_case_table_names | 0 | | max_allowed_packet | 16776192 | | max_binlog_cache_size | 4294967295 | | max_binlog_size | 1073741824 | | 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_user_connections| 0 | | max_tmp_tables | 32 | | max_write_lock_count| 4294967295 | | myisam_max_extra_sort_file_size | 256 | | myisam_max_sort_file_size | 2047 | | myisam_recover_options | 0 | | myisam_sort_buffer_size | 8388608 | | net_buffer_length | 16384 | | net_read_timeout| 30 | | net_retry_count | 10 | | net_write_timeout | 60 | | open_files_limit| 0 | | pid_file| /opt/mysql-3.23.47/var/winston.pid | | port| 3306 | | protocol_version| 10 | | record_buffer | 131072 | | record_rnd_buffer | 131072 | | query_buffer_size | 0 | | safe_show_database | OFF | | server_id | 1 | | slave_net_timeout | 3600 | | skip_locking| ON | | skip_networking | OFF | | skip_show_database
Re: Too Many Connections
On Mon, 06 May 2002 12:56:52 -0400 Gurhan Ozen <[EMAIL PROTECTED]> wrote: > Hi, > Change the max_connections variable's value to a higher value. By default it > is set to 100. You can see what yours is set to with SHOW VARIABLES command. > See: > > http://www.mysql.com/doc/T/o/Too_many_connections.html > http://www.mysql.com/doc/S/H/SHOW_VARIABLES.html > but you also have to check your Operating System configuration ... usually they have 1024 max connection to same port / socket. -- Let's call it an accidental feature. -- Larry Wall - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 up innodb
I am running mysql on solaris. This is a binary release. However, now I would like to start my server with the innodb functionality. But I can't start my server working for this. I am not able to run the ./configure --with-innodb I dont know how and where innodb_data_file_path should be specified I can't open the mysqld file to add the pathtodatafile Where am I suppose to set the variables at the startup(of mysql) Does someone have step by step process in mind that I can follow. Help would be extremely helpful. Regards. --Azhar Khan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Bug or error in SQL syntax - Specifying and using a user variable inside a single select query
> Gregg,
> Monday, May 06, 2002, 6:57:55 PM, you wrote:
>
> GG> Upon reading into the user variables section of the mysql manual, I
decided
> GG> to make my life easier inside several of my queries by specifying some
user
> GG> variables. Note that I'm trying to have everything inside the select
> GG> statement - Primarily because I'm simply passing it through to my data
> GG> mining software that interfaces through myODBC.
>
> GG> I'm trying to accomplish the following query (I'm executing these sql
> GG> queries directly from the command line) --
>
> GG>
> GG> SELECT
> GG>annual_filing.*,
> GG>companies.name AS company_name,
> GG>YEAR(filing_date) AS filing_year,
> GG>(@predictedYear := 1999) AS predictedYear,
> GG>(@earliestYear := 1996) AS earliestYear,
> GG>(@learnYear := 1998) AS learnYear
> GG> FROM
> GG>annual_filing,
> GG>companies
> GG> WHERE
> GG> annual_filing.company_id = companies.ds_id
> GG>AND
> GG> YEAR(filing_date) <= @predictedYear
> GG>AND
> GG> YEAR(filing_date) >= @earliestYear;
> GG>
>
> GG> The above query returned an empty set / no rows.
>
> You should first initialize user variables! By default they contain
> NULL values as SELECT works by first checking WHERE clause and only then
works
> for SELECT.
>
> Check the manual:
> http://www.mysql.com/doc/V/a/Variables.html
According to the manual from the above link, where it states:
==
You can set a variable with the SET syntax:
SET @variable= { integer expression | real expression | string expression }
[,@variable= ...].
You can also assign a value to a variable in statements other than SET.
However, in this case the assignment operator is := rather than =, because =
is reserved for comparisons in non-SET statements:
mysql> SELECT @t1:=(@t2:=1)+@t3:=4,@t1,@t2,@t3;
+--+--+--+--+
| @t1:=(@t2:=1)+@t3:=4 | @t1 | @t2 | @t3 |
+--+--+--+--+
|5 |5 |1 |4 |
+--+--+--+--+
==
mysql should be SET'ing the user variables in my query above. If mysql is
processing the WHERE first and then the SELECT, shouldn't the user variables
be set anyhow (even if the query returns an empty set)? For example:
==
mysql> SELECT
->annual_filing.*,
->companies.name AS company_name,
->YEAR(filing_date) AS filing_year,
->@predictedYear := 1999 AS predictedYear,
->@earliestYear := 1996 AS earliestYear,
->@learnYear := 1998 AS learnYear
-> FROM
->annual_filing,
->companies
-> WHERE
-> annual_filing.company_id = companies.ds_id
->AND
-> YEAR(filing_date) <= @predictedYear
->AND
-> YEAR(filing_date) >= @earliestYear;
Empty set (25.89 sec)
mysql> SELECT @predictedYear, @earliestYear, @learnYear;
++---++
| @predictedYear | @earliestYear | @learnYear |
++---++
| NULL | NULL | NULL |
++---++
1 row in set (0.00 sec)
==
If I execute a separate SELECT statement beforehand (Or SET for that matter)
setting the user variables then it works. However, I'm trying to use MyODBC
to connect into the server with my data mining software and I can't perform
multiple queries in this fashion (it expects me to only send one query).
:( Perhaps there's a workaround?
===
Gregg Graubins <[EMAIL PROTECTED]>
(PGP key available)
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
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: formatting currency in mysql
SELECT FORMAT(yourvalue,2) - Original Message - From: "Graeme B. Davis" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, May 06, 2002 10:16 PM Subject: formatting currency in mysql > Does anyone have a quick tip on how to format a float/numeric in the > following currency format with a query? > > $xx,xxx.xx > > Thanks! > > Graeme > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > 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: Merge tables, was [two table's columns into one columns w/oINSERT ... SELECT?]
At 15:44 -0500 5/6/02, Jay Blanchard wrote: >[snip] >>Then I attempt to query;mysql> select count(*) from tblCross1; >>ERROR 1016: Can't open file: 'tblCross1.MRG'. (errno: 143) >>perror 143 >>143 = Conflicting table definition between MERGE and mapped table >> >>Can anyone help with this? > >Drop the MERGE table, then try creating it with all the columns >in the original tables. >[/snip] > >OK, that work with two of the tables, I have to merge 3. Is that possible? Yes. > >Do the INDEXES have to exist on the same columns in each table? How >identical do the tables have to be? Identical. Column names, types, order within tables, and indexes. > >Thanks! > >Jay > >P.S. Paul, couldn't help but notice your last name, where are you from? Huh? Wisconsin. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Mac OS X connection error
Hi, I've installed MySQL through the entropy.ch installer. Everything works fine in the command line utillity but when I try to connect a php script i get this error message: Host 'localhost.127.in-addr.arpa' is not allowed to connect to this MySQL server I have tried various times to correc this but can't quite figure out what is causing this. Thanks ahead for any help. Bernardo - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Fw: SOP for hosting services?
Hi, I using Macromedia UltraDev to develop my dynamic web site and would like to use mySQL as the RDBMS. My hosting service folks are telling me that I should only update my database on their server via update transactions. They say this is for security reasons. UltraDev provides many good tools for viewing, adding, updating and deleting records for the database but I'm not sure how to produce add/delete/update transactions from UltraDev and I'm not convinced it is necessary to have the added layer of security. Is this standard operating procedure when making changes to mySQL databases or should I tell them that I want direct access to my database? Any help/suggestions/guidelines in this area would be very helpful. Thanks. Pete - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Merge tables, was [two table's columns into one columns w/o INSERT ... SELECT?]
[snip] >Then I attempt to query;mysql> select count(*) from tblCross1; >ERROR 1016: Can't open file: 'tblCross1.MRG'. (errno: 143) >perror 143 >143 = Conflicting table definition between MERGE and mapped table > >Can anyone help with this? Drop the MERGE table, then try creating it with all the columns in the original tables. [/snip] OK, that work with two of the tables, I have to merge 3. Is that possible? Do the INDEXES have to exist on the same columns in each table? How identical do the tables have to be? Thanks! Jay P.S. Paul, couldn't help but notice your last name, where are you 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: Merge tables, was [two table's columns into one columns w/oINSERT ... SELECT?]
At 15:29 -0500 5/6/02, Jay Blanchard wrote: >I have these two tables; >mysql> describe tblClass11; >+--+---+--+-+-++ >| Field| Type | Null | Key | Default | Extra | >+--+---+--+-+-++ >| ID | int(11) | | PRI | NULL| auto_increment | >| RecordID | varchar(6)| YES | | NULL|| >| RecordDate | varchar(10) | YES | | NULL|| >| CIC | varchar(4)| YES | | NULL|| >| Minutes | decimal(12,2) | YES | | NULL|| >| FileName | varchar(32) | YES | | NULL|| >| RecordNumber | int(11) | YES | | NULL|| >| WholeRecord | text | YES | | NULL|| >| ReceivedDate | varchar(10) | YES | | NULL|| >+--+---+--+-+-++ >9 rows in set (0.00 sec) > >mysql> describe tblClassOthers; >+--+---+--+-+-++ >| Field| Type | Null | Key | Default | Extra | >+--+---+--+-+-++ >| ID | int(11) | | PRI | NULL| auto_increment | >| RecordID | varchar(6)| YES | | NULL|| >| RecordDate | varchar(10) | YES | | NULL|| >| CIC | varchar(4)| YES | | NULL|| >| Minutes | decimal(12,2) | YES | | NULL|| >| FileName | varchar(32) | YES | | NULL|| >| RecordNumber | int(11) | YES | | NULL|| >| WholeRecord | text | YES | | NULL|| >| ReceivedDate | varchar(10) | YES | | NULL|| >+--+---+--+-+-++ >9 rows in set (0.00 sec) > >I attempt to MERGE; >mysql> CREATE TABLE tblCross1 (ID INT NOT NULL, > -> RecordID VARCHAR(6), > -> RecordDate VARCHAR(10), > -> Minutes DECIMAL(12,2), > -> KEY(ID)) > -> TYPE=MERGE > -> UNION=(tblClass11, tblClassOthers); >Query OK, 0 rows affected (0.01 sec) > >Then I attempt to query;mysql> select count(*) from tblCross1; >ERROR 1016: Can't open file: 'tblCross1.MRG'. (errno: 143) >perror 143 >143 = Conflicting table definition between MERGE and mapped table > >Can anyone help with this? > >Thanks! >Jay Drop the MERGE table, then try creating it with all the columns in the original tables. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: FULLTEXT search pattern syntax
Sergei, here:
RH7.2/2.4.9-31/Dual P-III 866MHz/MySQL4.0.2
A snapshot from a live database, sorry, couldn't prepare a more detailed
example:
--
select tdate, left(header,125) from archivel where match (header) against
('"donald rumsfeld"' in boolean mode);
==> 188 rows in set (0.12 sec)
--
select tdate, left(header,125) from archivel where match (header) against
('"president bush"' in boolean mode);
==> 1979 rows in set (2.40 sec)
--
select tdate, left(header,125) from archivel where match (header) against
('"president bush" "donald rumsfeld"' in boolean mode);
==> 1979 rows in set (2.39 sec)
--
select tdate, left(header,125) from archivel where match (header) against
('+"president bush" +"donald rumsfeld"' in boolean mode);
==> 1979 rows in set (2.39 sec)
--
select tdate, left(header,125) from archivel where match (header) against
('+"president bush" +"donald rumsfeld"' in boolean mode);
==> 1979 rows in set (2.39 sec)
--
select tdate, left(header,125) from archivel where match (header) against
('("president bush") ("donald rumsfeld")' in boolean mode);
==> 3522 rows in set (2.61 sec)
--
select tdate, left(header,125) from archivel where match (header) against
('+("president bush") +("donald rumsfeld")' in boolean mode);
==> 1979 rows in set (2.52 sec)
--
select tdate, left(header,125) from archivel where match (header) against
('+("president bush") -("donald rumsfeld")' in boolean mode);
1979 rows in set (2.53 sec)
--
select tdate, left(header,125) from archivel where match (header) against
('-("president bush") +("donald rumsfeld")' in boolean mode);
==> 1535 rows in set (2.45 sec)
--
Thanks,
Vadim.
Sergei Golubchik wrote:
>
> Hi!
>
> On May 06, Vadim P. wrote:
> > Hi,
> >
> > It's not quite clear from the manual, but it appears that queries with
> > FULLTEXT search patterns like this:
> >
> > MATCH (some_text_field) AGAINST ('("red pepper") ("green bean")')
> >
> > don't produce the result desired, that is, multiple ".." elements are not
> > allowed, with or without parentheses...
>
> Could you explain, what result is desired and what result you are getting ?
> Because, right now I can only say that multiple ".." elements ARE
> allowed, of course.
>
> > On a general note, it would be nice to have the formal syntax of FT search
> > patterns in the manual.
>
> I do not understand, what is missing in the manual right now ?
> There is a list of operators, you can use any of them in whatever
> combination you want.
>
> Regards,
> Sergei
>
> --
> MySQL Development Team
>__ ___ ___ __
> / |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
> /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
><___/
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
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: Merge tables, was [two table's columns into one columns w/o INSERT ... SELECT?]
I have these two tables; mysql> describe tblClass11; +--+---+--+-+-++ | Field| Type | Null | Key | Default | Extra | +--+---+--+-+-++ | ID | int(11) | | PRI | NULL| auto_increment | | RecordID | varchar(6)| YES | | NULL|| | RecordDate | varchar(10) | YES | | NULL|| | CIC | varchar(4)| YES | | NULL|| | Minutes | decimal(12,2) | YES | | NULL|| | FileName | varchar(32) | YES | | NULL|| | RecordNumber | int(11) | YES | | NULL|| | WholeRecord | text | YES | | NULL|| | ReceivedDate | varchar(10) | YES | | NULL|| +--+---+--+-+-++ 9 rows in set (0.00 sec) mysql> describe tblClassOthers; +--+---+--+-+-++ | Field| Type | Null | Key | Default | Extra | +--+---+--+-+-++ | ID | int(11) | | PRI | NULL| auto_increment | | RecordID | varchar(6)| YES | | NULL|| | RecordDate | varchar(10) | YES | | NULL|| | CIC | varchar(4)| YES | | NULL|| | Minutes | decimal(12,2) | YES | | NULL|| | FileName | varchar(32) | YES | | NULL|| | RecordNumber | int(11) | YES | | NULL|| | WholeRecord | text | YES | | NULL|| | ReceivedDate | varchar(10) | YES | | NULL|| +--+---+--+-+-++ 9 rows in set (0.00 sec) I attempt to MERGE; mysql> CREATE TABLE tblCross1 (ID INT NOT NULL, -> RecordID VARCHAR(6), -> RecordDate VARCHAR(10), -> Minutes DECIMAL(12,2), -> KEY(ID)) -> TYPE=MERGE -> UNION=(tblClass11, tblClassOthers); Query OK, 0 rows affected (0.01 sec) Then I attempt to query;mysql> select count(*) from tblCross1; ERROR 1016: Can't open file: 'tblCross1.MRG'. (errno: 143) perror 143 143 = Conflicting table definition between MERGE and mapped table Can anyone help with this? Thanks! Jay - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
formatting currency in mysql
Does anyone have a quick tip on how to format a float/numeric in the following currency format with a query? $xx,xxx.xx Thanks! Graeme - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: two table's columns into one columns w/o INSERT ... SELECT?
[snip] > If you have MySQL 4, you can use a UNION. > Otherwise you'll need a second table, because what you want is not > a join, but a concatenation of result sets. > [snip] > > Don't have 4.0 yet, probably going to wait until a production release comes > out. So if I need a second table I will have to do that...trying to keep one > query statement per PHP request. You might be able to use a merge table, but it will require a query to create it. That query could be done earlier, though, if the number of combinations of tables is small. [/snip] Do you know if there is a limit on table size with MERGE? Jay - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Two database servers, same physical server
Thanks Don, Gurhan, Peter! uhg. I am sure I searched the docs first. *sigh* -Original Message- From: Don Vu [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 3:19 PM To: Gurhan Ozen; Luc Foisy; MYSQL-List (E-mail) Subject: RE: Two database servers, same physical server more detail on this can be found here http://www.mysql.com/doc/M/u/Multiple_servers.html -Original Message- From: Gurhan Ozen [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 3:10 PM To: Luc Foisy; MYSQL-List (E-mail) Subject: RE: Two database servers, same physical server Hi, To run multiple mysqld servers, you at least have to specify a different port number, different socket file path, different pid and error log file to get it started. Different mysqld servers may point to the same database. To do this, just define the necessary information for your new mysqld server in a my.cnf file, and start it with ./bin/safe_mysqld --defaults-file=/path/to/new/my.cnf & . Gurhan -Original Message- From: Luc Foisy [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 1:33 PM To: MYSQL-List (E-mail) Subject: Two database servers, same physical server Has someone done this before? What things do I have to take into consideration The following are things I know that may be issues reading mysql.sock reading my.cnf database directory ( there is a parameter for command line operation ) I would suppose I would have to create a dual instance of the daemon script Anything else I might be missing? What should I do to make this work? --- Why do I want to do this? Replication. One slave can not be slave to mulitple masters. ( as far as I know ). I do not want to have a so many servers as I have clients ( the replication is a saftey thing offered by us, most clients still have thier own replication server, but some just can not afford it, so we replicate for them. ) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Two database servers, same physical server
more detail on this can be found here http://www.mysql.com/doc/M/u/Multiple_servers.html -Original Message- From: Gurhan Ozen [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 3:10 PM To: Luc Foisy; MYSQL-List (E-mail) Subject: RE: Two database servers, same physical server Hi, To run multiple mysqld servers, you at least have to specify a different port number, different socket file path, different pid and error log file to get it started. Different mysqld servers may point to the same database. To do this, just define the necessary information for your new mysqld server in a my.cnf file, and start it with ./bin/safe_mysqld --defaults-file=/path/to/new/my.cnf & . Gurhan -Original Message- From: Luc Foisy [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 1:33 PM To: MYSQL-List (E-mail) Subject: Two database servers, same physical server Has someone done this before? What things do I have to take into consideration The following are things I know that may be issues reading mysql.sock reading my.cnf database directory ( there is a parameter for command line operation ) I would suppose I would have to create a dual instance of the daemon script Anything else I might be missing? What should I do to make this work? --- Why do I want to do this? Replication. One slave can not be slave to mulitple masters. ( as far as I know ). I do not want to have a so many servers as I have clients ( the replication is a saftey thing offered by us, most clients still have thier own replication server, but some just can not afford it, so we replicate for them. ) Now that I have written the above "R" word, this mail will be completely ignored. Why is that? I have yet to see answers to any questions in regards to replication. Is it that nobody else uses replication except the people who have problems, or just that no person has extended knowlegde on the issue and they just keep their mouths shut so they don't lead others astray. Just curious. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Two database servers, same physical server
Hi If the databases are not too big, and are on the same machine, you could just copy the directory with the databases in. If you need to restore the database just copy it back. I think this is OK, though you might want to stop mysql to "lock" the database. I have only done this a couple of times (on a quiet database) because I replicate across two servers. If anybody knows better, or thinks this is a bad idea, then I will defer to their greater knowledge! HTH Peter --- Excellence in internet and open source software --- Sunmaia www.sunmaia.net [EMAIL PROTECTED] tel. 0121-242-1473 --- > -Original Message- > From: Luc Foisy [mailto:[EMAIL PROTECTED]] > Sent: 06 May 2002 18:33 > To: MYSQL-List (E-mail) > Subject: Two database servers, same physical server > > > > Has someone done this before? What things do I have to take into > consideration > > The following are things I know that may be issues > reading mysql.sock > reading my.cnf > database directory ( there is a parameter for command line operation ) > I would suppose I would have to create a dual instance of the > daemon script > > Anything else I might be missing? > What should I do to make this work? > > --- > > Why do I want to do this? Replication. One slave can not be slave to > mulitple masters. ( as far as I know ). I do not want to have a so many > servers as I have clients ( the replication is a saftey thing > offered by us, > most clients still have thier own replication server, but some > just can not > afford it, so we replicate for them. ) > Now that I have written the above "R" word, this mail will be completely > ignored. Why is that? I have yet to see answers to any questions > in regards > to replication. Is it that nobody else uses replication except the people > who have problems, or just that no person has extended knowlegde on the > issue and they just keep their mouths shut so they don't lead > others astray. > Just curious. > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > 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: SpamAssassin tags messages from the list as spam (was: [fwd] *****SPAM***** Re: Problems with Time field (from: dump_pj@red
On 6 May 2002, at 7:56, Alexander Skwar wrote: > As you can see below, SpamAssassin tags messages from the MySQL list as > spam. The main reason that this happens, is: > > SPAM: Hit! (3.5 points) URI: URL of page called "unsubscribe" It seems to me that that's a problem with SpamAssassin, not with the list. Many, many legitimate mailing lists have unsubscribe links that contain the word "unsubscribe". It's true that many spam messages contain such links, but many spam messages also contain the word "money", and marking all messages containing "money" as spam would be a bad idea. Maybe you need to set your threshold lower, or otherwise adjust the configuration. [Filter fodder: SQL] -- Keith C. Ivey <[EMAIL PROTECTED]> Tobacco Documents Online http://tobaccodocuments.org - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Two database servers, same physical server
Hi, To run multiple mysqld servers, you at least have to specify a different port number, different socket file path, different pid and error log file to get it started. Different mysqld servers may point to the same database. To do this, just define the necessary information for your new mysqld server in a my.cnf file, and start it with ./bin/safe_mysqld --defaults-file=/path/to/new/my.cnf & . Gurhan -Original Message- From: Luc Foisy [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 1:33 PM To: MYSQL-List (E-mail) Subject: Two database servers, same physical server Has someone done this before? What things do I have to take into consideration The following are things I know that may be issues reading mysql.sock reading my.cnf database directory ( there is a parameter for command line operation ) I would suppose I would have to create a dual instance of the daemon script Anything else I might be missing? What should I do to make this work? --- Why do I want to do this? Replication. One slave can not be slave to mulitple masters. ( as far as I know ). I do not want to have a so many servers as I have clients ( the replication is a saftey thing offered by us, most clients still have thier own replication server, but some just can not afford it, so we replicate for them. ) Now that I have written the above "R" word, this mail will be completely ignored. Why is that? I have yet to see answers to any questions in regards to replication. Is it that nobody else uses replication except the people who have problems, or just that no person has extended knowlegde on the issue and they just keep their mouths shut so they don't lead others astray. Just curious. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
SOP for hosting services?
Hi, I using Macromedia UltraDev to develop my dynamic web site and would like to use mySQL as the RDBMS. My hosting service folks are telling me that I should only update my database on their server via update transactions. They say this is for security reasons. UltraDev provides many good tools for viewing, adding, updating and deleting records for the database but I'm not sure how to produce add/delete/update transactions from UltraDev and I'm not convinced it is necessary to have the added layer of security. Is this standard operating procedure when making changes to mySQL databases or should I tell them that I want direct access to my database? Any help/suggestions/guidelines in this area would be very helpful. Thanks. Pete - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: High-Speed/Volume Database
At 12:56 PM 5/6/2002, you wrote: >We are designing an application that needs to use >a relational database to hold quite a large amount >of data. > >In particular there is one table that has about 33 >fields, 18 indexes, and 120 bytes per record. >Additionally, we are going to need to add about 2 >million records per day to the table, delete about 2 >million records per day from the table, hold 2 weeks >worth of data within the database (approx. 30 million >records), and sustain an average add rate of about 23 >records per second while, at the same time, sustaining >an average delete rate of 23 records per second. > >My questions are, what database software should we use, >what kind of hardware platform will be needed to >support the specifications enumerated above, and what >kind of average query performance can we expect? > Bob, You left out some critical information. 1a) How many concurrent users will there be reading from the busiest table, and 1b) how many will be deleting records from the busiest table? 2) Also how do you determine which records will be deleted? Do you delete an entire days worth of records at a time? If so, you might consider creating a table for each day, like table_mon, table_tue, ... table_sun, table_lastmon, ... table_lastsun so you have 14 tables. When you get a new day, you do a "Delete * from table_mon" (if it is Monday) which in effect drops the table and recreates it which is extremely fast. To query the entire set of tables, use Merge tables. This only works with MyISAM tables. If on the other hand you need to add and delete records concurrently, try InnoDb table type. It stands up well to deletes and inserts. One suggest I have is to use CHAR() field types rather than VarChar(). If you delete fixed length records (CHAR) then MySQL can re-use the deleted space. VarChar will have internal fragmentation especially when doing all those deletes, so eventually you will need to reload the data. So stick with CHAR if you can. You will need at least dual processors and stuff it with as much RAM as it can hold (2g or more). Mike - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: two table's columns into one columns w/o INSERT ... SELECT?
On 6 May 2002, at 13:06, Jay Blanchard wrote: > [snip] > If you have MySQL 4, you can use a UNION. > Otherwise you'll need a second table, because what you want is not > a join, but a concatenation of result sets. > [snip] > > Don't have 4.0 yet, probably going to wait until a production release comes > out. So if I need a second table I will have to do that...trying to keep one > query statement per PHP request. You might be able to use a merge table, but it will require a query to create it. That query could be done earlier, though, if the number of combinations of tables is small. -- Keith C. Ivey <[EMAIL PROTECTED]> Tobacco Documents Online http://tobaccodocuments.org - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Get the next AUTO INCREMENT value for a column
To the originator of this thread:
While what you are asking is possible, Id like to put my two cents in and
ask you please not to do it.
If this is a production database, you have no idea how helpful it will be
for you to know by those missing pk numbers that something was deleted
manually from the database as opposed to an index error, or some other more
disasterous problem. In my experiece leave those holes in the pk sequence,
and then later on when someone complains that a record is missing, you can
say with some confidence that someone actually deleted it.
AS a followup note, I would never allow user permissions to let a regular
user delete a record in the first place, and I would stop it with either
code, or database user access privelages. Instead create an active/inactive
status field and then you can rewrite some code to add a "where status =
'active'" or similar line of code
Then create a "purge records' function in your app so that admins who are
supposed to know what they are doing can delete records if they really want
to.
Just my opinion.
Rance
PS. hey filter, chew on this, MySQL, SQL,
>From: "Arthur Fuller" <[EMAIL PROTECTED]>
>To: "Harrison C. Fisk" <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>, "Paul
>DuBois" <[EMAIL PROTECTED]>
>Subject: Re: Get the next AUTO INCREMENT value for a column
>Date: Sun, 5 May 2002 14:06:43 -0400
>
>IMO the desire to know this answer suggests that something is wrong with
>the
>design. Again IMO, a PK must be absolutely meaningless. Any attempt to
>impost meaning on it is by definition wrong.
>
>By my lights, the only PK you want to know is the one just added. That's
>enough information to let you start adding rows to child tables. And that
>value you can easily obtain.
>
>Arthur
>
>- Original Message -
>From: "Paul DuBois" <[EMAIL PROTECTED]>
>To: "Harrison C. Fisk" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
>Sent: Saturday, May 04, 2002 12:34 PM
>Subject: Re: Get the next AUTO INCREMENT value for a column
>
>
> > At 12:29 -0400 5/4/02, Harrison C. Fisk wrote:
> > >Actually I think the SHOW TABLE STATUS like 'TABLENAME' command can
>show
> > >you the next auto_increment value.
> >
> > There is no guarantee that this value will actually be used for the
> > next AUTO_INCREMENT value. Suppose another client issues the following
> > query:
> >
> > ALTER TABLE tbl_name AUTO_INCREMENT = 123456;
> >
> > If you were relying on what SHOW TABLE STATUS said, you'd be hosed. :-)
> >
> >
> > >Although I can say I wouldn't really ever use it except for personal
>use,
> > >not in an actual application.
> > >
> > >Harrison
> > >- Original Message -
> > >From: "Paul DuBois" <[EMAIL PROTECTED]>
> > >To: "Son Nguyen" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> > >Sent: Saturday, May 04, 2002 12:16 PM
> > >Subject: Re: Get the next AUTO INCREMENT value for a column
> > >
> > >
> > >> At 9:01 -0700 5/4/02, Son Nguyen wrote:
> > >> > CREATE table test1 (ID int NOT NULL AUTO INCREMENT, name text,
>value
> > >> >text, Primary Key (ID));
> > >> >
> > >> > INSERT into test1 (name, value) values ("test1", "value1");
> > >> >
> > >> > INSERT into test1 (name, value) values ("test2", "value2");
> > >> >
> > >> > DELETE from test1 where ID=2;
> > >> >
> > >> > How can obtain the CURRENT value of next ID AUTO INCREMENT value
> > >> >(which is 3 right now)
> > >> >
> > >> >
> > >> >
> > >> >
> > >> > Son Nguyen
> > >> >mysql, query
> > >>
> > >> You can't. AUTO_INCREMENT values are not available until you
>generate
> > > > them.
> >
> >
> > -
> > Before posting, please check:
> >http://www.mysql.com/manual.php (the manual)
> >http://lists.mysql.com/ (the list archive)
> >
> > 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
>
_
Chat with friends online, try MSN Messenger: http://messenger.msn.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: High-Speed/Volume Database
Over here, we're doing an average of 95 queries per second (that's about 8 mill daily), on a Pentium III @ 900MHz with 768MB of ram. We're working with smaller data sets, than 30 million records, tho. I imagine that you could do well with a high end intel system, or a medium-end Sun box. A dual processor Athlon MP 1900+ system with 4GB of ram, and SCSI raid would probably serve you well. This would run about $5k at most. If you want to go with sun, a E450 would probably do the trick for ya. Figure 8GB of ram (more ram is good -- the more of the DB you can hold in memory, the better you'll do.) and 2 or 4 processors. (Actually, I suspect than an E450 would exceed your needs by a lot.) That sort of box would cost you about $20k, IIRC. HTH, Gabriel. Bob Smith wrote: > We are designing an application that needs to use > a relational database to hold quite a large amount > of data. > > In particular there is one table that has about 33 > fields, 18 indexes, and 120 bytes per record. > Additionally, we are going to need to add about 2 > million records per day to the table, delete about 2 > million records per day from the table, hold 2 weeks > worth of data within the database (approx. 30 million > records), and sustain an average add rate of about 23 > records per second while, at the same time, sustaining > an average delete rate of 23 records per second. > > My questions are, what database software should we use, > what kind of hardware platform will be needed to > support the specifications enumerated above, and what > kind of average query performance can we expect? -- Gabriel Cain Unix Systems Administrator [EMAIL PROTECTED] Dialup USA, Inc. 888-460-2286 ext 208 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: two table's columns into one columns w/o INSERT ... SELECT?
[snip] If you have MySQL 4, you can use a UNION. Otherwise you'll need a second table, because what you want is not a join, but a concatenation of result sets. [snip] Don't have 4.0 yet, probably going to wait until a production release comes out. So if I need a second table I will have to do that...trying to keep one query statement per PHP request. Thanks! Jay - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 create/write to file (more info)
Wow, Quick response... You guys ( gals) are Great !! All files /var/lib/CRdb/* (Database Directory) are 777 (CHMOD) and ownership mysql All files /var/lib/mysql/mysql/* are 777 as well. hmm. ( Very Puzzled ) Also the file #sql-6c4_a.frm in the error message does not exist. >Failed to save field : SQL alter table ZControl add pid tinyint(4) >failed : './CRdB/#sql-6c4_a.frm' (Errcode: 13) Thanks Again, Marko Palikko [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
High-Speed/Volume Database
We are designing an application that needs to use a relational database to hold quite a large amount of data. In particular there is one table that has about 33 fields, 18 indexes, and 120 bytes per record. Additionally, we are going to need to add about 2 million records per day to the table, delete about 2 million records per day from the table, hold 2 weeks worth of data within the database (approx. 30 million records), and sustain an average add rate of about 23 records per second while, at the same time, sustaining an average delete rate of 23 records per second. My questions are, what database software should we use, what kind of hardware platform will be needed to support the specifications enumerated above, and what kind of average query performance can we expect? _ Join the worlds largest e-mail service with MSN Hotmail. 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
Converting text files to MySQL
I've been trying to import text files into MySQL, but I can't get it to work. I'm new to MySQL and am still getting familiar with it, so perhaps I'm missing something. I'm using the LOAD DATA LOCAL command but I keep getting error 1148 "The used command is not allowed with this MySQL version." Now from reading the information in the docs section (http://www.mysql.com/doc/L/O/LOAD_DATA_LOCAL.html) it appears that LOAD DATA LOCAL is sometimes disabled for security reasons, and that there are two ways around this. I've tried both ways but it doesn't seem to work. I tried using the command --enable-local-infile but apparently that's only compatible with version 3.23.48 and before, and we have 3.23.49. Is there something else I should do? Can anyone help me please? Thanks so much! Christy Roberts Technical Project Lead iMIRADOR.com Inc. St. John's, Newfoundland Tel: 709.737.4485 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: two table's columns into one columns w/o INSERT ... SELECT?
If you have MySQL 4, you can use a UNION. Otherwise you'll need a second table, because what you want is not a join, but a concatenation of result sets. At 12:47 -0500 5/6/02, Jay Blanchard wrote: >Here is a puzzler for SQL jockies on a Monday afternoon. I have 2 tables, >each with what may or may not be a unique range of dates; > >tblDate1 >+++ >| field1 | rDate | >+++ >| 1 | 2002-03-01 | >| 2 | 2002-03-03 | >| 3 | 2002-03-05 | >| 4 | 2002-03-07 | >+++ > >tblDate2 >+++ >| field1 | rDate | >+++ >| 1 | 2002-03-02 | >| 2 | 2002-03-04 | >| 3 | 2002-03-06 | >| 4 | 2002-03-08 | >| 5 | 2002-03-07 | >+++ > >I need a SQL query that returns these as one column with no duplicates, >preferably without having to create a temp table by doing an INSERT >SELECT >++ >| rDate | >++ >| 2002-03-01 | >| 2002-03-02 | >| 2002-03-03 | >| 2002-03-04 | >| 2002-03-05 | >| 2002-03-06 | >| 2002-03-07 | >| 2002-03-08 | >++ > >Has anyone done this before? > >Jay - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
two table's columns into one columns w/o INSERT ... SELECT?
Here is a puzzler for SQL jockies on a Monday afternoon. I have 2 tables, each with what may or may not be a unique range of dates; tblDate1 +++ | field1 | rDate | +++ | 1 | 2002-03-01 | | 2 | 2002-03-03 | | 3 | 2002-03-05 | | 4 | 2002-03-07 | +++ tblDate2 +++ | field1 | rDate | +++ | 1 | 2002-03-02 | | 2 | 2002-03-04 | | 3 | 2002-03-06 | | 4 | 2002-03-08 | | 5 | 2002-03-07 | +++ I need a SQL query that returns these as one column with no duplicates, preferably without having to create a temp table by doing an INSERT SELECT ++ | rDate | ++ | 2002-03-01 | | 2002-03-02 | | 2002-03-03 | | 2002-03-04 | | 2002-03-05 | | 2002-03-06 | | 2002-03-07 | | 2002-03-08 | ++ Has anyone done this before? Jay - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: FULLTEXT search pattern syntax
Hi!
On May 06, Vadim P. wrote:
> Hi,
>
> It's not quite clear from the manual, but it appears that queries with
> FULLTEXT search patterns like this:
>
> MATCH (some_text_field) AGAINST ('("red pepper") ("green bean")')
>
> don't produce the result desired, that is, multiple ".." elements are not
> allowed, with or without parentheses...
Could you explain, what result is desired and what result you are getting ?
Because, right now I can only say that multiple ".." elements ARE
allowed, of course.
> On a general note, it would be nice to have the formal syntax of FT search
> patterns in the manual.
I do not understand, what is missing in the manual right now ?
There is a list of operators, you can use any of them in whatever
combination you want.
Regards,
Sergei
--
MySQL Development Team
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
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 create/write to file
Check your permissions and fileowners one more time. You definitely have permissions problem.. Make sure that all the datafiles are owned by mysql. Gurhan -Original Message- From: Marko Palikko [mailto:[EMAIL PROTECTED]] Sent: Monday, May 13, 2002 1:00 PM To: [EMAIL PROTECTED] Subject: Can't create/write to file Hello All, I have created a MySQL database on Linux Mandrake 8.0, all is well. I can add fields / tables ok. I moved the contents of the database directory and the mysql directory to another system (Same OS & MySQL). I can access the database but can not add fields. >Failed to save field : SQL alter table ZControl add pid tinyint(4) >failed : './CRdB/#sql-6c4_a.frm' (Errcode: 13) I have verified and checked the file permissions etc... I can create a new database no problems. I am just unable to modify the database I moved over ... Any suggestions would be most greatly appreciated. Marko Palikko [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Two database servers, same physical server
Has someone done this before? What things do I have to take into consideration The following are things I know that may be issues reading mysql.sock reading my.cnf database directory ( there is a parameter for command line operation ) I would suppose I would have to create a dual instance of the daemon script Anything else I might be missing? What should I do to make this work? --- Why do I want to do this? Replication. One slave can not be slave to mulitple masters. ( as far as I know ). I do not want to have a so many servers as I have clients ( the replication is a saftey thing offered by us, most clients still have thier own replication server, but some just can not afford it, so we replicate for them. ) Now that I have written the above "R" word, this mail will be completely ignored. Why is that? I have yet to see answers to any questions in regards to replication. Is it that nobody else uses replication except the people who have problems, or just that no person has extended knowlegde on the issue and they just keep their mouths shut so they don't lead others astray. Just curious. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 create/write to file
Hello All, I have created a MySQL database on Linux Mandrake 8.0, all is well. I can add fields / tables ok. I moved the contents of the database directory and the mysql directory to another system (Same OS & MySQL). I can access the database but can not add fields. >Failed to save field : SQL alter table ZControl add pid tinyint(4) >failed : './CRdB/#sql-6c4_a.frm' (Errcode: 13) I have verified and checked the file permissions etc... I can create a new database no problems. I am just unable to modify the database I moved over ... Any suggestions would be most greatly appreciated. Marko Palikko [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQLGUI source distribution: files missing
Hi! I have great trouble compiling MySQLGUI 1.7.5: Missing headers: FL/Enumerations.H FL/filename.H FL/fl_ask.H FL/Fl_Bitmap.H Fl/Fl_Box.H FL/Fl_Box.H FL/Fl_Browser.H FL/Fl_Button.H FL/Fl_Check_Button.H FL/Fl_Choice.H FL/Fl_Dial.H FL/Fl_Double_Window.H Fl/fl_draw.H FL/fl_draw.H FL/fl_file_chooser.H FL/Fl_Group.H FL/Fl.H FL/Fl_Hold_Browser.H FL/Fl_Input.H FL/Fl_Light_Button.H FL/Fl_Menu_Bar.H FL/Fl_Menu_Button.H FL/Fl_Menu_.H FL/Fl_Menu.H FL/Fl_Multi_Browser.H FL/Fl_Multiline_Input.H FL/Fl_Output.H FL/Fl_Pixmap.H FL/Fl_Return_Button.H FL/Fl_Round_Button.H Fl/Fl_Scrollbar.H FL/Fl_Scrollbar.H FL/Fl_Scroll.H FL/Fl_Select_Browser.H FL/Fl_Slider.H FL/Fl_Tabs.H Fl/Fl_Tile.H FL/Fl_Tile.H FL/Fl_Valuator.H FL/Fl_Value_Output.H FL/Fl_Value_Slider.H FL/Fl_Widget.H FL/Fl_Window.H mysql++ sqlplus.hh Missing files: the source for edfile.o Missing Flags: -IFL Volker -- The early bird gets the worm. If you want something else for breakfast, get up later. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Too Many Connections
Hi, Change the max_connections variable's value to a higher value. By default it is set to 100. You can see what yours is set to with SHOW VARIABLES command. See: http://www.mysql.com/doc/T/o/Too_many_connections.html http://www.mysql.com/doc/S/H/SHOW_VARIABLES.html Gurhan -Original Message- From: David McInnis [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 12:49 PM To: [EMAIL PROTECTED] Subject: Too Many Connections MySQL keeps locking up (I get a "Too many connections" error.) Is there a way that I can increase the number of connections that MySQL will take? SQL and Query David McInnis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: please help: search database - code attached
Get rid of percentage signs in your keyword...
See: http://www.mysql.com/doc/F/u/Fulltext_Search.html
Gurhan
-Original Message-
From: Shehryar Shafiq [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 06, 2002 12:46 PM
To: [EMAIL PROTECTED]
Subject: please help: search database - code attached
Hi,
I have a table of jobs.
I would like user to search the jobs on three columns:
description,
location,
type,
on the search page, i have one text field, and one
drop down menu. the search field will be used for
keywords against the description and location columns.
the drop down will choose between the ONLY two types
of entry for a type column (permanent and temp)
here is my sql (i'm using mysql fulltext search)
Select * from tbl_jobs WHERE MATCH (description,
location) AGAINST ('%mm_keywords%') AND type =
'mm_type'
i keep on getting empty sets.
is there anything i am missing here?
any help would be greatly appreciated.
cheers
Shez
__
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: FULLTEXT search pattern syntax
Hi..
Rewrite it as:
WHERE MATCH (some_text_field) AGAINST ('"red pepper"' IN BOOLEAN MODE) AND
MATCH (some_text_field) AGAINST ("green bean"' IN BOOLEAN MODE);
Gurhan
-Original Message-
From: Vadim P. [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 06, 2002 12:07 PM
To: [EMAIL PROTECTED]
Subject: Re: FULLTEXT search pattern syntax
Of course, I forgot to mention 'IN BOOLEAN MODE'.
...
MATCH (some_text_field) AGAINST ('("red pepper") ("green bean")' IN BOOLEAN
MODE)
...
>
"Vadim P." wrote:
>
> Hi,
>
> It's not quite clear from the manual, but it appears that queries with
> FULLTEXT search patterns like this:
>
> MATCH (some_text_field) AGAINST ('("red pepper") ("green bean")')
>
> don't produce the result desired, that is, multiple ".." elements are not
> allowed, with or without parentheses...
>
> Could someone confirm, please?
>
> On a general note, it would be nice to have the formal syntax of FT search
> patterns in the manual.
>
> TIA,
> Vadim.
>
> [sql query - to satisfy the darn spam filter]
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>http://lists.mysql.com/ (the list archive)
>
> 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
Too Many Connections
MySQL keeps locking up (I get a "Too many connections" error.) Is there a way that I can increase the number of connections that MySQL will take? SQL and Query David McInnis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
please help: search database - code attached
Hi,
I have a table of jobs.
I would like user to search the jobs on three columns:
description,
location,
type,
on the search page, i have one text field, and one
drop down menu. the search field will be used for
keywords against the description and location columns.
the drop down will choose between the ONLY two types
of entry for a type column (permanent and temp)
here is my sql (i'm using mysql fulltext search)
Select * from tbl_jobs WHERE MATCH (description,
location) AGAINST ('%mm_keywords%') AND type =
'mm_type'
i keep on getting empty sets.
is there anything i am missing here?
any help would be greatly appreciated.
cheers
Shez
__
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.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: Bug or error in SQL syntax - Specifying and using a user variable inside a single select query
Gregg, Monday, May 06, 2002, 6:57:55 PM, you wrote: GG> Upon reading into the user variables section of the mysql manual, I decided GG> to make my life easier inside several of my queries by specifying some user GG> variables. Note that I'm trying to have everything inside the select GG> statement - Primarily because I'm simply passing it through to my data GG> mining software that interfaces through myODBC. GG> I'm trying to accomplish the following query (I'm executing these sql GG> queries directly from the command line) -- GG> GG> == GG> SELECT GG>annual_filing.*, GG>companies.name AS company_name, GG>YEAR(filing_date) AS filing_year, GG>(@predictedYear := 1999) AS predictedYear, GG>(@earliestYear := 1996) AS earliestYear, GG>(@learnYear := 1998) AS learnYear GG> FROM GG>annual_filing, GG>companies GG> WHERE GG> annual_filing.company_id = companies.ds_id GG>AND GG> YEAR(filing_date) <= @predictedYear GG>AND GG> YEAR(filing_date) >= @earliestYear; GG> GG> == GG> The above query returned an empty set / no rows. You should first initialize user variables! By default they contain NULL values as SELECT works by first checking WHERE clause and only then works for SELECT. Check the manual: http://www.mysql.com/doc/V/a/Variables.html GG> === GG> Gregg Graubins <[EMAIL PROTECTED]> -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
please take me off from the mail list thank you
-Original Message- From: Peter Lovatt [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 12:09 PM To: Yvon Darang; [EMAIL PROTECTED] Subject: RE: Newbie Question Hi If you are developing for a Windows desktop, MyODBC with Access, Paradox or Delphi all workm, from experience. If you are developing for Linux desktop, then not sure, but perhaps others have experience Peter --- Excellence in internet and open source software --- Sunmaia www.sunmaia.net [EMAIL PROTECTED] tel. 0121-242-1473 --- > -Original Message- > From: Yvon Darang [mailto:[EMAIL PROTECTED]] > Sent: 06 May 2002 14:31 > To: [EMAIL PROTECTED] > Subject: Newbie Question > > > Hi everybody, > Let's say I do not want to use any microsoft tool on my PC. Is it possible > to develop a desktop application using MySQL as database server without > having to program in C or C++ to access and display the Data? > > My question probably should be: If not ODBC, what desktop database > application (like MS-Access) can I use in Linux to access MySQL data or to > develop and application that can access those data. > > TIA > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > 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: C++ API for Mysql
Hi Carsten, I've tried Mysql++ and SQLAPI. I am asking if someone out there know about other best tools in C++ for Mysql on linux. Thanks, Hisseine - Original Message - From: "Carsten Gehling" <[EMAIL PROTECTED]> To: "Hisseine Dj." <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, May 06, 2002 11:31 AM Subject: SV: C++ API for Mysql > You can download MySQL++ from www.mysql.com > > - Carsten > > > -Oprindelig meddelelse- > > Fra: Hisseine Dj. [mailto:[EMAIL PROTECTED]] > > Sendt: 6. maj 2002 17:24 > > Til: [EMAIL PROTECTED] > > Emne: C++ API for Mysql > > > > > > Hello, > > > > Can someone tell me if there is an C++ API that works smooth with MYSQL on > > linux. > > So far I was trying msql++ and SQLAPI++. > > SQLAPI++ seems to be good by there are problems when runing the program. > > > > My system is Redhat 7.2 and Mysql 3.23.49 > > > > > > Thanks, > > > > Hisseine > > > > > > > > > > - > > Before posting, please check: > >http://www.mysql.com/manual.php (the manual) > >http://lists.mysql.com/ (the list archive) > > > > 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: Every user can access the databases
Dennis, Monday, May 06, 2002, 4:51:50 PM, you wrote: D> I have tried almost everything and nothing works. D> The problem is, I have a server with different MySQL databases from D> different people. D> User 1 should not access database 2 and user 2 should not access database 1. D> What is the easiest way to prevent user 1 to access database 2. I can't get D> it right. You should set permissions for user 1 on every required database, except database 2. Use GRANT statement: http://www.mysql.com/doc/G/R/GRANT.html D> Thanks in advance, D> Dennis -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Newbie Question
Hi If you are developing for a Windows desktop, MyODBC with Access, Paradox or Delphi all workm, from experience. If you are developing for Linux desktop, then not sure, but perhaps others have experience Peter --- Excellence in internet and open source software --- Sunmaia www.sunmaia.net [EMAIL PROTECTED] tel. 0121-242-1473 --- > -Original Message- > From: Yvon Darang [mailto:[EMAIL PROTECTED]] > Sent: 06 May 2002 14:31 > To: [EMAIL PROTECTED] > Subject: Newbie Question > > > Hi everybody, > Let's say I do not want to use any microsoft tool on my PC. Is it possible > to develop a desktop application using MySQL as database server without > having to program in C or C++ to access and display the Data? > > My question probably should be: If not ODBC, what desktop database > application (like MS-Access) can I use in Linux to access MySQL data or to > develop and application that can access those data. > > TIA > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > 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: FULLTEXT search pattern syntax
Of course, I forgot to mention 'IN BOOLEAN MODE'.
...
MATCH (some_text_field) AGAINST ('("red pepper") ("green bean")' IN BOOLEAN
MODE)
...
>
"Vadim P." wrote:
>
> Hi,
>
> It's not quite clear from the manual, but it appears that queries with
> FULLTEXT search patterns like this:
>
> MATCH (some_text_field) AGAINST ('("red pepper") ("green bean")')
>
> don't produce the result desired, that is, multiple ".." elements are not
> allowed, with or without parentheses...
>
> Could someone confirm, please?
>
> On a general note, it would be nice to have the formal syntax of FT search
> patterns in the manual.
>
> TIA,
> Vadim.
>
> [sql query - to satisfy the darn spam filter]
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>http://lists.mysql.com/ (the list archive)
>
> 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
Bug or error in SQL syntax - Specifying and using a user variable inside a single select query
Greetings, Upon reading into the user variables section of the mysql manual, I decided to make my life easier inside several of my queries by specifying some user variables. Note that I'm trying to have everything inside the select statement - Primarily because I'm simply passing it through to my data mining software that interfaces through myODBC. I'm trying to accomplish the following query (I'm executing these sql queries directly from the command line) -- == SELECT annual_filing.*, companies.name AS company_name, YEAR(filing_date) AS filing_year, (@predictedYear := 1999) AS predictedYear, (@earliestYear := 1996) AS earliestYear, (@learnYear := 1998) AS learnYear FROM annual_filing, companies WHERE annual_filing.company_id = companies.ds_id AND YEAR(filing_date) <= @predictedYear AND YEAR(filing_date) >= @earliestYear; == The above query returned an empty set / no rows. Replacing the user variables with actual values, as shown below, returns the appropriate rows (5537 rows) (for obvious reasons because I'm not using any user variables in the WHERE clause): == SELECT annual_filing.*, companies.name AS company_name, YEAR(filing_date) AS filing_year, (@predictedYear := 1999) AS predictedYear, (@earliestYear := 1996) AS earliestYear, (@learnYear := 1998) AS learnYear FROM annual_filing, companies WHERE annual_filing.company_id = companies.ds_id AND YEAR(filing_date) <= 1999 AND YEAR(filing_date) >= 1996; == I also tried the below ... == SET @predictedYear = 1999; SET @earliestYear = 1996; SET @learnYear = 1998; SELECT company_id, @findEarliestYear AS findEarliestYear, @findLearnYear AS findLearnYear, @findPredictedYear AS findPredictedYear FROM annual_filing WHERE YEAR(annual_filing.filing_date) > @findPredictedYear; == And mysql returned no results / an empty set. Trying to debug the problem further, I tried ... == SET @predictedYear = 1999; SET @earliestYear = 1996; SET @learnYear = 1998; SELECT company_id, @findEarliestYear, @findLearnYear, @findPredictedYear FROM annual_filing WHERE YEAR(annual_filing.filing_date) > @findPredictedYear; == Still an empty set... And also verified the SET is actually doing its job (which it is) -- == mysql> SET @predictedYear = 1999; Query OK, 0 rows affected (0.00 sec) mysql> SET @earliestYear = 1996; Query OK, 0 rows affected (0.01 sec) mysql> SET @learnYear = 1998; Query OK, 0 rows affected (0.00 sec) mysql> SELECT @predictedYear, @earliestYear, @learnYear; ++---++ | @predictedYear | @earliestYear | @learnYear | ++---++ | 1999 | 1996 | 1998 | ++---++ 1 row in set (0.00 sec) == Does anyone have any insights or clues as to what the problem could be? Thanks in advance! === Gregg Graubins <[EMAIL PROTECTED]> (PGP key available) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
FULLTEXT search pattern syntax
Hi,
It's not quite clear from the manual, but it appears that queries with
FULLTEXT search patterns like this:
MATCH (some_text_field) AGAINST ('("red pepper") ("green bean")')
don't produce the result desired, that is, multiple ".." elements are not
allowed, with or without parentheses...
Could someone confirm, please?
On a general note, it would be nice to have the formal syntax of FT search
patterns in the manual.
TIA,
Vadim.
[sql query - to satisfy the darn spam filter]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
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 udf_example.cc
Hi, I'm using MySQL4.0.1-alpha under linux and want to use my own udfs. I tried to get working the udf_example and followed the MySQL manual. Compiling the file and using the CREATE FUNCTION command didn't succeed. I got the following error messages: gcc -shared -o udf_example.so -rdynamic udf_example.o mysql> CREATE FUNCTION metaphon RETURNS STRING SONAME "udf_example.so"; ERROR 1126: Can't open shared library 'udf_example.so' (errno: 2 /usr/lib/udf_example.so: undefined symbol: default_charset_info) gcc -c -o udf_example.so -rdynamic udf_example.cc mysql> CREATE FUNCTION metaphon RETURNS STRING SONAME "udf_example.so"; ERROR 1126: Can't open shared library 'udf_example.so' (errno: 2 udf_example.so: ELF file's phentsize not the expected size) What am I doing wrong? I would be grateful for an advice. Thanks in advance. Stefan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
New Release
Hi, The long awaited version 1.0.13 is now available for downloading. The list of changes and new features is too long, so I will give you a short description of what we changed: - New relationship editor ( now it can handle add new, update and delete and shows the SQL statement as an example) - New integrated User Manager (Add, Drop and Change all the privileges) - New Table Editor (Quick Editor, looks like MSAccess table design) - Fixed BLOB/TEXT fields when exporting results - Multiple statements is now back - Created format toolbar in the grid view to help cell formatting - Import Wizard and Import Text Wizard now saves the definitions, and these can be run at any time by clicking on the menu options - PHP-WSG now handles updates - Run External SQL now parses big SQL files - Added option to empty a table - Fixed bugs in the Export Data - Text Editor now uses a RichEdit Control, without size limitation - Added copy function in the Table Manager - Added support for FULLTEXT index - Fixed bug when exporting multiple files to text files - Query Editor now starts with the selected database as default - Added option to Go/ Don't Go full screen when starting - Import Wizard was improved a lot, now it can handles some data types better and it is quite faster for XBase tables - Removed the List View, now DBTools uses the HTML View to show object's data The new version can be download at http://www.dbtools.com.br as also all information about it. I'd like to thank all people envolved in the test fase and those who sent suggestions and bug-reports. Crercio O. Silva / DBTools Development - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
moving databases question...
I have before me what seems to be a very daunting task to someone with my limited SQL knowledge. I'm upgrading our ad server which runs on MySQL 3.22.32 to a newer machine and MySQL 3.23.39. Right now there are 16GB worth of databases that need to be transferred over, and the old server lacks enough hard disks space to even do a dump on one of those tables. So is there a way I can do a mysqldump directly from the old machine to the new one over the network? And if I can or if I'm offered a better way to do this, will the difference in MySQL version affect anything? Thanks in advance for any help/information. --- Richard Idalski System Administrator Nando Media Office: 919.836.4805 AIM: Ryusonuke www.nandomedia.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
SV: C++ API for Mysql
You can download MySQL++ from www.mysql.com - Carsten > -Oprindelig meddelelse- > Fra: Hisseine Dj. [mailto:[EMAIL PROTECTED]] > Sendt: 6. maj 2002 17:24 > Til: [EMAIL PROTECTED] > Emne: C++ API for Mysql > > > Hello, > > Can someone tell me if there is an C++ API that works smooth with MYSQL on > linux. > So far I was trying msql++ and SQLAPI++. > SQLAPI++ seems to be good by there are problems when runing the program. > > My system is Redhat 7.2 and Mysql 3.23.49 > > > Thanks, > > Hisseine > > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
C++ API for Mysql
Hello, Can someone tell me if there is an C++ API that works smooth with MYSQL on linux. So far I was trying msql++ and SQLAPI++. SQLAPI++ seems to be good by there are problems when runing the program. My system is Redhat 7.2 and Mysql 3.23.49 Thanks, Hisseine - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
C++ API for Mysql
Hello, Can someone tell me if there is an C++ API that works smooth with MYSQL on linux. So far I was trying msql++ and SQLAPI++. SQLAPI++ seems to be good by there are problems when runing the program. My system is Redhat 7.2 and Mysql 3.23.49 Thanks, Hisseine - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Every user can access the databases
GRANT ALL PRIVILEGES ON databasename.* TO user IDENTIFIED BY 'password'; http://www.mysql.com/doc/G/R/GRANT.html Gurhan -Original Message- From: Dennis [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 9:52 AM To: [EMAIL PROTECTED] Subject: Every user can access the databases I have tried almost everything and nothing works. The problem is, I have a server with different MySQL databases from different people. User 1 should not access database 2 and user 2 should not access database 1. What is the easiest way to prevent user 1 to access database 2. I can't get it right. Thanks in advance, Dennis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
SV: Newbie Question
You could use Kylix from Borland. It's a RAD tool - it's actually Delphi ported to Linux. - Carsten > -Oprindelig meddelelse- > Fra: Yvon Darang [mailto:[EMAIL PROTECTED]] > Sendt: 6. maj 2002 15:31 > Til: [EMAIL PROTECTED] > Emne: Newbie Question > > > Hi everybody, > Let's say I do not want to use any microsoft tool on my PC. Is it possible > to develop a desktop application using MySQL as database server without > having to program in C or C++ to access and display the Data? > > My question probably should be: If not ODBC, what desktop database > application (like MS-Access) can I use in Linux to access MySQL data or to > develop and application that can access those data. > > TIA > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Newbie Question
Hi everybody, Let's say I do not want to use any microsoft tool on my PC. Is it possible to develop a desktop application using MySQL as database server without having to program in C or C++ to access and display the Data? My question probably should be: If not ODBC, what desktop database application (like MS-Access) can I use in Linux to access MySQL data or to develop and application that can access those data. TIA - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: FULLTEXT search bugs in 4.0.1 alpha?...
Hi! On May 06, Gurhan Ozen wrote: >Is there anyway to see what bugs have been reported for fulltext search > in 4.0.1 alpha ? I know that Jeremy Zawodny has mentioned that a few bugs > were found in fulltext search in 4.0.1 , but didn't tell what they were. > I have installed 4.0.1 and ran it as second mysqld in my web server, > mainly to utilize its fulltext search in boolean mode capability, but I have > encountered some discrepancies. I don't want to resubmit them if they have > already been submitted. > > Gurhan Take a look at http://www.mysql.com/doc/N/e/News-4.0.2.html but it's not easy to find out whether your particular bug is covered. I'd recommend to wait till 4.0.2 - it should be out very soon. Regards, Sergei -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany <___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Every user can access the databases
[snip]
The problem is, I have a server with different MySQL databases from
different people.
User 1 should not access database 2 and user 2 should not access database 1.
What is the easiest way to prevent user 1 to access database 2. I can't get
it right.
[/snip]
http://www.mysql.com/doc/G/R/GRANT.html
GRANT priv_type [(column_list)] [, priv_type [(column_list)] ...]
ON {tbl_name | * | *.* | db_name.*}
TO user_name [IDENTIFIED BY [PASSWORD] 'password']
[, user_name [IDENTIFIED BY 'password'] ...]
Notice the second line of the query "ON {tbl_name | * | *.* | db_name.*}",
this is where you set permissions for a given database and/or table.
Jay Blanchard
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
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: quota on mysql
HI, Praful Saijare wrote: >Hi all, > How do I go about applying user quota on mysql databases, so that I = >can keep track of the disk space used by all the databases users. > >I am using RH linux 7.0 =20 >Mysql 3.23.40 installed on /var/lib/mysql/ >quota-2.00pre3-7 applied on /home partation > >Thanks in advance >Praful > Place user databases in their home dirs with some conventional names and make symlinks into mysql datadirs. Example: mkdir /home/user1/mysql_db chmod 700 /home/user1/mysql_db chown mysql home/user1/mysql_db ln -s /home/user1/mysql_db /var/lib/mysql/user1_db -- Best regards -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Alexander Keremidarski <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Sofia, Bulgaria <___/ www.mysql.com M: +359 88 231668 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Turning on logging SQL-Commands
Hi! Can I turn on logging of all SQL-Commands send by one particular client on the server side? Turning on logging for all clients seems to be possible. Does it work for one client only too? -- 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
Re: Re: Access denied irregularities
Nick, Monday, May 06, 2002, 3:58:34 PM, you wrote: NW> * and then Egor Egorov declared >> "Access denied" error occurs when you have no required privileges to >> connect to the MySQL server. You gave incomplete error message and I >> can't give you detailed answer. Please, check the following >> link, you can find description of this error there: >> http://www.mysql.com/doc/A/c/Access_denied.html NW> Yes, I've already been there. No luck. the problem seems to be on/off NW> part of the time it is okay and at other times not. It is just a regular NW> 'Access denied to user 'nick@localhost using passwore YES' error. Did you have successfully connected as 'nick@localhost' with the same password before or "Access denied" error appeared after you added this user? If you have no successful connections before, how did you set up privileges for your user? Are you sure that your password is correct? Check also privilege tables, if there are any conflict entries. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Trouble with indexing
Hi Donna, Donna Robinson wrote: >Hi Jeremy, > >On Sunday 05 May 2002 5:52 am, Jeremy Zawodny wrote: > >>REGEXP queries don't use indexes. Change the: >> REGEXP "^A" >>to >> LIKE "A%" >>and it'll use the index and give you a nice speed boost. >> > >which indeed it did! I checked the manual (yet again) and it doesn't actually >say anything about regexp not using indices (grr). So I went thru the db fns >and stripped out regexp and replaced with like. > It is true for every where clause which uses function. Think about it. When you match: ... Column = MySQL can use index on Column to find the match. When you match: ... function(Column) = . MySQL must evaluate result of function and just then compare this result. How can index be used in this case? LIKE is not a function but comparison operator so it can be optimized in case it matches Prefix of column. This is because of nature of keys in MySQL they can be used for prefix-match. Column LIKE "%A" - will not use index too. > >BUT I have hit a snag on the last query to fix: >select dances.danceid as id, dancetitles.title from dances, dancetitles where >dances.danceid=dancetitles.danceid and dances.has_crib='T' and >dancetitles.title regexp "^[T-Z]"; > >Despite multiple offerings of every perm and comb I can think of (and even >rtfm) I can't persuade mysql to eat a "like" query which will return the same >ans as the regexp one. Am beginning to think am flogging a dead horse here? > If you often need to match agains first letter it will be wize to use prefix index on first letter only. ALTER TABLE dancetitles ADD KEY (title(1)); This will be very small and fast index. I want to mention also that in your first posting table dancetitles has no index at all on title column. > >Donna > -- Best regards -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Alexander Keremidarski <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Sofia, Bulgaria <___/ www.mysql.com M: +359 88 231668 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Every user can access the databases
I have tried almost everything and nothing works. The problem is, I have a server with different MySQL databases from different people. User 1 should not access database 2 and user 2 should not access database 1. What is the easiest way to prevent user 1 to access database 2. I can't get it right. Thanks in advance, Dennis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
FULLTEXT search bugs in 4.0.1 alpha?...
Is there anyway to see what bugs have been reported for fulltext search in 4.0.1 alpha ? I know that Jeremy Zawodny has mentioned that a few bugs were found in fulltext search in 4.0.1 , but didn't tell what they were. I have installed 4.0.1 and ran it as second mysqld in my web server, mainly to utilize its fulltext search in boolean mode capability, but I have encountered some discrepancies. I don't want to resubmit them if they have already been submitted. Gurhan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 denied irregularities
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 * and then Gurhan Ozen declared > Make sure that the user + host combination you are giving has privileges > in the MySQL server you are trying to connect. You may wanna check user > table in the mysql database. Well, there must be privileges because as I said, I can connect sometimes and not others. - -- Nick Wilson // www.tioka.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) iD8DBQE81oh/HpvrrTa6L5oRApPXAJ4uZhnlEh1uVOUva5QJRXtFq8H82ACfedLj ss8aXzi5/Spgwn2migqqnW4= =HVzX -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 denied irregularities
Make sure that the user + host combination you are giving has privileges
in the MySQL server you are trying to connect. You may wanna check user
table in the mysql database.
Gurhan
-Original Message-
From: Nick Wilson [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 06, 2002 6:30 AM
To: [EMAIL PROTECTED]
Subject: Access denied irregularities
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi all, I'm getting intermittent 'Access denied' errors when running a
php script to admin a mysql db. I've looked in the manual but cannot
work out why I can connect in some parts of the script and not in others
Perhaps there is some common 'gotchas' you might let me know about?
Here is the code I use to connect:
function _db_connect() {
if(!$this->link_id) {
$this->link_id=mysql_connect($this->host, $this->user,
$this->pass);
}
if(!$this->link_id) {
return FALSE;
}
$db=mysql_select_db($this->db) or die ("can't select db");
return TRUE;
}
Many thanks for any help :-)
- --
Nick Wilson // www.explodingnet.com
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.6 (GNU/Linux)
iD8DBQE81ls+HpvrrTa6L5oRAp0nAJwLLRlGpFV6ZQndPhqqF1+pW6w2MwCeK+H8
bsslUwVkhNA+8vVU/8S4qTc=
=jhe5
-END PGP SIGNATURE-
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
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: Error 28
You can use perror to see what that error code is> perror 28 Error code 28: No space left on device Seems like you ran out of space? Gurhan -Original Message- From: Scott Raley [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 8:44 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Error 28 I'm using DBTools Table Manager to make table changes in Mysql 3.23... I'm trying to add an auto_increment ID field to 2 tables that already have data in them.. 1 table worked fine, the other table I get "Got Error 28 from Table Handler" can anyone tell me why I get this? TIA - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Performance issues between two servers
Have you checked the network connection? You should be running at full-duplex so you don't get collisions. But more importantly, make sure you aren't getting errors on the line. A poor crimp or pinched wire could really slow things down, especially if you try running at 100MB. Try copying a single large file between APPDEV1/SQLDEV0 and APPDEV1/SQLDEV1. See what the speed difference is. > Backgroud: > We have a process that runs on a server (APPDEV1) that writes records to a > mysql server (SQLDEV0). We attempted to move the databases from SQLDEV0 to > SQLDEV1 and have run into some sort of performance bottleneck. The server > SQLDEV0 is a Compac server with ~2GB of ram and two processors. The server > SQLDEV1 is also a Compac server. It has 4GB of ram and two processors that > are a bit faster than the ones in SQLDEV0. > > One big difference between SQLDEV0 and SQLDEV1 is the version of RedHat. > SQLDEV0 is running RedHat 7.2. SQLDEV1 is running an enterprise version of > RedHat 7.2 so that it can take advantage of the 4GB of ram. > > All the table spaces are using Innodb. > > Problem: > The process on APPDEV1 can write records to the box SQLDEV0 about eight time > faster than to SQLDEV1. We've looked over the my.sql configurations and they > seem to be ok. In fact we adjusted the my.cnf file on SQLDEV1 so that it was > identicle to SQLDEV0 but it did not help. The systems are running ~70-95% > cpu idle so cpu is not a bottle neck. In testing, raw disk I/O rates are > about 50% faster on SQLDEV1 as SQLDEV0. We don't see a bottle neck on I/O. > > This is the only process using mysql on SQLDEV1. On SQLDEV0 it shares access > with several other programs but the box is not very busy. > > Thoughts? Comments? Criticism? > > Carl McNamee > Systems Administrator/DBA > Billing Concepts > (210) 949-7282 > > - > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > -- Brent Baisley Systems Architect Landover Associates, Inc. Search & Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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.23.50???
Balteo, MySQL/InnoDB-3.23.50 for Windows is available for download at http://www.mysql.com/downloads/mysql-3.23-pre.html. The 'prerelease' status only concerns Linux, where a new glibc and a new compiler are tested. For other platforms this is a normal stable release. For the InnoDB changelog see http://www.innodb.com/ibman.html#InnoDB_history. Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, row level locking, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com - Original Message - From: <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Monday, May 06, 2002 3:25 AM Subject: 3.23.50??? > What's going on at Mysql?? > When can we expect 3.23.50??? > Balteo. > > - Original Message - > From: Rodrigo Pérez <[EMAIL PROTECTED]> > To: <> > Sent: Sunday, May 05, 2002 11:32 PM > Subject: Re: Optimization > > > > Thanks Jay, > > Actually what i want to do is much more simple. I want to have on the same > > query result, the first 10 rows with this word and the total of rows from > > the table with this specific word. > > > > The result should be like a search engine page result. Has the total of > > pages with that word and the first 10 results. I want to put it together > in > > only one query. Is it possible ? > > > > SELECT COUNT(*) from TABLE where name="JOHN" > > SELECT * from TABLE where name="JOHN" limit 10 > > > > Thanks, > > Rodrigo > > - Original Message - > > From: "Jay Blanchard" <[EMAIL PROTECTED]> > > To: "'Rodrigo Pérez'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > > Sent: Friday, May 03, 2002 2:23 PM > > Subject: RE: Optimization > > > > > > > [snip] > > > I want to optimize one of my php scripts to acess mysql only once. Is > > there > > > anyway to put these two queries together: > > > > > > SELECT COUNT(*) from TABLE where name="JOHN" > > > SELECT * from TABLE where name="JOHN" limit 10 > > > [/snip] > > > > > > try > > > > > > select *, > > > sum(if(name = 'JOHN', 1, 0)) AS COUNT > > > from table > > > where name = 'JOHN' > > > group by name > > > > > > HTH! > > > > > > Jay > > > > > > > > > > > > - > > > Before posting, please check: > > >http://www.mysql.com/manual.php (the manual) > > >http://lists.mysql.com/ (the list archive) > > > > > > 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
RE: insert into integer field
{snip]
When I try and insert a string into an integer field, instead of throwing
an error MySQL accepts the insert and set that field's value to zero (I
assume default value). I am using the php mysql module by the way (not
PEAR). I would like to get an error when I insert the wrong data type into
a column. Is this something I need to setup in MySQL or is the fault of
the PHP MySQL module?
[/snip]
This is default behavior for MySQL. It will give a warning, but not an
error. If memory serves there is nothing in the setup that will change this
behavior.
Jay Blanchard
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
insert into integer field
When I try and insert a string into an integer field, instead of throwing an error MySQL accepts the insert and set that field's value to zero (I assume default value). I am using the php mysql module by the way (not PEAR). I would like to get an error when I insert the wrong data type into a column. Is this something I need to setup in MySQL or is the fault of the PHP MySQL module? -Mike - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: display days between two dates?
Hello, Tim Carlson wrote: >Hello, > >Newbie SQL person here. I am hoping to be able to do the >following. Given two dates, I would like to display all of the days >between them. > >So if I had the dates 2002-02-08 and 2002-02-12, I would like to have >MySQL spit back > >2002-02-08 >2002-02-09 >2002-02-10 >2002-02-11 >2002-02-12 > >Any way I can do this directly in MySQL without constructing a table? I've >looked through the date maniplulation routines in the manual, but nothing >jumps out at me. Any pointers would be appreciated. > Suppose you have some table with column called date_col DATE. i.e. containing dates as above Now if your question is: How to select all rows where is true that date_col is between dates 2002-02-08 and 2002-02-12? You can use almost same spelling. (SQL is written to be close to natural english) mysql> SELECT date_col FROM your_table WHERE date_col BETWEEN '2002-02-08' AND '2002-02-12'; will be valid statement :) -- Best regards -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Alexander Keremidarski <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Sofia, Bulgaria <___/ www.mysql.com M: +359 88 231668 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 denied irregularities
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 * and then Egor Egorov declared > "Access denied" error occurs when you have no required privileges to > connect to the MySQL server. You gave incomplete error message and I > can't give you detailed answer. Please, check the following > link, you can find description of this error there: > http://www.mysql.com/doc/A/c/Access_denied.html Yes, I've already been there. No luck. the problem seems to be on/off part of the time it is okay and at other times not. It is just a regular 'Access denied to user 'nick@localhost using passwore YES' error. - -- Nick Wilson // www.explodingnet.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) iD8DBQE81n36HpvrrTa6L5oRAsTCAKCmYg8C6gO98Ci95gUJFFDP29KIGgCgh3AF nA5VXs3zxNVcnd4HsLB6cS8= =dTXx -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 28
I'm using DBTools Table Manager to make table changes in Mysql 3.23... I'm trying to add an auto_increment ID field to 2 tables that already have data in them.. 1 table worked fine, the other table I get "Got Error 28 from Table Handler" can anyone tell me why I get this? TIA - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: General error: Got error 12 from table handler on Linux.
Doron, Monday, May 06, 2002, 3:44:02 AM, you wrote: D> I got the above error when inserting a row into a heap table on linux D> mySQL version 3.23.49a from the Java JDBC driver. This is not reproduceable D> on a win32 DB. This does not appear to be space related as it failed after D> only about 200 rows. Just wondering if anyone has seen this before? # perror 12 Error code 12: Cannot allocate memory Heap table is stored in memory. So, looks like your memory limit is exhausted. D> -Doron -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Transfer data/ Insert +select
Sven, Saturday, May 04, 2002, 4:52:00 PM, you wrote: SB> The mySQL DB I have to rebuild was only one big table. Afer developing a SB> new DB design for it, I ran into the problem of transfering the data SB> from the old to the new database. SB> I need to split up the records and insert them into the specific tables. SB> My problem is that I can not figure out (as a total novice on mySQL) how SB> to insert the data properly. Every time I try there's either a SQL error SB> or the data is messed up and not ordered as it should be. SB> I tried to use the following statement: SB> insert into priv_details (hobbies, experi, quali, marital [.]) SB> select me.hobbies, me.experi [..] from memberscopy me, priv_details pd SB> where pd.id=me.id; SB> What can i do? First of all, read the manual: http://www.mysql.com/doc/I/N/INSERT_SELECT.html You can't use your table priv_details in the SELECT statement. SB> Regards, SB> Sven -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Access denied irregularities
Nick,
Monday, May 06, 2002, 1:30:22 PM, you wrote:
NW> Hi all, I'm getting intermittent 'Access denied' errors when running a
NW> php script to admin a mysql db. I've looked in the manual but cannot
NW> work out why I can connect in some parts of the script and not in others
NW> Perhaps there is some common 'gotchas' you might let me know about?
NW> Here is the code I use to connect:
NW> function _db_connect() {
NW> if(!$this->link_id) {
NW> $this->link_id=mysql_connect($this->host, $this->user,
NW> $this->pass);
NW> }
NW> if(!$this->link_id) {
NW> return FALSE;
NW> }
NW> $db=mysql_select_db($this->db) or die ("can't select db");
NW> return TRUE;
NW> }
NW> Many thanks for any help :-)
"Access denied" error occurs when you have no required privileges to
connect to the MySQL server. You gave incomplete error message and I
can't give you detailed answer. Please, check the following
link, you can find description of this error there:
http://www.mysql.com/doc/A/c/Access_denied.html
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL on Mac OS X
Phil,
Monday, May 06, 2002, 1:42:28 PM, you wrote:
PD> I've just installed MySQL 3.23.49 on Mac OS X.1.4. The installation went fine
(into /usr/local/) but now I'm having what I believe is a common permission problem.
When trying to add a database I
PD> get the following error:
PD> [localhost:~] phil% mysql
PD> Welcome to the MySQL monitor. Commands end with ; or \g.
PD> Your MySQL connection id is 12 to server version: 3.23.49-entropy.ch
PD> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
PD> mysql> create database CONTACT;
PD> ERROR 1044: Access denied for user: '@localhost' to database 'CONTACT'
PD> I couldn't find anything in the archives so I wondered, could somebody let me know
the workaround I need to do on the permissions to get me started?
By default anonymous user ('') has permissions only on the database
'test'. You should have permissions to create databases. You can find
a lot of info about MySQL privilege system in our manual:
http://www.mysql.com/doc/P/r/Privilege_system.html
http://www.mysql.com/doc/U/s/User_Account_Management.html
PD> Any help appreciated.
PD> Regards,
PD> Phil.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: quota on mysql
Praful, Monday, May 06, 2002, 2:41:54 PM, you wrote: PS>How do I go about applying user quota on mysql databases, so that I = PS> can keep track of the disk space used by all the databases users. PS> I am using RH linux 7.0 =20 PS> Mysql 3.23.40 installed on /var/lib/mysql/ PS> quota-2.00pre3-7 applied on /home partation You can use usual disk quotes. If the database size is more than available space for a user(or group), an error will take place. PS> Thanks in advance PS> Praful -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: problem on Load Data!
Jack, Monday, May 06, 2002, 7:40:08 AM, you wrote: J> Two Question : J> 1. J> I know that the 'LOAD DATA' command loads a bulk of data into a table, but J> what happen if i only want to load the data into specifc fields on a table J> instead of whole table. J> eg. J> Let say i had a file with 3 column of data, and i want to load these data J> into a 'ABC' table's field 3 to 5 and leave field 1 & 2 as it was! You can load data in certain table columns. Look at: http://www.mysql.com/doc/L/O/LOAD_DATA.html J> 2. J> I copied a file into server's root directory, and i was trying to load that J> file's data to table which i had failed using the following command in J> MYSQL: J> "LOAD DATA infile 'c:\hkd_rate.csv' into table hkd_deposit1 fields J> terminated by ',' " J> It said couldn't find the file! J> but if i put the file into the data directory of mysql, then it can find it! Yeah, because MySQL doesn't have permissions on that dir. J> So what should i do if i want mysql will able to find that file from root J> directory? You should change permissions on file and pathname dirs. J> -- J> Thx a lot! J> Jack -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: hostname.err
Samuel, Monday, May 06, 2002, 1:55:44 PM, you wrote: SM> REALFROM: "Samuel Mendelowski" <[EMAIL PROTECTED]> SM> HOUR: 2002050614 SM> The file hostname.err description: SM>mysqld started SM>/usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) SM>mysql ended SM> The file host.frm exists in /var/lib/mysql/mysql # perror 13 Error code 13: Permission denied MySQL doesn't have permissions on the MySQL data dir. SM> I can't open mysql using 'mysql' from prompt.I see an error: Can't connect SM> to local MySQL server through socket '/var/run/mysql/mysql.sock' (111) SM> Any ideas? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: LOAD DATA LOCAL error
Hi, Neil Bobstone wrote: >Hi, > >I Have compile Mysql 3.23.49 with : --enable-local-infile > > > >But when I want to use LOAD DATA LOCAL its says : The used command is >not allowed with this MySQL version > --enable-local-infile affects client library libmysqlclient Can you check if client library you are using is installed from same source? - the one you compiled. It often happens that you have different files from different releases installed. Proper way to "upgrade" if you use source is: 1. cd new_src; ./configure ... your opts; make; 2. cd old_src; make uninstall 3. stop mysqld 4. cd new_src; make install 5. start mysqld make uninstall will clean all libraries, headers and binaries, but will not touch your datadir nor config files. (/etc/my.cnf /etc/rc.d if any) -- Best regards -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Alexander Keremidarski <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Sofia, Bulgaria <___/ www.mysql.com M: +359 88 231668 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Group by "counted" records...
[snip] iduser | dtaccess --- 10 | '2000-10-02' 3 | '2000-12-04' 4 | '2000-10-09' 3 | '2000-12-04' 5 | '2001-02-10' 10 | '2001-03-01' 10 | '2001-01-10' 10 | '2001-01-11' 3 | '2000-12-10' I need to group the records by the number of time some user (iduser) appears in the table, and i need to know how many users appears once, how many appears twice and so on. Example: for these data, the resultset must bring: num_times | num_users - 1 | 2 3 | 1 4 | 1 - i.e: 2 users appears twice, one user - three times, one user - four times. Does anyone knows how can i do that? [/snip] SELECT COUNT(*) AS num_times, iduser FROM table GROUP BY iduser ORDER BY num_times HTH! Jay mysql, sql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
quota on mysql
Hi all, How do I go about applying user quota on mysql databases, so that I = can keep track of the disk space used by all the databases users. I am using RH linux 7.0 =20 Mysql 3.23.40 installed on /var/lib/mysql/ quota-2.00pre3-7 applied on /home partation Thanks in advance Praful - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
