MySQL Problem in Slackware 8.0
Hello gurus, I have Slackware 8.0 and RHL7.1 both on my Linux box. In Red Hat mysql is working smoothly but I am having having following problems in Slack8 In Slack8 mysql is installed as a per of standard installtion but not under /usr/local.The scripts are in /usr/bin and includes in /usr/include/mysql and libs in /usr/lib/mysql etc.. I could see that there is a group mysql and user mysql added to it. I could not loacte mention of mysqld in any of the rc scripts.when as root I give command /usr/bin/safe_mysqld It gives me following messages: Starting mysqld daemon with databases from /var/lib/mysql and on the next line it says mysqld ended. Also when as user mysql I give command mysql -u mysql -p it prompts for the password but after giving the password it gives error: can't connect to loacl mysql server through socket /var/run/mysql/mysql.sock I also copied the file /etc/my-small.cnf to ~mysql/.my.cnf (This is as per documentation in my-small.cnf) Still I am not able to log on to the database. I am not able to understand why mysqld is ending.Is there any other thing I am missing which would start this daemon and then I can connect to database. Regards, Prasad __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MySQL Problem in Slackware 8.0
when as root I give command /usr/bin/safe_mysqld It gives me following messages: Starting mysqld daemon with databases from /var/lib/mysql and on the next line it says mysqld ended. What does /var/lib/mysql/`hostname`.err say? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL Problem in Slackware 8.0
Hi, I also noticed one thing , will the entry in the file /etc/hosts make a diffrenece. In Red Hat it is 127.0.0.1 localhost But in Slack it is 127.0.0.1 prasad( which is my name) Regards, Prasad --- Prasad Paranjape [EMAIL PROTECTED] wrote: Hello gurus, I have Slackware 8.0 and RHL7.1 both on my Linux box. In Red Hat mysql is working smoothly but I am having having following problems in Slack8 In Slack8 mysql is installed as a per of standard installtion but not under /usr/local.The scripts are in /usr/bin and includes in /usr/include/mysql and libs in /usr/lib/mysql etc.. I could see that there is a group mysql and user mysql added to it. I could not loacte mention of mysqld in any of the rc scripts.when as root I give command /usr/bin/safe_mysqld It gives me following messages: Starting mysqld daemon with databases from /var/lib/mysql and on the next line it says mysqld ended. Also when as user mysql I give command mysql -u mysql -p it prompts for the password but after giving the password it gives error: can't connect to loacl mysql server through socket /var/run/mysql/mysql.sock I also copied the file /etc/my-small.cnf to ~mysql/.my.cnf (This is as per documentation in my-small.cnf) Still I am not able to log on to the database. I am not able to understand why mysqld is ending.Is there any other thing I am missing which would start this daemon and then I can connect to database. Regards, Prasad __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger. http://im.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: INFILE DATE Problem
Vernon, I'm using the: LOAD DATA LOCAL INFILE /home/filename.txt INTO TABLE list; which works just fine. Only problem is the date column which is formatted as such 4/11/1970 comes out as - 00- 00 The date field is setup as Field: s_date, Type: date, Null, YES, Key: BLANK, Default: Null, Extra BLANK. Any ideas on how to resolve this? =I assume that you have RTFM to know the formatting options for representing dates in MySQL. =Given the incompatibility of formats you have two choices (1) change the date data's format before the LOAD DATA, or (2) change it (er) afterwards. The choice will depend upon the current format of the data file, the tools you have at your disposal, and your skill set. I'm practising 'tinkering' in SQL so... =In the second case: a) redefine the CREATE TABLE so that s_date is a string column (call it something else, eg temp_date); b) perform the LOAD DATA and check; c) ALTER TABLE to insert the desired s_date column and format; d) run an UPDATE to copy the data out of temp_date, reformatting it, and storing it into s_date; e) check, then ALTER TABLE to remove temp_date; f) if s_date is an indexed column, do NOT add the index when you add the column (will slow down/complicate the processing in (d)) - but don't forget to ALTER TABLE to add the index at this time. =ok? =dn - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: BINARY, NULL, and GROUP BY
Hi!
Miguel == Miguel Angel Solorzano [EMAIL PROTECTED] writes:
Miguel At 12:13 12/01/2002 +0100, Carl Troein wrote:
Miguel Hi!
Miguel Thanks you for the bug report I was be able to repeat
Miguel in the 4.0.1 Windows release too.
Miguel Regards,
Miguel Miguel
CREATE TABLE t1 (txt varchar(10) default NULL);
INSERT INTO t1 VALUES ('aaa');
INSERT INTO t1 VALUES (NULL);
SELECT BINARY txt AS t FROM t1 GROUP BY t;
On my Linux systems, and MySQL compiled with gcc 2.95.3,
this invariably leads to a segfault. Removing the non-null
row from t1 solves the problem, as does removing the row
with null. Without BINARY everything works.
I'm no longer on the list, so if you reply to this mail
with comments or questions that you think I should read,
please be sure to include my address.
This is now fixed and pushed into the MySQL 4.0.2 source repository. If
nothing unexpected happens, we will start building binary releases of
MySQL 4.0.2 next week. (Note that because we will not do a release
while there is any not solved critical bug, it may from time to time
take longer than expected before a new release is available).
Regards,
Monty
--
For technical support contracts, goto https://order.mysql.com/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Michael Widenius [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO
/_/ /_/\_, /___/\___\_\___/ Helsinki, Finland
___/ 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
MySql 3.23.29 on RedHat 6.2 restarts itself
Hello! My MySql server on RedHat 6.2 restarts itself. In the MySql log writes: Number of processes running now: 0 020116 14:16:16 mysqld restarted 020116 14:16:17 Can't start server: Bind on TCP/IP port: Address already in 020116 14:16:17 Do you already have another mysqld server running on port: 020116 14:16:17 Aborting 020116 14:16:17 mysqld ended\n Can somebody help me! It's urgent. Is the problem in scripts. Do I need to upgrade mysql version. Thank you __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
SELECT DISTINCT - bug?
Jag har problem med en enkel SELECT DISTINCT, på ett enda fält i en enda
tabell. Har jag missat något mycket grundläggande eller är det en BUG?
mysql repair table faktura_history;
+++--+--+
| Table | Op | Msg_type | Msg_text |
+++--+--+
| adzdisplay.faktura_history | repair | status | OK |
+++--+--+
1 row in set (0.00 sec)
mysql describe faktura_history;
+---+---+--+-+-++
| Field | Type | Null | Key | Default | Extra |
+---+---+--+-+-++
| id| int(11) | | PRI | NULL| auto_increment |
| salj_id | int(11) | YES | | NULL||
| kund_id | int(11) | YES | | NULL||
| summa | int(11) | YES | | NULL||
| fritext | text | YES | | NULL||
| fakturerad| enum('y','n') | YES | | NULL||
| dagar | int(11) | YES | | NULL||
| pris | int(11) | YES | | NULL||
| extra_procent | float(10,5) | YES | | NULL||
| updated | timestamp(14) | YES | | NULL||
| indate| timestamp(8) | YES | | NULL||
| ovrig | enum('y','n') | YES | | n ||
+---+---+--+-+-++
12 rows in set (0.00 sec)
mysql SELECT DISTINCT indate FROM faktura_history;
+--+
| indate |
+--+
| 20010515 |
| 20010516 |
| 20010517 |
| 20010521 |
| 20010522 |
| 20010522 |
| 20010522 |
| 20010522 |
| 20010522 |
| 20010530 |
| 20010530 |
| 20010530 |
| 20010530 |
| 20010530 |
| 20010530 |
| 20010530 |
| 20010530 |
| 20010530 |
| 20010530 |
| 20010531 |
| 20010531 |
| 20010531 |
| 20010531 |
| 20010531 |
| 20010531 |
| 20010531 |
| 20010531 |
| 20010531 |
| 20010531 |
| 20010531 |
| 20010531 |
| 20010531 |
| 20010531 |
| 20010531 |
| 20010531 |
| 20010531 |
| 20010531 |
| 20010531 |
| 20010531 |
| 20010531 |
| 20010531 |
| 20010531 |
| 20010531 |
| 20010531 |
| 20010601 |
| 20010601 |
| 20010601 |
| 20010601 |
| 20010601 |
| 20010605 |
| 20010605 |
| 20010605 |
| 20010612 |
| 20010612 |
| 20010612 |
| 20010612 |
| 20010612 |
| 20010612 |
| 20010612 |
| 20010613 |
| 20010618 |
| 20010618 |
| 20010618 |
| 20010618 |
| 20010618 |
| 20010618 |
| 20010618 |
| 20010618 |
| 20010618 |
| 20010618 |
| 20010618 |
| 20010618 |
| 20010626 |
| 20010626 |
| 20010626 |
| 20010626 |
| 20010626 |
| 20010626 |
| 20010626 |
| 20010626 |
| 20010626 |
| 20010626 |
| 20010626 |
| 20010626 |
| 20010627 |
| 20010702 |
| 20010702 |
| 20010703 |
| 20010716 |
| 20010719 |
| 20010802 |
| 20010807 |
| 20010809 |
| 20010813 |
| 20010814 |
| 20010814 |
| 20010814 |
| 20010814 |
| 20010814 |
| 20010814 |
| 20010814 |
| 20010814 |
| 20010815 |
| 20010815 |
| 20010815 |
| 20010815 |
| 20010815 |
| 20010907 |
| 20011009 |
| 20011012 |
| 20011029 |
| 20011029 |
| 20011029 |
| 20011029 |
| 20011029 |
| 20011029 |
| 20011029 |
| 20011029 |
| 20011029 |
| 20011029 |
| 20011029 |
| 20011029 |
| 20011029 |
| 20011029 |
| 20011029 |
| 20011029 |
| 20011029 |
| 20011029 |
| 20011029 |
| 20011029 |
| 20011029 |
| 20011029 |
| 20011029 |
| 20011029 |
| 20011029 |
| 20011029 |
| 20011029 |
| 20011029 |
| 20011029 |
| 20011029 |
| 20011029 |
| 20011029 |
| 20011029 |
| 20011029 |
| 20011029 |
| 20011029 |
| 20011029 |
| 20011029 |
| 20011029 |
| 20011029 |
+--+
150 rows in set (0.00 sec)
Känns inte särskilt DISTINCT. :( Samma sak händer med DISTINCTROW.
Mvh Anders Bjarby, Infomaker Scandinavia AB
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
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: SELECT DISTINCT - bug?
* Anders Bjarby Jag har problem med en enkel SELECT DISTINCT, på ett enda fält i en enda tabell. Har jag missat något mycket grundläggande eller är det en BUG? I would suggest you use english on this list... :) cut | indate| timestamp(8) | YES | | NULL|| I think your problem is the data type... timestamp is a special field type, used for automatic storing of the current time for inserts and updates. I think the entire timestamp is stored in the column, even if you have defined it as timestamp(8). (Only the display width of the column is restricted by (8).) Try changing it to a DATE field. -- Roger database, table - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Semi-static binary version of mysqlgui 1.7.5 for SPARC Solaris 2.8
Hi! As it has been asked by several users, there is finally a mysqlgui binary for the SPARC Solaris 2.8. It is as static as possible. The only dynamically linked libraries are those for which Sun does not supply static variants. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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: Compile woes :(
Ryn writes: Has anyone received the following [Exhibit 1] when building mysql 3.23.47 on Solaris 8? I am following the directions from the source installation web page on mysql.com. Thanks for any info, Ryan [Exhibit 1] gcc -DUNDEF_THREADS_HACK -I./../include -I../inc lude -I./.. -I..-I..-O3 -DDBUG_OFF -O3 -feli de-constructors -fno-exceptions -fno-rtti -fno-implicit-templates -fno-exceptio ns -fno-rtti -DHAVE_CURSES_H -I/export/home/desc/pkg/mysql-3.23.47/include -DHAV E_RWLOCK_T -c mysqlbinlog.cc /bin/sh ../libtool --mode=link gcc -O3 -DDBUG_OFF -O3 -felide-constructors -fno-exceptions -fno-rtti -fno-imp licit-templates -fno-exceptions -fno-rtti -DHAVE_CURSES_H -I/export/home/desc/pk g/mysql-3.23.47/include -DHAVE_RWLOCK_T -o mysqlbinlog mysqlbinlog.o ../libmysql/libmysqlclient.la -lz -lcrypt -lgen -lsocket -lnsl -lm gcc -O3 -DDBUG_OFF -O3 -felide-constructors -fno-exceptions -fno-rtti -fno-impli cit-templates -fno-exceptions -fno-rtti -DHAVE_CURSES_H -I/export/home/desc/pkg/ mysql-3.23.47/include -DHAVE_RWLOCK_T -o .libs/mysqlbinlog mysqlbinlog.o ../libmysql/.libs/libmysqlclient.so -lz -lcrypt -lgen -lsocket -lnsl -lm -lz -lc rypt -lgen -lsocket -lnsl -lm -Wl,--rpath -Wl,/usr/local/mysql/lib/mysql mysqlbinlog.o(.gnu.linkonce.d._ZTV9Log_event+0xc): undefined reference to `__cxa_pure_virtual' mysqlbinlog.o(.gnu.linkonce.d._ZTV9Log_event+0x1c): undefined reference to `__cxa_pure_virtual' collect2: ld returned 1 exit status make[2]: *** [mysqlbinlog] Error 1 make[2]: Leaving directory `/export/home/desc/pkg/mysql-3.23.47/client' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/export/home/desc/pkg/mysql-3.23.47' make: *** [all-recursive-am] Error 2 Hi! You have to define CXXLD as g++ with 3.0.* in order to link mysqld. There is a better workaround for this in our 4.0.2 BK repository. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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: Skip-Show-Database
Vernon A Webb writes: I'm sorry if I'm bothering people, some times I get the feeling that I am, so please let me know if I'm out of line. So now I've figured out that I need to use the skip-show-database option which I have added to the my.cnf file under [mysqld]. When I do this now and log in using MySQLGUI as any other user other than root I get access denied. Any ideas? Could be mysqlgui bug. Check it out with mysql monitor program. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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: Changing root password
If you have just finished installing, then root has no current password and you can leave out the -p altogether: root@localhost bin]# ./mysqladmin -u root password 'new-password' good luck Richard Ward Jay Paulson [EMAIL PROTECTED] 01/16/02 12:57AM I'm trying to change the root password for mysql. This is the first time I've tried to change the password and I can't get it to work. Below is the error message I get: [root@localhost bin]# ./mysqladmin -u root -p password 'new-password' Enter password: ./mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: YES)' I've looked at the manual and it doesn't say much that I've already done. I've also looked up the --skip-grant-tables but the only mysqld file I have to run is in the /etc/rc.d/init.d/ directory and it doesn't take the --skip-grant-tables flag. So I'm at a lost at what to do next. thanks. -- Content-Type: text/plain; Content-Disposition: attachment; filename=disclaimer.txt . Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Changing root password
Skip the -p. You have no current password . Jay Paulson wrote: I'm trying to change the root password for mysql. This is the first time I've tried to change the password and I can't get it to work. Below is the error message I get: [root@localhost bin]# ./mysqladmin -u root -p password 'new-password' Enter password: ./mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: YES)' I've looked at the manual and it doesn't say much that I've already done. I've also looked up the --skip-grant-tables but the only mysqld file I have to run is in the /etc/rc.d/init.d/ directory and it doesn't take the --skip-grant-tables flag. So I'm at a lost at what to do next. thanks. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: auto_increment
To answer your second question about how to retrieve the auto_incremented
values:
$dbh-do(SELECT last_insert_id() AS myvalue);
execute the above IMMEDIATELY after inserting the record
-Original Message-
From: Ben Curran [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 15, 2002 5:59 PM
To: [EMAIL PROTECTED]
Subject: auto_increment
Sorry if this is a newbie question, I've been through the manual, still
can't figure it out.
If one has created a table, with a key using auto_increment, how does one
Insert data into it?
If my table consists of (inID (primary key, auto incremented), employeeID
(foreign key) time, date).
if I use
$dbh-do(INSERT INTO timein VALUES('$employeeID','$timein','$day'));
obviously, it tells me that
DBD::mysql::db do failed: Column count doesn't match value count.
How do I refer to the auto incremented field when attempting to place values
in a new row?
my only thought is that it has something to do with mysql_insert_id. not
sure how though.
thanks.
ben.
This e-mail (and any attachments) is confidential and may contain personal
views which are not the views of the BBC unless specifically stated.
If you have received it in error, please delete it from your system, do not
use,
copy or disclose the information in any way nor act in reliance on it and
notify
the sender immediately. Please note that the BBC monitors e-mails sent
or received. Further communication will signify your consent to this.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
list of tables in a database
I need to know how to get a list of all the tables in a database. In Oracle you could select OWNER, TABLE_NAME from ALL_TABLES to get a list of all tables and their schemas. How does one do this in MySQL? Thanks, Bret - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: list of tables in a database
show tables will get you a list of tables. To get the schema of tables type 'describe tablename' J Bret Ewin wrote: I need to know how to get a list of all the tables in a database. In Oracle you could select OWNER, TABLE_NAME from ALL_TABLES to get a list of all tables and their schemas. How does one do this in MySQL? Thanks, Bret - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php . - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql daemon under macos X unstoppable?
hi everybody, i am new to mysql, got it up and running nicely under macos X 10.1, BUT i can't stop the daemon! myqsqladmin shutdown used with correct arguments does not show any effect. a normal kill won't do either. kill -9 is the only option to get rid of the daemon. anything i can do to solve this?? thanks a LOT for all help. Mit freundlichen Gruessen / Best regards Sven Hoffmann ___ thingk IT-Dienstleistungsgesellschaft mbH CAE-Support fuer EDS Informationstechnologie und Service GmbH Tel.: +49 33708-6-1465 Fax:+49 33708-6-3500 Email: [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: Purging records
Hi, Because i don't like the mysql DELETE syntax, i prefer using this quick method: % create a new table = table1 CREATE TABLE Table3 (...) % insert into table3 the records from table1 that aren't in table2 INSERT INTO Table3 (Table3.fields) SELECT Table1.fields FROM Table1 LEFT JOIN Table2 USING (id) WHERE Table2.id IS NULL % remove table1 DROP TABLE Table1 % rename table3 to table1 RENAME TABLE Table3 TO Table1; On Tue, 2002-01-15 at 22:32, SNK wrote: Hi , I would need help with the syntax for this: I have Table1 and Table2. Table2 consists only of records that also exist in Table1 (duplicates), and I wish to delete all the records in Table1 that are matched in Table2, while keeping the rest of the records in Table1 intact. Can anyone help? Thanks very much in advance. Fers, Buenos Aires - Argentina. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Diana Soares - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: list of tables in a database
Show Tables; - VirtualChicagoLand.com Is Your Chicagoland Resource! Visit: http://VirtualChicagoLand.com On Wed, 16 Jan 2002, Bret Ewin wrote: I need to know how to get a list of all the tables in a database. In Oracle you could select OWNER, TABLE_NAME from ALL_TABLES to get a list of all tables and their schemas. How does one do this in MySQL? Thanks, Bret - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
current development
Hello, I did not follow mySQL development really in the last months / year, so I can't estimate that: When can we expect foreign key support in mySQL? I think it's the most important feature for me that is missing, cascading deletes and this stuff. I know its planned in the mySQL 4 development cycle, but any ideads about release dates? And how long does it usually take until a mySQL release is declared stable? Or what influences declaring stability? I am not really sure about using alpha versions in a maybe productive environment, but mySQL 3 misses some key features and I don't really want to use MS SQL Server or Oracle... Regards Bruno - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
current development
Hello, I did not follow mySQL development really in the last months / year, so I can't estimate that: When can we expect foreign key support in mySQL? I think it's the most important feature for me that is missing, cascading deletes and this stuff. I know its planned in the mySQL 4 development cycle, but any ideads about release dates? And how long does it usually take until a mySQL release is declared stable? Or what influences declaring stability? I am not really sure about using alpha versions in a maybe productive environment, but mySQL 3 misses some key features and I don't really want to use MS SQL Server or Oracle... Regards Bruno - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
INstall error
I am getting the following when trying to compile. checking if gcc PIC flag -fPIC works... yes checking if gcc supports -c -o file.o... yes checking if gcc supports -c -o file.lo... yes checking if gcc supports -fno-rtti -fno-exceptions ... yes checking if gcc static flag -static works... -static checking if the linker (/usr/ccs/bin/ld) is GNU ld... no checking whether the linker (/usr/ccs/bin/ld) supports shared libraries... yes checking command to parse /usr/ccs/bin/nm -p output... ok checking how to hardcode library paths into programs... immediate checking for /usr/ccs/bin/ld option to reload object files... -r checking dynamic linker characteristics... solaris2.8 ld.so checking if libtool supports shared libraries... yes checking whether to build shared libraries... yes checking whether to build static libraries... yes checking for objdir... .libs creating libtool loading cache ./config.cache checking for a BSD compatible install... ./install-sh -c checking for bison... no checking for byacc... no checking for pdftex... no checking return type of sprintf... configure: error: can not run test program while cross compiling DEBUG: NU ld... no SEND-PR: -*- send-pr -*- SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as SEND-PR: will all comments (text enclosed in `' and `'). Category: mysql Class: [ sw-bug | doc-bug | change-request | support ] (one line) Release: mysql-3.23.47 (Source distribution) Environment: machine, os, target, libraries (multiple lines) System: SunOS prime5 5.8 Generic_108528-10 sun4u sparc SUNW,Ultra-80 Architecture: sun4 Some paths: /usr/bin/perl /usr/local/bin/make /usr/local/bin/gcc /usr/ucb/cc GCC: Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.7/2.95.3/specs gcc version 2.95.3 20010315 (release) Compilation info: CC='gcc' CFLAGS='' CXX='gcc' CXXFLAGS='' LDFLAGS='' LIBC: -rw-r--r-- 1 root bin 1759400 Aug 3 15:55 /lib/libc.a lrwxrwxrwx 1 root root 11 Aug 10 11:18 /lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 root bin 1136720 Aug 3 15:55 /lib/libc.so.1 -rw-r--r-- 1 root bin 1759400 Aug 3 15:55 /usr/lib/libc.a lrwxrwxrwx 1 root root 11 Aug 10 11:18 /usr/lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 root bin 1136720 Aug 3 15:55 /usr/lib/libc.so.1 Configure command: ./configure --with-unix-socket-path=/var/tmp/mysql.sock --with-low-memory --with-mit-threads=yes --without-perl --enable-thread-safe-client --with-berkeley-db --with-innodb Perl: This is perl, version 5.005_03 built for sun4-solaris Vinnie Salerno WARSIM Staff Systems Engineer Lockheed Martin Information Systems 12506 Lake Underhill Road, MP-855 Orlando, FL 32825-5002 e-mail: [EMAIL PROTECTED] Phone: 407-306-3735 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: current development
On Wed, Jan 16, 2002 at 04:51:55PM +0100, Bruno Haller wrote: : Hello, : : I did not follow mySQL development really in the last months / year, so : I can't estimate that: When can we expect foreign key support in mySQL? : I think it's the most important feature for me that is missing, : cascading deletes and this stuff. With InnoDB, FK support is in the 3.23.x branch. That's a stable branch. * Philip Molter * Texas.net Internet * http://www.texas.net/ * [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: mysql daemon under macos X unstoppable?
Hoffmann, Sven (thingk) writes: hi everybody, i am new to mysql, got it up and running nicely under macos X 10.1, BUT i can't stop the daemon! myqsqladmin shutdown used with correct arguments does not show any effect. a normal kill won't do either. kill -9 is the only option to get rid of the daemon. anything i can do to solve this?? thanks a LOT for all help. Mit freundlichen Gruessen / Best regards Sven Hoffmann ___ thingk IT-Dienstleistungsgesellschaft mbH CAE-Support fuer EDS Informationstechnologie und Service GmbH Tel.: +49 33708-6-1465 Fax: +49 33708-6-3500 Email:[EMAIL PROTECTED] Hi! This was fixed in MySQL 3.23.45. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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: INstall error
http://home.earthlink.net/~jaymzh666/mysql.html Have a look at this. Plus I gcc V3 would not work but V2 did Hope this helps Simon -Original Message- From: Salerno, Vincent [mailto:[EMAIL PROTECTED]] Sent: 16 January 2002 15:54 To: '[EMAIL PROTECTED]' Subject: INstall error I am getting the following when trying to compile. checking if gcc PIC flag -fPIC works... yes checking if gcc supports -c -o file.o... yes checking if gcc supports -c -o file.lo... yes checking if gcc supports -fno-rtti -fno-exceptions ... yes checking if gcc static flag -static works... -static checking if the linker (/usr/ccs/bin/ld) is GNU ld... no checking whether the linker (/usr/ccs/bin/ld) supports shared libraries... yes checking command to parse /usr/ccs/bin/nm -p output... ok checking how to hardcode library paths into programs... immediate checking for /usr/ccs/bin/ld option to reload object files... -r checking dynamic linker characteristics... solaris2.8 ld.so checking if libtool supports shared libraries... yes checking whether to build shared libraries... yes checking whether to build static libraries... yes checking for objdir... .libs creating libtool loading cache ./config.cache checking for a BSD compatible install... ./install-sh -c checking for bison... no checking for byacc... no checking for pdftex... no checking return type of sprintf... configure: error: can not run test program while cross compiling DEBUG: NU ld... no SEND-PR: -*- send-pr -*- SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as SEND-PR: will all comments (text enclosed in `' and `'). Category: mysql Class: [ sw-bug | doc-bug | change-request | support ] (one line) Release: mysql-3.23.47 (Source distribution) Environment: machine, os, target, libraries (multiple lines) System: SunOS prime5 5.8 Generic_108528-10 sun4u sparc SUNW,Ultra-80 Architecture: sun4 Some paths: /usr/bin/perl /usr/local/bin/make /usr/local/bin/gcc /usr/ucb/cc GCC: Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.7/2.95.3/specs gcc version 2.95.3 20010315 (release) Compilation info: CC='gcc' CFLAGS='' CXX='gcc' CXXFLAGS='' LDFLAGS='' LIBC: -rw-r--r-- 1 root bin 1759400 Aug 3 15:55 /lib/libc.a lrwxrwxrwx 1 root root 11 Aug 10 11:18 /lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 root bin 1136720 Aug 3 15:55 /lib/libc.so.1 -rw-r--r-- 1 root bin 1759400 Aug 3 15:55 /usr/lib/libc.a lrwxrwxrwx 1 root root 11 Aug 10 11:18 /usr/lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 root bin 1136720 Aug 3 15:55 /usr/lib/libc.so.1 Configure command: ./configure --with-unix-socket-path=/var/tmp/mysql.sock --with-low-memory --with-mit-threads=yes --without-perl --enable-thread-safe-client --with-berkeley-db --with-innodb Perl: This is perl, version 5.005_03 built for sun4-solaris Vinnie Salerno WARSIM Staff Systems Engineer Lockheed Martin Information Systems 12506 Lake Underhill Road, MP-855 Orlando, FL 32825-5002 e-mail: [EMAIL PROTECTED] Phone: 407-306-3735 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: INstall error
Salerno, Vincent writes: I am getting the following when trying to compile. checking if gcc PIC flag -fPIC works... yes checking if gcc supports -c -o file.o... yes checking if gcc supports -c -o file.lo... yes checking if gcc supports -fno-rtti -fno-exceptions ... yes checking if gcc static flag -static works... -static checking if the linker (/usr/ccs/bin/ld) is GNU ld... no checking whether the linker (/usr/ccs/bin/ld) supports shared libraries... yes checking command to parse /usr/ccs/bin/nm -p output... ok checking how to hardcode library paths into programs... immediate checking for /usr/ccs/bin/ld option to reload object files... -r checking dynamic linker characteristics... solaris2.8 ld.so checking if libtool supports shared libraries... yes checking whether to build shared libraries... yes checking whether to build static libraries... yes checking for objdir... .libs creating libtool loading cache ./config.cache checking for a BSD compatible install... ./install-sh -c checking for bison... no checking for byacc... no checking for pdftex... no checking return type of sprintf... configure: error: can not run test program while cross compiling Vinnie Salerno WARSIM Staff Systems Engineer Lockheed Martin Information Systems 12506 Lake Underhill Road, MP-855 Orlando, FL 32825-5002 e-mail: [EMAIL PROTECTED] Phone: 407-306-3735 Hi! The above is a frequent error on Solaris and our manual finely documents how to circumvent it. However, I would recommend you to download our binary for SPARC Solaris 2.8 as they are regularly built. It is possible, but not that easy, to make the binaries of the same quality that we obtain. Using our binary, you will be much safer. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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: auto_increment
On Wednesday 16 January 2002 07:28, Hamlin Nicholas-qa568 wrote:
Easier yet, when using DBI::mysql, is:
my $IncrementedID = $dbh-{'mysql_insertid'};
When executed after the INSERT command.
Does this now work with 64-bit auto-increment fields now in DBI? As of
less than a year ago, DBI would incorrectly truncate the result to 32-bits
and we had to use the SELECT LAST_INSERT_ID() method instead. A real pain
to track down all the code that used the old method :-(
We prefix some of our IDs with server IDs and when we tried a server with
a number so high that the ID was outside the range of 2^32, we got garbage
:-(
Best,
Kyle
--
Cut costs, Fax smart. Use iPrint2Fax worldwide and save!
- iPrint2Fax software is FREE, no fax modem required.
- FREE iPrint2Fax to a single email address.
- iPrint2Fax to PSTN based Fax (Up to 95% Savings)
- iPrint2Fax Broadcasting: Send 100s of faxes and fax to emails
in the time it takes to send just one!
==
FREE software download available at www.iPrint2Fax.com
==
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
AW: current development
With InnoDB, FK support is in the 3.23.x branch. That's a stable branch. I never used innoDB before so I checked out the homepage now, but unfortunately it says: InnoDB does not yet support CASCADE ON DELETE or other special options on the constraints. Thanks anyway, that innoDB stuff seems to be interesting though. Regards Bruno - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
SQL issue: avoid double entries, but note the attempt!
I have data coming into the database from various sources. Some of these data may be duplicated, except that there is a field noting the data source they are coming from. I do not wish them to appear twice, but I do wish to make a note that these records were seen in two or more sources. As I understand a UNIQUE INDEX will just filter out the double entries. What I really want to say is: IF INDEX(field1,field2,field3,...,fieldN) is seen, then do not insert this record, but in the existing record, UPDATe field N+1 to whatever it is plus the string ,field0 Example: field0 filed1 field2field3field4 172.16.166.1 10 trans1 already exists and we see a record 172.16.166.2 10 trans1 then UPDATE the excisting record to 172.16.166.1 10 trans,172.16.166.2 I suspect this cannot be done in SQL, so maybe I need to try via say DBI do an INSERT and if it fails then do the update. But I guess I need to look at failure codes then to make sure this is tthe problem indeed. Is there maybe a cleaner way?? Thanks, S.Alexiou - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql and FULLTEXT
Hi there. I need to do this sentence: select * from table1 where match column1 against word; But it don´t works becouse crate the column like this: alter table table1 add column1 varchar(100); Well my question is: How I should create the column1 to have fulltext for this query?? Thanks Victor. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql and FULLTEXT
On Wed, 2002-01-16 at 18:51, [EMAIL PROTECTED] wrote: Hi there. I need to do this sentence: select * from table1 where match column1 against word; Try: select * from table1 where match column1 against (word); But it don´t works becouse crate the column like this: alter table table1 add column1 varchar(100); That's ok, but don't forget to create an index of type FULLTEXT. (with ALTER TABLE or CREATE INDEX). There is a good example in: http://mysql.com/doc/F/u/Fulltext_Search.html Well my question is: How I should create the column1 to have fulltext for this query?? Thanks Victor. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Diana Soares - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: mysql and FULLTEXT
I think you need to do this: ALTER TABLE table1 ADD FULLTEXT (column1) I may be wrong though, and I too have a question. Does adding the FULLTEXT index affect performance dramatically? If it does, what is a better way to search for exact word matches in columns that may contain thousands of words in each entry? LIKE doesn't do it properly. It will find 'then Richard said to' when I search for Rich and I don't want that.. Thanks, Rich Foreman -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Hi there. I need to do this sentence: select * from table1 where match column1 against word; But it don´t works becouse crate the column like this: alter table table1 add column1 varchar(100); Well my question is: How I should create the column1 to have fulltext for this query?? Thanks Victor. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
searchable archives of mysql list
Hi, There used to be a link to searchable archives of the mysql list on the old mysql web site. Is there still a link to it somewhere? Thanks, Ben - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL newbie question
Hello, and sorry for the bother with what is probaby a very simple problem. I'm new to MySQL. I have just installed RedHat 7.2 Linux, and installed the included distribution of MySQL, which is version 3.23.41 When I try to run the mysql program, either by itself, or with any arguments, I get the following error. ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) Could anyone provide advice as to what I need to do to get this running? Thanks for any assistance you can provide. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 newbie question
did you start mysqld ? -Original Message- From: David Burklin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 1:36 PM To: '[EMAIL PROTECTED]' Subject: MySQL newbie question Hello, and sorry for the bother with what is probaby a very simple problem. I'm new to MySQL. I have just installed RedHat 7.2 Linux, and installed the included distribution of MySQL, which is version 3.23.41 When I try to run the mysql program, either by itself, or with any arguments, I get the following error. ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) Could anyone provide advice as to what I need to do to get this running? Thanks for any assistance you can provide. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MySQL newbie question
yes... at least I thought so, although I think I may not have started it properly. I have set it to an on state, using chkconfig --level 2345 mysqld on. Afterwhich, if I do a chkconfig --list mysqld, it reports that mysqld is running. However, I have found reference to using the command mysql.server start in the online help manual. When I run that, I get [root@Acillatem mysql]# ./mysql.server start [root@Acillatem mysql]# Starting mysqld daemon with databases from /var/lib/mysql 020115 13:38:41 mysqld ended I think I've missed something somewhere... a ps -ax does not report the daemon running, so that's the big part of my problem. -Original Message- From: Rick Emery [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 1:44 PM To: David Burklin; '[EMAIL PROTECTED]' Subject: RE: MySQL newbie question did you start mysqld ? -Original Message- From: David Burklin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 1:36 PM To: '[EMAIL PROTECTED]' Subject: MySQL newbie question Hello, and sorry for the bother with what is probaby a very simple problem. I'm new to MySQL. I have just installed RedHat 7.2 Linux, and installed the included distribution of MySQL, which is version 3.23.41 When I try to run the mysql program, either by itself, or with any arguments, I get the following error. ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) Could anyone provide advice as to what I need to do to get this running? Thanks for any assistance you can provide. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL newbie question
On Wednesday 16 Jan 2002 7:36 pm, you wrote: Hello, and sorry for the bother with what is probaby a very simple problem. I'm new to MySQL. I have just installed RedHat 7.2 Linux, and installed the included distribution of MySQL, which is version 3.23.41 When I try to run the mysql program, either by itself, or with any arguments, I get the following error. ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) Could anyone provide advice as to what I need to do to get this running? Thanks for any assistance you can provide. type ps -A | grep mysql to see if mysql is running. If its not then try /etc/init.d/mysqld start to see if there are any error messages. If it just wasn't started when you booted type ntsys and scroll down the menu until you reach mysqld and hit space which should put a little star by it and therfore get it working - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 newbie question
This did the trick. Thanks Nod and everyone else! -Original Message- From: nod [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 2:02 PM To: David Burklin Cc: [EMAIL PROTECTED] Subject: Re: MySQL newbie question On Wednesday 16 Jan 2002 7:36 pm, you wrote: Hello, and sorry for the bother with what is probaby a very simple problem. I'm new to MySQL. I have just installed RedHat 7.2 Linux, and installed the included distribution of MySQL, which is version 3.23.41 When I try to run the mysql program, either by itself, or with any arguments, I get the following error. ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) Could anyone provide advice as to what I need to do to get this running? Thanks for any assistance you can provide. type ps -A | grep mysql to see if mysql is running. If its not then try /etc/init.d/mysqld start to see if there are any error messages. If it just wasn't started when you booted type ntsys and scroll down the menu until you reach mysqld and hit space which should put a little star by it and therfore get it working - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: searchable archives of mysql list
http://lists.mysql.com/ (the list archive) (This is at the end of each email) - Original Message - From: Ben Olasov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, January 16, 2002 9:40 PM Subject: searchable archives of mysql list Hi, There used to be a link to searchable archives of the mysql list on the old mysql web site. Is there still a link to it somewhere? Thanks, Ben - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: searchable archives of mysql list
Sorry, I just re-subscribed just to ask this question and didn't actually read any of the messages. Thanks for pointing this out. B On Wed, 16 Jan 2002, Marinos wrote: http://lists.mysql.com/ (the list archive) (This is at the end of each email) - Original Message - From: Ben Olasov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, January 16, 2002 9:40 PM Subject: searchable archives of mysql list Hi, There used to be a link to searchable archives of the mysql list on the old mysql web site. Is there still a link to it somewhere? Thanks, Ben - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
URGENT - THIS ERROR IS KILLING ME!
Dear folks, It´s the first time I´m using this list and now I got a really big problem. It´s the fourth time the error below hapens to my server and every time it happened I had to process back my backup file. I´ve been working all day long and I don´t wanna loose the information this time. How can I get inside the log and delete manually this uncommitted transaction to put my server up again? Is there a way to do such a thing? Thanks. Guto Vannini 020116 17:21:23 mysqld started InnoDB: Database was not shut down normally. InnoDB: Starting recovery from log files... InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 96570467 InnoDB: Doing recovery: scanned up to log sequence number 0 96587059 Innobase: 1 uncommitted transaction(s) which must be rolled back Innobase: Starting rollback of uncommitted transactions Innobase: Rolling back trx no 760417 mysqld got signal 11; The manual section 'Debugging a MySQL server' tells you how to use a stack trace and/or the core file to produce a readable backtrace that may help in finding out why mysqld died. Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Bogus stack limit or frame pointer, aborting backtrace. 020116 17:21:23 mysqld ended - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
tables_priv not working
I can't get table-specific grants to work.
(FIRST: I log in as an administrator and run the following command:)
mysql GRANT SELECT, INSERT, UPDATE, DELETE ON myDataBase.watch TO '%';
Query OK, 0 rows affected (0.00 sec)
mysql SELECT * FROM tables_priv;
+--++--++---++-+-+
| Host | Db | User | Table_name | Grantor | Timestamp |
|Table_priv | Column_priv |
+--++--++---++-+-+
| %| myDataBase | %| watch | nhamlin@localhost | 20020116151451 |
|Select,Insert,Update,Delete | |
+--++--++---++-+-+
1 row in set (0.00 sec)
mysql select Host, Db, User, Select_priv as SEL, Insert_priv as INS, Update_priv as
UPDT, Delete_priv as DEL FROM db WHERE user = 'dummy';
+--++---+-+-+--+-+
| Host | Db | User | SEL | INS | UPDT | DEL |
+--++---+-+-+--+-+
| %| myDataBase | dummy | Y | N | N| N |
+--++---+-+-+--+-+
1 row in set (0.00 sec)
(SECOND: I log out and log back in using another user with the following credentials:)
mysql select user, Select_priv as SEL, Insert_priv as INS, Update_priv as UPDT,
Delete_priv as DEL FROM user WHERE user = 'dummy';
+---+-+-+--+-+
| user | SEL | INS | UPDT | DEL |
+---+-+-+--+-+
| dummy | N | N | N| N |
+---+-+-+--+-+
1 row in set (0.00 sec)
(THIRD: I see if I can access the table.)
mysql select * from watch;
+-+-+-+-+
| user| w_table | w_value | create_date |
+-+-+-+-+
| nhamlin | fo | 6075| 2002-01-03 13:46:22 |
| nhamlin | fo | 7584| 2002-01-04 14:51:56 |
| nhamlin | p_q | 3350| 2002-01-10 12:23:48 |
| nhamlin | cpr | 4101| 2002-01-10 19:24:56 |
| nhamlin | cpr | 4094| 2002-01-11 17:38:46 |
| nhamlin | fo | 7 | 2002-01-15 10:10:34 |
| qa568 | fo | 10409 | 2002-01-16 12:46:38 |
+-+-+-+-+
7 rows in set (0.00 sec)
(FOURTH: I then try to add a value to the table. This is where it fails.)
mysql insert into watch values ('dummy','fo','6075',NOW());
ERROR 1142: insert command denied to user: 'dummy@localhost' for table 'watch'
What am I doing wrong? I have about 9 tables inside of MyDataBase, and I only want
two tables, 'watch' and 'user', to be updatable by anyone with an existing account who
can log in from anywhere (more specifically, the web).
Nicholas
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Summary: Board Meeting
All, Below is Marten's IRC summary of the recent MySQL AB Board Meeting that he attended. 14:04:00 marten Kaj asked about the board meeting, so here we go with a fresh report 14:04:12 * Kaj listens eagerly 14:04:13 marten SUMMARY: Board meeting went fine 14:04:52 marten BUDGET: Board will make a final decision in appr 3 weeks, and until then we continue on scenario LOW 14:05:17 marten Board was very happy with recent press publicity and with sales 14:05:28 Kaj good! 14:05:32 marten I demoed Olof's system, i.e. the sales database online 14:05:55 Kaj a LAMP application 14:05:59 marten We spoke about last year and what we learned from it. 14:06:11 marten And we spoke about goal setting for this year, next year, and the coming ten years. 14:06:44 marten I said we (=the company) can build MySQL AB to be a company with one hundred million in annual sales 14:07:05 Kaj within this century :) 14:07:10 marten But first we have to reach ten million. 14:07:19 marten (yes, definitely within this century) 14:07:28 Kaj the first ten million are the hardest! 14:07:46 marten To reach ten million, we just have to work hard and avoid making stuping mistakes 14:08:05 marten To go from ten up to something higher, we ALSO need a very well thought-out strategy 14:08:16 Kaj so no stuping mistakes, then :) 14:08:39 Kaj will the board have valuable input for the strategy? 14:08:48 marten eksaktly, and no speing errirs 14:08:53 --venu_ ([EMAIL PROTECTED]) has joined #mysql 14:09:01 marten hi venu 14:09:12 venu_marten, hi 14:09:38 marten venu: I am halfway through informing of today's board meeting 14:09:50 Kaj Well, thanks for the overview! It seems you're a happy ceo with the board meeting -- oh there's more to come! 14:10:16 marten (Summary again, for Venu: board meeting went well, they are happy with what we do, they will make budget decision in 3 weeks or so) 14:10:43 venu_thanks for updating me 14:10:57 * mwagner can mail the IRC logs to discuss@ or something 14:10:59 marten Let me see what else we discussed 14:11:01 venu_thats really good to know 14:11:18 marten The board also discussed our budget proposal. 14:11:30 marten We (= the management) have proposed the budget in three scenarios. 14:12:04 marten LOW means that we survive without further investment and build the company slowly but steadily towards profitabilty that is to be reached within 6-9 months. 14:12:32 marten MEDIUM is a scenario where we INVEST in building up a direct sales force and some proactive marketing 14:13:00 marten HIGH is a scenario that we can do if we get significant additional funding and can speed up all our processes: development, sales, marketing 14:14:01 marten In conclusion, the board likes the idea of three scenarios and the fact that all of them are designed to take us into profitability before the year ends. 14:14:12 marten That's it - questions! 14:14:25 Kaj Who attended? 14:15:05 marten The entire board: John Wattin (Chair), Morten Austestad, Terje Laugerud, Fredrik Oweson, Eric Cronstedt, David Axmark plus officers Hans and MGM. 14:15:49 Kaj For how long did you meet today? 14:16:00 marten 10am to 1pm 14:16:52 marten Matt, I don't remember how to send a msg to you only, but feel free to mail the log to discuss if you find it of interest. 14:17:05 mwagner ok 14:17:08 Kaj messages /msg marten way to go! 14:17:37 Kaj Mårten, back in Finland already? 14:17:55 marten Yes, I am back in MySQL Kyrkslätt Offices 14:18:08 Kaj Good! 14:18:20 Kaj Wirelessly so? 14:18:46 marten not wireless now, but will soon seat myself more comfortably with the wireless stuff 14:18:55 marten BTW, one more thing from the board meeting 14:19:00 marten (or actually not from the board meeting) 14:19:14 Kaj make up your mind :) 14:19:35 marten If you want to take one business-oriented buzz word (or term) with you now - and one that will guide our business this year, it is... 14:19:45 * Kaj waits in suspension 14:19:52 marten MONTH-ON-MONTH TOP-LINE GROWTH 14:20:02 Kaj every month bigger than the previous one? 14:20:17 marten Yep, first: growth EVERY month 14:20:19 Kaj so what about July-on-June, eh? 14:20:38 marten Second: growth specifically in SALES (which is on the top line in a profit and loss calculation - hence the term) 14:21:26 marten July-on-June we can manage by asking trusted customers to place their orders specifically in July 14:21:34 Kaj :) 14:22:12 marten Now I need to log off - any other questions? 14:22:32 mwagner none here 14:22:46 Kaj http://www.polycon.fi/~ksa/foton/ukraina/stora/DCP_5069.JPG 14:23:27 marten yep, that's me 14:23:53 Kaj worm just said he had never been to Kiev 14:24:00 Kaj hence I showed him some pics 14:24:09 Kaj worm is
Re: tables_priv not working
On Wednesday 16 Jan 2002 8:35 pm, Hamlin Nicholas-qa568 wrote: I can't get table-specific grants to work. snip Have you flush privileges ? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: tables_priv not working
On Wednesday 16 Jan 2002 8:35 pm, Hamlin Nicholas-qa568 wrote: I can't get table-specific grants to work. snip Have you flush privileges ? Yes. That didn't change it. Nicholas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: command mysql -u $user without typing it - getting shafted and annoyed now.
How did you add the users? If you inserted them into the user table, you are asking for trouble unless you understand exactly what you are doing. That is why the GRANT and REVOKE statements were added. Since you did not use 'identified by somepassword' I'm not sure if you set one, in which case the -p option would cause a failure. Also, even though the manual states that you don't need to FLUSH PRIVILEGES after using GRANT, I find that sometimes I do. Matthew Darcy wrote: I must be going so wrong here. I deleted the users and started again. added 2 users dba and matt. Both of these have the host of % (connect from anything yes ?) I then do a grant all privileges on *.* to dba@% flush privileges and grant all privileges on *.* to matt@% flush privileges then mysql -u matt -p gives me ERROR 1045: Access denied for user: 'dba@localhost' (Using password: YES) and I am on the local host ??? what the hell is going on I thougth I understood and was getting somewhere. obviously not. Sorry to drag this up again. Matt. -Original Message- From: Ho, Kam [mailto:[EMAIL PROTECTED]] Sent: 09 January 2002 16:10 To: '[EMAIL PROTECTED]'; Gerald Clark Cc: MySql List Subject: RE: command mysql -u $user without typing it Try this: mysql grant all privileges on *.* to test2@localhost also read manual about the grant command. -Original Message- From: Matthew Darcy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 09, 2002 11:04 AM To: Gerald Clark Cc: MySql List Subject: RE: command mysql -u $user without typing it I read similar notes on this in the manual, saying that invoking mysql without the username will try to take the unix username if it exists in the database. I tried this with test2, it opened an mysql session no problem, but when I did a connect mysql it said access is denyed for user @localhostto database mysql to me this looks like it is trying to connect with no user instead of test2@localhost can you explain this ? Thanks, Matt. -Original Message- From: Gerald Clark [mailto:[EMAIL PROTECTED]] Sent: 09 January 2002 15:56 To: [EMAIL PROTECTED] Cc: MySql List Subject: Re: command mysql -u $user without typing it Matthew Darcy wrote: I have 3 UNIX users on my server. test1, test2, and test3. I have created 3 users for mysql test1, test2, and test3 (shock horror) If I want to connect to the database as root then I understand I must do mysql -u root -p but I would like test1 2 and 3 to be able to type mysql and be either logged in as their unix username, ie test2 types mysql and connects to the database as test2 (mysql account) or at least be prompted for the password for test2. The only way I can think of doing this is by setting up an alias ie alias mysql_connect=`mysql -u $username -p` there must be some sort of autologin from username like in oracle. Thanks, Matt. The user defaults to the unix user. You can put a .my.cnf file in their home directory with [client] password=whatever to make it even easier. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: URGENT - THIS ERROR IS KILLING ME!
Guto, what version of MySQL you are running and on what operating system and version? Please upgrade to the latest 3.23.47. Many bugs in earlier versions have been fixed. Starting from 3.23.44 you have the following forced recovery option which you can use to dump your tables from a corrupt database. See the online manual at http://www.innodb.com/ibman.html for more information. Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB .. 6.1 Forcing recovery In some cases apparent database page corruption is actually due to the operating system which has corrupted its own file cache, and the data on disk may be ok. It is best first to try rebooting your computer. It may remove the errors which appeared as database page corruption. If there is database page corruption, you may want to dump your tables from the database with SELECT INTO OUTFILE, and usually most of the data is intact and correct. But the corruption may cause InnoDB background operations to crash or assert, or even the InnoDB roll-forward recovery to crash. Starting from the InnoDB version 3.23.44 there is a my.cnf option with which you can force InnoDB to start up, and you can also prevent background operations from running, so that you will be able to dump your tables. For example, you can set set-variable = innodb_force_recovery = 4 in my.cnf. The alternatives for innodb_force_recovery are listed below. The database must not otherwise be used with these options! As a safety measure InnoDB prevents a user from modifying data when this option is 0. A bigger number below means that all precautions of lower numbers are included. If you are able to dump your tables with an option at most 4, then you are relatively safe that only some data on corrupt individual pages is lost. Option 6 is more dramatic, because database pages are left in an obsolete state, which in turn may introduce more corruption into B-trees and other database structures. 1 (SRV_FORCE_IGNORE_CORRUPT) let the server run even if it detects a corrupt page; 2 (SRV_FORCE_NO_BACKGROUND) prevent the main thread from running: if a crash would occur in purge, this prevents it; 3 (SRV_FORCE_NO_TRX_UNDO) do not run transaction rollbacks after recovery; 4 (SRV_FORCE_NO_IBUF_MERGE) prevent also insert buffer merge operations: if they would cause a crash, better not do them; 5 (SRV_FORCE_NO_UNDO_LOG_SCAN) do not look at undo logs when starting the database: InnoDB will treat even incomplete transactions as committed; 6 (SRV_FORCE_NO_LOG_REDO) do not do the log roll-forward in connection with recovery. .. ... Dear folks, It´s the first time I´m using this list and now I got a really big problem. It´s the fourth time the error below hapens to my server and every time it happened I had to process back my backup file. I´ve been working all day long and I don´t wanna loose the information this time. How can I get inside the log and delete manually this uncommitted transaction to put my server up again? Is there a way to do such a thing? Thanks. Guto Vannini 020116 17:21:23 mysqld started InnoDB: Database was not shut down normally. InnoDB: Starting recovery from log files... InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 96570467 InnoDB: Doing recovery: scanned up to log sequence number 0 96587059 Innobase: 1 uncommitted transaction(s) which must be rolled back Innobase: Starting rollback of uncommitted transactions Innobase: Rolling back trx no 760417 mysqld got signal 11; The manual section 'Debugging a MySQL server' tells you how to use a stack trace and/or the core file to produce a readable backtrace that may help in finding out why mysqld died. Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Bogus stack limit or frame pointer, aborting backtrace. 020116 17:21:23 mysqld ended - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
quick questions - wierd
running isamchk -eis and -o gives me following output 1) impossible length!!! does anyone got this before? 2) recordspace used: 100% ??? what does this mean? I have plenty of space on my hard drive # isamchk -o trend_data - recovering ISAM-table 'trend_data.ISM' Data records: 2371874 Found block with impossible length 4294967229 at 160392545; Skipped Data records: 2238318 # isamchk -eis trend_data Checking ISAM file: trend_data Key: 1: Keyblocks used: 50% Packed: 92% Max levels: 4 Key: 2: Keyblocks used: 60% Packed: 70% Max levels: 6 Key: 3: Keyblocks used: 49% Packed: 85% Max levels: 4 Key: 4: Keyblocks used: 49% Packed: 92% Max levels: 4 Key: 5: Keyblocks used: 83% Packed:0% Max levels: 4 Key: 6: Keyblocks used: 51% Packed: 81% Max levels: 5 Total:Keyblocks used: 57% Packed: 80% Records: 2238318M.recordlength: 72 Packed:64% Recordspace used: 100% Empty space: 0% Blocks/Record: 1.00 Record blocks: 2238318Delete blocks: 0 Record data: 163384748Deleted data : 0 Lost space: 0Linkdata: 6714954 User time 1576.95, System time 75.15 Maximum resident set size 0, Integral resident set size 0 Non physical pagefaults 0, Physical pagefaults 9912, Swaps 0 Blocks in 0 out 0, Messages in 0 out 0, Signals 0 Vouluntary context switches 10493, Invouluntary context switches 12475 __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Foreign keys, mysql ??
Below are two tables..
How can table 'regs' populate 'type' from table
'equip'??
code
$sth=$dbh-prepare ( CREATE TABLE equip (
typevarchar(255),
type_id smallint unsigned not null auto_increment,
primary key (type_id) ) );
$sth-execute ();
$sth-finish ();
eval { $dbh-do(DROP TABLE regs) }; # see if table
exists, then drop !
print Dropping sicc failed: $@\n if $@;
$sth=$dbh-prepare ( CREATE TABLE regs (
citevarchar(255),
reg blob,
reg_id smallint unsigned not null auto_increment,
ref_id smallint unsigned not null REFERENCES
refs,
pn_id smallint unsigned not null REFERENCES permitno,
type_id smallint unsigned not null REFERENCES equip,
sic_id smallint unsigned not null REFERENCES sicc,
primary key (reg_id) ) );
$sth-execute ();
$sth-finish ();
=
Regards,
Investorclb
__
Do You Yahoo!?
Send FREE video emails in Yahoo! Mail!
http://promo.yahoo.com/videomail/
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
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 error
Mysql in a shared environment is prone to punish all clients with too many connections errors if one client is hyperactive. There seems to be no way to deal with this within the standard framework. This could be dealt with by adding max_connections_per_ip and max_connections_per_user to protect against deliberate or accidental denial of service by slurping all the available connections. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: tables_priv not working
On Wednesday 16 Jan 2002 8:50 pm, Hamlin Nicholas-qa568 wrote: On Wednesday 16 Jan 2002 8:35 pm, Hamlin Nicholas-qa568 wrote: I can't get table-specific grants to work. snip Have you flush privileges ? Yes. That didn't change it. I think I've got it, from the manual section 4.2.9 :- http://www.mysql.com/doc/R/e/Request_access.html The tables_priv and columns_priv tables are sorted on the Host, Db, and User fields.This is similar to db table sorting, although the sorting is simpler because only the Host field may contain wild cards. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 error
I agree with you, sometimes my server experiences some DoS and because MySQL cannot handle all that connections, the load goes really high and we can't do anything :( - Original Message - From: Dave Dyer [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, January 16, 2002 11:17 PM Subject: Too Many Connections error Mysql in a shared environment is prone to punish all clients with too many connections errors if one client is hyperactive. There seems to be no way to deal with this within the standard framework. This could be dealt with by adding max_connections_per_ip and max_connections_per_user to protect against deliberate or accidental denial of service by slurping all the available connections. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
My Apologies - Re: Summary: Board Meeting
All, Please disregard this Summary: Board Meeting message. It was sent to the public mailing list in error. This message was NOT at all meant for the public mailing list. Please except my apologies for the intrusion. Matt Wagner, MySQL AB -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Matt Wagner [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Herr Direktor /_/ /_/\_, /___/\___\_\___/ Hopkins, Minnesota USA ___/ 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: my.ini vs. my.cnf on Winodws?
Hi! Sinisa == Sinisa Milivojevic [EMAIL PROTECTED] writes: Sinisa Jeremy Zawodny writes: According to what I read in the manual, I'm lead to believe that MySQL on Windows can read from either C:\my.cnf or systemdir\my.ini. Which will it read first? The manual also seems to say that you can only use one. So if you create both, which will it prefer? cut Sinisa my.cnf will be read first and if it is found my.ini will not be read Sinisa at all. Sinisa Take a look at mysys/default.c for futher details ... To refresh my memory, I did. MySQL will first read systemdir\my.ini and then C:\my.cnf Sorry, Sinisa, you can't get things right every time ;) (No one can...) I have updated the manual regarding this. Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland ___/ 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
OSX Migration Problem
After some trial and [much] error, I finally have the latest version of PHP (4.0.6??) and MySQL running under Mac OSX 10.1.2. And they seem to be working... sort of. The only problem is when I try to load some pages that use the PHP Session ID function. Now, these exact pages--the whole site in fact--is already running without incident on my ISP (FatCow), and has been for a while. So I figure there must be a configuration issue to deal with. In any case, here are the errors when the page loads (and that's also interesting, it does load). If any of you can shed light on this, I would very much appreciate it. Thanks. Warning: Cannot send session cache limiter - headers already sent (output started at /Users/rene/Sites/smartslitters/jupiter/europa/header.inc:6) in /Users/rene/Sites/smartslitters/jupiter/europa/header.inc on line 19 Warning: Unable to save MySQL query result in /Users/rene/Sites/smartslitters/jupiter/europa/header.inc on line 44 Warning: Supplied argument is not a valid MySQL result resource in /Users/rene/Sites/smartslitters/jupiter/europa/header.inc on line 45 --- ...Rene -- René Fournier - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 OSX and a pound of my flesh
Can someone PLEASE explain why I get the following error message under OSX (PHP+MySQL), but not under Windows ME or Linux? Warning: Cannot send session cache limiter - headers already sent (output started at /Users/rene/Sites/smartslitters/jupiter/europa/header.inc:6) in /Users/rene/Sites/smartslitters/jupiter/europa/header.inc on line 19 Warning: Unable to save MySQL query result in /Users/rene/Sites/smartslitters/jupiter/europa/header.inc on line 44 Warning: Supplied argument is not a valid MySQL result resource in /Users/rene/Sites/smartslitters/jupiter/europa/header.inc on line 45 --- ...Rene --- René Fournier [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
Mac OSX !?!?!?
Can someone PLEASE explain why I get the following error message under OSX (PHP+MySQL), but not under Windows ME or Linux? Warning: Cannot send session cache limiter - headers already sent (output started at /Users/rene/Sites/smartslitters/jupiter/europa/header.inc:6) in /Users/rene/Sites/smartslitters/jupiter/europa/header.inc on line 19 Warning: Unable to save MySQL query result in /Users/rene/Sites/smartslitters/jupiter/europa/header.inc on line 44 Warning: Supplied argument is not a valid MySQL result resource in /Users/rene/Sites/smartslitters/jupiter/europa/header.inc on line 45 --- After these lines, the pages load fine. I'm using PHP Session ID variables (or trying to)--they work fine as I said under other OSes, but now break under OSX. ...Rene --- René Fournier [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: [PHP] Mac OSX !?!?!?
Kind of hard to say without source code for the session part.. Although the MySQL warnings, I got those because MySQL does not automatically start in OSX, if you know it's started then Im not sure, but if not.. go here to get the autostart utility: http://www.entropy.ch/software/macosx/mysql/ This link will have information and a link of where you can download the utility. Rick The human mind is not capable of grasping the Universe. We are like a little child entering a huge library. The walls are covered to the ceilings with books in many different tongues. The child knows that someone must have written these books. It does not know who or how. It does not understand the languages in which they are written. But the child notes a definite plan in the arrangement of the books---a mysterious order which it does not comprehend, but only dimly suspects. - Albert Einstein From: René Fournier [EMAIL PROTECTED] Date: Wed, 16 Jan 2002 17:50:06 -0700 To: [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: [PHP] Mac OSX !?!?!? Can someone PLEASE explain why I get the following error message under OSX (PHP+MySQL), but not under Windows ME or Linux? Warning: Cannot send session cache limiter - headers already sent (output started at /Users/rene/Sites/smartslitters/jupiter/europa/header.inc:6) in /Users/rene/Sites/smartslitters/jupiter/europa/header.inc on line 19 Warning: Unable to save MySQL query result in /Users/rene/Sites/smartslitters/jupiter/europa/header.inc on line 44 Warning: Supplied argument is not a valid MySQL result resource in /Users/rene/Sites/smartslitters/jupiter/europa/header.inc on line 45 --- After these lines, the pages load fine. I'm using PHP Session ID variables (or trying to)--they work fine as I said under other OSes, but now break under OSX. ...Rene --- René Fournier [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [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
running sql commands from a shell
Hi everyone This is the first time I have posted to this list and I was wondering if someone could answer my question. I know you can run commands from a shell prompt (such as unix...) like: shell mysql -e 'SELECT * FROM table' database for a simple select query and shell mysqlimport --local database table.txt to import information from a text file. I was just wondering how (and even if you can) set up a pager and write to a file from the shell. I can do it from the mysql command prompt like this: mysql pager cat /home/aaron/tube.txt; mysql select Run from tubes; This will put the result of the query into tubes.txt So does anyone know if i can do this from the shell prompt?? Thanks alot for your help Aaron - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
OS X Waiting on pid file
Hello, I'm using the 3.23.46 mysql binary kindly supplied by Marc Liyanage (www.entropy.ch/software/macosx/) on OS X 10.1.1. Maybe 1 out of 5 tries mysqladmin shutdown fails, timed-out waiting for the pid file it says. mysqladmin doesn't return and I have to either use ^C or open a new window and kill mysqladmin to get terminate it and get the error. After that the mysql sock file is gone (so I may no longer connect) but the pid file remains and I have to kill -9 safe_mysqld and mysqld then run isamchk. Here's what I'm doing: -- Development on a laptop; no one else connecting to the DB -- I make certain nothing is working against the DB before trying to shutdown -- Most db queries coming through PHP4.0.6 all else through mysql cli -- start from /usr/local/mysql using sudo bin/safe_mysqld --user=mysql -- stop with mysqladmin -u root -pppassword shutdown -- Being on a laptop, mysql sometimes sees the host as localhost and sometimes as dhcp-* host. -- I've noticed I get different .pid and .err files depending on host -- Hosts are switching mid-stream (I always shutdown myslq before going on/off a network) I've been through books and website, but I haven't been able to resolve what I'm doing wrong. . . mysql has been really great to have on the laptop and I'm hoping someone could help through this one problem. Thanks in advance, Steve Fox UT CMHC - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL on RH7.0 Alpha permissions don't work?
When I try to use MySQL 3.23.38 on my RH7.0 Alpha system, the only way I can create and access tables is as a root user. BUT --- I don't need to be logged in as root to become root user, it will let anyone be root with the command: mysql -u root I tried granting permissions for users, but it makes no difference. I tried putting passwords on the grant statements, but I can't log in as a different user using a password -- it never authenticates. And as any other user than root it won't let me access any tables. Am I doing something wrong, is it configured wrong, or is it a problem with the particular RH7.0/Alpha/MySQL distribution? I admit I'm a MySQL newbie. John Dudeck Home: [EMAIL PROTECTED]Tel: 704-588-9891 Work: [EMAIL PROTECTED] Tel: 704-588-4300 -- Some of the things you learn don't jump right out at you. You have to think about them awhile. -- Norm Ducharme - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 error
Won't this handle half of your issues? http://www.mysql.com/doc/S/e/Security.html If you want to restrict the number of connections for a single user, you can do this by setting the max_user_connections variable in mysqld. nickg -Original Message- From: Dave Dyer [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 4:18 PM To: [EMAIL PROTECTED] Subject: Too Many Connections error Mysql in a shared environment is prone to punish all clients with too many connections errors if one client is hyperactive. There seems to be no way to deal with this within the standard framework. This could be dealt with by adding max_connections_per_ip and max_connections_per_user to protect against deliberate or accidental denial of service by slurping all the available connections. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Bug in replication 3.23.46-max
On Tue, Jan 15, 2002 at 10:59:07PM -0500, Wendell Dingus wrote: I'm fairly certain this is a bug. It's on 3.23.46-max and the changelog for .47 doesn't mention it. I have 2 servers using replication. Server1 is used by client machines and all updates are to it. Server2 stays in perfect sync with it and logs all updates to it's own binary log. I then use mysqlbinlog from server2 to parse out those database changes every half hour or so and send to another server via a (part-time) internet connection where it attempts to maintain a synced copy of the data as well. A modify table to add a new field on server1 propogates to server2 but NOT to the third server. I've not tracked down exactly where things are breaking down yet. Server1 and 2 are Linux and are using INNODB tables. Server3 is not Linux and is not able to use INNODB at the moment. Even a create table ... type=INNODB works on server3 making the table MyISAM instead. It's just the modify table statements with the addition of a new field that don't make it. I've not captured and analyzed one of the binary logs yet but will try to do so. Just wanted to let someone know of a probable bug. I'll also upgrade to .47 and report back if that resolves this. But you can see the query in the binary log? Is it just a case of mysqlbinlog not extracting the query properly? Jeremy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 1169: Can't write, because of unique constraint, to table '#sql3aa_a_1'
Can anyone please explain what the subject error means? Full details are
below. Have tried searching and not come up with anything.
Thanks!
Darryl Luff
[EMAIL PROTECTED]
When running this query:
select src as Source, dst as Destination, count(*) as Drops
from data
where (action in ('drop', 'reject'))
group by src, dst
;
on this table:
create table data (
id int unsigned auto_increment primary key,
ldate DATE,
ltime TIME,
ltype varchar(50),
action varchar(50),
proto varchar(50),
src varchar(255),
dst varchar(255),
service varchar(50),
s_port varchar(50),
xlatesrc varchar(255),
xlatedst varchar(255),
reason varchar(255),
icmptype varchar(50),
icmpcode varchar(50),
sysmsgs varchar(50)
);
I get this error:
mysql \. sql/drops-src-dst.sql
ERROR 1169: Can't write, because of unique constraint, to table
'#sql3aa_a_1'
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Memory
From the innodb.com site (bugs fixes): On Linux x86 you must be careful you do not set memory usage too high. glibc will allow the process heap to grow over thread stacks, which will crash your server. Make sure innodb_buffer_pool_size + key_buffer + max_connections * (sort_buffer + record_buffer) + max_connections * 1 MB is significantly smaller than 2 GB. Each thread will use a stack (often 1 MB) and in the worst case also sort_buffer + record_buffer additional memory. This has me worried, but I haven't seen this behaviour on our site. We have innodb_buffer_pool = 1100Mb key_buffer = 400 Mb record_buffer = 10Mb sort_buffer = 20Mb max_connections = 220 which according to this formula gives me 1100 + 400 + (220 * (20 + 10)) + ( 220 * 1) = 8320Mb at max capacity. At roughly half capacity (96 connections) we're using only 1390Mb, so I'm finding it hard to believe it's going to scale that badly right now. We only have 4Gb memory on our linux-based database machine right now - should I be upgrading? ;-) Does anyone have any information that either supports or refutes the statement above? I'd be interested if you did Thanks, John John Kemp Director, Software Development Streetmail Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 1169: Can't write, because of unique constraint, to table '#sql3aa_a_1'
I have a bit more info. The only thing I could think of that could
create a constraint problem was that the two columns being grouped on
have some data in common.
ie., there could be two records like this:
src dst
=== ===
9.9.9.9 aaa
bbb 9.9.9.9
From my limited knowledge with SQL, that shouldn't cause a problem when
grouping by both columns should it?
To test it, I modified the query to be:
select concat(s,src) as Source, concat(d, dst) as Destination,
count(*) as Drops
from data
where (action in ('drop', 'reject'))
group by Source, Destination
;
And it worked, as now the above sample becomes:
Source Destination
=== ===
s9.9.9.9 daaa
sbbb d9.9.9.9
Is this a feature or a bug?
Thanks.
[EMAIL PROTECTED]
Darryl Luff wrote:
Can anyone please explain what the subject error means? Full details are
below. Have tried searching and not come up with anything.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
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: running sql commands from a shell
At 11:13 +1000 1/17/02, Mr Aaron Brandis wrote: Hi everyone This is the first time I have posted to this list and I was wondering if someone could answer my question. I know you can run commands from a shell prompt (such as unix...) like: shell mysql -e 'SELECT * FROM table' database for a simple select query and shell mysqlimport --local database table.txt to import information from a text file. I was just wondering how (and even if you can) set up a pager and write to a file from the shell. I can do it from the mysql command prompt like this: mysql pager cat /home/aaron/tube.txt; mysql select Run from tubes; This will put the result of the query into tubes.txt So does anyone know if i can do this from the shell prompt?? Writing to a file and paging the output are normally mutually exclusive activities. Why do you want to do this? If you just want to save the output in a file, you don't need to use a pager. Just do this: mysql -e 'select Run from tubes' database /home/aaron/tube.txt And if you want the usual boxed-table output (rather than tab-delimited, which is what you normally get when redirecting the output to a file), do this instead: mysql -t -e 'select Run from tubes' database /home/aaron/tube.txt Thanks alot for your help Aaron - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Palm - MySQL synching?
Howdy, Does anyone know of a good conduit and supporting Palm-side software that will allow me to cart a small database around in my Palm, and sync it with my MySQL server through ODBC? Surely someone must be doing this but I'm having a heck of a time finding the software for my Palm V. My desktop software is Windows 2000. MySQL is running on a different box (Linux). Thanks, Chris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Architecture Diagram of MySQL
Hai, Where can I find the Architecture Diagram of MySQL. Just like in Oracle do we have a diagram which explains how MySQL works behind screen. I am using MySQL 3.23.44(NT) and 3.23.40 (Linux)Version Thanks and Regards Aravind Aravind Gorthy, VisualSoft Technolgies, Hyderabad-India. _ 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
Re: [PHP] Mac OSX !?!?!?
Somebody suggested I post the source--good idea! So here it is... The
header.inc file, in its entirety:
html
head
titleSite :: Jupiter :: Europa/title
meta http-equiv=Content-Type content=text/html; charset=iso-8859-1
link rel=stylesheet href=../../common/styles.css type=text/css
?php
// DETERMINE THE LANGUAGE FROM THE PARENT DIRECTORY
// GENERATE VARIABLES FOR LANGUAGE, FILENAME AND NAME
$path = explode(/,$PHP_SELF);
if (!$lang) { $lang = $path[sizeof($path)-2]; }
$file = $path[sizeof($path)-1];
$prename = explode(.,$file);
$name = $prename[sizeof($prename)-2];
// SECURITY CHECK
session_start();
if (!$PHPSESSID) { die;
} elseif (!$auth) { die;
} elseif ($auth != $path[sizeof($path)-2]) { die; }
$language = All Languages;
if ($lang == en) { $language = English; }
if ($lang == fr) { $language = FranÁais; }
if ($lang == es) { $language = EspaÒol; }
if ($lang == de) { $language = Deutsch; }
if ($lang == it) { $language = Italiano; }
$priv = 2;
// CONNECT TO DATABASE
$db = mysql_connect(localhost,database,password);
mysql_select_db(database,$db);
// FETCH TABLE NAMES
$listtables = mysql_list_tables(database,$db);
// FETCH SELECTED TABLE DATA
$fields = mysql_list_fields(database, $table, $db);
$columns = mysql_num_fields($fields);
?
script language=JavaScript
!--
function GP_popupConfirmMsg(msg) { //v1.0
document.MM_returnValue = confirm(msg);
}
//--
/script
/head
body bgcolor=#FF text=#00 link=#00 vlink=#00
alink=#00 leftmargin=20 topmargin=20 marginwidth=0
marginheight=0 background=../../common/bg.gif
?php
if ($language) { echo span class=adminnormalgreya
href=../index.php4Europa/a/span; }
if ($table) { echo span class=adminnormalgrey : /spanspan
class=adminnormalgreya href=tables.php4Tables/a/span; }
?
pnbsp;
On Wednesday, January 16, 2002, at 06:01 PM, Richard Baskett wrote:
Kind of hard to say without source code for the session part..
Although the
MySQL warnings, I got those because MySQL does not automatically start
in
OSX, if you know it's started then Im not sure, but if not.. go here to
get
the autostart utility:
http://www.entropy.ch/software/macosx/mysql/
This link will have information and a link of where you can download the
utility.
Rick
The human mind is not capable of grasping the Universe. We are like a
little child entering a huge library. The walls are covered to the
ceilings
with books in many different tongues. The child knows that someone must
have
written these books. It does not know who or how. It does not
understand the
languages in which they are written. But the child notes a definite
plan in
the arrangement of the books---a mysterious order which it does not
comprehend, but only dimly suspects. - Albert Einstein
From: René Fournier [EMAIL PROTECTED]
Date: Wed, 16 Jan 2002 17:50:06 -0700
To: [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: [PHP] Mac OSX !?!?!?
Can someone PLEASE explain why I get the following error message under
OSX (PHP+MySQL), but not under Windows ME or Linux?
Warning: Cannot send session cache limiter - headers already sent
(output started at
/Users/rene/Sites/smartslitters/jupiter/europa/header.inc:6) in
/Users/rene/Sites/smartslitters/jupiter/europa/header.inc on line 19
Warning: Unable to save MySQL query result in
/Users/rene/Sites/smartslitters/jupiter/europa/header.inc on line 44
Warning: Supplied argument is not a valid MySQL result resource in
/Users/rene/Sites/smartslitters/jupiter/europa/header.inc on line 45
---
After these lines, the pages load fine. I'm using PHP Session ID
variables (or trying to)--they work fine as I said under other OSes,
but
now break under OSX.
...Rene
---
René Fournier
[EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: php-list-
[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 mysql-unsubscribe-
[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: [PHP] Mac OSX !?!?!?
Somebody suggested I post the source--good idea! So here it is... The
header.inc file, in its entirety:
html
head
titleSite :: Jupiter :: Europa/title
meta http-equiv=Content-Type content=text/html; charset=iso-8859-1
link rel=stylesheet href=../../common/styles.css type=text/css
?php
// DETERMINE THE LANGUAGE FROM THE PARENT DIRECTORY
// GENERATE VARIABLES FOR LANGUAGE, FILENAME AND NAME
$path = explode(/,$PHP_SELF);
if (!$lang) { $lang = $path[sizeof($path)-2]; }
$file = $path[sizeof($path)-1];
$prename = explode(.,$file);
$name = $prename[sizeof($prename)-2];
// SECURITY CHECK
session_start();
if (!$PHPSESSID) { die;
} elseif (!$auth) { die;
} elseif ($auth != $path[sizeof($path)-2]) { die; }
$language = All Languages;
if ($lang == en) { $language = English; }
if ($lang == fr) { $language = FranÁais; }
if ($lang == es) { $language = EspaÒol; }
if ($lang == de) { $language = Deutsch; }
if ($lang == it) { $language = Italiano; }
$priv = 2;
// CONNECT TO DATABASE
$db = mysql_connect(localhost,database,password);
mysql_select_db(database,$db);
// FETCH TABLE NAMES
$listtables = mysql_list_tables(database,$db);
// FETCH SELECTED TABLE DATA
$fields = mysql_list_fields(database, $table, $db);
$columns = mysql_num_fields($fields);
?
script language=JavaScript
!--
function GP_popupConfirmMsg(msg) { //v1.0
document.MM_returnValue = confirm(msg);
}
//--
/script
/head
body bgcolor=#FF text=#00 link=#00 vlink=#00
alink=#00 leftmargin=20 topmargin=20 marginwidth=0
marginheight=0 background=../../common/bg.gif
?php
if ($language) { echo span class=adminnormalgreya
href=../index.php4Europa/a/span; }
if ($table) { echo span class=adminnormalgrey : /spanspan
class=adminnormalgreya href=tables.php4Tables/a/span; }
?
pnbsp;
On Wednesday, January 16, 2002, at 06:01 PM, Richard Baskett wrote:
Kind of hard to say without source code for the session part..
Although the
MySQL warnings, I got those because MySQL does not automatically start
in
OSX, if you know it's started then Im not sure, but if not.. go here to
get
the autostart utility:
http://www.entropy.ch/software/macosx/mysql/
This link will have information and a link of where you can download the
utility.
Rick
The human mind is not capable of grasping the Universe. We are like a
little child entering a huge library. The walls are covered to the
ceilings
with books in many different tongues. The child knows that someone must
have
written these books. It does not know who or how. It does not
understand the
languages in which they are written. But the child notes a definite
plan in
the arrangement of the books---a mysterious order which it does not
comprehend, but only dimly suspects. - Albert Einstein
From: René Fournier [EMAIL PROTECTED]
Date: Wed, 16 Jan 2002 17:50:06 -0700
To: [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: [PHP] Mac OSX !?!?!?
Can someone PLEASE explain why I get the following error message under
OSX (PHP+MySQL), but not under Windows ME or Linux?
Warning: Cannot send session cache limiter - headers already sent
(output started at
/Users/rene/Sites/smartslitters/jupiter/europa/header.inc:6) in
/Users/rene/Sites/smartslitters/jupiter/europa/header.inc on line 19
Warning: Unable to save MySQL query result in
/Users/rene/Sites/smartslitters/jupiter/europa/header.inc on line 44
Warning: Supplied argument is not a valid MySQL result resource in
/Users/rene/Sites/smartslitters/jupiter/europa/header.inc on line 45
---
After these lines, the pages load fine. I'm using PHP Session ID
variables (or trying to)--they work fine as I said under other OSes,
but
now break under OSX.
...Rene
---
René Fournier
[EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: php-list-
[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 mysql-unsubscribe-
[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: [PHP] Mac OSX !?!?!?
try calling session_start() as the very first thing in your php script.
- Original Message -
From: René Fournier [EMAIL PROTECTED]
To: PHP General [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, January 16, 2002 7:41 PM
Subject: Re: [PHP] Mac OSX !?!?!?
Somebody suggested I post the source--good idea! So here it is... The
header.inc file, in its entirety:
html
head
titleSite :: Jupiter :: Europa/title
meta http-equiv=Content-Type content=text/html; charset=iso-8859-1
link rel=stylesheet href=../../common/styles.css type=text/css
?php
// DETERMINE THE LANGUAGE FROM THE PARENT DIRECTORY
// GENERATE VARIABLES FOR LANGUAGE, FILENAME AND NAME
$path = explode(/,$PHP_SELF);
if (!$lang) { $lang = $path[sizeof($path)-2]; }
$file = $path[sizeof($path)-1];
$prename = explode(.,$file);
$name = $prename[sizeof($prename)-2];
// SECURITY CHECK
session_start();
if (!$PHPSESSID) { die;
} elseif (!$auth) { die;
} elseif ($auth != $path[sizeof($path)-2]) { die; }
$language = All Languages;
if ($lang == en) { $language = English; }
if ($lang == fr) { $language = FranÁais; }
if ($lang == es) { $language = EspaÒol; }
if ($lang == de) { $language = Deutsch; }
if ($lang == it) { $language = Italiano; }
$priv = 2;
// CONNECT TO DATABASE
$db = mysql_connect(localhost,database,password);
mysql_select_db(database,$db);
// FETCH TABLE NAMES
$listtables = mysql_list_tables(database,$db);
// FETCH SELECTED TABLE DATA
$fields = mysql_list_fields(database, $table, $db);
$columns = mysql_num_fields($fields);
?
script language=JavaScript
!--
function GP_popupConfirmMsg(msg) { //v1.0
document.MM_returnValue = confirm(msg);
}
//--
/script
/head
body bgcolor=#FF text=#00 link=#00 vlink=#00
alink=#00 leftmargin=20 topmargin=20 marginwidth=0
marginheight=0 background=../../common/bg.gif
?php
if ($language) { echo span class=adminnormalgreya
href=../index.php4Europa/a/span; }
if ($table) { echo span class=adminnormalgrey : /spanspan
class=adminnormalgreya href=tables.php4Tables/a/span; }
?
pnbsp;
On Wednesday, January 16, 2002, at 06:01 PM, Richard Baskett wrote:
Kind of hard to say without source code for the session part..
Although the
MySQL warnings, I got those because MySQL does not automatically start
in
OSX, if you know it's started then Im not sure, but if not.. go here to
get
the autostart utility:
http://www.entropy.ch/software/macosx/mysql/
This link will have information and a link of where you can download the
utility.
Rick
The human mind is not capable of grasping the Universe. We are like a
little child entering a huge library. The walls are covered to the
ceilings
with books in many different tongues. The child knows that someone must
have
written these books. It does not know who or how. It does not
understand the
languages in which they are written. But the child notes a definite
plan in
the arrangement of the books---a mysterious order which it does not
comprehend, but only dimly suspects. - Albert Einstein
From: René Fournier [EMAIL PROTECTED]
Date: Wed, 16 Jan 2002 17:50:06 -0700
To: [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: [PHP] Mac OSX !?!?!?
Can someone PLEASE explain why I get the following error message under
OSX (PHP+MySQL), but not under Windows ME or Linux?
Warning: Cannot send session cache limiter - headers already sent
(output started at
/Users/rene/Sites/smartslitters/jupiter/europa/header.inc:6) in
/Users/rene/Sites/smartslitters/jupiter/europa/header.inc on line 19
Warning: Unable to save MySQL query result in
/Users/rene/Sites/smartslitters/jupiter/europa/header.inc on line 44
Warning: Supplied argument is not a valid MySQL result resource in
/Users/rene/Sites/smartslitters/jupiter/europa/header.inc on line 45
---
After these lines, the pages load fine. I'm using PHP Session ID
variables (or trying to)--they work fine as I said under other OSes,
but
now break under OSX.
...Rene
---
René Fournier
[EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: php-list-
[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 mysql-unsubscribe-
[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
JDBC and MySQL problem, please help.
Hi All, I just installed resin-cmp-1.0.5 with Apache1.3.22 and mysql3.23.47. I used m.mmysql.2.0.8 JDBC driver with the following config segment in my resin.conf: resource-ref res-ref-namejdbc/test/res-ref-name res-typejavax.sql.XADataSource/res-type init-param driver-name=org.gjt.mm.mysql.Driver/ init-param url=jdbc:mysql://localhost:3306/test_tx/ init-param user=USER/ init-param password=PASSWORD/ init-param relaxAutocommit=false/ /resource-ref The initialization servlet did create and populate tables into a 'test_tx' db which I created with 'INNODB' type. When I run the 'Single Table' servlet example, the page showed the data of two field of two rows under the same column swapped properly. However, when I check on the data in the table. The data never got swapped at all. That's it, I receive no exception during the process but no swapping effect on that two piece of data in the table. Would someone kindly show me what's I did wrong or what I have missed?? Many thanks. Cheers, Michael - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL with TOMCAT and JSP giving problems..
Hai, I am using MySQL with TOMCAT and JSP for development purpose. 1. Every morning without restarting the tomcat server, i am unable to connect the MySql Database. What might be the problem.. I did't get this type of problem in Oracle SQL server. 2. While Running Tomcat Server , I Loose Database Connection To get Connection from database server, i am restarting tomcat server each time, Is MySQL Behaves same with all Servers ?] Does any one in the list face this type of Problem. Thanks in advance Aravind Gorthy, VisualSoft Technolgies, Hyderabad-India. _ 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: Architecture Diagram of MySQL
On Thu, Jan 17, 2002 at 10:37:22AM +0530, aravind gorthy wrote: Hai, Where can I find the Architecture Diagram of MySQL. Just like in Oracle do we have a diagram which explains how MySQL works behind screen. I am using MySQL 3.23.44(NT) and 3.23.40 (Linux)Version I've never seen one for Oracle, so I'm not sure what you'd expect to see in one. Can you give us some ideas, or maybe point to on-line? I've been planning to do something that you might be able to call an architecture diagram (of sorts), but haven't really started yet. 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.41-max: up 14 days, processed 334,555,943 queries (269/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
