SV: most viewed
Hiya Tyler As everyone else has suggested, I do too. Read the MySQL-manual. Not from the start to the end, but the parts that you need. I'd look up the syntax for SELECT and then find out what is possible to do with it. I'll also recommend you an article about MySQL/PHP which was the one getting me started (And I'm making a living of it actually!) : http://hotwired.lycos.com/webmonkey/programming/php/tutorials/tutorial4.html A book worth reading would be : "MySQL" by Paul DuBois, which covers almost every aspect of the MySQL-DB ... Yours sincerly Jacob "Techek" Kamp Hansen - webmonkey at Portaltjenesten A/S (dk) -Oprindelig meddelelse- Fra: Tyler Longren [mailto:[EMAIL PROTECTED]] Sendt: 1. april 2001 23:23 Til: MySQL List Emne: most viewed I've got a table that contains a list of bands. There's a field named views. This field contains how many times each band's page has been viewed. Ex: id artist views 1 No names6 2 WISH10 3 Deftones45 What's the SQL to select the top 2 most viewed bands(which would be WISH Deftones)? I've tried a few things, but haven't gotten anything to work correctly for me. Thanks. Tyler Longren - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Starting Mysql with system
How can i put mysql to start with my system, im worcking with RedHat Linux RTFM: go to your sourcedir, cd Docs and read manual.txt.. or one of the other manuals.. like the one at www.mysql.com Bye, B. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
can't get MySQL 3.23.37
Hi, I can't find MySQL 3.23.37. Please tellme where I can dl it. Where is the really latest release? regards, -ilham- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Betr.: can't get MySQL 3.23.37
Hay Iham, Should be there on www.mysql.com Best regards, Maarten Verheijen MvG, Maarten Verheijen T/EXP kamernummer C558 Telefoonummer 4559 Mohamad Ilhami [EMAIL PROTECTED] 02-04-01 09:35 Hi, I can't find MySQL 3.23.37. Please tellme where I can dl it. Where is the really latest release? regards, -ilham- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
update - select query
i need to update a row of a table taking the values of a "select ... from table1, table2 where table1.row=table2.row group by row" query. say: desc source_table; key int(10) FK column_source timestamp desc table_to_update; key int(10) column_to_update datetime i want the result of: select s.key1,max(s.column_source) from source_table s, column_to_update c where s.key=c.key group by key; to be the values in a query something like (please ignore the syntax ... just trying to explain what i need to do): update table_to_update set table_to_update.column_to_update=source_table.column_source where table_to_update.key=source_table.key a ... im not good in explaining ... hope u get what i wanted to say. tnxs in advance. __ www.edsamail.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 dies
Hi, When trying to run mysql I get the message 'found old style password for user 'graham' . Restart using --old-protocol' How can I cure this problem please? I tried running mysql --old-protocol without success. Many thanks, Graham
getpwnam: Bad file number
Hi all, I am trying to install MySQL on Solaris 8 on Intel Architecture. Everything goes ok, until I try to execute command: safe_mysqld --user=mysql nothing happens and in the file /usr/local/var/host_name.err there is such a statement: 010402 10:24:16 getpwnam: Bad file number 010402 10:24:16 Aborting I am newbie, so any suggestions will be appreciated. Marbie - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 mysqld as another user
I have set up a user called mysqlusr which belongs to the group mysqlgrp. I want to run the mysqld as this user, but am unsure how to. Info on this can be found in the manual.txt file found in your_sourcedir/Docs Bye, B. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How do I
Just try "mysqladmin --user root --password flush-tables" before. regards Uwe - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Replication question
Hi there, My situation is like this: I have a local server behind a firewall. On the outside I have a webserver. I want the local server to act like a master for replications, and the external server to act like a slave. This way I can make the changes on my database directly on the local server. But the problem is that I can't connect to the local server from the external server because of the firewall. Is there a way where I can have the external server acting as a slave, but where the master a doing the connection stuff? in other words : The local server can do a connection to the external server, but the external server can't open a connection to the local server. Please help me out! -- Jakob Vad Nielsen System Developer NHST/TDN/EUROPOWER - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
User table problem
Hi, I have a problem with mysql users. I can`t connect to database with any user when I use password. Eg, if from the command line I try to connect like mysql -h myhost -u myuser -p and then on the password line write my password, it gives permission denied... If I try to go in just without password, I can get in, but this I don`t have lots of permissions. The problem exists in all users, including root. The passwords have been set, that`s for sure and it even used to workany ideas what might be wrong? Thanks Siim Einfeldt - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
New user for MySql
Hi friends... Iam a new user for MySql, please I want to ask the folloing: First, My OS is WINNT4 Server. the name of the server is SERVER1. I have installed mysql-3.32.32-win, and installed also myodbc-2.50.3, as zip files then run the setup as recommended. Okey, now, I have installed it on D:\MySql coz my WINNT4 is installed on this drive, amI in need to install it as recommended the default path on c, or I can freely install it on D? will there be any changes for that if I install it on D while working with mysql ? Second, I wonder about the steps for installing, what shall I type ? mysqld --install? if yes, then I face a problem after typing D:\mysql\bin\mysql, a msg comes up saying : cant connect to host SERVER1? so where will be the problem ? no mysql shell comes and I can't work with mysql... Is there any other things should be done for working properly with mysql ? I noticed the winAdminSql, that sign that comes in the bar looks like the light traffic, is there must something to be done there or not to play with it ??? I need help please as soon as possibile ( actually limited time ) Thanx Friends in Advance Hanan Khader _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Win 2000 apache module
Can someone tell me where / how to get the Windows 2000 equivalent of the mod_auth_mysql.so in Linux. Thanks Nick - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: mysqldump hangs
FYI, I tested MySQL 3.23.36 with the same setup as below. I got identical results. -Original Message- From: Ide, Jim Sent: Saturday, March 31, 2001 4:59 PM To: '[EMAIL PROTECTED]' Subject: mysqldump hangs OpenBSD 2.8 swap partition is 256mb /tmp partition is 1gb Pentium III 667mhz, 256mb ram MySQL 3.22.32 (installed by: pkg_add mysql-3.22.32.tgz) df reports that I have plenty of free disk space I have a table that has 422,000 rows, and has a key field defined as: integer unsigned not null auto_increment primary key. I loaded the data into the table from a MS Access 97 database using MyODBC. mysqld was started with: safe_mysqld --user=mysql If I type: cd /path/to/MyDB mysqldump --opt MyDB MyTable MyTable.backup ls -l MyTable* mysqldump will start dumping MyTable, and MyTable.backup grows in size. After about a minute, MyTable.backup stops growing in size (according to ls -l). 'top' shows that mysqld has over 99% of cpu. Note that this box is a dedicated db server, and no other major processes are running. Nothing changes after 10, 20, 30 minutes. After killing mysqldump, mysqld is still at 99% cpu. I then kill -9 mysqld, and cpu % goes to zero. I have similar behavior when I try to create an index on this table. For example, if I type mysql create index MyIndex on MyTable ( MyField ); 'top' shows that mysqld is at 99% cpu, and the index is still not done being built after 30 minutes (the identical data is on a linux box, and the index takes 3 minutes to build. Any ideas? Many thanks - Jim - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Need examples of companies using mysql
HAHA! You'll be a good example, since I'm pretty sure you buy data from us... hehe. FT Interactive Data We use MySQL quite a lot and even manage to generate money once in a while... Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 -- ___ __ ____ _ _ _ _ / __)( )( ) /__\( \/ )( ___) ( \( )( ___)(_ _) \__ \ )(__)( /(__)\\ / )__)) ( )__) )( (___/(__)(__)(__)\/ ()()(_)\_)() (__) Corruption. The most infallible symptom of liberty - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Need examples of companies using mysql
Unless you're going to have a LOT of users accessing a HUGE database, the system you've outlined below will be overkill (do you have any current usage statistics ? Are you using the system (is it an E450 ?) for any other applications/processes ?). It would be, if it was dedicated to mysql :) One of their concerns is load testing, which we haven't done a lot of yet. I'm confident it'll hold up, I am a little worried it may generate enough load to annoy them, but worse comes to worse we can set up a dedicated box. -- ___ __ ____ _ _ _ _ / __)( )( ) /__\( \/ )( ___) ( \( )( ___)(_ _) \__ \ )(__)( /(__)\\ / )__)) ( )__) )( (___/(__)(__)(__)\/ ()()(_)\_)() (__) I/O, I/O, it's off to work we go... - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Performance question
Hi, I've got a question 'bout the number of number of writes a MySQLserver can handle in a second. I've written a program which contains the following code: typedef struct { MYSQL * connection; char * database; } con; int resolvequery(char * vraag, MYSQL_RES toReturn, int affected, int control) { MYSQL_RES * result; MYSQL_ROW row; int state,counter; char * query; char * db; MYSQL * connect; int * temporal; connect = standardcon.connection; db = standardcon.database; state = mysql_real_query(connect, vraag, 1024); if (state != 0) { printf(mysql_error(connect)); return 1; } if((strncmp(vraag,"SEL",3)==0)||(strncmp(vraag,"SHO",3)==0) ||(strncmp(vraag,"DES",3)==0)) { result = mysql_store_result(connect); affected = mysql_num_rows(result); toReturn = *result; } else affected = 0; return 0; } And when I call this procedure 50 times/second (from one client) or 100 times/second (two clients at the same time) it stores all the data without generating an error, but immediatly when I start a third client it crashes with the usual segmentation fault. In case you need it, the calls are made from this function: CORBA::Short i_DBM_impl::storeData(const DINA::t_Table table, const char * e) throw(CORBA::SystemException) { int state; char * mission; MYSQL_RES temp; mission = (char *) malloc(256 * sizeof(char)); sprintf(mission, "INSERT DELAYED INTO %s VALUES ('%s',CURRENT_TIMESTAMP())", (char *) table.name, e); cout mission endl; if (resolvequery(mission,temp,state,0)==0) return 1; else return 0; } So is it possible that some buffer is full or something when more than 100 inserts in second are requested?? What can I do to adjust the performance or did I make other mistakes?? I'm using mysql Ver 9.38 Distrib 3.22.32, for pc-linux-gnu (i586) on Debian Linux machine. Please can you also mail to me ([EMAIL PROTECTED]) and not only directly to the list (I'm receiving the index-version and else I've to wait too long :-) Greetings, Raf _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL 3.23.36 is relased
Everyone: why did the volume of the source distribution jump from something like 5+ MB to 10+ MB ? This is not likely from a bugfix. Am I downloading lots of new stuff I will probably not use? http://www.mysql.com/downloads/mysql-3.23.html says: MySQL 3.23.34a and newer source releases include the full source for Berkeley DB and Innobase tables; By using these table handler you can use transactions in MySQL. That might explain something. Dunno if you're going to use it.. perhaps sometime.. somewhere.. Bye, B. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Can't recover a bad corrupeted table...
'date' is a reserved word. Try renaming your date column, and see if the problem remains. Antonio Gulli wrote: Hello Bob, first at all thank you for your support. Bob Hall wrote: Let me see if I understand you correctly. You created a new table (CREATE TABLE?) and you imported data from a file that had nothing to do with MySQL (comma or tab delimited file?), and therefore couldn't be affected by whatever crashed your server. And this brand new table with pristine data was corrupted? Yep this is whats happen. I first i got a corrupted table, i tried to repair the table following all known strategies... then i create a table from scratch and use a perl program for importing data, but at the end i got a corrupted table and no way to rapair it. This is the schema: 1) use queries drop table keywords; create table keywords (querystring varchar(255), numref int(11), multiword smallin t(6), date date, origine varchar(16)); create FULLTEXT INDEX qfindex ON keywords(querystring); create INDEX qindex ON keywords(querystring); create INDEX orindex ON keywords(origine); 2) Importing data with perl program 3) Corrupted table I have limited experience maintaining MySQL databases on Linux, and I have very limited knowledge of the internal workings of MySQL. The only thing that I know of that you haven't mentioned trying is recreating the table description file from backup. However, if CREATE TABLE statements are creating corrupted tables, then I believe that the server itself is corrupted. If I were in your shoes, I would reinstall, after backing up everything short of the refrigerator. Perhaps someone else can give you better advice. The strange thing is that this is a production server used by a lot of programs and they works. Now i'm tring to use ISAM (instead of MYISAM) table with such schema: use queries drop table keywords; create table keywords (querystring varchar(255) NOT NULL, numref int(11), multiwor d smallint(6), date date, origine varchar(16) NOT NULL) TYPE = ISAM; create INDEX qindex ON keywords(querystring); create INDEX orindex ON keywords(origine); I don't know if this work at the moment it is importing... Notice a strange thing, ISAM ask for not null definition of indexed fields, MYISAM not .. why ? Bob Hall I tried -r I tried -o I tried to truncate the table and re-build the index from scratch. I tried to create ex-novo a table, import data from scratch and it result in a corrupted table. None of these seems to work Bob Hall wrote: Sir, I looked quickly through the mass of data supplied below, and it looks like you only tried m with the -r -q option combination. Try it with just -r. If that doesn't work, try it with -o. If that doesn't work, restore from backup. Got backup? Bob Hall Antonio gulli wrote: Any help is appreciated Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 158 to server version: 3.23.36-log myisamchk -V myisamchk Ver 1.45 for pc-linux-gnu at i686 a) Trying a recovery. myisamchk -r -q -Osort_key_blocks=16 keywords - check key delete-chain - check record delete-chain - recovering (with keycache) MyISAM-table 'keywords.MYI' Data records: 2062985 7000 [root@ideare queries]# myisamchk -r -q -Osort_key_blocks=16 -Okey_buffer_size=256M -Oread_buffer_size=256M -Osort_buffer_size=256M keywords - check key delete-chain - check record delete-chain - recovering (with keycache) MyISAM-table 'keywords.MYI' Data records: 2062985 - - check key delete-chain - check record delete-chain - recovering (with keycache) MyISAM-table 'keywords.MYI' Data records: 2062985 b) Trying a check Database changed mysql CHECK TABLE keywords; +--+---+--+--- -+| Table| Op| Msg_type | Msg_text |+--+---+--+-- --+| keywords | check | error| Key in wrong position at page 24942592 || queries.keywords | check | error| Corrupt |+--+---+--+-- --+2 rows in set (10.12 sec) yisamchk -a -Osort_key_blocks=16 -Okey_buffer_size=256M -Oread_buffer_size=256M -Osort_buffer_size=256M keywords \Checking MyISAM file: keywords Data records: 2062985 Deleted blocks: 0 myisamchk: warning: Table is marked as crashed - check file-size - check key delete-chain - check record delete-chain - check index reference - check data record references index: 1 - check data record references index: 2 - check data record references index: 3 myisamchk: error: Key in wrong position at page
Re: how to copy the mysql bin and data dir to another machine and make it work without the lib files?..
jagadeesh wrote: Get a good beginners book for your operating system and read it. One clue might be 'tar'. Anothe clue might be 'tape drive'. Perhaps 'NFS' is a clue. I just don't know, because I have no 'clue' as to what you are running, or what the other machine is running. hi i have installed mysql binary distribution and the perl modules DBI,mysql modules on one machine and want to copy the data and the bin directory , to onother machine and make it work in that machine ,without copying the lib directory , is it possible if yes , how do i do it .. thanks very eagerly waiting for a clue bye jagadeesh _ Chat with your friends as soon as they come online. Get Rediff Bol at http://bol.rediff.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: SELECT ... FOR UPDATE
From the manual: If you are using FOR UPDATE on a table handler with page/row locks, the examined rows will be write locked. I agree that this does not tell me much. When are the rows unlocked? -- Richard Ellerbrock [EMAIL PROTECTED] Andrew Gould [EMAIL PROTECTED] 2001/04/02 03:56:33 I am, at this moment, installing MySQL version 3.23.36. I noted that the "SELECT...FOR UPDATE" feature has been added. What does this do and how is it used? The online manual simply mentions that it exists; but doesn't explain what it is or how to use it. Thanks, Andrew Gould __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/?.refer=text - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Database instance
I am planning for a migration from MS-SQL MY-SQL. Does Mysql support database instance? How can I configure Mysql to support transaction rollback ? Regards Peter Li This message was sent through MyMail http://www.mymail.com.au - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Is updating a subsection of a field possible?
Sir, use the Replace function. Regex isn't necessary. I've got a table with 500+ records in it now... and I need to update just a small section of one of the fields (an URL) to change a parameter on it... I know I'm probably going to be told "NO", but I thought I'd ask before I go start writing a program to do this Is it possible to update just a small subsection of a field automagically via SQL and the mysql query language extensions? I'd need some sort of regex intervention, such that the text that surrounds the text I need to change isnt affected - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Know thyself? Absurd direction! Bubbles bear no introspection. -Khushhal Khan Khatak - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Can't recover a bad corrupeted table...
Hello Bob, first at all thank you for your support. Bob Hall wrote: Let me see if I understand you correctly. You created a new table (CREATE TABLE?) and you imported data from a file that had nothing to do with MySQL (comma or tab delimited file?), and therefore couldn't be affected by whatever crashed your server. And this brand new table with pristine data was corrupted? Yep this is whats happen. I first i got a corrupted table, i tried to repair the table following all known strategies... then i create a table from scratch and use a perl program for importing data, but at the end i got a corrupted table and no way to rapair it. This is the schema: 1) use queries drop table keywords; create table keywords (querystring varchar(255), numref int(11), multiword smallin t(6), date date, origine varchar(16)); The use of a reserved word as a column name probably is the reason that your table is corrupted as soon as it is created. Since your server is working normally, and this particular table and only this particular table was corrupted ab ovo, then the problem seems to be specific to the table. In general, use of a reserved word as a column name is definitely a problem. create FULLTEXT INDEX qfindex ON keywords(querystring); create INDEX qindex ON keywords(querystring); create INDEX orindex ON keywords(origine); 2) Importing data with perl program 3) Corrupted table I have limited experience maintaining MySQL databases on Linux, and I have very limited knowledge of the internal workings of MySQL. The only thing that I know of that you haven't mentioned trying is recreating the table description file from backup. However, if CREATE TABLE statements are creating corrupted tables, then I believe that the server itself is corrupted. If I were in your shoes, I would reinstall, after backing up everything short of the refrigerator. Perhaps someone else can give you better advice. The strange thing is that this is a production server used by a lot of programs and they works. Now i'm tring to use ISAM (instead of MYISAM) table with such schema: use queries drop table keywords; create table keywords (querystring varchar(255) NOT NULL, numref int(11), multiwor d smallint(6), date date, origine varchar(16) NOT NULL) TYPE = ISAM; create INDEX qindex ON keywords(querystring); create INDEX orindex ON keywords(origine); I don't know if this work at the moment it is importing... Notice a strange thing, ISAM ask for not null definition of indexed fields, MYISAM not .. why ? Bob Hall I tried -r I tried -o I tried to truncate the table and re-build the index from scratch. I tried to create ex-novo a table, import data from scratch and it result in a corrupted table. None of these seems to work Bob Hall wrote: Sir, I looked quickly through the mass of data supplied below, and it looks like you only tried m with the -r -q option combination. Try it with just -r. If that doesn't work, try it with -o. If that doesn't work, restore from backup. Got backup? Bob Hall Antonio gulli wrote: Any help is appreciated Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 158 to server version: 3.23.36-log myisamchk -V myisamchk Ver 1.45 for pc-linux-gnu at i686 a) Trying a recovery. myisamchk -r -q -Osort_key_blocks=16 keywords - check key delete-chain - check record delete-chain - recovering (with keycache) MyISAM-table 'keywords.MYI' Data records: 2062985 7000 [root@ideare queries]# myisamchk -r -q -Osort_key_blocks=16 -Okey_buffer_size=256M -Oread_buffer_size=256M -Osort_buffer_size=256M keywords - check key delete-chain - check record delete-chain - recovering (with keycache) MyISAM-table 'keywords.MYI' Data records: 2062985 - - check key delete-chain - check record delete-chain - recovering (with keycache) MyISAM-table 'keywords.MYI' Data records: 2062985 b) Trying a check Database changed mysql CHECK TABLE keywords; +--+---+--+--- -+| Table| Op| Msg_type | Msg_text |+--+---+--+-- --+| keywords | check | error| Key in wrong position at page 24942592 || queries.keywords | check | error| Corrupt |+--+---+--+-- --+2 rows in set (10.12 sec) yisamchk -a -Osort_key_blocks=16 -Okey_buffer_size=256M -Oread_buffer_size=256M -Osort_buffer_size=256M keywords \Checking MyISAM file: keywords Data records: 2062985 Deleted blocks: 0 myisamchk: warning: Table is marked as crashed - check file-size - check key delete-chain - check record delete-chain - check index reference - check data record references index: 1 - check data record
Re: possible deady
Kurt Washington wrote: I am curious if any knows of possible deadlock conditions that can ocurr when using the lock tables command in MySQL when you are referenceing multiple tables? _ Get your FREE download of MSN Explorer at http://explorer.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Since you can not read or write any files you did not obtain a lock for, what deadlock could you envision? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Termcap not found in install...
It would be nice to know what you are running. If Linux, the termcap files should be on your install CD. Package name and installation methods vary with supplier and version. Pedro Fonseca wrote: Hi everybody... I'm pretty much trying to install MySQL by compiling the sources (I like to avoid RMPs as much as I can), but I'm getting an error at configure time. This is what I do: # ./configure --prefix=/usr/local/mysql --with-mysqld-user=mysql There is some output and then it stops at the following line: checking for termcap functions library... configure: error: No curses/termcap library found Obviously the termcap functions library is missing in my system, but I've got no clue as to what it is, what it does and where to find it... Can anyone help? Best regards. __ Pedro Fonseca ([EMAIL PROTECTED]) Mob.: (+351)964598357 http://www.pedrofonseca.com ADETTI/ISCTE (Instituto Superior de Cincias do Trabalho e da Empresa) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Innobase on WinNt.
In the last episode (Apr 02), Leonard Coonan said: I am trying to install Mysql (3.23.36) on windows NT. I have installed the software, but cannot find how to use the Innobase table structure. Can someone please point me in the right direction (apart from installing it on something else). I have tried putting in the setting from the 8.7.2 INNOBASE startup options chapter in the manual, exchanging the linux paths for windows paths, but the service dies unexpectedly whenever I try to start it. Any errors in the mysql log or error files? -- Dan Nelson [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: can't get MySQL 3.23.37
Hi. On Mon, Apr 02, 2001 at 03:35:43PM +0700, [EMAIL PROTECTED] wrote: Hi, I can't find MySQL 3.23.37. Please tellme where I can dl it. Where is the really latest release? According to http://www.mysql.com/downloads/mysql-3.23.html the latest release is 3.23.36. I assume you have read about 3.23.37 in the Changes History section of the manual. There is written: -- Note that we tend to update the manual at the same time we make changes to MySQL. If you find a version listed below that you can't find on the MySQL download page, this means that the version has not yet been released! -- Bye, Benjamin. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL 3.23.36 is relased
Hi. From the download page http://www.mysql.com/downloads/mysql-3.23.html: -- MySQL 3.23.34a and newer source releases include the full source for Berkeley DB and Innobase tables; By using these table handler you can use transactions in MySQL -- Bye, Benjamin. On Mon, Apr 02, 2001 at 02:32:38PM +0200, [EMAIL PROTECTED] wrote: On Tue, 27 Mar 2001, Michael Widenius wrote: This release should fix the final bugs we accidently got into 3.23.34 and a long security bug that has been in MySQL a long time! Thanks, Monty! Everyone: why did the volume of the source distribution jump from something like 5+ MB to 10+ MB ? This is not likely from a bugfix. Am I downloading lots of new stuff I will probably not use? Regards, Thomas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Mirroring/Failover for MySQL (Was Need examples of companies using mysql)
Hi Steve, To achieve mirroring, MySQL can be run in a master/slave replication ring with two servers (look up replication in the manual). That way you can split reads and writes over both servers and get better read performance, and also more resilience. The way to achieve transparent failover is to have a load-balancer such as LVS (http://www.linuxvirtualserver.org). You can have two (again for failover) 1U rackmounts running LVS - the hardware can be something as low as 486 class. The LVS takes connections and redirects them to each of the MySQL servers in round-robin fashion. If one of the MySQL servers dies, it will be taken out of the pool until it is back up again. The way replication works in MySQL, if one of the servers dies, the other server will keep a binary log which is used to catch the downed server up when it comes back online. The only drawback with dual-master configuration is that unique IDs cannot be guaranteed if generated from the database - for instance, if an INSERT is processed at the same time by both masters. Therefore, unique IDs must be generated in the client with the use of mutexes. Regards, Jason Saunders -- Choose a Free Mobile or Free Line Rental, and get Free Connection with Free Calls, Free Smartbox, International Roaming, No Minimum Contract! For information and to order click over to http://www.iwantafreemobile.co.uk - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Innobase on WinNt.
Leonard Coonan writes: I am trying to install Mysql (3.23.36) on windows NT. I have installed the software, but cannot find how to use the Innobase table structure. Can someone please point me in the right direction (apart from installing it on something else). I have tried putting in the setting from the 8.7.2 INNOBASE startup options chapter in the manual, exchanging the linux paths for windows paths, but the service dies unexpectedly whenever I try to start it. thanks in advance len. Building MySQL with Innobase on Win32 is in the works. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: possible deady(dead lock)
here is an example in perl my $sthLock = $dbh-prepare("LOCK TABLES table1 WRITE, table2 WRITE") could there ever be a possibility of a race condition or dead lock where you have two threads that access the code almost at the same time One gets a lock on table one and another gets a lock on table 2. Then they result in deadlock trying to get a lock on the other table. could this ever happen using the lock tables command in MySQL? From: Gerald Clark [EMAIL PROTECTED] To: Kurt Washington [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: possible deady Date: Mon, 02 Apr 2001 09:28:25 -0500 Kurt Washington wrote: I am curious if any knows of possible deadlock conditions that can occur when using the lock tables command in MySQL when you are referencing multiple tables? _ Get your FREE download of MSN Explorer at http://explorer.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Since you can not read or write any files you did not obtain a lock for, what deadlock could you envision? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Get your FREE download of MSN Explorer at http://explorer.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: possible deady(dead lock)
The manual chapter 7.32 declares it to be deadlock free. Did you read the manual? Kurt Washington wrote: here is an example in perl my $sthLock = $dbh-prepare("LOCK TABLES table1 WRITE, table2 WRITE") could there ever be a possibility of a race condition or dead lock where you have two threads that access the code almost at the same time One gets a lock on table one and another gets a lock on table 2. Then they result in deadlock trying to get a lock on the other table. could this ever happen using the lock tables command in MySQL? From: Gerald Clark [EMAIL PROTECTED] To: Kurt Washington [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: possible deady Date: Mon, 02 Apr 2001 09:28:25 -0500 Kurt Washington wrote: I am curious if any knows of possible deadlock conditions that can occur when using the lock tables command in MySQL when you are referencing multiple tables? _ Get your FREE download of MSN Explorer at http://explorer.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Since you can not read or write any files you did not obtain a lock for, what deadlock could you envision? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Get your FREE download of MSN Explorer at http://explorer.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: email only two columns
"PM" == Prasad Mhatre [EMAIL PROTECTED] writes: PM Is it possible to mail only three columns from a database ? Third column PM being email ID? PM I need to send email to all with a valid email ID in a database. MySQL doesn't send email. Perhaps you need to write a program that queries the database and then sends the mail you want. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Lock objects
I want to work with an object that provides numbers, like sequence in Oracle database. Is there anything similar ? Of course, the object should be locked every time a specific user wants to get the next value. ( again, like sequence in oracle ). Thanks a lot. Einav. Einav Lavi-Pdut software engineer [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
problem with LOAD TABLE command
why do i get: mysql load table aca from master; ERROR 1189: Net error reading from master the error log shows: 010402 11:37:10 create_table_from_dump::failed in handler::net_read_dump() 010402 11:37:10 fetch_nx_table: failed on create table status shows: mysql status -- mysql Ver 11.12 Distrib 3.23.33, for pc-linux-gnu (i686) Connection id: 5 Current database: esp Current user: jcz@localhost Current pager: stdout Using outfile: '' Server version: 3.23.33-log Protocol version: 10 Connection: Localhost via UNIX socket Client characterset:latin1 Server characterset:latin1 UNIX socket:/var/run/mysqld/mysqld.sock Uptime: 2 hours 4 min 40 sec Threads: 1 Questions: 20 Slow queries: 0 Opens: 12 Flush tables: 1 Open tables: 1 Queries per second avg: 0.003 -- status on the master: mysql status; -- mysql Ver 11.12 Distrib 3.23.33, for pc-linux-gnu (i686) Connection id: 34 Current database: Current user: jcz@localhost Current pager: stdout Using outfile: '' Server version: 3.23.33-log Protocol version: 10 Connection: Localhost via UNIX socket Client characterset:latin1 Server characterset:latin1 UNIX socket:/var/run/mysqld/mysqld.sock Uptime: 1 hour 50 min 34 sec Threads: 1 Questions: 224 Slow queries: 0 Opens: 12 Flush tables: 1 Open tables: 6 Queries per second avg: 0.034 -- -- [EMAIL PROTECTED] (Jim Ziegler) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Yahoo! Auto Response
I will be back Saturday night. Thanks, Joseph Say I'm Hot! - Post Your Picture! http://www.sayimhot.com Original Message: X-Track: 16: 40 Received: from web.mysql.com (HELO www.mysql.com) (192.58.197.162) by mta137.mail.yahoo.com with SMTP; 31 Mar 2001 09:07:07 -0800 (PST) Received: (qmail 21736 invoked by uid 7797); 31 Mar 2001 17:02:01 - Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm (http://www.ezmlm.org) List-ID: mysql.mysql.com Precedence: bulk List-Help: mailto:[EMAIL PROTECTED] List-Unsubscribe: mailto:[EMAIL PROTECTED] List-Post: mailto:[EMAIL PROTECTED] List-Subscribe: mailto:[EMAIL PROTECTED] Delivered-To: mailing list [EMAIL PROTECTED] Received: (qmail 21721 invoked from network); 31 Mar 2001 17:02:00 - Date: Sat, 31 Mar 2001 09:03:59 -0800 From: "Jeremy D . Zawodny" [EMAIL PROTECTED] To: Hamid Hashemi Golpayegani [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: Dual Processor and MySQL ! Message-ID: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] References: _ DO YOU YAHOO!? Get your free @yahoo.com address at http://mail.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: Lock objects
Einav Lavi-Lapidot wrote: I want to work with an object that provides numbers, like sequence in Oracle database. Is there anything similar ? Of course, the object should be locked every time a specific user wants to get the next value. ( again, like sequence in oracle ). Thanks a lot. Einav. Einav Lavi-Pdut software engineer [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 Did you look at autoincrement? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Strange Error Message, I need explaination.
Hello, When I try to drop a database as follows: mysql drop database test; I get an error message of ERROR 1010: Error dropping database (can't rmdir './test', errno: 39) How do I fix this problem or even how do I delete the database. I'm using RedHat 6.2 and MySQL version: 3.22.32 and i'm logged in as user root. Thank you --Mike __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/?.refer=text - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: backup mysql using crontab
Hi, the cammod looks wiered to me try something like mysqldump --flush-logs --add-drop-table -u root -pmarkloky shuncheong /backup/shuncheong.sql lars "Mark Lo (3)" wrote: Hi, I would like to know how to backup mysql using crontab or cron jog. I have add a line in my crontab file : mysqldump --flush-logs --add-drop-table shuncheong /backup/shuncheong.sql -u root -pmarkloky; but I got nothing in shuncheong.sql file. Thank you for your help Mark Lo - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: backup mysql using crontab
Probably because you need to redirect your output into the file AFTER all the options. Rewrite your command like this: mysqldump --flush-logs --add-drop-table -u root -p markloky shuncheong /backup/shuncheong.sql See if that works. The way you had it written, you weren't passing the -u and -p options to mysqldump. So, mysqldump was connecting as an unprivileged user. On 4/2/01 9:08 AM, "Mark Lo (3)" [EMAIL PROTECTED] wrote: Hi, I would like to know how to backup mysql using crontab or cron jog. I have add a line in my crontab file : mysqldump --flush-logs --add-drop-table shuncheong /backup/shuncheong.sql -u root -pmarkloky; but I got nothing in shuncheong.sql file. Thank you for your help Mark Lo - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: backup mysql using crontab
"Mark Lo (3)" [EMAIL PROTECTED] wrote: I would like to know how to backup mysql using crontab or cron jog. I have add a line in my crontab file : mysqldump --flush-logs --add-drop-table shuncheong /backup/shuncheong.sql -u root -pmarkloky; but I got nothing in shuncheong.sql file. You need to supply the MySQL username and password to the left of the standard output ("") operator. Try: mysqldump --flush-logs --add-drop-table shuncheong -u root -pmarkloky /backup/shuncheong.sql -- Steve Werby President, Befriend Internet Services LLC http://www.befriend.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: backup mysql using crontab
mysqldump --flush-logs -u root -pmarkloky --add-drop-table shuncheong /backup/shuncheong.sql You have to put username and password as an argument to mysqldump, before your redirection John Barton Unix Systems Administrator Primary Networks, Inc. [EMAIL PROTECTED] On Tue, 3 Apr 2001, Mark Lo (3) wrote: Hi, I would like to know how to backup mysql using crontab or cron jog. I have add a line in my crontab file : mysqldump --flush-logs --add-drop-table shuncheong /backup/shuncheong.sql -u root -pmarkloky; but I got nothing in shuncheong.sql file. Thank you for your help Mark Lo - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Strange Error Message, I need explaination.
You are logged in as root, but what user is mysqld running as? If you stop the database, you can manually remove the test dir from the datadir. Or fix the permissions on your directories in the datadir, so that mysqld can add/remove directories and files. Look in your my.cnf file to find out what user the daemon is running as. Usually, it gets set up with an unprivileged user of mysql Did the scripts add the mysql user to etc/passwd? How's that for a start? On 4/2/01 9:34 AM, "Mike Mike" [EMAIL PROTECTED] wrote: Hello, When I try to drop a database as follows: mysql drop database test; I get an error message of ERROR 1010: Error dropping database (can't rmdir './test', errno: 39) How do I fix this problem or even how do I delete the database. I'm using RedHat 6.2 and MySQL version: 3.22.32 and i'm logged in as user root. Thank you --Mike __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/?.refer=text - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Trying to compile/build MySQL on SUSEv7.0 running on S/390
Hello, The configure program doesnt recognize my machine type. I am running SuSe v7.0 on a S/390 mainframe. uname -m returns S390, uname -s returns Linux and uname -p returns unknown. When I try to configure I get: Checking host system type... Invalid configuration `s390-unknown-linux-gnu': machine `s390-unknown' not recognized. I tried adding --host=Linux to the configure command, but get similar error and then it tells me I must specify Host type when using the --no-verify option in ltconfig. Is there a value I can plug in to get going? The other stuff configure checks out seems OK. Thanks for any help you can offer, Leo McCarthy Boston College Systems Services Tel: 617 552-4629 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Grant/Revoke dialog doesn't open
I am havving the same problem. I even tried compiling a version. If it is a window manager problem then how do I fix it. It seems like it should work wiith both the kde 2.0 window manager and the enlightenment window manager that is part on gnome. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: ---- Virus Detected ----
they are the morons that babbled about a LINUX/WINDOZE hybrid virus nothing that they say has credibility. On Sat, 31 Mar 2001 18:36:19 -0500, Gary Huntress wrote: I have received several of the same messages, and I too believe that I'm virus free (I just updated and ran NAV). Since the message is signed with an ad for marshal software, which is sells anti-virus services, I am viewing this as 100% spam. Gary - Original Message - From: "Lindsay Adams" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, March 31, 2001 6:24 PM Subject: Re: Virus Detected On 3/31/01 1:51 PM, "[EMAIL PROTECTED]" [EMAIL PROTECTED] wrote: MailMarshal (an automated content monitoring gateway) has stopped the following message: Message: B00049bf4.0001.mml From:[EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: Odd issue Because it believes an attachment to this message contains a virus. The virus scanning software used was: F-Prot Please clean the file and resend it. http://www.marshalsoftware.com Is anyone else on this list getting responses like this returned to them? I have run Virex, Symantec Antivirus, and even disenfectant. The emails I sent out had no file attachments. I email from a mac, and don't have any macro viruses in the MS apps I don't even use. So, is anyone else getting these? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
daylight savings
I have a problem with my time (now()) in mysql running on WIN98 (also in WIN NT). After the daylight savings, the time on the WIN machines is changed by 1 hour. But still the now() function returns a time as if there is no change for daylight savings. Timezone parameter is currently set to Central Standard Time. Where do I set in mysql configuration for daylight savings switch. 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
FP exception in sql/sql_select.cc on osf1/4.0f + gcc 2.95.2
Description: On mysql-3.23.33 on Tru64 4.0f, using gcc 2.95.2 (any optimisation level), sql_select.cc will raise a FP exception at line 1785 of sql/sql_select.cc, quoted here: : if (tmp best_time - records/(double) TIME_FOR_COMPARE) At the time that the exception occurs, the values are: tmp = 3 best_time = DBL_MAX records = 1 This code works properly on virtually all other os's, so after some amount of digging, it became apparent that it was a compiler issue of some form. Eventually, I reduced the problem down to this bit of code: -- #include stdio.h #include float.h int main(void) { volatile double a = 1, b = DBL_MAX; a = b - 1; return 0; } -- The volatile statement is just to ensure that the variables a and b are stored in memory rather then being optimised away into registers. If you compile this with gcc, a FP exception will occur when you attempt to subtract 1 from b (=DBL_MAX). This is caused by the fact that Alpha's FP handling is pretty damn weird, to say the least. This behaviour can be "fixed" by using the "-mieee" compiler option in gcc. How-To-Repeat: Stuff some non-trivial select statements into a mysql server compiled in this way, and it will crash very quickly. Alternatively, try compiling/running the demo code given above. Fix: Add "-mieee" to CXXFLAGS and CFLAGS. Submitter-Id: submitter ID Originator:Nick Hilliard Organization: MySQL support: none Synopsis: FP problems on alpha / gcc Severity: serious Priority: high Category: mysql Class: sw-bug Release: mysql-3.23.33 (Source distribution) Environment: System: OSF1 fafnir V4.0 1229 alpha Machine: alpha Some paths: /common/bin/perl /local/bin/make /common/bin/gmake /local/bin/gcc /usr/bin/cc GCC: Reading specs from /local/lib/gcc-lib/alphaev6-dec-osf4.0f/2.95.2/specs gcc version 2.95.2 19991024 (release) Compilation info: CC='gcc' CFLAGS='-mieee' CXX='c++' CXXFLAGS='-mieee' LDFLAGS='-s' LIBC: lrwxr-xr-x 1 root system17 Dec 20 14:54 /lib/libc.a - ../ccs/lib/libc.a lrwxr-xr-x 1 root system17 Dec 20 14:54 /usr/lib/libc.a - ../ccs/lib/libc.a Configure command: ./configure --enable-assembler --with-mysqld-user=mysql --without-debug --without-bench --with-charset=latin1 --prefix=/local/mysql Perl: This is perl, version 5.005_03 built for alpha-dec_osf - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 message: [Incorrect information in file: './ts1/tbl_status.frm']
Might the NFS dependence be a problem? Yes, it could , particularly if you do not have --skip-locking as mysqld startup or if some other processes access the files. Regards, Sinisa Hi Sinisa, What does "some other processes access the files" mean? Are you thinking like automated system backup software, or my own database client accesses? "configure" apparently placed -skip-locking into safe_mysqld, so I have always been running with this option on Linux. Since Saturday AM, - I moved all databases ("/var") onto my /tmp disk, - forced table operations to occur 12 times a day, and cannot replicate the original problem, so stability has returned. So, either: 1. should not be using -skip-locking on NFS, 2. NFS implementation + Linux should not be used (i.e., continue using a local disk). Do I really need -skip-locking on a Linux 2.2.12 kernel? = I rolled up a fcntl() test fragment, and it seems to work with 2 unrelated processes: stuff lk.l_type = F_WRLCK; /* advisory lock on entire file. */ fcntl(fd, F_SETLK, lk) stuff lk.l_type = F_UNLCK; fcntl(fd, F_SETLK, lk) I assume "configure" knows best about my system's fcntl() lock implementation and that it would do the correct thing? Should I try an NFS usage mode w/o -skip-locking, or will this create other more serious errors on Linux? Thanks for the pointers. Silvio - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 MS Access
Verify that you have a primary key and a DateTime Stamp field for your table. I do this with a Serial field {Serial int(11) not null Primary Key auto_increment} as the first field and {DateChanged (TimeStamp)} as the second field for each table that I intend on accessing from MSAccess. -Original Message- From: mysql-digest-help [mailto:[EMAIL PROTECTED]] Sent: Sunday, April 01, 2001 10:45 PM To: mysql Cc: rsa Subject: Mysql and MS Access Hi, I am trying to access a Mysql database from MS Access using the Mysql ODBC driver. I can connect to the database and open the table and browse the data but I can not modify anything (the file is read only). The username I am connecting with have Select, Insert, Update and Delete permissions. Any idea on how I can open the database in Read/Write mode? Thanks Ramzi - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: daylight savings
This is an issue with the msvcrt.dll file on Windows Platforms...see this link: http://archives.neohapsis.com/archives/ntbugtraq/1998-1999/msg00255.html (It's an old one too) Thanks, Tom -- #!/usr/bin/perl -w # 526-byte qrpff, Keith Winstein and Marc Horowitz [EMAIL PROTECTED] # MPEG 2 PS VOB file on stdin - descrambled output on stdout # arguments: title key bytes in least to most-significant order $_='while(read+STDIN,$_,2048){$a=29;$c=142;if((@a=unx"C*",$_)[20]48){$h=5; $_=unxb24,join"",@b=map{xB8,unxb8,chr($_^$a[--$h+84])}@ARGV;s/...$/1$/;$d= unxV,xb25,$_;$b=73;$e=256|(ord$b[4])9|ord$b[3];$d=$d8^($f=($t=255)($d 12^$d4^$d^$d/8))17,$e=$e8^($t($g=($q=$e147^$e)^$q*8^$q6))9 ,$_=(map{$_%16or$t^=$c^=($m=(11,10,116,100,11,122,20,100)[$_/16%8])110;$t ^=(72,@z=(64,72,$a^=12*($_%16-2?0:$m17)),$b^=$_%64?12:0,@z)[$_%8]}(16..271)) [$_]^(($h=8)+=$f+(~$g$t))for@a[128..$#a]}print+x"C*",@a}';s/x/pack+/g;eval On Mon, 2 Apr 2001, Srinivas Mulpuri wrote: I have a problem with my time (now()) in mysql running on WIN98 (also in WIN NT). After the daylight savings, the time on the WIN machines is changed by 1 hour. But still the now() function returns a time as if there is no change for daylight savings. Timezone parameter is currently set to Central Standard Time. Where do I set in mysql configuration for daylight savings switch. Thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
indexing in mysql
Hi everyone, I am having trouble to understand how exactly indexing for BLOBS work in mysql through servlets? Can someone send me some sample code which indexes BLOBS in some table in mysql with resect to some parameters thru servlet and mm-mysql.jdbc1.2c driver? Thanks Amod _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Calculations in a field?
Is there any way to make one field in a table calculate another field. I'm making a DB that calculates commissions. So in the money_made field would have the # of sales (sales field) times whatever the commission would be. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Newbie question
Hi, I've installed mysql 3.22.32 and created a test table via mysql. now, when I try to run safe_mysqld --log I get the error message [[EMAIL PROTECTED]]$ Starting mysqld daemon with databases from /usr/local/var ./scripts/safe_mysqld: /usr/local/var/www.server-1.com.err: Permission denied rm: cannot remove `/usr/local/var/www.server-1.com.pid': Permission denied ./scripts/safe_mysqld: /usr/local/var/www.server-1.com.err: Permission denied ./scripts/safe_mysqld: /usr/local/var/www.server-1.com.err: Permission denied mysqld daemon ended How do I cure this please? Once I know this, I'm off the runway at long last!!! regards, Graham
problems
Hi, I have one site developed with php+mysql. We have about 10.000 visits per day with more or less 250/300 users on prime time. When users increase over 200 mysql starts runing some errors and restarting... Number of processes running now: 0 010402 21:33:13 mysqld restarted /usr/sbin/mysqld: ready for connections 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. Number of processes running now: 0 010402 21:37:48 mysqld restarted /usr/sbin/mysqld: ready for connections This is what I get. The result y a lot of connectios of clients lost, but it restarts alone. I increase number of connections to 1000 and set key_bufffer=256. The server is a dual p-800 with 1GB RAM running linux with kerne.. Red Hat Linux release 6.2 (Zoot) Kernel 2.2.14-5.0smp on a 2-processor i686 What can I do to avoid this fatal errors? Thanks
unable to get access
I cant get access into mysql. I get access denied for user when trying to log into mysql as root with password. Anyone help? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Calculations in a field?
"Mike Roberts" [EMAIL PROTECTED] wrote: Is there any way to make one field in a table calculate another field. I'm making a DB that calculates commissions. So in the money_made field would have the # of sales (sales field) times whatever the commission would be. If you're updating existing records use an UPDATE query. UPDATE my_table SET money_made = sales * 0.15; Otherwise, if you're using a programming language like PHP or Perl to access the DB, do something like this. INSERT INTO my_table VALUES ( $sales, $sales * $commission_rate ); -- Steve Werby President, Befriend Internet Services LLC http://www.befriend.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Newbie question
It seems like those directories are owned by someone other than the user that MySQL runs under. chown them to the user MySQL runs under. In the future, posting info about MySQL ownership, who you're logged in as when running safe_mysqld, ownership and permissions on problem files, OS, etc. will get you better responses since they can all be important to solving the problem. -- Steve Werby President, Befriend Internet Services LLC http://www.befriend.com/ "Graham Nichols" [EMAIL PROTECTED] wrote: safe_mysqld --log I get the error message [[EMAIL PROTECTED]]$ Starting mysqld daemon with databases from /usr/local/var ./scripts/safe_mysqld: /usr/local/var/www.server-1.com.err: Permission denied rm: cannot remove `/usr/local/var/www.server-1.com.pid': Permission denied ./scripts/safe_mysqld: /usr/local/var/www.server-1.com.err: Permission denied ./scripts/safe_mysqld: /usr/local/var/www.server-1.com.err: Permission denied mysqld daemon ended How do I cure this please? Once I know this, I'm off the runway at long last!!! regards, Graham - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Update TimeStamp
Is there any way to query a mySQL database for the last time it was updated? I need this ability to trigger a "restart" in some other applications that create config files and such for MRTG... Thanks, --- Jason H. Frisvold Senior ATM Engineer Engineering Dept. Penteledata CCNA Certified - CSCO10151622 [EMAIL PROTECTED] --- "It is a silly, childish discussion and only exposes the want of brains of those who maintain a contrary opinion to that we have stated." - The Times (London) December 26, 1799 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: backup mysql using crontab
Probably because you need to redirect your output into the file AFTER all the options. Rewrite your command like this: In which shell? In SunOS /bin/sh, or in bash, the shell strips out the redirection, and the program sees what's left. It doesn't matter where the redirection is; it can even be before the call to mysqldump. --Pete mysqldump --flush-logs --add-drop-table -u root -p markloky shuncheong /backup/shuncheong.sql See if that works. The way you had it written, you weren't passing the -u and -p options to mysqldump. So, mysqldump was connecting as an unprivileged user. On 4/2/01 9:08 AM, "Mark Lo (3)" [EMAIL PROTECTED] wrote: Hi, I would like to know how to backup mysql using crontab or cron jog. I have add a line in my crontab file : mysqldump --flush-logs --add-drop-table shuncheong /backup/shuncheong.sql -u root -pmarkloky; but I got nothing in shuncheong.sql file. Thank you for your help Mark Lo - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: unable to get access
I cant get access into mysql. I get access denied for user when trying to log into mysql as root with password. Anyone help? You did go through the complete installation?? Including the create_db stuff and the root password setting stuff.. If not, read the manual.. it will help you to get things going. If this is an older install which ran fine, you might want to check the manual on removing the root password.. Bye, B. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Newbie question
I've installed mysql 3.22.32 and created a test table via mysql. now, when I try to run safe_mysqld --log Do you run this while you already could connect via mysql?? if so, then your server was already running.. No need to start it twice.. Also, checkout www.devshed.com and the fine MySQL manual at www.mysql.com or in your sourcedir/Docs. Please do yourself and us a favor, read those.. Bye, B. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: unable to get access
yes it was an old install, strange, it seems to want to connect now. bizarre - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Converting Access to MySQL
Hello to all, I was wondering if anyone could help me out with a little project i have going. I have a database in access 7.0 I would like to transfor all the fields, tables, plus information it has to mysql running on a linux box (rh 7.0) running mysql. now how would i go about that? is there a howto some were , plus is it hard to do.? Thank you Luis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Help!! New Win32 mySQL User
I am a newbie to the mySQL world and am having some difficulties with it. I am running a Win2K network (Win2K Pro, Win2K Adv. Server) using TCP/IP. I loaded mySQL on both a server and a workstation. I was able to get the server going (mysqld-nt --install, net start mysql), and was able to log into the server from my workstation (mysql.exe -h webserver -u administrator). I was able to see the databases (show databases;). I went out to the web and started poking around for a GUI client program. I loaded and tested a whole bunch of them, but my favorite was mySQL Front. I was able to load it, log in to the "Test" database, create tables, and everything else. I loaded a couple of others, but didn't find anything I liked better. I decided to go with mySQL Front. When I retried mySQL Front, I could no longer access the database. I was still able to access it, however, from mysql.exe (mysql.exe -h webserver -u administrator). I bought the Paul DuBois book, and started combing through it. I found something that sounded like it made sense - permissions. I tried shutting down the server, and then restarting it using "mysqladmin --skip-grant-tables", but the NT Command Processor just hangs when I issue this command. Now I have this thing so messed up, that I cannot log into the server at all except locally. What am I doing wrong??? Thanks! Greg Miller, IS/Development SantaPlus - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Update TimeStamp
select _timestamp from mytable order by _timestamp desc limit 1; Jason Frisvold wrote: Is there any way to query a mySQL database for the last time it was updated? I need this ability to trigger a "restart" in some other applications that create config files and such for MRTG... Thanks, --- Jason H. Frisvold Senior ATM Engineer Engineering Dept. Penteledata CCNA Certified - CSCO10151622 [EMAIL PROTECTED] --- "It is a silly, childish discussion and only exposes the want of brains of those who maintain a contrary opinion to that we have stated." - The Times (London) December 26, 1799 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Update TimeStamp
"Jason Frisvold" [EMAIL PROTECTED] wrote: Is there any way to query a mySQL database for the last time it was updated? I need this ability to trigger a "restart" in some other applications that create config files and such for MRTG... Create a field with type DATETIME and update it when a record is updated or inserted. Then use SELECT MAX(datetime_field_name) and trigger your action based on your criteria. If you are running MySQL with logging you may be able to get update time info. from there as well. -- Steve Werby President, Befriend Internet Services LLC http://www.befriend.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
Binlog has bad magic number
What causes: 010402 17:08:56 Error reading packet from server: Binlog has bad magic number, fire your magician (read_errno 0,server_errno=65535) in the err log of a replication slave? is it related to: 010402 17:10:34 create_table_from_dump::failed in handler::net_read_dump() 010402 17:10:34 fetch_nx_table: failed on create table when i try to: mysql load table aca from master; ERROR 1189: Net error reading from master -- [EMAIL PROTECTED] (Jim Ziegler) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysqld silently quits on date-related query
Description: We just upgraded our Sun Ultra 60's to Solaris 8, and in so doing, We upgraded MySQL from 3.22.32 to 3.23.36 (installed from source package). The new version of the server quits with status 1, and no error log output, when we do the following query: select * from foo where fooDate = '2001/1/2' (or any date). It also happens with "... = '2001/1/2'", ie., any query on a date. Here's a dump of the simple table: # MySQL dump 8.13 # # Host: localhostDatabase: allenhdb # # Server version3.23.36-log # # Table structure for table 'foo' # CREATE TABLE foo ( fooDate date default NULL ) TYPE=MyISAM; # # Dumping data for table 'foo' # INSERT INTO foo VALUES ('2001-01-02'); We re-installed 3.22.32, and it works fine. This problem also existed with 3.23.35 when I tried that. It's hard to believe that this is a bug in MySQL, more likely some configuration problem or OS compatibility issue (?). Either way, it's pretty serious for us. Maybe we just did something wrong. How-To-Repeat: The Description section pretty well describes how to duplicate the problem, at least on our machines. Hopefully you'll see the same thing. Fix: Submitter-Id: submitter ID Originator:Allen Hopkins Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: server quits on date query Severity: serious Priority: Category: mysql Class: Release: mysql-3.23.36 (Source distribution) Server: mysqladmin Ver 8.18 Distrib 3.23.36, for sun-solaris2.8 on sparc Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.23.36-log Protocol version10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 2 min 51 sec Threads: 1 Questions: 1 Slow queries: 0 Opens: 6 Flush tables: 1 Open tables: 0 Queries per second avg: 0.006 Environment: System: SunOS markov 5.8 Generic_108528-06 sun4u sparc SUNW,Ultra-60 Architecture: sun4 Some paths: /bin/perl /home/allenh/bin/make /usr/sww/bin/gmake /usr/local/bin/gcc /usr/ucb/cc GCC: Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.8/2.95.3/specs gcc version 2.95.3 20010315 (release) Compilation info: CC='gcc' CFLAGS='-O1' CXX='gcc' CXXFLAGS='-O1 -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' LIBC: -rw-r--r-- 1 root 1749356 Jul 20 2000 /lib/libc.a lrwxrwxrwx 1 root 11 Mar 26 20:32 /lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 root 1135056 Jul 20 2000 /lib/libc.so.1 -rw-r--r-- 1 root 1749356 Jul 20 2000 /usr/lib/libc.a lrwxrwxrwx 1 root 11 Mar 26 20:32 /usr/lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 root 1135056 Jul 20 2000 /usr/lib/libc.so.1 Configure command: ./configure --prefix=/usr/local/mysql-3.23.36 --localstatedir=/home/www/mysql Perl: This is perl, version 5.005_03 built for sun4-solaris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Importing
I'm tring to import a text file to mysql. The problem I am having is that the mysql database is located on a seperate server from the web site. I can do query's and inserts but I can not get the mysql server to grab a txt file from the web server and load it into the database. I have been using the following code: $query = "LOAD DATA LOCAL INFILE '$tmp\\$file1_name' "; $query .= "INTO TABLE usr FIELDS "; $query .= "TERMINATED BY ',' ENCLOSED BY '\"' LINES TERMINATED BY '\n' (name,email,login,active,defaultpw)"; The site is located on an NT server and the database is on a UNIX server. Not sure if that matters or not. Any help would be great.. Ian
Time function
What time function should I use to add 2 hours to a time value I am getting from the database ? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
About the upper limit of data storage...
Hi all, Some one told me that the upper limit of MySql data storage is 1 Gb of data. As I am new so I am not sure of this. If any gurus of MySql can please tell me about it, it would be great. Regards Dp Balcom Systems Technologies, Inc. (408)468-6608
after changing master-host in my.cnf, slave remained committed to old master.info
i initially had a master-host=A defined in my.cnf. later i changed that to master-host=B. i was mystified when i got a connection error: Slave thread: error connecting to master:Host 'dumbo.pobox.com' is not allowed to connect to this MySQL server(0), retry in 60 sec i spent much time prodding and poking before i realized that due to the preexisting master.info, the slave was trying to connect to the old master A, not the new master B. i propose the following patch to make the error string more verbose: it indicates what host, user, and password are in use. it may need to be edited to be NULL-safe --- if password is null, etc. --- mysql-3.23.36/sql/slave.cc Tue Mar 27 05:11:05 2001 +++ mysql-3.23.36/sql/slave.cc-verboser Mon Apr 2 18:34:02 2001 @@ -1372,8 +1372,8 @@ !mc_mysql_connect(mysql, mi-host, mi-user, mi-password, 0, mi-port, 0, 0)) { -sql_print_error("Slave thread: error connecting to master:%s(%d),\ - retry in %d sec", mc_mysql_error(mysql), errno, mi-connect_retry); +sql_print_error("Slave thread: error connecting to master %s as %s with password +%s: %s(errno %d), will retry in %d sec", + mi-host, mi-user, mi-password, mc_mysql_error(mysql), errno, +mi-connect_retry); safe_sleep(thd, mi-connect_retry); } - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Converting Access to MySQL
Luis, This is an easy one. Go here ftp://ftp.informate.co.nz/pub/ and download one of the scripts, the instructions are in the script. It will create a text file that has the sql commands needed to create and fill your mySQL tables with your Access info. You can exec the script from the mySQL prompt. -bryce on 4/2/01 3:52 PM, Luis at [EMAIL PROTECTED] wrote: Hello to all, I was wondering if anyone could help me out with a little project i have going. I have a database in access 7.0 I would like to transfor all the fields, tables, plus information it has to mysql running on a linux box (rh 7.0) running mysql. now how would i go about that? is there a howto some were , plus is it hard to do.? Thank you Luis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Time function
"Rekha Das" [EMAIL PROTECTED] wrote: What time function should I use to add 2 hours to a time value I am getting from the database ? Convert the time to seconds, add 7200 seconds (2 hours), then convert back to time format. SELECT SEC_TO_TIME(TIME_TO_SEC(my_time_field) +7200); -- Steve Werby President, Befriend Internet Services LLC http://www.befriend.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: About the upper limit of data storage...
"Dhirendra Pal Singh" [EMAIL PROTECTED] wrote: Some one told me that the upper limit of MySql data storage is 1 Gb of data. The limit depends on the operating system. On some operating systems it's 2 GB, on others it's much higher. Search the mailing list at http://marc.theaimsgroup.com/?l=mysqlr=1w=2 for search phrases like "big table" "2GB", etc. for past discussions on the topic. Also, I believe this is covered in the manual. -- Steve Werby President, Befriend Internet Services LLC http://www.befriend.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: Converting Access to MySQL
Thank you for the help, but I'm a newbie on MySQL . Some of the stuff i been reading tells me to download MyODBC or i could make a txt file out of access when exporting. If i try to inport a all the fields from access to mysql do i have to create a database plus tables that are the same as in windows? I'm sorry i'm a newbie at all 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
problem compiling on Sol 8 - I don't know where to go from here.
checking for crypt.h... yes checking for alloca.h... yes checking for floor in -lm... yes checking for gethostbyname_r in -lnsl_r... no checking for gethostbyname_r in -lnsl... yes checking for socket in -lsocket... yes checking for p2open in -lgen... yes checking for bind in -lbind... no checking for crypt in -lcrypt... yes checking for compress in -lz... yes checking LinuxThreads... Not found checking DEC threads... no checking DEC 3.2 threads... no checking SCO threads... no checking SCO UnixWare7 native threads... no checking Siemens threads... no checking Solaris threads... yes checking named thread libs:... -lpthread -lthread checking for strtok_r in -lpthread... yes checking for strtok_r... yes checking for dlopen in -ldl... yes checking for restartable system calls... configure: error: can not run test program while cross compiling thanks ahead of time David C. McCall UNIX Administrator [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: Time function
rekha, mysql select date_format(dateEntered, "%m-%d-%Y %H:%I") as dateEntered, - date_format(date_add(dateEntered, interval 2 hour), "%m-%d-%Y %H:%I") as '2 Hours Later' - from newsStories where storyID = 1122; +--+--+ | dateEntered | 2 Hours Later| +--+--+ | 03-28-2001 20:08 | 03-28-2001 22:08 | +--+--+ 1 row in set (0.00 sec) Both DATE_FORMAT, DATE_ADD *are* in the manual http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#Dat e_and_time_functions chris -Original Message- From: Rekha Das [mailto:[EMAIL PROTECTED]] Sent: Monday, April 02, 2001 2:52 PM To: '[EMAIL PROTECTED]' Subject: Time function What time function should I use to add 2 hours to a time value I am getting from the database ? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
time and date
Is there a way to store the time and date that a record was added within MySQL? I want to show the time and date on some of my records and can't seem to figure out an easy way to do it. 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
Re: time and date
It's in the manual. Check the datatypes section, and the now() mysql function. On 4/2/02 6:26 PM, "chris" [EMAIL PROTECTED] wrote: Is there a way to store the time and date that a record was added within MySQL? I want to show the time and date on some of my records and can't seem to figure out an easy way to do it. 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: time and date
Check the manual for the TIMESTAMP datatype. Will hold the last update time per record abd therefore the insert time that you want. regards, thalis -- No excellent soul is exempt from a mixture of madness. -- Aristotle On Tue, 2 Apr 2002, chris wrote: Is there a way to store the time and date that a record was added within MySQL? I want to show the time and date on some of my records and can't seem to figure out an easy way to do it. 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: time and date
Add a date/time column and dump the current time into it when you do an insert jason - Original Message - From: "chris" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, April 03, 2002 11:26 AM Subject: time and date Is there a way to store the time and date that a record was added within MySQL? I want to show the time and date on some of my records and can't seem to figure out an easy way to do it. 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
Re: speed problems
[..] Why this is s slow with BSD we still don't know (like i said in my first mail, same query was 3 secs or ~20 sec on Linux) I haven't followed the entire thread so feel free to diss me.. There was problem with the userland threading under early OpenBSD 2.8 versions (including the 'stable' release). This affected MySQL. This is in the docs. Use a 2.8 dated after 2001-01-25 (if I remember correctly) or revert to 2.7. -- Aigars - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 reports time incorrectly.
using 3.23.28-gamma on win2000. With the change over to daylights savings, the system time was increased by one hour. MySQL is still reporting the time to be one hour ago. eg, it is now 20:08 pm (just double checked it through bios) Doing a SELECT NOW() reports it to be 19:08. I've tried shutting down the service and restarting, rebooting the computer it is on and nothing works. help? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 reports time incorrectly.
%% Craig Washburn [EMAIL PROTECTED] writes: cw using 3.23.28-gamma on win2000. cw With the change over to daylights savings, the system time was cw increased by one hour. MySQL is still reporting the time to be one cw hour ago. cw eg, it is now 20:08 pm (just double checked it through bios) Doing a cw SELECT NOW() reports it to be 19:08. I've tried shutting down the cw service and restarting, rebooting the computer it is on and nothing cw works. This is a bug in Windows, and has been known for over two years. Unfortunately it takes Microsoft about 3.73 years, on average, to fix a simple bug like incorrect handling of DST, so you're basically screwed until next week. Maybe by the next time Apr 1 is on a Sunday, they will have fixed this bug. :-/. -- --- Paul D. Smith [EMAIL PROTECTED] Find some GNU make tips at: http://www.gnu.org http://www.paulandlesley.org/gmake/ "Please remain calm...I may be mad, but I am a professional." --Mad Scientist - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Selecting certain fields
Hi all, I suppose this is more of a feature request for the mysql developers. I have a user who only has read access to a few columns of one table. This table is very large so that it means that the columns, this user has access to, is still quite large. If I do a SELECT * FROM... returns an access denied error. Is it possible to change it so that it returns all the columns that this user has access to, rather then the error. Stating 50 or so columns in a SELECT statement each time, is rather time consuming. Cheers Rolf - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 reports time incorrectly.
"Craig Washburn" [EMAIL PROTECTED] wrote: using 3.23.28-gamma on win2000. With the change over to daylights savings, the system time was increased by one hour. MySQL is still reporting the time to be one hour ago. eg, it is now 20:08 pm (just double checked it through bios) Doing a SELECT NOW() reports it to be 19:08. I've tried shutting down the service and restarting, rebooting the computer it is on and nothing works. Several users have posted requesting help with this problem today. One person posted the URL of an article on the bug (which dates back about 2 years if I remember right). You should be able to find it and all of the other posts on the subject from today in the archives at http://marc.theaimsgroup.com/?l=mysqlr=1w=2. -- Steve Werby President, Befriend Internet Services LLC http://www.befriend.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
SQL : multiple SELECT and missing rows.
Hello Guys, I have a (very simple?) SQL question. I'm more then sure the answer to it is whether "just do this..." or "It's impossible man, how could you even get that into your mind..." I have this database design: (it's more complex of course, but you get an idea) Table 'accounts': +---+--++ | ID| type | since | +---+--++ | 1 | P| 1999-08-01 | | 2 | F| 1999-11-06 | | 3 | S| 2000-07-05 | | 4 | P| 2001-01-01 | +---+--++ Table 'addresses': +---+--+--+-+ | ID| city | pref | country | +---+--+--+-+ | 1 | Shibuya-ku | 13 | JP | | 2 | Nakano-ku| 13 | JP | | 4 | Toyonaka-shi | 27 | JP | +---+--+--+-+ As you can see, the main data is in 'accounts', the 'addresses.ID' is UNIQUE and corresponds to 'accounts.ID'. The fact is that not every account has an address registered with it. I need to list ALL the accounts in this order: +---+--+-++---+ | ID | Type | City | Country | Since | +---+--+-++---+ Therefore I am trying to do it with the following query: SELECT accounts.ID AS ID, accounts.type AS Type, addresses.city AS City, addresses.country AS Country, accounts.since AS Since FROM accounts, addresses WHERE addresses.ID=accounts.ID ORDER BY accounts.ID ASC LIMIT 10 ; And, this selects me IDs 1, 2 and 4. 3, obviously, is not here because there's no such address.ID as stated in my WHERE clause. Can anyone suggest me how do I SELECT ALL of the accounts having simply NULL on 'addresses.*' when there's no such row, instead of 'loosing' the whole 'account' row? I sure know how to do it using two queries, still, I wonder if one single query can do this job. Where do I miss the logic? Thanks in advance. -maxim Maxim Maletsky - [EMAIL PROTECTED] Webmaster, J-Door.com / J@pan Inc. LINC Media, Inc. TEL: 03-3499-2175 x 1271 FAX: 03-3499-3109 http://www.j-door.com http://www.japaninc.net http://www.lincmedia.co.jp - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [PHP] SQL : multiple SELECT and missing rows.
"Maxim Maletsky" [EMAIL PROTECTED] wrote: As you can see, the main data is in 'accounts', the 'addresses.ID' is UNIQUE and corresponds to 'accounts.ID'. The fact is that not every account has an address registered with it. snip FROM accounts, addresses You're doing a straight join. You need to use a LEFT JOIN to return all the records from one table and those from a second table that match based on a common field. Read about joins in the manual and find a resource on SQL statements - it'll pay off. SELECT * FROM accounts LEFT JOIN addresses ON addresses.ID = accounts.ID Can anyone suggest me how do I SELECT ALL of the accounts having simply NULL on 'addresses.*' when there's no such row, instead of 'loosing' the whole 'account' row? Use the query above and add: WHERE addresses.ID IS NULL -- Steve Werby President, Befriend Internet Services LLC http://www.befriend.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: multiple SELECT and missing rows.
This is best done with a LEFT JOIN. Please read up the manual about it. - Original Message - From: "Maxim Maletsky" [EMAIL PROTECTED] To: [EMAIL PROTECTED]; "'PHP General List. (E-mail)'" [EMAIL PROTECTED] Sent: Tuesday, April 03, 2001 9:41 Subject: SQL : multiple SELECT and missing rows. Hello Guys, I have a (very simple?) SQL question. I'm more then sure the answer to it is whether "just do this..." or "It's impossible man, how could you even get that into your mind..." I have this database design: (it's more complex of course, but you get an idea) Table 'accounts': +---+--++ | ID| type | since | +---+--++ | 1 | P| 1999-08-01 | | 2 | F| 1999-11-06 | | 3 | S| 2000-07-05 | | 4 | P| 2001-01-01 | +---+--++ Table 'addresses': +---+--+--+-+ | ID| city | pref | country | +---+--+--+-+ | 1 | Shibuya-ku | 13 | JP | | 2 | Nakano-ku| 13 | JP | | 4 | Toyonaka-shi | 27 | JP | +---+--+--+-+ As you can see, the main data is in 'accounts', the 'addresses.ID' is UNIQUE and corresponds to 'accounts.ID'. The fact is that not every account has an address registered with it. I need to list ALL the accounts in this order: +---+--+-++---+ | ID | Type | City | Country | Since | +---+--+-++---+ Therefore I am trying to do it with the following query: SELECT accounts.ID AS ID, accounts.type AS Type, addresses.city AS City, addresses.country AS Country, accounts.since AS Since FROM accounts, addresses WHERE addresses.ID=accounts.ID ORDER BY accounts.ID ASC LIMIT 10 ; And, this selects me IDs 1, 2 and 4. 3, obviously, is not here because there's no such address.ID as stated in my WHERE clause. Can anyone suggest me how do I SELECT ALL of the accounts having simply NULL on 'addresses.*' when there's no such row, instead of 'loosing' the whole 'account' row? I sure know how to do it using two queries, still, I wonder if one single query can do this job. Where do I miss the logic? Thanks in advance. -maxim Maxim Maletsky - [EMAIL PROTECTED] Webmaster, J-Door.com / J@pan Inc. LINC Media, Inc. TEL: 03-3499-2175 x 1271 FAX: 03-3499-3109 http://www.j-door.com http://www.japaninc.net http://www.lincmedia.co.jp - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: speed problems
On 2001-03-21, Viljo Marrandi [EMAIL PROTECTED] wrote: No, only one SELECT with 3 joins. Just in case i send this query again: SELECT f.foto_id, f.imgname, f.path FROM foto f, indeks k1, indeks k2 WHERE f.foto_id = k1.foto_id AND k1.word = 'mati' AND f.foto_id = k2.foto_id AND k2.word = 'kose' GROUP BY f.foto_id; [snip; heavy snippage on the following tables to clean them up] 3.22.32 (old and fast) EXPLAIN: +---++---+-+-++- | table | type | possible_keys | key | key_len | ref| rows +---++---+-+-++- | k1| ref| idx2 | idx2| 100 | mati | 986 | f | eq_ref | PRIMARY | PRIMARY | 4 | k1.foto_id |1 | k2| range | idx2 | idx2|NULL | NULL | 1470 3.23.32 (new and slow) EXPLAIN: +---++---+-+-++- | table | type | possible_keys | key | key_len | ref| rows +---++---+-+-++- | k1| ref| idx2 | idx2| 101 | const | 996\ | where used; Using temporary | f | eq_ref | PRIMARY | PRIMARY | 4 | k1.foto_id |1 | k2| ref| idx2 | idx2| 101 | const | 1264 Hm. A couple of things occur to me looking at the above: -the tables in the 3.23.32 example may not be defined the same way. In particular, key_len changes from 100 to 101 bytes for the indeks table lookup. Perhaps a char/varchar is defined NOT NULL on the 3.22 box and not on the 3.23 ? -a temp table is/will be used in 3.23, and not in 3.22. Significance...? -3.22 thinks that there is no index it can use for the k2 join of indeks. Therefore it plans to table-scan through 1470 records. OTOH, 3.23 plans to use a key on the k2 join. But, perhaps (gasping) that causes instead of a single scan through the indeks table, 1,264 seeks from the index file to the data file to the index file... etc? Still, your data set is surely small enough to fit all in disk cache. But perhaps there's also a thousandfold increase in the work done by mysqld at some point during this query? (Grasping again.) In terms of query-optimization, it seems (logically, not necessarily the same as SQLese :) that you really want to join indeks with itself to find indeks.foto_id's which have a word='foo' and a word='bar', and then join that result set with f. Perhaps there's a better way to optimize the query / indexes to reflect that? -- Hank Leininger [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: SQL : multiple SELECT and missing rows.
You want to use the "LEFT JOIN" syntax. A general outline would be: SELECT [your fields] FROM accounts LEFT JOIN addresses ON addresses.ID = accounts.ID WHERE ... ORDER ... LIMIT ... This would select all addresses.ID's, including those where accounts.ID is NULL. -Kevin --On Tuesday, April 03, 2001 10:41 AM +0900 Maxim Maletsky [EMAIL PROTECTED] wrote: Hello Guys, I have a (very simple?) SQL question. I'm more then sure the answer to it is whether "just do this..." or "It's impossible man, how could you even get that into your mind..." I have this database design: (it's more complex of course, but you get an idea) Table 'accounts': +---+--++ | ID| type | since | +---+--++ | 1 | P| 1999-08-01 | | 2 | F| 1999-11-06 | | 3 | S| 2000-07-05 | | 4 | P| 2001-01-01 | +---+--++ Table 'addresses': +---+--+--+-+ | ID| city | pref | country | +---+--+--+-+ | 1 | Shibuya-ku | 13 | JP | | 2 | Nakano-ku| 13 | JP | | 4 | Toyonaka-shi | 27 | JP | +---+--+--+-+ As you can see, the main data is in 'accounts', the 'addresses.ID' is UNIQUE and corresponds to 'accounts.ID'. The fact is that not every account has an address registered with it. I need to list ALL the accounts in this order: +---+--+-++---+ | ID | Type | City | Country | Since | +---+--+-++---+ Therefore I am trying to do it with the following query: SELECT accounts.IDAS ID, accounts.type AS Type, addresses.city AS City, addresses.country AS Country, accounts.since AS Since FROM accounts, addresses WHERE addresses.ID=accounts.ID ORDER BY accounts.ID ASC LIMIT 10 ; And, this selects me IDs 1, 2 and 4. 3, obviously, is not here because there's no such address.ID as stated in my WHERE clause. Can anyone suggest me how do I SELECT ALL of the accounts having simply NULL on 'addresses.*' when there's no such row, instead of 'loosing' the whole 'account' row? I sure know how to do it using two queries, still, I wonder if one single query can do this job. Where do I miss the logic? Thanks in advance. -maxim Maxim Maletsky - [EMAIL PROTECTED] Webmaster, J-Door.com / J@pan Inc. LINC Media, Inc. TEL: 03-3499-2175 x 1271 FAX: 03-3499-3109 http://www.j-door.com http://www.japaninc.net http://www.lincmedia.co.jp - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] om Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Kevin C. Miller - Carnegie Mellon University - [EMAIL PROTECTED] - School of Computer Science -412.512.3144 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
NEW MAKE BUG? sigcontext.h
Doing a "make" on the newest MySQL stable 3.23.36 source tarball - on a stock Cobalt RaQ3 (Linux 386) which I've installed MySQL on many times before. Got this strange error: gcc -DUNDEF_THREADS_HACK -DHAVE_CONFIG_H -I./../include -I./.. -I..-O6 -DDBUG_OFF -c readline.c In file included from /usr/include/signal.h:300, from readline.c:50: /usr/include/bits/sigcontext.h:28: asm/sigcontext.h: No such file or directory Anyone know what it means? How would you debug this? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL Security
Dear sir or madam MySQL user's account is not related to user's account on Linux System, so they can be different. My problem is that I use perl DBI to interact MySQL server as belows: -- use DBI; $dbh = DBI-connect("DBI:mysql:DatabaseName","$user","$password"); --- So $user and $password can be known by any users in Linux system because they are written in text format and DataBase can be changed or updated by other users in Linux system easily by using Perl DBI. Is there any way to prevent Database from being changed? Millon of thanks Regards Taing Nguon
Re: Importing
I believe the problem is with your use of "LOCAL". This is telling the server to try to load the file on the computer it is running on. If this is not where the file is on the computer running mysqld this could explain why it cant read it. Try removing the "LOCAL" part, you also might want to enable compression depending on how fast the link between the two computers are. ryan I'm tring to import a text file to mysql. The problem I am having is that the mysql database is located on a seperate server from the web site. I can do query's and inserts but I can not get the mysql server to grab a txt file from the web server and load it into the database. I have been using the following code: $query = "LOAD DATA LOCAL INFILE '$tmp\\$file1_name' "; $query .= "INTO TABLE usr FIELDS "; $query .= "TERMINATED BY ',' ENCLOSED BY '\"' LINES TERMINATED BY '\n' (name,email,login,active,defaultpw)"; The site is located on an NT server and the database is on a UNIX server. Not sure if that matters or not. Any help would be great.. Ian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Security
Taing Nguon wrote: Dear sir or madam MySQL user's account is not related to user's account on Linux System, so they can be different. My problem is that I use perl DBI to interact MySQL server as belows: -- use DBI; $dbh = DBI-connect("DBI:mysql:DatabaseName","$user","$password"); --- So $user and $password can be known by any users in Linux system because they are written in text format and DataBase can be changed or updated by other users in Linux system easily by using Perl DBI. Is there any way to prevent Database from being changed? Millon of thanks Regards Taing Nguon Taing: I use php3 to do my apps for web applications and chown the /www/ files to www.www and chmod them to 0750 with the server running as user www. This prevents any users from viewing the source code: i.e. the /www/ files that contain your perl scripts. This might be an option for you if the perl user can run as www.www and you can run those perl scripts as user www within the web context. This is just how I do it, but, others might have different implementations. Best Regards, Van -- = Linux rocks!!! http://www.dedserius.com = - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How to recover from accidental 'drop database mysql'
Greetings: I accidently dropped (my thunderous stupidity!!!) our mysql database. There were a few usernames and other databases. I expected hell to break loose (it may still happen!), but strangely enough, I noticed that I was still able to login, probably because mysql server caches usernames, passwords, etc ?? I quickly backed up the remaining databases using mysqldump. I did a make install to update the database and everything still seems ok. Now, anyone know if there is any way to create or repair my existing mysql database with the information that is currently cached in the server ? For example, if I do "show databases", I see all the databases that should exist, but when I do a "select * from mysql.db", I only see the "test" database!. Any ideas will be gratefully appreciated and accepted ! --== Sent via Deja.com ==-- http://www.deja.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: How to recover from accidental 'drop database mysql'
Hi, Its called your backup tape. Quentin -Original Message- From: Anonymous Individual [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 3 April 2001 4:16 p.m. To: [EMAIL PROTECTED] Subject: How to recover from accidental 'drop database mysql' Greetings: I accidently dropped (my thunderous stupidity!!!) our mysql database. There were a few usernames and other databases. I expected hell to break loose (it may still happen!), but strangely enough, I noticed that I was still able to login, probably because mysql server caches usernames, passwords, etc ?? I quickly backed up the remaining databases using mysqldump. I did a make install to update the database and everything still seems ok. Now, anyone know if there is any way to create or repair my existing mysql database with the information that is currently cached in the server ? For example, if I do "show databases", I see all the databases that should exist, but when I do a "select * from mysql.db", I only see the "test" database!. Any ideas will be gratefully appreciated and accepted ! --== Sent via Deja.com ==-- http://www.deja.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 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php