Re: LAST_INSERT_ID returning 3 rows?
So sprach Graeme B. Davis am Tue, May 01, 2001 at 01:09:15PM -0400: Ok I was thinking that you had to tell LAST_INSERT_ID the table you wanted to get the last insert id from. What if you run a web site and you have 10 tables in a database, how can you tell what the last insert id of table 6 was? You can't. last_insert_id() will tell you the last_insert_id from the current session/connection. Alexander Skwar -- How to quote: http://learn.to/quote (german) http://quote.6x.to (english) Homepage: http://www.digitalprojects.com | http://www.iso-top.de iso-top.de - Die günstige Art an Linux Distributionen zu kommen Uptime: 2 days 12 hours 3 minutes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
distinct on varchar fields
Hi All, when I use a distinct on varchar fields, does mySQL truncate the value of the string to some set value. This two queries give me a completely different number of rows and I am not sure how to influence the behaviour: select distinct x from y; (many rows result) and select distinct concat(some long string,x,some more string from y (one row result) where x is a varchar(255) field. Is there any way that I can get the same results with both queries or as an alternative use: select concat(some long string, distinct x,some more string) from y, where the problem is that distinct is not allowed in concat (as in any other function for that matter as I assume) Thanks , Markus - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: distinct on varchar fields
Have you tried: select concat(blah, x, bleh) from y group by x; Hi All, when I use a distinct on varchar fields, does mySQL truncate the value of the string to some set value. This two queries give me a completely different number of rows and I am not sure how to influence the behaviour: select distinct x from y; (many rows result) and select distinct concat(some long string,x,some more string from y (one row result) where x is a varchar(255) field. Is there any way that I can get the same results with both queries or as an alternative use: select concat(some long string, distinct x,some more string) from y, where the problem is that distinct is not allowed in concat (as in any other function for that matter as I assume) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MYISAM recovery.
Hello mysql, It seems like mysql sometimes tries to hard to repair the table with myisam tables with fixed row format. I've had a chance to several times found data in one of the tables completely destroyed - the data looked like random. mysql select * from g01layers_stat_cities limit 10; ++--++++++ | id | type | begin | counter| last | last_hit | |page_group | ++--++++++ | 539167267 | 84 | 20231203141129 | 1920234272 | 20320611141829 | 1713399154 | | 111 | | 1650553888 | 108 | 20241103100405 | 1684091184 | 20311128204214 | 1936291423 | | 39 | | 1124731427 | 82 | 20061110120717 | 577632 | 20241029051540 | 1684091184 | | 118 | | 1985967218 | 105 | 19750527085147 | 1684611104 | 20311125200848 | 691024168 | | 32 | | 1734964078 | 110 | 20110715200141 | 1310741583 | 19870304184629 | 1869903201 | | 95 | | 1701995374 | 109 | 19930820102541 | 1663049738 | 20311125210119 | 1767862885 | | 100 | | 678719081 | 49 | 20320408165928 | 1734964078 | 19870323012758 | 1095124292 | | 85 | | 807870548 | 39 | 20141028110448 | 1280658976 | 19870113150012 | 544437280 | | 116 | | 1953719661 | 97 | 19960219154325 | 170666292 | 20340728025216 | 1948280176 | | 105 | | 1953393017 | 40 | 20320408165931 | 1734964078 | 19870323012758 | 1095124292 | | 85 | ++--++++++ 10 rows in set (0.00 sec) It did't look like a possible bug in mysql so I checked other thing. I took a table and completely replaced the data file with over file which is not connected with mysql in any way, really it was a mysqldump output for one of the databases and mysql was easily able to repair the same way as it repairs a bit damaged tables - some of duplicate key records there removed but it looked quite normal. Of couse I had a trash in a file afterwards. I don't have good solution for this yet, but it's not quite nice behavior :) -- Best regards, Peter mailto:[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
Can we store Japaneese characters in MySql Database
Hello, Is it possible to store the Japaneese character set in MySql Database? Thanks Regards Narayanan. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Occasional hang of mysql
Hi there! I encounterd with a problem recently. Mysql occasionally hangs so that it can't be killed with -SIGKILL, that is there is one thread persist after killall -9 mysqld and it can't be killed in any way. The only way to get mysql back to work is server reboot. I'm using mysql-3.23.37 on RedHat 6.2 linux kernel 2.4.3. It happens both on binary distribution and on myself compiled one. It can't be predicted and mysql can work the whole day without hang or it can hang in 5 minutes after reboot. Is there somebody that have the same troubles or maybe someone can help me. Thanks. Victor. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RTFM - Show locks
database, sql Hi there I have tried looking in the manual but can't see the solution to this. user a issues a lock on table1, userb then tries to do a select and obviously the select will wait until the lock is released. So my questions are :- 1. How do you change the 'timeout' period that userb will wait for? 2. When the timeout is reached, I want to give the user a message box that shows them who is currently locking the table. How do I see who is locking table1? Regards Warren ~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t/a RedTie Durban, South Africa Cell (+27-83) 262-9163 Office (+27-31) 767-0249 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: auto_increment
I believe that this behaviour is standard for autoincrementing fields on all database systems that support them. -Original Message- From: Stefan Wehowsky [mailto:[EMAIL PROTECTED]] Sent: Fri, 04 May 2001 10:37 To: [EMAIL PROTECTED] Subject: auto_increment Let´s say I got a column id that is of type tinyint and has the extra auto_increment. Let´s further say that I have 50 entries in that column. Now if I delete e.g. entry No. 30 and right after that add another entry without naming an id (for ist auto_increment) MySQL gives it the id 51 AND NOT 30 which leads to more and more gaps between the id´s. Is there anything i can do about that ? Best regards, Stefan Wehowsky - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: auto_increment
True. The only thing that could be done is write a UDF (user-defined function), which accepts a table and field name as parameters and somehow manages to find the first unused ID in that table.. and hope it is atomic, too.. I don't think this is too easy to do, though :) G'luck, Peter -- Hey, out there - is it *you* reading me, or is it someone else? On Fri, May 04, 2001 at 02:01:42PM +0200, Bruce Stewart wrote: I believe that this behaviour is standard for autoincrementing fields on all database systems that support them. -Original Message- From: Stefan Wehowsky [mailto:[EMAIL PROTECTED]] Sent: Fri, 04 May 2001 10:37 To: [EMAIL PROTECTED] Subject: auto_increment Let's say I got a column id that is of type tinyint and has the extra auto_increment. Let's further say that I have 50 entries in that column. Now if I delete e.g. entry No. 30 and right after that add another entry without naming an id (for ist auto_increment) MySQL gives it the id 51 AND NOT 30 which leads to more and more gaps between the id's. Is there anything i can do about that ? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 not see data or tables in database
Are the database directories and tables owned my the user under which you have mysqld running? Richard Kurth wrote: I set up a couple of databases last night in mysql and every thing is working just fine. Today when I try to access the data it is not there Using phpMyAdmin when I look at the databases that are completely empty of tables and data that also includes the mysql database. If I start up telnet and go into mysql it shows that all of the tables and data are their including the mysql data. This seems realy strange to me. Could you tell me what I need to do to correct this problem or at lest looking in the right direction. Thank you Richard Kurth - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Gerald L. Clark [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: auto_increment
Hi, There is no other go.I too had similar problems.But it does not hurt me as the auto_increment column is always being used as a primary key in my case. We have got to live with it until and unless we have some option to insert into the deleted row. Regards, Ravi --- Joseph Bueno [EMAIL PROTECTED] wrote: Stefan Wehowsky wrote: Let´s say I got a column id that is of type tinyint and has the extra auto_increment. Let´s further say that I have 50 entries in that column. Now if I delete e.g. entry No. 30 and right after that add another entry without naming an id (for ist auto_increment) MySQL gives it the id 51 AND NOT 30 which leads to more and more gaps between the id´s. Is there anything i can do about that ? No. Also, don't use TINYINT unless you are sure that you will never insert more than 127 records ! (Both issues have already been discussed in this mailing list, check the archives for more details). Best regards, Stefan Wehowsky Best Regards -- Joseph Bueno NetClub/Trader.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 Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 C API
Hi PAUL, 1.Thanks for the mail. 2.Regarding the return values I wonder anyone else has encountered other than the values -1,0 for mysql_query(). 3. I will try our the option suggested by you for mysql_real_connect(); 3. Another thing does mysql_api has any provision to send the error messages to the log files. Regards, Ravi --- Paul DuBois [EMAIL PROTECTED] wrote: At 8:13 PM +0100 5/3/01, VVM Ravikumar Sarma Chengalvala wrote: Hi, 1. I am using C_API for accessing data from MYSQL. 2. mysql_query() function returns the following values: 0 if the query is successful -1 if the query fails. No. It returns 0 if the query is successful and NON-ZERO if it fails. You cannot count on the non-zero value being -1. 3. At the same time mysql-C_API documentation specifies that it returns a non zero number if query is a failure.Does the function return any other values other than -1 if the query fails? Don't test for -1. Test for non-zero. 4. If I use the mysql_query() for INSERT or UPDATE statements I am facing the following problem: If the database column value I am trying to update is the same as the the value already existing in the database,then the mysql_query() returns 0 and the mysql_affected_rows() returns zero. It will be good if mysql_query either returns -1 for this case as the value being updated is same as that of existing one. Try setting the CLIENT_FOUND_ROWS option in your mysql_real_connect() call when you connect to the server and see what happens.. Regards, Ravi -- Paul DuBois, [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 Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 C API
At 3:03 PM +0100 5/4/01, VVM Ravikumar Sarma Chengalvala wrote: Hi PAUL, 1.Thanks for the mail. 2.Regarding the return values I wonder anyone else has encountered other than the values -1,0 for mysql_query(). You need to stop asking this question. The function is explicitly documented to say that it returns zero or non-zero, and the reason is precisely to keep people from trying to perform more specific tests. You cannot rely on anything more specific than zero or non-zero. 3. I will try our the option suggested by you for mysql_real_connect(); 3. Another thing does mysql_api has any provision to send the error messages to the log files. In general, no, because it's the client API. The logs are written by the server. Some errors are both logged by the server and cause a message to be returned to the client, but I don't think that's what you're asking? -- Paul DuBois, [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: auto_increment
Check out the myisamchk manual page and the --set-auto-increment[=value] flag. regards, thalis On Fri, 4 May 2001, Stefan Wehowsky wrote: Let´s say I got a column id that is of type tinyint and has the extra auto_increment. Let´s further say that I have 50 entries in that column. Now if I delete e.g. entry No. 30 and right after that add another entry without naming an id (for ist auto_increment) MySQL gives it the id 51 AND NOT 30 which leads to more and more gaps between the id´s. Is there anything i can do about that ? Best regards, Stefan Wehowsky - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Database size
Hi, I have a problem, my database has reached Linux Redhat 7.1 max file size. (2147483647 Bytes). Does eny one know what i can do to make a lager database. (lager filesystem) Thanks Erik Dhiin I myself run a 300Gb database on a Linux redhat 6.0 Machine. And it works fine. What you do is to read the manual about the CREATE TABLE RAIDTYPE = ... But before you do that you need to recompile using --with-raid, or download the -max version wich I think has the raid option. What the raid option do is to split the data files up into alot of smaller files (RAIDCHUNKS=XX) But only the datafile. Not the indexfile, with is my problem. So What I have done is to create my own indexfiles (its about 170 tables) and agve a realy simple key column (that isn't space comsuming in the index) I loose alot of performance in many of the serahces, but the searching in the indexfiles of my own I Can make a query over the 300Gb (about 4 500 000 000 rows) in about 2 sec, wich is ok for now. /roger - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: missing fields after load data from text file
I have a table with 62 fields, I loaded data into MYSQL table from text file using LOAD DATA INFILE...TERMINATE BY '|' ENCLOSED BY '!' After the load, I did a describe on that table, only the first 21 fields showed up. However, when I did SELECT on the missing fields, there were actually correct data in the fields. What went wrong? And how do I fix this problem? FC - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Open Source MySQL Appl. Dev Tools for W2K/NT?W98.
I will be having to develop a MySQL application on Windows 2000, NT, and/or Windows 98 system - no choice on the OS. What I would like to do is develop using Open Source tools instead of MS products like VB, etc. What tools are available? Thanks, J.T.Fowler 512-326-6371 [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
some question about create db
I have to create a database from an application (written in perl) how can I do? how can I create a db if the user is not a root? which command can I use? Thank you in advance, Mario. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Occasional hang of mysql
Sorry to say I can't help but am really interested in the resolution. If it helps the brains at all, I experience the same thing on the following system. mandrake 8 kernel 2.4.3 ReiserFS (mysql data on scsi drive, rest on an IDE) mysql .37 binary (couldn't get the source to compile) seems to have happened mostly when I hit it with over 50 users (using seige) on the site that's accessing it, although apache::DBI didn't let the process get over 40 to the various database's, then lowered that significantly). I also have no luck with a kill -9 on that last process. On 04 May 2001 14:37:02 +0400, Vinche wrote: Hi there! I encounterd with a problem recently. Mysql occasionally hangs so that it can't be killed with -SIGKILL, that is there is one thread persist after killall -9 mysqld and it can't be killed in any way. The only way to get mysql back to work is server reboot. I'm using mysql-3.23.37 on RedHat 6.2 linux kernel 2.4.3. It happens both on binary distribution and on myself compiled one. It can't be predicted and mysql can work the whole day without hang or it can hang in 5 minutes after reboot. Is there somebody that have the same troubles or maybe someone can help me. Thanks. Victor. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Errcode 28 then 122?
I looked through the mailing list archive for an answer to this, but I can't find a way around this problem. I have a table with about 225,000 records. I kept getting an out of disk space error when running this query: mysql select count(*),state from import_talents group by state; ERROR 3: Error writing file '/tmp/MYRuTInF' (Errcode: 28) Other people with this problem have been told to redirect their TMPDIR to another location. The /tmp is mounted on /: [root@www /]# df -a Filesystem 1k-blocks Used Available Use% Mounted on /dev/hda1 743466526930216536 71% / none 0 0 0 - /proc /dev/hda3 198601 43943154658 22% /var /dev/hda4 6901425849752 6051673 12% /home none 0 0 0 - /dev/pts My /home directory has about 6G, so I created a directory under there called /home/tempspace and chmod that directory 777. I changed /etc/rc.d/init.d/mysql to point the TMPDIR to this directory. Stop and Start mysql: mysql show variables; ++---+ | Variable_name | Value | ++---+ | back_log | 5 | | connect_timeout| 5 | | basedir| / | | datadir| /var/lib/mysql/ | | delayed_insert_limit | 100 | | delayed_insert_timeout | 300 | | delayed_queue_size | 1000 | | join_buffer| 131072| | flush_time | 0 | | key_buffer | 8388600 | | language | /usr/share/mysql/english/ | | log| OFF | | log_update | OFF | | long_query_time| 10| | low_priority_updates | OFF | | max_allowed_packet | 1048576 | | max_connections| 100 | | max_connect_errors | 10| | max_delayed_insert_threads | 20| | max_join_size | 4294967295| | max_sort_length| 1024 | | max_write_lock_count | 4294967295| | net_buffer_length | 16384 | | pid_file | /var/lib/mysql/mysqld.pid | | port | 3306 | | protocol_version | 10| | record_buffer | 131072| | skip_locking | ON| | skip_networking| OFF | | socket | /var/lib/mysql/mysql.sock | | sort_buffer| 2097144 | | table_cache| 64| | thread_stack | 65536 | | tmp_table_size | 1048576 | | tmpdir | /home/tempspace/ | | version| 3.22.32 | | wait_timeout | 28800 | ++---+ 37 rows in set (0.00 sec) Run the query again: mysql select count(*),state from import_talents group by state; ERROR 3: Error writing file '/home/tempspace/MYfZExbS' (Errcode: 122) Error 122 tells me that the USER LIMIT has been reached. (I'm on a Redhat Linux system). Well, let's check what the limit is: [root@www]$ ulimit unlimited Maybe the mysql has a limit? [root@www /]# su mysql [mysql@www /]$ ulimit unlimited Does anyone have a suggestion about what I'm doing wrong? This is a two-pronged I'm a Linux Newbie/Please rescue me from my ignorance type of question. Thank you, Richard [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: some question about create db
Might be a case of the blind leading the blind here (list folks: please correct me if I'm way off base ...) I believe that one way to do this would be to create a file with any SQL commands you want to run and then redirect it to mysql via back ticks: `mysql -uroot sql_command_file`; Normally, mysql expects a table listed after -uroot, but it might work if sql_command_file has 'create database db name here' in it. -Brian - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, May 04, 2001 8:34 AM Subject: some question about create db I have to create a database from an application (written in perl) how can I do? how can I create a db if the user is not a root? which command can I use? Thank you in advance, Mario. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Do You Yahoo!? Get 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: some question about create db
That's a good question and I need some help related to the same too. Usually I create scripts like: createSequences.sql, createTableX.sql, createTableY.sql, populateTableX,etc.. that are called by a script called makeDB.sql The way I run it in Oracle is: sqL @makeDB How can I do the same with mySQL??? What is the sintax for calling a script like these? Thanks siomara From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: some question about create db Date: Fri, 4 May 2001 17:34:59 +0200 I have to create a database from an application (written in perl) how can I do? how can I create a db if the user is not a root? which command can I use? Thank you in advance, Mario. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Newbie installation problems with Apache/MySQL/PHP under Linux
Rather than tell me my question is too far off-topic from MySQL list, would you please suggest another list that you know of? Thanks, but if you are willing to help, here is my problem: I'm attempting to get Apache, MySQL, and PHP working together on a RedHat Linux system that I have total control of. My PHP fasteasy book by Meloni and its associated CD-ROM have been anything but fasteasy. MySQL and Apache installations go beautifully. It's not till I try to rebuild PHP to use MySQL and to work with Apache as a dynamic server object (DSO) that everything falls apart. I've tried numerous distributions/versions, source versus RPMs, and every FAQ suggestion that I can find. Here is my latest error, and one that has surfaced under several variations of installations I've tried: After error-free rebuilds and installations of MySQL, Apache, and PHP, I attempt to restart apache (it worked before rebuilding PHP) using ./sbin/apachectl start command. I get this error message: Syntax error on line 26 of /usr/local/apache_1.3.3/etc/httpd.conf: Cannot load /usr/local/apache_1.3.3/libexec/libphp4.so int server: /usr/local/apache_1.3.3/libexec/libphp4so: undefined symbol: uncompress. ./sbin/apachectl start: httpd could not be started Line 26 just tells location of libphp4.so file. It's where it's supposed to be and seems OK except that it appears to have one (or more?) unresolved symbols. * Do I need to locate a pre-built version of libphp4.so and download it? If so, where might I find that? * Do I need to learn to rebuild libphp4.so from its source? If so, where might I learn to do that? And how come *I* need to do this when (according to PHP book and FAQs) other persons trying the same thing apparently don't have to do it? I know I'm going to love MySQL if I can just get it to start working with Apache and PHP. I would deeply appreciate any help you could offer. Thanks in advance! Kelly D. Carter // Director, Web Management Mercer University // Langdale // 1400 Coleman Avenue // Macon, GA 31207 478-301-5525 voice // 478-301-2313 fax [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: Open Source MySQL Appl. Dev Tools for W2K/NT?W98.
I use both MySQL winDOZE and the the Linux RH version with ASTA Servers sharing the databases between win machines , Linux and Palm. ASTA is not Freeware. But the MySQL Server that can connect to Win, Linux from a Win machine is as well as a few other cool tools. Cheers Mike -Original Message- FROM: Fowler, J.T. TO: [EMAIL PROTECTED] CC: J.T. Fowler DATE: Fri 5/4/01 9:18 SUBJECT: Open Source MySQL Appl. Dev Tools for W2K/NT?W98. I will be having to develop a MySQL application on Windows 2000, NT, and/or Windows 98 system - no choice on the OS. What I would like to do is develop using Open Source tools instead of MS products like VB, etc. What tools are available? Thanks, J.T.Fowler 512-326-6371 [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: 'Show' output
echo 'show blah blah blah' | mysql -u user -ppassword /directory/filename Tim wrote: Is there any way to redirect the output of a 'Show' command to a text file?? I know you can do this with a SELECT sql statement... -TIM - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 query?
On Fri, 04 May 2001, Roger Karnouk wrote: Something like this should work: select ip, mac, count(mac) from ipmac group by ip,mac having count(mac) 1 hope this helps Yes! Thanks Roger - this is just the thing. group by ip, mac having count(mac) 1 returns nothing, but if we use group by mac having count(mac) 1 Then we get the number of different mac's using an ip. Can then query the mac for different IP's used. It would be nice to roll it all into one query and I'll work on that. Thanks again. -- Best regards, Tony Hunter - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
help with libmysqlclient.so
Hi, I have recently installed mysql-3.23.29a-gamma on Solaris 2.8. This works fine but I am having problems installing the Msql-Mysql Perl module. This makes but bombs out during testing with what seems to be a fairly common error (I've been scouring email lists)... Can't load '../blib/arch/auto/DBD/mysql/mysql.so'for module DBD::mysql: ld.so.1: ../../perl: fatal: relocation error: file ../blib/arch/auto/DBD/mysql/mysql.so: symbol uncompress: referenced symbol not found at ../../lib/DynaLoader.pm line 206. It seems that the reference to mysql.so in fact means libmysqlclient.so with the solution being to move this file into the library path for shared libraries. My problem is that libmysqlclient.so has not installed. I've checked carefully with find / -name 'libmysqlclient*' but all this finds is the static library libmysqlclient.a. I've tried to build the module using the this static library... perl Makeperl.PL --static --config (perl is 5.6 which seems fine) but it still looks for the shared library. I'm probably doing something totally silly but if not can anyone help? Is it possible to download libmysqlclient.so (I've seen it for Linux - as part of an RPM (?) package - but not for Solaris)? Or is there a patch? Any help will be much appreciated. Tony -- __ Tony Austin http://ads.ahds.ac.uk/project/staff.html Computing Officer Archaeology Data Service The King's Manor York YO1 7EP UK phone +44 (0)1904-433975 fax +44(0)1904-433939 http://ads.ahds.ac.uk/catalogue/ __ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: 'Show' output
On Fri, May 04, 2001 at 01:48:59PM -0400, Tim wrote: Is there any way to redirect the output of a 'Show' command to a text file?? I know you can do this with a SELECT sql statement... tee somefile show tables; notee -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 121 days, processed 750,651,248 queries (71/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: running mysql as different users
the script. However, after that, I could not run mysql as root or mysql. It gave me the same error message as it could not connect to local MySQL server through /var/lib/mysql/mysql.sock. /etc/my.cnf might have a line giving the uri above. Mysql.sock normally lives in /tmp change my.cnf accordingly.. or create one.. I assume your mysql server is up and running.. if it isn't start it first.. 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: Open Source MySQL Appl. Dev Tools for W2K/NT?W98.
try http://www.nusphere.com Curtis On Fri, 4 May 2001, Fowler, J.T. wrote: I will be having to develop a MySQL application on Windows 2000, NT, and/or Windows 98 system - no choice on the OS. What I would like to do is develop using Open Source tools instead of MS products like VB, etc. What tools are available? Thanks, J.T.Fowler 512-326-6371 [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Aggregate string values
Hello, I was wondering if there is a way to aggregate string values when grouping together results. I guess what I'm looking for is the string version of the SUM() function. Is there such a thing in MySQL? Thanks. Joel
Re: database problems
Shut down the server before repairing tables. Robert Clugston wrote: List, I'm having some serious problems with MySQL. I have some PHP and perl scripts that do INSERTs into MySQL. Multiple times during the day various tables become corrupted. Repairing the table using myisamchk with -r usually fixes the problem, but sometimes I have to restart mysqld to get things working again. Any ideas as to what is going on or how to fix this? /var/site/mysql/libexec/mysqld -V /var/site/mysql/libexec/mysqld Ver 3.23.36 for unknown-openbsd2.7 on i386 /var/site/mysql/bin/myisamchk: ISAM file /var/site/mysql/var/MailingList/MailingList.MYI /var/site/mysql/bin/myisamchk: error: Size of datafile is: 280400 Should be: 281328 /var/site/mysql/bin/myisamchk: error: Found key at page 38912 that points to record outside datafile /var/site/mysql/bin/myisamchk: error: Record-count is not ok; is 4723 Should be: 4738 /var/site/mysql/bin/myisamchk: warning: Found 4723 parts Should be: 4738 parts MyISAM-table '/var/site/mysql/var/MailingList/MailingList.MYI' is corrupted Fix it using switch -r or -o /var/site/mysql/bin/myisamchk: ISAM file /var/site/mysql/var/bob/announcements_mailinglist.MYI /var/site/mysql/bin/myisamchk: error: Size of datafile is: 203460 Should be: 204312 /var/site/mysql/bin/myisamchk: error: Found key at page 38912 that points to record outside datafile /var/site/mysql/bin/myisamchk: error: Record-count is not ok; is 4783 Should be: 4804 /var/site/mysql/bin/myisamchk: warning: Found 4783 parts Should be: 4804 parts MyISAM-table '/var/site/mysql/var/bob/announcements_mailinglist.MYI' is corrupted Fix it using switch -r or -o /var/site/mysql/bin/myisamchk: ISAM file /var/site/mysql/var/bob/contest.MYI /var/site/mysql/bin/myisamchk: error: Size of datafile is: 195772 Should be: 196040 /var/site/mysql/bin/myisamchk: error: Found key at page 35840 that points to record outside datafile /var/site/mysql/bin/myisamchk: error: Record-count is not ok; is 4358 Should be: 4364 /var/site/mysql/bin/myisamchk: warning: Found 4358 parts Should be: 4364 par ts MyISAM-table '/var/site/mysql/var/bob/contest.MYI' is corrupted Fix it using switch -r or -o /var/site/mysql/bin/myisamchk: MyISAM file /var/site/mysql/var/bob/bob_eval.MYI /var/site/mysql/bin/myisamchk: warning: 1 clients is using or hasn't closed the table properly /var/site/mysql/bin/myisamchk: error: Size of datafile is: 3276 Should be: 3344 /var/site/mysql/bin/myisamchk: error: Found key at page 1024 that points to record outside datafile /var/site/mysql/bin/myisamchk: error: Record-count is not ok; is 96 Should be: 98 /var/site/mysql/bin/myisamchk: warning: Found 96 parts Should be: 98 parts MyISAM-table '/var/site/mysql/var/bob/bob_eval.MYI' is corrupted Fix it using switch -r or -o - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Gerald L. Clark [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: 'Show' output
On your mysql monitor do: mysql tee filename.out This will redirect everhting to filename.out besides ptinting it to the screen. Alternatively from you shell: $ echo show status;|mysql -u thalis -p lala filename.out regards, thalis On Fri, 4 May 2001, Tim wrote: Is there any way to redirect the output of a 'Show' command to a text file?? I know you can do this with a SELECT sql statement... -TIM - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Aggregate string values
On Fri, 4 May 2001, Joel Desamero wrote: Hello, I was wondering if there is a way to aggregate string values when grouping together results. I guess what I'm looking for is the string version of the SUM() function. Is there such a thing in MySQL? Thanks. No. You could write your UDF and take it public as well :o) cheers, thalis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: database problems
I have a similar problem to this.. What happens is somehow something is causing mysql to hang which forces it to reach max connections.. if i shutdown and restart mysql using safe_mysqld --skip=networking it starts fine.. will do selects fine but not inserts because the tables that were being inserted to while the hang caught have become currupted.. I shutdown mysql, myisamchk -r the tables, it reports the tables were fixed. I then restart mysql and when trying to insert into the fixed table it just hangs forever.. if i do a drop on the table and recreate it it goes back to working fine.. so it seems the myisamchk is not fixing the tables.. any clues? -- Webmaster AngelHaven.com Gerald Clark wrote: Shut down the server before repairing tables. Robert Clugston wrote: List, I'm having some serious problems with MySQL. I have some PHP and perl scripts that do INSERTs into MySQL. Multiple times during the day various tables become corrupted. Repairing the table using myisamchk with -r usually fixes the problem, but sometimes I have to restart mysqld to get things working again. Any ideas as to what is going on or how to fix this? /var/site/mysql/libexec/mysqld -V /var/site/mysql/libexec/mysqld Ver 3.23.36 for unknown-openbsd2.7 on i386 /var/site/mysql/bin/myisamchk: ISAM file /var/site/mysql/var/MailingList/MailingList.MYI /var/site/mysql/bin/myisamchk: error: Size of datafile is: 280400 Should be: 281328 /var/site/mysql/bin/myisamchk: error: Found key at page 38912 that points to record outside datafile /var/site/mysql/bin/myisamchk: error: Record-count is not ok; is 4723 Should be: 4738 /var/site/mysql/bin/myisamchk: warning: Found 4723 parts Should be: 4738 parts MyISAM-table '/var/site/mysql/var/MailingList/MailingList.MYI' is corrupted Fix it using switch -r or -o /var/site/mysql/bin/myisamchk: ISAM file /var/site/mysql/var/bob/announcements_mailinglist.MYI /var/site/mysql/bin/myisamchk: error: Size of datafile is: 203460 Should be: 204312 /var/site/mysql/bin/myisamchk: error: Found key at page 38912 that points to record outside datafile /var/site/mysql/bin/myisamchk: error: Record-count is not ok; is 4783 Should be: 4804 /var/site/mysql/bin/myisamchk: warning: Found 4783 parts Should be: 4804 parts MyISAM-table '/var/site/mysql/var/bob/announcements_mailinglist.MYI' is corrupted Fix it using switch -r or -o /var/site/mysql/bin/myisamchk: ISAM file /var/site/mysql/var/bob/contest.MYI /var/site/mysql/bin/myisamchk: error: Size of datafile is: 195772 Should be: 196040 /var/site/mysql/bin/myisamchk: error: Found key at page 35840 that points to record outside datafile /var/site/mysql/bin/myisamchk: error: Record-count is not ok; is 4358 Should be: 4364 /var/site/mysql/bin/myisamchk: warning: Found 4358 parts Should be: 4364 par ts MyISAM-table '/var/site/mysql/var/bob/contest.MYI' is corrupted Fix it using switch -r or -o /var/site/mysql/bin/myisamchk: MyISAM file /var/site/mysql/var/bob/bob_eval.MYI /var/site/mysql/bin/myisamchk: warning: 1 clients is using or hasn't closed the table properly /var/site/mysql/bin/myisamchk: error: Size of datafile is: 3276 Should be: 3344 /var/site/mysql/bin/myisamchk: error: Found key at page 1024 that points to record outside datafile /var/site/mysql/bin/myisamchk: error: Record-count is not ok; is 96 Should be: 98 /var/site/mysql/bin/myisamchk: warning: Found 96 parts Should be: 98 parts MyISAM-table '/var/site/mysql/var/bob/bob_eval.MYI' is corrupted Fix it using switch -r or -o - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Gerald L. Clark [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 -- Sign up for your free AngelHaven E-mail Today... Join the growing community, http://www.AngelHaven.com Come Cruisin with the Angels http://www.AngelCruise.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:
mysql install problem
Hi: I tried to install mysql on my machine. So I download the binary tarball and proceed according to the instruction in the INSTALL file (same problem happened for two different versions that I tried). However, when I tried to run the last step bin/safe_mysqld --user=mysql . It says mysqld ended and just hangs there. Nothings seems to be happening. Can someone tell me what's going on? Thank you very much. Xiaowu Xiaowu Gai 2104 Molecular Biology Building Department of Zoology Genetics Iowa State University Ames, IA 50010 Tel: (515)-2940022 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Result: Got error -1 from table handler
Hi, What's the meanning of this error? Message: General error: Got error -1 from table handler SQLState: S1000 ErrorCode: 1030 Thank you Carlos Godoy
Question.
Hi! Peter == Peter Zaitsev [EMAIL PROTECTED] writes: Peter Hello mysql, Peter Any ideas how this may happen: Peter Mysql version 3.23.37, auto recovery turned on. mysql check table layers_st50.g00stat_sitepaths; Peter +---+---+--++ Peter | Table | Op| Msg_type | Msg_text | Peter +---+---+--++ Peter | g00stat_sitepaths | check | warning | Table is marked as crashed | Peter | layers_st50.g00stat_sitepaths | check | status | OK | Peter +---+---+--++ Peter 2 rows in set (24.32 sec) Peter Also I would report the folowing problem with auto recovery: Peter If auto recovery fails because of out of disk space problem, the Peter behavior is not mysql default (to wait until there are some space) but Peter the table becomes dammaged and is not retried to be recovered even Peter disk space is freeed. Because repair, recovery and optimize may use a LOT of disk space we did a long time ago define that when any of the above options are run, MySQL will when out of disk stop the operation at once, remove the big temporary files and mark the table as crashed. We thought this was better than let the recovery use up all disk space this way crash the whole system. I will add a note to the documentation about this! Regards, Monty - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MYISAM recovery.
Hi! Peter == Peter Zaitsev [EMAIL PROTECTED] writes: Peter Hello mysql, Peter It seems like mysql sometimes tries to hard to repair the table with Peter myisam tables with fixed row format. Peter I've had a chance to several times found data in one of the tables Peter completely destroyed - the data looked like random. mysql select * from g01layers_stat_cities limit 10; Peter ++--++++++ Peter | id | type | begin | counter| last | last_hit | page_group | Peter ++--++++++ Peter | 539167267 | 84 | 20231203141129 | 1920234272 | 20320611141829 | 1713399154 |111 | Peter | 1650553888 | 108 | 20241103100405 | 1684091184 | 20311128204214 | 1936291423 | 39 | Peter | 1124731427 | 82 | 20061110120717 | 577632 | 20241029051540 | 1684091184 |118 | Peter | 1985967218 | 105 | 19750527085147 | 1684611104 | 20311125200848 | 691024168 | 32 | Peter | 1734964078 | 110 | 20110715200141 | 1310741583 | 19870304184629 | 1869903201 | 95 | Peter | 1701995374 | 109 | 19930820102541 | 1663049738 | 20311125210119 | 1767862885 |100 | Peter | 678719081 | 49 | 20320408165928 | 1734964078 | 19870323012758 | 1095124292 | 85 | Peter | 807870548 | 39 | 20141028110448 | 1280658976 | 19870113150012 | 544437280 |116 | Peter | 1953719661 | 97 | 19960219154325 | 170666292 | 20340728025216 | 1948280176 |105 | Peter | 1953393017 | 40 | 20320408165931 | 1734964078 | 19870323012758 | 1095124292 | 85 | Peter ++--++++++ Peter 10 rows in set (0.00 sec) Peter It did't look like a possible bug in mysql so I checked other thing. I Peter took a table and completely replaced the data file with over file Peter which is not connected with mysql in any way, really it was a Peter mysqldump output for one of the databases and mysql was easily Peter able to repair the same way as it repairs a bit damaged tables - some Peter of duplicate key records there removed but it looked quite normal. Peter Of couse I had a trash in a file afterwards. Peter I don't have good solution for this yet, but it's not quite nice Peter behavior :) In a fixed format file, all rows are stored after each other; No row markers, no checksums... This is very fast an efficient and pretty secure. The bad thing with this is that if you somehow get bad data in the table, then MySQL has no way of knowing if the data is a correct row or not. Regards, Monty - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Question
Hello all, mysql uses only one index for the entire execution of a query? i.e. if it uses one index to do the row retrieval because it matches the where criteria but then has to sort these rows on something else that would benefit from index, would mysql use this index? tia, thalis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 a simple select
Hi all, I am able to show all the table in a database but when I try a simple selct in one of the table I get the following mysql show tables; +-+ | Tables_in_bugunison | +-+ | attachments | | bugs| | bugs_activity | | cc | | components | | dependencies| | fielddefs | | groups | | keyworddefs | | keywords| | logincookies| | longdescs | | milestones | | namedqueries| | products| | profiles| | profiles_activity | | shadowlog | | versions| | votes | | watch | +-+ 21 rows in set (0.00 sec) mysql select * from versions; ERROR 1017: Can't find file: './bugunison/versions.frm' (errno: 13) mysql Can someone help fix this issue??? Thanks Siomara _ 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