Mysql user
Hi all, Can any one tell me the command to list all mysql users ??? Thanks in advance Binay
Mysql user
Hi all, Can any one tell me the command to list all mysql users ??? Thanks in advance Binay
RE: Mysql user
Hi Binay, Use the mysql client to open the mysql database. For example, enter the following at the mysql prompt: use mysql Then type: select * from user; Bob -Original Message- From: Binay [mailto:[EMAIL PROTECTED] Sent: Friday, December 05, 2003 12:26 AM To: mysql users Subject: Mysql user Hi all, Can any one tell me the command to list all mysql users ??? Thanks in advance Binay -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Large data set load and access
[EMAIL PROTECTED] wrote: Thanks for the heads up on this. Unfortunately the only varchar is the gbl_locus field, so I'm not sure how much this would by me for the space. Thanks again, Brad Eacker ([EMAIL PROTECTED]) No, it wouldn't save you any space. It would make your file a little bigger on the drive. varchar is a variable length field. As you've got it now, if you store a 10 byte string in that field, it'll only take up something like 14 bytes. If you store 1 character, it'll take up 5 bytes. So you are currently saving a little space. BUT! Variable length fields slow Mysql down a little bit when it's reading the table, since Mysql needs to read in each record completely to get to the next record. If you have no variable length fields, then mysql can calculate right away the starting position of any record based on the fixed record size. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Licence question
Ivan Cukic wrote: 1. Free use for those who are 100% GPL 2. Free use for those who never copy, modify or distribute 3. Commercial use for everyone else Strange thing: How can SUSE redistribute mySQL when it is not 100% GPL? (It has MPL, ... also, beside commercial programs) Ivan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Mysql user
Binay wrote: Hi all, Can any one tell me the command to list all mysql users ??? Thanks in advance Binay use mysql; select User from user; Ivan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Importing data
Hi all, How can i import table structure and data which is there in a text file to database say test_database using phpmyadmin. I m asking using phpMyadmin as i don have shell access and hence can't use mysql commands. Plz help me ... its very urgent .. Thanks in advance Binay
Re: Installation Problem
Hi. Thanks for the prompt reply. It seems strange that the installation procedure should include an instruction that requires a password with no indication that one is required (i.e. there is no -p in the command sequence). Reading through Mark Liyanage's installation instructions, I notice that the second command ( /usr/local/mysql/bin/mysqladmin -u root -h localhost password mysql) is not included. Your recommended instruction to set the password from inside MySQL (GRANT ALL ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY 'newpassword') worked fine. My (perceived) problem with the PowerBook is that when at work the PowerBook is connected to a server via an Ethernet connection - the server then gives the PowerBook a hostname which is different from that when I have the PowerBook at home (and not networked): in both locations `hostname` gives different results. Could I set-up a root user (or any other user) with the '@%' hostname ? I would hope to read through the Reference Manual, but at 800 - 1000 pages, I thought I might wait for the video :) Many thanks, Cheers, Alex Brown MRC-T. On Wednesday, December 3, 2003, at 09:39 PM, Michael Stassen wrote: Alex Brown wrote: Hi. I installed MySQL on a Mac (OS 10.1) a while ago with the good intension of learning to use, and using, MySQL, but other things got in the way. However, I have finally found some time (so far) and I am now trying to install the latest version of MySQL (4.0.16) onto OSX 10.2 (on an iMAC G4), and I must admit to having run into a problem ( I have a vague recollection of having problems before). I have a similar setup: 4.0.16 on 10.2.8 on an iMac G3. I downloaded the installation file mysql-standard-4.0.16.dmg from the MySQl web site as recommended by Mark Liyanage, and followed the installation instructions given in the README. All was fine until I reached the point where the root password is set - the following is what happened [blah:~] alexbrown% /usr/local/mysql/bin/mysqladmin -u root password mysql This set the password for [EMAIL PROTECTED] to mysql. (I hope that's not the real password.) [blah:~] alexbrown% /usr/local/mysql/bin/mysqladmin -u root -h `hostname` password mysql /usr/local/mysql/bin/mysqladmin: connect to server at 'blah.local.' failed error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)' The error says that you are connecting as [EMAIL PROTECTED], but you didn't supply the password, which is needed because you just set it in the first step. [blah:~] alexbrown% /usr/local/mysql/bin/mysqladmin -u root -h localhost password mysql /usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)' Same here. The last command I got from the searchable Reference Manual, from a posting made by briantrino. Could someone please explain. I must admit that the program is running, and I have four users, two of whom are 'root', one on 'localhost' with a password and the other on 'blah.local.' with no password. The other two users have no user-name or password. Can I set the password for the other 'root' (on 'blah.local.') fromiside MySQL ? What are the other two unnamed users ? Yes, you can do this within mysql. Use mysql -u root -p mysql to log into mysql as [EMAIL PROTECTED] You'll be prompted for the password. Use the one you set in step 1. Then enter GRANT ALL ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY 'newpassword' Replace newpassword with the password you want for [EMAIL PROTECTED] The two users with empty username and password fields are the anonymous user, one for localhost, one for external access. If you do not need them, you can safely delete them. (I'd definitely get rid of the external anonymous user.) For more detailed info, see MySQL User Account Management http://www.mysql.com/doc/en/User_Account_Management.html in the manual. I am hoping to install MySL onto a PowerBook G4. The above problem may more obvious here as the 'host' can appear to change depending on whether the PowerBook is on the internet or not. Note that you don't actually need a [EMAIL PROTECTED] account if you connect from localhost. You only need a [EMAIL PROTECTED] account if you want that user to be able to connect from the named external host. I hope this all make some sense, and that someone can help. Many thanks in advance, You're welcome. Alex Brown MRC-T. Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
4.1.0 - 4.1.1 = Unknown character set: 'latin1_swedish_ci'
I have upgraded from MySQL (rpm) 4.1.0 to 4.1.1 and now I see lots of lines in the error log with: Unknown character set: 'latin1_swedish_ci' How can I fix this? Regards Jacob -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
setting values to default w/ null
hi i'm trying to get musql to insert the default values into a table. from the insert section in the manual: Warnings can occur under any of the following conditions: * Inserting NULL into a column that has been declared NOT NULL. The column is set to the default value appropriate for the column type. This is 0 for numeric types, the empty string ('') for string types, and the ``zero'' value for date and time types. for myisam tables, nulls are handled as above, so how does one get the default value set to a column? i know that if a column name is missing in a insert statement then it get assigned to default value. is there any way to SET it to the dafault value in an UPDATE query? so one could use a function like: switch ($type) { case text: $var = ($var != ) ? ' . $var . ' : NULL; break; (etc.) and replace the null with DEFAULT so that when mysql sees the keyword, it sets that column's value to the column's default (and not the column type's default) ty abs Download Yahoo! Messenger now for a chance to win Live At Knebworth DVDs http://www.yahoo.co.uk/robbiewilliams -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
DELETE on a huge table; how long *should* it take?
Hello, I have quite a large table, 45 million rows, which has 3 indexes on it. The rows are evenly distributed across one particular index, which records the time the row was inserted. At any given time there's between 20 and 21 days worth of rows, and every night I delete anything over 20 days. So I'm deleting about 2.2 million rows, with what is basically: DELETE QUICK from table WHERE indexed_row UNIX_TIMESTAMP()-86400 I have PACK_KEYS=1 DELAY_KEY_WRITE=1, and this ia MyISAM table. Now, roughly, should this take half an hour or more? It seems very disk bound, producing lots of small disk transactions. I wouldn't really mind, but the entire table is locked for the process and the site it's powering grinds to a halt. My first thought is to change it to InnoDB and use a transaction so the delete can take as long as it wants without interrupting anything else. I am however I bit worried about space; the MyISAM files are using 5G for data + 763M for index; it's only an 18G drive thus I'm a bit worried the InnoDB equivalent is going to be too big. Any other pointers, speedup tips, ways to avoid this issue entirely? -- Chris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Subquery ( show columns from...)
Hi all, I was wondering is it possible to use SHOW COLUMNS FROM tbl_name as a subquery. I tried something like this ( w/o success ): SELECT * FROM tbl1 INNER JOIN (SHOW COLUMNS FROM tbl2) AS t2 WHERE t1.ID =t2.field; or SELECT field FROM (show columns from Research.idefix); Teemu -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Optimization on query with WHERE, GROUP BY and ORDER BY
Hi, I have a table with about 500 000 rows and need to execute a query with first a WHERE then a GROUP BY and then ORDER BY all on different columns is their any way to optimize this? The table can look something like this: row_id INT PRIMARY KEY where_column SET('a','b','c') groupby_column VARCHAR(255) orderby_column DATE .. more rows that I need to fetch with the select. I have one index on each of the rows. The query can look like this: SELECT * FROM my_table WHERE FIND_IN_SET('a',where_column) GROUP BY groupby_column ORDER BY orderby_column DESC,row_id This is what I have tried but not seen any dramaticly speed improvements with: I have tried but I can't get mysql to use one index only. A also get that mysql uses temp tables and also store them disk. I have raised tmp_table_size without any success. I have experimented with sort_buffer_size, read_rnd_buffer_size, key_buffer_size. First only fetching the row_id (PRIMARY KEY) and then fetch the rows. This is a bit faster. Thanks for your help. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Optimization on query with WHERE, GROUP BY and ORDER BY
Hello, On Fri, Dec 05, 2003 at 12:02:05PM +0100, Martin Gillstr?m wrote: The table can look something like this: row_id INT PRIMARY KEY where_column SET('a','b','c') groupby_column VARCHAR(255) orderby_column DATE .. more rows that I need to fetch with the select. This is what I have tried but not seen any dramaticly speed improvements with: I have tried but I can't get mysql to use one index only. A also get that mysql uses temp tables and also store them disk. I have raised tmp_table_size without any success. I have experimented with sort_buffer_size, read_rnd_buffer_size, key_buffer_size. As I understand it, you can't get MySQL to use an index for sorting and grouping if you're sorting and grouping on a different row. This one bites me too, and forces me to live with a using temporary; using filesort query on one of my biggest busiest tables. -- Chris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL 4.1.1 is released
For those who are interested like me: MySQL 4.1.1 is released. Thanks, __ NZEYIMANA Emery Fabrice NEFA Computing Services, Inc. P.O. Box 5078 Kigali Office Phone: +250-51 11 06 Office Fax: +250-50 15 19 Mobile: +250-08517768 Email: [EMAIL PROTECTED] http://www.nefacomp.net/
RE: Importing data
[snip] How can i import table structure and data which is there in a text file to database say test_database using phpmyadmin. I m asking using phpMyadmin as i don have shell access and hence can't use mysql commands. [/snip] What format is the table structure in? As for the data it should be fairly straighht forward. Even as text it should be delimited (either by comma, tab, or other similar delimeter). Once the tables are created you can import in phpmyadmin by viewing the table properties page and clicking the 'Insert data from a textfile into table' link and following the directions. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Subquery ( show columns from...)
Teemu Kuulasmaa [EMAIL PROTECTED] wrote: I was wondering is it possible to use SHOW COLUMNS FROM tbl_name as a subquery. I tried something like this ( w/o success ): SELECT * FROM tbl1 INNER JOIN (SHOW COLUMNS FROM tbl2) AS t2 WHERE t1.ID =t2.field; or SELECT field FROM (show columns from Research.idefix); Nope. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Where to find MySQL-shared-compat-VERSION.i386.rpm ?
Hello, Please forgive me my newbee-question: Where can I find MySQL-shared-compat-VERSION.i386.rpm ? I have just installed MySQL 4.0 and an application requests libmysqlclient.so.10 Franz -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Tree-like structure: make it simply
how about recreating the table w/o the autoincrement, then reload the data, then alter table to reimplement the autoincrement? -Original Message- From: Matthew [mailto:[EMAIL PROTECTED] Sent: Thursday, December 04, 2003 7:12 PM To: Alex E.Wintermann; [EMAIL PROTECTED] Subject: Re: Tree-like structure: make it simply I think I can help with questions 1 and 3... see below, - Original Message - From: Alex E.Wintermann [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, December 04, 2003 11:44 PM Subject: Tree-like structure: make it simply Hello mysql, I have some table: /* BEGIN DUMP */ CREATE TABLE `sp_tovar_vid` ( `id` int(11) NOT NULL auto_increment, `id_tovar_vid` int(11) NOT NULL default '0', `name` varchar(100) NOT NULL default '', `description` varchar(255) NOT NULL default '', UNIQUE KEY `id` (`id`) ); INSERT INTO `sp_tovar_vid` VALUES (0, 0, 'root', 'root category'); INSERT INTO `sp_tovar_vid` VALUES (7, 0, 'cat.1', ''); INSERT INTO `sp_tovar_vid` VALUES (8, 0, 'cat.2', ''); INSERT INTO `sp_tovar_vid` VALUES (9, 0, 'cat.3', ''); INSERT INTO `sp_tovar_vid` VALUES (10, 0, 'cat.4', ''); INSERT INTO `sp_tovar_vid` VALUES (11, 0, 'cat.5', ''); INSERT INTO `sp_tovar_vid` VALUES (12, 7, 'subcat 1', '(to cat.1)'); INSERT INTO `sp_tovar_vid` VALUES (13, 7, 'subcat 2', '(to cat.1)'); INSERT INTO `sp_tovar_vid` VALUES (14, 7, 'subcat 3', '(to cat.1)'); INSERT INTO `sp_tovar_vid` VALUES (15, 9, 'subcat 1', '(to cat.3)'); INSERT INTO `sp_tovar_vid` VALUES (16, 9, 'subcat 2', '(to cat.3)'); INSERT INTO `sp_tovar_vid` VALUES (17, 9, 'subcat 3', '(to cat.3)'); INSERT INTO `sp_tovar_vid` VALUES (18, 13, 'subsubcat 1', '(to subcat.2 to cat.1)'); /* END DUMP / _QUESTION 1_: in what way should i run query to restore table with `id`' like in dump? (`id` is auto_increment) either omit the `id` field when re-loading the data, e.g. INSERT INTO `sp_tovar_vid` (`id_tovar_vid`,`name`,`description`) VALUES (0, 'root', 'root category'); or, replace the `id` values with an empty string when re-loading the table data, e.g. INSERT INTO `sp_tovar_vid` VALUES ('', 0, 'cat.1', ''); both techniques prompt mysql to reassign the `id` values. note that I do not think it is wise/possible to run a query to restore (or clean up) the auto_increment values without re-loading the table data. _QUESTION 2_: how to display table with columns= ('parent_category.name' ,'category.name')? i tried this: /***/ SELECT t1.`name`,t2.`name` FROM `sp_tovar_vid` AS t1, `sp_tovar_vid` AS t2 WHERE t1.`id`=t2.`id_tovar_vid` ORDER BY t1.`name`,t2.`name`; /***/ How to make it more simply? _QUESTION 3_: how to display string: subsubcat 1 - subcat.2 - cat.1 if we have only `id`=18 ? use SELECT IF(id=18, true_expression, false expression) FROM table... I'm not clear what you mean by subsubcat 1 - subcat.2 - cat.1... minus, or some sort of string concatenation? true expression might be field1 - field2, or CONCAT(field1, field2, ...) -- Best regards, Alex mailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Where to find MySQL-shared-compat-VERSION.i386.rpm ?
Look at http://www.mysql.com/downloads/mysql-4.0.html for Dynamic client libraries for your platform. Enjoy Nitin - Original Message - From: Franz Edler [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, December 05, 2003 6:25 PM Subject: Where to find MySQL-shared-compat-VERSION.i386.rpm ? Hello, Please forgive me my newbee-question: Where can I find MySQL-shared-compat-VERSION.i386.rpm ? I have just installed MySQL 4.0 and an application requests libmysqlclient.so.10 Franz -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: DELETE on a huge table; how long *should* it take?
Hi, You can do it in several smaller and faster deletes using the LIMIT option - for example DELETE QUICK from table WHERE indexed_row UNIX_TIMESTAMP()-86400 limit 1; HTH Dobromir Velev [EMAIL PROTECTED] - Original Message - From: Chris Elsworth [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, December 05, 2003 12:42 Subject: DELETE on a huge table; how long *should* it take? Hello, I have quite a large table, 45 million rows, which has 3 indexes on it. The rows are evenly distributed across one particular index, which records the time the row was inserted. At any given time there's between 20 and 21 days worth of rows, and every night I delete anything over 20 days. So I'm deleting about 2.2 million rows, with what is basically: DELETE QUICK from table WHERE indexed_row UNIX_TIMESTAMP()-86400 I have PACK_KEYS=1 DELAY_KEY_WRITE=1, and this ia MyISAM table. Now, roughly, should this take half an hour or more? It seems very disk bound, producing lots of small disk transactions. I wouldn't really mind, but the entire table is locked for the process and the site it's powering grinds to a halt. My first thought is to change it to InnoDB and use a transaction so the delete can take as long as it wants without interrupting anything else. I am however I bit worried about space; the MyISAM files are using 5G for data + 763M for index; it's only an 18G drive thus I'm a bit worried the InnoDB equivalent is going to be too big. Any other pointers, speedup tips, ways to avoid this issue entirely? -- Chris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: [OT] RE: New Microsoft Critical Patch
Furthermore, Microsoft will *not* email you about real critical updates either. The only way to get an email from Microsoft is to request support or to sign up for a mailing list. That's something they bring up at just about every Microsoft seminar these days. Thanks, Rob Brahier Web Architect Phone: x357 Email: [EMAIL PROTECTED] Special Notice: This email transmission may contain material, which is confidential under Florida statutes and is intended to be delivered only to the named addressee. This information belongs to our facility and is legally privileged. Unauthorized dissemination of this information may be a violation of criminal statutes. The recipient of this information is prohibited from disclosing, copying, distributing or using this information except as permitted by current government law governing privacy information issues. Such information must be destroyed after its stated need has been fulfilled, unless otherwise prohibited by law. If this information is received by anyone other than the named addressee, the recipient should immediately notify us at the address or telephone number shown and obtain instructions as to the disposal thereof. Under no circumstances should this material be read, retained, or copied by anyone other than the named addressee. -Original Message- From: Jakob Dölling [mailto:[EMAIL PROTECTED] Sent: Thursday, December 04, 2003 1:05 PM To: John Griffin Cc: [EMAIL PROTECTED] Subject: [OT] RE: New Microsoft Critical Patch Can we do anything about these? I am getting several of them a day. Do delete them WITHOUT having read them as soon as possible! Someone wants to abuse M$ Security issues for him/her and to infect your PC! These mails almost like M$, but only almost. Have close look at the sending address. If it really was from Mc$oft, the sender would have been something like [EMAIL PROTECTED] HTH, Jakob -- +++ GMX - die erste Adresse für Mail, Message, More +++ Neu: Preissenkung für MMS und FreeMMS! http://www.gmx.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Optimizing and repair impact
We have a database that supports our customers and runs pretty much 24/7/365. Obviously we need to keep this database healthy and optimized. I've read the official documentation and third party books on MySQL and they all are very good at explaining what should be done and how to do it but none that I can find explain the impact of running mysqlcheck commands on the other applications or user issuing reads and writes to the database at the same time. Is it prudent to set up a script that runs mysqlcheck on the whole database at a set time each week? Will users and applications be prevented from accessing tables for reads and writes while the mysqlcheck process is running or will they simply suffer a performance hit? Thanks, Jeff -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: fulltext search speed issue with SQL_CALC_FOUND_ROWS
Hi! On Dec 04, tk wrote: Hello, Thanks for the response. There is one thing that is not clear however. Regardless of whether or not I perform the fulltext search with or without the SQL_CALC_FOUND_ROWS keyword, the results that I get are exactly the same. Also, the notion of stopping after the limit is reached cannot apply in the fulltext search or otherwise we would only get the first 10 matches but not the first 10 most relevant matches. This leads me to believe that the fulltext search must be looking at all the rows in both cases since it otherwise would not find the same first 10 most relevant records. Hence the question why there should be a difference in time. The difference is that you only need to read 10 rows from the disk without SQL_CALC_FOUND_ROWS. With SQL_CALC_FOUND_ROWS MySQL goes on and reads all rows, it takes time. Finding relevant rows and sorting is based on index only, row data are not read. Regards, Sergei -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: fulltext search speed issue with SQL_CALC_FOUND_ROWS
Hi TK, There was an optimizer bug in MySQL 4.0 This bug is fixed in 4.0.17 (not yet released) # Fixed bug when the optimiser did not # take SQL_CALC_FOUND_ROWS into account # if LIMIT clause was present. (Bug #1274) Kind regards Gunnar -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Donnerstag, 4. Dezember 2003 16:13 To: [EMAIL PROTECTED] Subject: fulltext search speed issue with SQL_CALC_FOUND_ROWS I have some_table with 100,000 rows and with an average of 500 words in some_column of each row. When i do a fulltext search on this table using a query such as the following, all of my results are under 0.1 seconds: SELECT something FROM some_table WHERE MATCH (some_column) AGAINST ('some_search_term') LIMIT 0,10 However, when i add the SQL_CALC_FOUND_ROWS keyword like in the following query, some queries take longer than 1 minute: SELECT SQL_CALC_FOUND_ROWS something FROM some_table WHERE MATCH (some_column) AGAINST ('some_search_term') LIMIT 0,10 How can there be a huge difference in speed if both queries always return the exact same results? Thanks, TK -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Need help with query. Please!
I have the following 3 tables: table 1: companies fields 1: company_id, company name, status Sample data: 1 , company 1 , 0 2 , company 2 , 1 3 , company 3 , 1 4 , company 4 , 0 5 , company 5 , 1 table 2: groups fields 2: group_id, group_name Sample data: 1 , Group 1 2 , Group 2 3 , Group 3 4 , Group 4 5 , Group 5 table 3: company_group_intersect table 3: group_id, company_id Sample data: 1 , 2 1 , 3 2 , 2 2 , 3 2 , 5 As you can see, Group 1 consists of Companies 2 and 3. And Group 2 consists of Companies 2, 3 and 5. The query I'm having trouble with is trying to get a result set of (status=1) companies that AREN'T in a particular group. group_id is my only available variable passed in from the script. I need a results set that has: * companies.company_name, companies.company_id where companies.status='1' and companies.company_id is not in intersect table next to the variable group_id. If I pass in group_id 1 the result set should be: 5 , company 5 since it's the only status='1' company that's not in group 1 Thanks in advance for your help. Robert --- At Executive Performance Group we take security very seriously. All emails and attachments are scanned for viruses prior to sending. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.544 / Virus Database: 338 - Release Date: 11/25/2003 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Relationships
How do I create relationships between tables? I have tried but have no way of being sure that I am successful just by looking at the db. I am not sure how to relate one record in one table to it corresponding record in another. Mat -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
invalid compressed data ?
I am trying to untar the .gz but this is what I get. #tar xzvf mysql-standard-4.0.16-pc-linux-i686.tar.gz mysql-standard-4.0.16-pc-linux-i686/ mysql-standard-4.0.16-pc-linux-i686/bin/ mysql-standard-4.0.16-pc-linux-i686/bin/comp_err mysql-standard-4.0.16-pc-linux-i686/bin/replace mysql-standard-4.0.16-pc-linux-i686/bin/perror mysql-standard-4.0.16-pc-linux-i686/bin/resolveip mysql-standard-4.0.16-pc-linux-i686/bin/my_print_defaults gzip: stdin: invalid compressed data--format violated tar: Unexpected EOF in archive tar: Unexpected EOF in archive tar: Error is not recoverable: exiting now -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: fulltext search speed issue with SQL_CALC_FOUND_ROWS
Hello Sergei, Gunnar, and others, thank you for your quick responses. One little mystery remains: Why does one need to read all the row data (with SQL_CALC_FOUND_ROWS) to get the total number of results when using a limit? When the index is used to find relevant rows and sort the results, the code certainly must know how many total results there are. Could one not store the total while using the index and use select FOUND_ROWS() without SQL_CALC_FOUND_ROWS to retrieve the total? Thanks and regards, TK --- Sergei Golubchik [EMAIL PROTECTED] wrote: Hi! On Dec 04, tk wrote: Hello, Thanks for the response. There is one thing that is not clear however. Regardless of whether or not I perform the fulltext search with or without the SQL_CALC_FOUND_ROWS keyword, the results that I get are exactly the same. Also, the notion of stopping after the limit is reached cannot apply in the fulltext search or otherwise we would only get the first 10 matches but not the first 10 most relevant matches. This leads me to believe that the fulltext search must be looking at all the rows in both cases since it otherwise would not find the same first 10 most relevant records. Hence the question why there should be a difference in time. The difference is that you only need to read 10 rows from the disk without SQL_CALC_FOUND_ROWS. With SQL_CALC_FOUND_ROWS MySQL goes on and reads all rows, it takes time. Finding relevant rows and sorting is based on index only, row data are not read. Regards, Sergei __ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: 4.1.0 - 4.1.1 = Unknown character set: 'latin1_swedish_ci'
Jacob Friis Larsen [EMAIL PROTECTED] wrote: I have upgraded from MySQL (rpm) 4.1.0 to 4.1.1 and now I see lots of lines in the error log with: Unknown character set: 'latin1_swedish_ci' How can I fix this? Does 'latin1_swedish_ci' present in the output of SHOW COLLATION LIKE 'latin1%'? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Lost connection to MySQL server during query - pls help
At 14:14 5/12/2003 +0800, Kiky wrote: Hi Guys, I have a problem with Error 2013 - Lost connection to MySQL server during query I'm using mysql 3.23.41 under Linux Mandrake, and mysql 4.0.15 under Win XP Pro. They turn out to have the same error. Please upgrade you MySQL Windows client to 4.0.16 there is a bug with net_read_timeout and net_write_timeout on 4.0.15 that disconnect when the query takes more than 30 secons. -- Regards, For technical support contracts, visit https://order.mysql.com/ Are you MySQL certified?, http://www.mysql.com/certification/ Miguel Angel Solórzano [EMAIL PROTECTED] São Paulo - Brazil --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.547 / Virus Database: 340 - Release Date: 2/12/2003 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL 4.1.1 has been released
Hallo Lenz, From: Lenz Grimmer [mailto:[EMAIL PROTECTED] Any chance to offer binaries for PowerPC Linux as well ? (Preferable tgz) Yes, we plan to offer Linux/PPC binaries in the near future - we're currently working on purchasing a system for that. If you have some harddisk space left, then you can install Linux on one of your MACs. I have not decided which Linux Distribution to use, though - maybe Yellowdog? My recommendation would be, as always, Debian. :-) But thats a metter of taste. You can install nearly every distro on PPC. Good examples are: YellowDog, Mandrake, Red Hat, Suse, Gentoo, Debian Unfortunately my favourite Linux distribution (SuSE) does not support the PPC platform anymore :( SUSE has very good PPC support. IBM even recommands SUSE and RedHat together with their big POWER-machines. For PPC you need to use the SUSE Server version. I have tried Yellow Dog on one of my MACs. = the install was a piece of cake. On my Pegasos ( www.pegasosppc.com ) I'm very happy with Debian. The Pegasos is a really nice, geeky machine. With a Pegasos you could release binaries for MorphOS as well. :-) Kind regards Gunnar -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Need help with query. Please!
Try: SELECT C.company_id, C.company_name FROM companies C LEFT JOIN company_group_intersect CG ON (C.company_id=CG.company_id AND CG.group_id='1') WHERE C.status='1' AND CG.company_id IS NULL -- Diana Soares On Fri, 2003-12-05 at 15:08, Robert Hughes wrote: I have the following 3 tables: table 1: companies fields 1: company_id, company name, status Sample data: 1 , company 1 , 0 2 , company 2 , 1 3 , company 3 , 1 4 , company 4 , 0 5 , company 5 , 1 table 2: groups fields 2: group_id, group_name Sample data: 1 , Group 1 2 , Group 2 3 , Group 3 4 , Group 4 5 , Group 5 table 3: company_group_intersect table 3: group_id, company_id Sample data: 1 , 2 1 , 3 2 , 2 2 , 3 2 , 5 As you can see, Group 1 consists of Companies 2 and 3. And Group 2 consists of Companies 2, 3 and 5. The query I'm having trouble with is trying to get a result set of (status=1) companies that AREN'T in a particular group. group_id is my only available variable passed in from the script. I need a results set that has: * companies.company_name, companies.company_id where companies.status='1' and companies.company_id is not in intersect table next to the variable group_id. If I pass in group_id 1 the result set should be: 5 , company 5 since it's the only status='1' company that's not in group 1 Thanks in advance for your help. Robert --- At Executive Performance Group we take security very seriously. All emails and attachments are scanned for viruses prior to sending. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.544 / Virus Database: 338 - Release Date: 11/25/2003 -- Diana Soares -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re[2]: Tree-like structure: make it simply
Hello Matthew, Friday, December 5, 2003, 2:12:08 AM, you wrote: thanks, but some more see below. [skipped] I have some table: /* BEGIN DUMP */ CREATE TABLE `sp_tovar_vid` ( `id` int(11) NOT NULL auto_increment, `id_tovar_vid` int(11) NOT NULL default '0', `name` varchar(100) NOT NULL default '', `description` varchar(255) NOT NULL default '', UNIQUE KEY `id` (`id`) ); INSERT INTO `sp_tovar_vid` VALUES (0, 0, 'root', 'root category'); INSERT INTO `sp_tovar_vid` VALUES (7, 0, 'cat.1', ''); INSERT INTO `sp_tovar_vid` VALUES (8, 0, 'cat.2', ''); INSERT INTO `sp_tovar_vid` VALUES (9, 0, 'cat.3', ''); INSERT INTO `sp_tovar_vid` VALUES (10, 0, 'cat.4', ''); INSERT INTO `sp_tovar_vid` VALUES (11, 0, 'cat.5', ''); INSERT INTO `sp_tovar_vid` VALUES (12, 7, 'subcat 1', '(to cat.1)'); INSERT INTO `sp_tovar_vid` VALUES (13, 7, 'subcat 2', '(to cat.1)'); INSERT INTO `sp_tovar_vid` VALUES (14, 7, 'subcat 3', '(to cat.1)'); INSERT INTO `sp_tovar_vid` VALUES (15, 9, 'subcat 1', '(to cat.3)'); INSERT INTO `sp_tovar_vid` VALUES (16, 9, 'subcat 2', '(to cat.3)'); INSERT INTO `sp_tovar_vid` VALUES (17, 9, 'subcat 3', '(to cat.3)'); INSERT INTO `sp_tovar_vid` VALUES (18, 13, 'subsubcat 1', '(to subcat.2 to cat.1)'); /* END DUMP / [skipped] _QUESTION 2_: how to display table with columns= ('parent_category.name' ,'category.name')? i tried this: /***/ SELECT t1.`name`,t2.`name` FROM `sp_tovar_vid` AS t1, `sp_tovar_vid` AS t2 WHERE t1.`id`=t2.`id_tovar_vid` ORDER BY t1.`name`,t2.`name`; /***/ How to make it more simply? _QUESTION 3_: how to display string: subsubcat 1 - subcat.2 - cat.1 if we have only `id`=18 ? M use SELECT IF(id=18, true_expression, false expression) FROM table... M I'm not clear what you mean by subsubcat 1 - subcat.2 - cat.1... minus, or M some sort of string concatenation? M true expression might be field1 - field2, or CONCAT(field1, field2, ...) elucidation: i need to run recurse search to build string shown. it means: if we have `id`=18, we must build following string after mentioned recurse search runnnig. string: subsubcat 1 + subcat 2 + cat.1 + root it's tree: /**/ root (`id`=0, `parent`=0) |--cat.1 (`id`=7, `parent`=0) | |-subcat 1 | |--subcat 2 (`id`=13, `parent`=7) | | |-subsubcat 1 (`id`=18, `parent`=13) | |-subcat 3 |-cat.2 |--cat.3 | |-subcat 1 | |-subcat 2 | |-subcat 3 |-cat.4 |-cat.5 /**/ -- Best regards, Alexmailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Need help with query. Please!
That worked perfectly!!! Thanks so much :-) -Original Message- From: Diana Soares [mailto:[EMAIL PROTECTED] Sent: Friday, December 05, 2003 10:31 AM To: Robert Hughes Cc: [EMAIL PROTECTED] Subject: Re: Need help with query. Please! Try: SELECT C.company_id, C.company_name FROM companies C LEFT JOIN company_group_intersect CG ON (C.company_id=CG.company_id AND CG.group_id='1') WHERE C.status='1' AND CG.company_id IS NULL -- Diana Soares On Fri, 2003-12-05 at 15:08, Robert Hughes wrote: I have the following 3 tables: table 1: companies fields 1: company_id, company name, status Sample data: 1 , company 1 , 0 2 , company 2 , 1 3 , company 3 , 1 4 , company 4 , 0 5 , company 5 , 1 table 2: groups fields 2: group_id, group_name Sample data: 1 , Group 1 2 , Group 2 3 , Group 3 4 , Group 4 5 , Group 5 table 3: company_group_intersect table 3: group_id, company_id Sample data: 1 , 2 1 , 3 2 , 2 2 , 3 2 , 5 As you can see, Group 1 consists of Companies 2 and 3. And Group 2 consists of Companies 2, 3 and 5. The query I'm having trouble with is trying to get a result set of (status=1) companies that AREN'T in a particular group. group_id is my only available variable passed in from the script. I need a results set that has: * companies.company_name, companies.company_id where companies.status='1' and companies.company_id is not in intersect table next to the variable group_id. If I pass in group_id 1 the result set should be: 5 , company 5 since it's the only status='1' company that's not in group 1 Thanks in advance for your help. Robert --- At Executive Performance Group we take security very seriously. All emails and attachments are scanned for viruses prior to sending. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.544 / Virus Database: 338 - Release Date: 11/25/2003 -- Diana Soares -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.544 / Virus Database: 338 - Release Date: 11/25/2003 --- At Executive Performance Group we take security very seriously. All emails and attachments are scanned for viruses prior to sending. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.544 / Virus Database: 338 - Release Date: 11/25/2003 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Lost connection to MySQL server during query - pls help
[snip] Please upgrade you MySQL Windows client to 4.0.16 there is a bug with net_read_timeout and net_write_timeout on 4.0.15 that disconnect when the query takes more than 30 secons. [/snip] Can you elaborate on this, we have not seen this problem -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Lost connection to MySQL server during query - pls help
Kiky [EMAIL PROTECTED] wrote: I have a problem with Error 2013 - Lost connection to MySQL server during query I'm using mysql 3.23.41 under Linux Mandrake, and mysql 4.0.15 under Win XP Pro. They turn out to have the same error. My problem is: I have a Java program which is actually a thread to send emails, so it keeps running all the time. When it's time to send emails, it will access MySQL database. Based on my wait_timeout in mysql, I think the connection closes after 8 hrs. If it's the time to send emails, and mysql has already closed the connection, the first connection attemp will throw an error Error 2013 - Lost connection to MySQL server during query * Is there a way that I can avoid this error? Or to make the connection keeps open all the the time? You can increase value of wait_timeout variable. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Database Internals Engineer opportunity
Outstanding opportunity for someone in the San Diego area. Database Internals Engineer Successful candidate will be responsible for the architecture, design and implementation of a database engine and its interface with a variety of commercial databases. Responsibilities include authoring of specifications and design documents, evaluation of impacts on system performance and recommendations for improvements. Requires experience with SQL and relational databases (Oracle, Microsoft SQLServer etc.) including significant product experience with the internals (SQL query parsing, optimization, planning, execution and database API internal implementation).May also include technical direction and scheduling of less senior engineers. Apply on-line at: http://www.alcockmcfadden.com/k84.html Or send your resume to: [EMAIL PROTECTED]
RE: Lost connection to MySQL server during query - pls help
At 10:44 -0600 12/5/03, Jay Blanchard wrote: [snip] Please upgrade you MySQL Windows client to 4.0.16 there is a bug with net_read_timeout and net_write_timeout on 4.0.15 that disconnect when the query takes more than 30 secons. [/snip] Can you elaborate on this, we have not seen this problem See the Bugs fixed section of: http://www.mysql.com/doc/en/News-4.0.16.html -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Named Pipe crashes on MySQL (4.1.1 alpha) WinXP
At 19:04 4/12/2003 -0600, Matt W wrote: Hi, Named Pipe crashes on MySQL (4.1.1 alpha) WinXPI have been unable to get named pipes to work on mysqld-nt 4.1.1 Alpha(including today's official release). As soon as I attempt a connect the server crashes. I can't create a debug trace because named pipes aren't enabled during a --debug. I have enable-named-pipe turned on and my client is connecting with hostname of . notation. The last several weeks of bitkeeper source distributions haven't worked for me either. The last time I can confirm it worked for me was a bitkeeper source build I did on Sep 2 2003. Does anyone have an Alpha 4.1.1 working with named pipes on WinXP (DELL 2.6ghz, P4, 640mb ram, ServPack 1)? Thanks, Ed Mierzwa Thank you for the bug report I was able to repeat. Below the stack trace: () mysqld.exe!net_real_write(st_net * net=0x036ef04c, const char * packet=0x036f5b88, unsigned long len=74) Line 493 + 0x18 C++ mysqld.exe!net_flush(st_net * net=0x036ef04c) Line 233 + 0x1d C++ mysqld.exe!net_write_command(st_net * net=0x036ef04c, unsigned char command=' ', const char * header=0x008c51a8, unsigned long head_len=0, const char * packet=0x046efe24, unsigned long len=69) Line 350 + 0x79 C++ mysqld.exe!check_connection(THD * thd=0x036ef040) Line 722 + 0x2a C++ mysqld.exe!handle_one_connection(void * arg=0x036ef040) Line 916 + 0x9 C++ mysqld.exe!pthread_start(void * param=0x036e7fd0) Line 63 + 0x7C mysqld.exe!_threadstart(void * ptd=0x036f51c8) Line 173 + 0xd C kernel32.dll!77e6d33b() -- Regards, For technical support contracts, visit https://order.mysql.com/ Are you MySQL certified?, http://www.mysql.com/certification/ Miguel Angel Solórzano [EMAIL PROTECTED] São Paulo - Brazil --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.547 / Virus Database: 340 - Release Date: 2/12/2003 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Replication
Stefan: Thank you very much, I got the point. I'll make some tests with the 'log-slave-updates' parameter, I think if the master can log the updates made from any slave, then it can propagate the changes to the others. Regards From: Stefan Kuhn [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: rubn ruvalcaba [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: Replication Date: Wed, 3 Dec 2003 18:01:39 +0100 Am Wednesday 03 December 2003 18:21 schrieb rubn ruvalcaba: You guys are right, as Cuck said I need each machine acts as server and slave, I did it with two servers in a circular replication and works pretty fine, but when add a third machine, there comes the problems, because the central server must be the master (no problem) and the slave of two servers (here is the problem). If you want to do a circular replication, it needs to be like this: A is slave of B B is slave of C C is slave of A Important: You need to set log-slave-updates in my.cnf, so that B logs what it gets from C and A gets it then from B. I have such a configuration in production use and all works fine. Stefan P. S: Note your two server configuration is just a special case of this. From: Lloyd Kvam [EMAIL PROTECTED] To: Chuck Gadd [EMAIL PROTECTED] CC: rubn ruvalcaba [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: Replication Date: Wed, 03 Dec 2003 09:59:29 -0500 You can setup a circular replication stream. Make sure that the replicated data gets written to the output binlogs. From the manual: `log-slave-updates' Tells the slave to log the updates from the slave thread to the binary log. Off by default. You will need to turn it on if you plan to daisy-chain the slaves. Chuck Gadd wrote: rubn ruvalcaba wrote: I want to know how could solve the next replication scenario: I have a master. I have 5 slaves. At start the slaves has a master snapshot. Now imagine slave 1, inserts a record. When it gets connected to the lan, it must replicate it's changes to the master. No, a slave receives changes that occur at the master. That's why it's a slave. I suspect you want each machine to be a Master and a slave. -- Lloyd Kvam Venix Corp. 1 Court Street, Suite 378 Lebanon, NH 03766-1358 voice: 603-653-8139 fax: 801-459-9582 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] _ MSN. Más Útil Cada Día http://www.msn.es/intmap/ -- Stefan Kuhn M. A. Cologne University BioInformatics Center (http://www.cubic.uni-koeln.de) Zülpicher Str. 47, 50674 Cologne Tel: +49(0)221-470-7428 Fax: +49 (0) 221-470-7786 My public PGP key is available at http://pgp.mit.edu -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] _ Charla con tus amigos en línea mediante MSN Messenger: http://messenger.microsoft.com/es -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Installation Problem
Alex Brown wrote: Hi. Thanks for the prompt reply. It seems strange that the installation procedure should include an instruction that requires a password with no indication that one is required (i.e. there is no -p in the command sequence). Reading through Mark Liyanage's installation instructions, I notice that the second command ( /usr/local/mysql/bin/mysqladmin -u root -h localhost password mysql) is not included. I assume you are talking about the directions given at the end of the run of mysql_install_db. That script uses /bin/hostname to look up your mmachine's hostname. When setting up the user table, it creates an entry for [EMAIL PROTECTED] with no password and an entry for [EMAIL PROTECTED] with no password. At the end, it gives the instructions PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is done with: $bindir/mysqladmin -u root password 'new-password' $bindir/mysqladmin -u root -h your_hostname password 'new-password' See the manual for more instructions. where $bindir is the path to the mysql executables (/usr/local/mysql/bin, in our case). In theory, when you run the second command given, you will be connecting as [EMAIL PROTECTED] rather than [EMAIL PROTECTED], so no password will be needed because you haven't set it yet. (So far you've only set the password for [EMAIL PROTECTED], in the first command). I gather from your description that the second command was given to you as mysqladmin -u root -h localhost password 'new-password' This is redundant (it's equivalent to the first command) and won't work without the password you set in the first step. I have a suspicion that your /bin/hostname command is returning localhost instead of blah.local, or at least did so back when you ran mysql_install_db. The other possible complication here is that mysql_install_db won't mess with your user table if you already have one. This is a very good thing, but it sometimes bites people who, like you, installed mysql once before but didn't get very far, as the instructions assume the user table looks the way mysql_install_db creates it. Your recommended instruction to set the password from inside MySQL (GRANT ALL ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY 'newpassword') worked fine. My (perceived) problem with the PowerBook is that when at work the PowerBook is connected to a server via an Ethernet connection - the server then gives the PowerBook a hostname which is different from that when I have the PowerBook at home (and not networked): in both locations `hostname` gives different results. Could I set-up a root user (or any other user) with the '@%' hostname ? You shouldn't need a [EMAIL PROTECTED] account in mysql to connect to the mysql server on the same machine. Simply leave out the -h hostname when you connect, like this: mysql -u username -p This will prompt you for the password to connect as [EMAIL PROTECTED] You usually use the [EMAIL PROTECTED] account(s) to allow connections from other hosts. That said, you can set up mysql to work with your changing hostname if you want/need to. You can, as you suggest, use the wildcard '%' for the hostname, but that allows that user access from EVERYWHERE, leaving only the password as protection. A better idea would be to create [EMAIL PROTECTED] accounts with the hostname specified or constrained, so as to limit access to the named machines. Some possibilities: * If your PowerBook has 2 separate hostnames (1 at home, 1 at work), or you want to allow access from 2 specific external hosts, say host1 and host2, you can create a [EMAIL PROTECTED] account and a [EMAIL PROTECTED] account. * If your hostname varies somewhat (using DHCP, for example), or you want to give a user access from any machine in your domain, say 1.2.3.x, where x varies, you can create a [EMAIL PROTECTED] account. See section 4.4 in the manual for more details. http://www.mysql.com/doc/en/User_Account_Management.html I would hope to read through the Reference Manual, but at 800 - 1000 pages, I thought I might wait for the video :) It is huge, but I find reading the section relevant to my current task is usually quicker than figuring out what I did wrong. YMMV. Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
How do I convert MDF (MS SQL) to MySQL w/o having MS SQL?
I run a website using MySQL, PHP, and CFMX. Someone recently gave a data file to me that they'd like to access. The problem is that it appears to be from MS SQL. How can I convert/import this into MySQL? I did some searching and found MSSQL-to-MySQL, but this program requires that I have MSSQL server, which I don't. Any help would be appreciated. mg -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How do I convert MDF (MS SQL) to MySQL w/o having MS SQL?
there is a command but i didnt found it in the documentation. Try dump MS SQL database into a text file and then try mysqlimport. --- Mark Graves [EMAIL PROTECTED] wrote: I run a website using MySQL, PHP, and CFMX. Someone recently gave a data file to me that they'd like to access. The problem is that it appears to be from MS SQL. How can I convert/import this into MySQL? I did some searching and found MSSQL-to-MySQL, but this program requires that I have MSSQL server, which I don't. Any help would be appreciated. mg -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How do I convert MDF (MS SQL) to MySQL w/o having MS SQL?
..I don't have MSSQL Zenzo [EMAIL PROTECTED] 12/5/2003 2:30:44 PM there is a command but i didnt found it in the documentation. Try dump MS SQL database into a text file and then try mysqlimport. --- Mark Graves [EMAIL PROTECTED] wrote: I run a website using MySQL, PHP, and CFMX. Someone recently gave a data file to me that they'd like to access. The problem is that it appears to be from MS SQL. How can I convert/import this into MySQL? I did some searching and found MSSQL-to-MySQL, but this program requires that I have MSSQL server, which I don't. Any help would be appreciated. mg -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: How do I convert MDF (MS SQL) to MySQL w/o having MS SQL?
Ask the person who gave you the file to do the work. Give them a list of formats you can read (i.e. SQL, csv, etc.) and let them decide which of those formats they want to export into. John -Original Message- From: Mark Graves [mailto:[EMAIL PROTECTED] Sent: Friday, December 05, 2003 2:36 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: How do I convert MDF (MS SQL) to MySQL w/o having MS SQL? ..I don't have MSSQL Zenzo [EMAIL PROTECTED] 12/5/2003 2:30:44 PM there is a command but i didnt found it in the documentation. Try dump MS SQL database into a text file and then try mysqlimport. --- Mark Graves [EMAIL PROTECTED] wrote: I run a website using MySQL, PHP, and CFMX. Someone recently gave a data file to me that they'd like to access. The problem is that it appears to be from MS SQL. How can I convert/import this into MySQL? I did some searching and found MSSQL-to-MySQL, but this program requires that I have MSSQL server, which I don't. Any help would be appreciated. mg -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: How do I convert MDF (MS SQL) to MySQL w/o having MS SQL?
Do you only have the Microsoft DBF and ldf files? -Original Message- From: Mark Graves [mailto:[EMAIL PROTECTED] Sent: Friday, December 05, 2003 1:24 PM To: [EMAIL PROTECTED] Subject: How do I convert MDF (MS SQL) to MySQL w/o having MS SQL? I run a website using MySQL, PHP, and CFMX. Someone recently gave a data file to me that they'd like to access. The problem is that it appears to be from MS SQL. How can I convert/import this into MySQL? I did some searching and found MSSQL-to-MySQL, but this program requires that I have MSSQL server, which I don't. Any help would be appreciated. mg -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
replication question
Greetings, Firstly I have searched the archives and received exactly 0 results returned for 'START SLAVE 1064' so... I have a mysql server I wish to replicate, its running 3.23.54. I have two test FreeBSD 5.1 servers I installed and from ports version 3.23.58. I completed the following steps to setup replication. I followed the steps in the documentation on mysql.com, made the necessary my.conf modification, archived and imported my test db to the slave, defined the master config w/ 'change master to' on the slave. Everything worked well up to this point, but if I execute 'START SLAVE' on my slave I get ERROR 1064: You have an error in your SQL syntax near 'START SLAVE' at line 1 This tells me that my version of mysql does not support the 'START' command. Do I need to add something at compile time? Are the instructions only for 4.x? Am I just missing something really obvious? Thank you for your time in advance, Andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: replication question
Try slave start -Original Message- From: Andrew Hall [mailto:[EMAIL PROTECTED] Sent: Friday, December 05, 2003 2:46 PM To: [EMAIL PROTECTED] Subject: replication question Greetings, Firstly I have searched the archives and received exactly 0 results returned for 'START SLAVE 1064' so... I have a mysql server I wish to replicate, its running 3.23.54. I have two test FreeBSD 5.1 servers I installed and from ports version 3.23.58. I completed the following steps to setup replication. I followed the steps in the documentation on mysql.com, made the necessary my.conf modification, archived and imported my test db to the slave, defined the master config w/ 'change master to' on the slave. Everything worked well up to this point, but if I execute 'START SLAVE' on my slave I get ERROR 1064: You have an error in your SQL syntax near 'START SLAVE' at line 1 This tells me that my version of mysql does not support the 'START' command. Do I need to add something at compile time? Are the instructions only for 4.x? Am I just missing something really obvious? Thank you for your time in advance, Andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: replication question
DUH!! I should have tried that... Thank you! Drew On Fri, 2003-12-05 at 15:49, Victor Pendleton wrote: Try slave start -Original Message- From: Andrew Hall [mailto:[EMAIL PROTECTED] Sent: Friday, December 05, 2003 2:46 PM To: [EMAIL PROTECTED] Subject: replication question Greetings, Firstly I have searched the archives and received exactly 0 results returned for 'START SLAVE 1064' so... I have a mysql server I wish to replicate, its running 3.23.54. I have two test FreeBSD 5.1 servers I installed and from ports version 3.23.58. I completed the following steps to setup replication. I followed the steps in the documentation on mysql.com, made the necessary my.conf modification, archived and imported my test db to the slave, defined the master config w/ 'change master to' on the slave. Everything worked well up to this point, but if I execute 'START SLAVE' on my slave I get ERROR 1064: You have an error in your SQL syntax near 'START SLAVE' at line 1 This tells me that my version of mysql does not support the 'START' command. Do I need to add something at compile time? Are the instructions only for 4.x? Am I just missing something really obvious? Thank you for your time in advance, Andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Installation ERRORS MySql 3.23.51
I came across the following errors after install I am not able to start server from terminal (only progress i made was running as root NOT user) 1. ERROR: 1062 Duplicate entry 'localhost-root' for key 1 ERROR: 1062 Duplicate entry 'localhost-root' for key 1 2. WARNING: The host 'localhost' could not be looked up with resolveip. This probably means that your libc libraries are not 100 % compatible with this binary MySQL version. The MySQL deamon, mysqld, should work normally with the exception that host name resolving will not work. This means that you should use IP addresses instead of hostnames when specifying MySQL privileges ! 3. chown: mysql: invalid user name Starting mysqld daemon with databases from /Library/MySQL/var 031203 21:19:05 mysqld ended Fatal error: Can't change to run as user 'mysql' ; Please check that the user exists! Please check that /tmp/mysql.sock' exists! __ any references or help on these issues? running Darwin on Mac OS 10.1.5 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
how to add a new user to the users table, with out having grant options
Hi, I have a password to a database with all the databse privileges, except reload, shutdown, process, file and with Grant options. This is the administrator or super user password, with most of the privileges. Someone else has created the data base. Now I'll maintain it. I need to add a new user with select privilege. I tried with FLUSH PRIVILEGES, BUT THE SYSTEM GIVES THE ERROR: ACEESS DENIED. yOU NEED THE RELOAD PRIVILEGE FOR THIS OPERATION. How can I add a new user, when I don't have a grant option privilege? any insights are greatly appreciated. TIA. Sheela Lakshmi
[Fwd: RE: replication question]
Didn't have the list cc-ed. -Forwarded Message- From: Andrew Hall [EMAIL PROTECTED] To: Mike Johnson [EMAIL PROTECTED] Subject: RE: replication question Date: Fri, 05 Dec 2003 16:17:14 -0500 Ok, at this point it appears my replication is working, but I have two questions: 1. I tested by creating a table on the master, populated it, then on the slave did a 'show tables', and 'select * from test', and my test table and data was there. Is this methodology acceptable for a basic test? Any suggestions on testing methodology? 2. When I execute 'show master status' the Binlog_db_do fields is empty. This seems erroneous to me. Shouldn't this field be populated with the db name(s) to replicate? Thanks again, Drew execute 'START SLAVE' on my slave I get ERROR 1064: You have an error in your SQL syntax near 'START SLAVE' at line 1 This tells me that my version of mysql does not support the 'START' command. Do I need to add something at compile time? Are the instructions only for 4.x? Am I just missing something really obvious? Don't quote me on it, but I think START SLAVE was introduced in 4.x. Try SLAVE START. I recently read that SLAVE START was being deprecated; I can only assume START SLAVE was a recent introduction. Regardless, I always used SLAVE START on 3.23.x. HTH -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MAC OS X installation problem
A newbie here, with a simple question (I guess). I just installed MySQL on my OS X 10.2 But failed pretty quick. Please help me... I wanna get started. This it what it looks like after following the description in the ReadMe file. Last login: Fri Dec 5 22:41:28 on ttyp1 Welcome to Darwin! [COVERMAN:~] staffan% sudo /Library/StartupItems/MySQL/MySQL start Starting MySQL database server [COVERMAN:~] staffan% /usr/local/mysql/bin/mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) [COVERMAN:~] staffan% I'm on a Mac with different users able to login and also a swedish os (if that could be a problem?). Staffan _ Hitta rätt köpare på MSN Köp Sälj http://www.msn.se/koposalj -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
What is code and what's not?
I found a script on this help page, that should be used when giving the root user a password, but I really don't understand what of this is words and what is just an example. /usr/local/mysql/bin/mysqladmin -u root password password /usr/local/mysql/bin/mysqladmin -u root -h `hostname` password password Where in this script am I supposed to write my password and where is the word supposed to acctually be written as the word password? And what about hostname? Is that a command or should I write the host name of my computer? Since I'm a newbie it's hard to understand. Can someone please mark this for me? Is this the right way? /usr/local/mysql/bin/mysqladmin -u root password xyxyxyxy /usr/local/mysql/bin/mysqladmin -u root -h `this_is_me` password xyxyxyxy Weird question maybe... but I guess I'm not the only one here. It would've been easier with underscored or different colours here... I guess ;-) _ Hitta rätt köpare på MSN Köp Sälj http://www.msn.se/koposalj -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
with-openssl failing?
I compiled MySQL 4.1.1 --with-openssl --with-vio and when I look at the variables with mysqladmin, has_openssl is set to NO. What could have happened to cause this? I've got OpenSSL 0.9.7c installed. I'm seeing this on both Solaris and Debian hosts. I'm not seeing any errors during the configure or compile phases. Thanks. -Greg G -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: What is code and what's not?
Swedish should not be a problem ... the chief software architect behind MySQL is a Swedish-speaking Finn. If you want the password to be bubba, then the syntax is: /usr/local/mysql/bin/mysqladmin -u root password bubba If the computer (host) name is snickers, it would be written as: /usr/local/mysql/bin/mysqladmin -u root -h snickers password bubba - Original Message - From: Lost Idols [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, December 05, 2003 4:06 PM Subject: What is code and what's not? I found a script on this help page, that should be used when giving the root user a password, but I really don't understand what of this is words and what is just an example. /usr/local/mysql/bin/mysqladmin -u root password password /usr/local/mysql/bin/mysqladmin -u root -h `hostname` password password Where in this script am I supposed to write my password and where is the word supposed to acctually be written as the word password? And what about hostname? Is that a command or should I write the host name of my computer? Since I'm a newbie it's hard to understand. Can someone please mark this for me? Is this the right way? /usr/local/mysql/bin/mysqladmin -u root password xyxyxyxy /usr/local/mysql/bin/mysqladmin -u root -h `this_is_me` password xyxyxyxy Weird question maybe... but I guess I'm not the only one here. It would've been easier with underscored or different colours here... I guess ;-) _ Hitta rätt köpare på MSN Köp Sälj http://www.msn.se/koposalj -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
can't seem to reset password
I have been reading and following the instructions from: http://www.mysql.com/doc/en/Resetting_permissions.html But, if I do: ./bin/mysqld_safe --skip-grant-tables And then I: mysqladmin -u root password 'mypassword' I get: mysqladmin: unable to change password; error: 'You must have privileges to update tables in the mysql database to be able to change passwords for others' this is a 3.2 install that was working just fine but I just did an upgrade to 4.1. I think I did the ?update permissions? script ok when I did the install. But is this the problem? --ja -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
How to find my directory?
I've read a lot of tips (even if I'm not up and running yet) about telling people to setup the correct way to their mysql directory. So, what I wanna know (when I get there) is if there is any command that I can write to make the computer tell where this files actually are? _ Hitta rätt på nätet med MSN Sök http://search.msn.se/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
How to find my directory?
I've read a lot of tips (even if I'm not up and running yet) about telling people to setup the correct way to their mysql directory. So, what I wanna know (when I get there) is if there is any command that I can write to make the computer tell where this files actually are? _ Hitta rätt köpare på MSN Köp Sälj http://www.msn.se/koposalj -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: fulltext search speed issue with SQL_CALC_FOUND_ROWS
Hi! On Dec 05, tk wrote: Hello Sergei, Gunnar, and others, thank you for your quick responses. One little mystery remains: Why does one need to read all the row data (with SQL_CALC_FOUND_ROWS) to get the total number of results when using a limit? When the index is used to find relevant rows and sort the results, the code certainly must know how many total results there are. Yes, but it's different code, it works on a different level and knows nothing about SQL_CALC_FOUND_ROWS :( Could one not store the total while using the index and use select FOUND_ROWS() without SQL_CALC_FOUND_ROWS to retrieve the total? Yes, it could. It is the optimization that wasn't implemented yet. (but it's in the TODO) Regards, Sergei -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MyODBC errors
Mysqlians, I am getting the following errors in an application log for 4.0.16 mysql and 3.51 myODBC SQL Error: SQLSTATE=S0002 Native error=1146 '[unixODBC][MySQL][ODBC 3.51 Driver][mysqld-4.0.16-Max-log]Table 'TRIBE.NETWORK_VECTOR' doesn't exist' SQL Error: SQLSTATE=S1000 Native error=1136 '[unixODBC][MySQL][ODBC 3.51 Driver][mysqld-4.0.16-Max-log]Column count doesn't match value count at row 1' I have no problems reading/writing when I connect with the same user from the command line or otherwise. The table does exist with correct permissions and is read by the application earlier. The failings all deal with write operations. Many Thanks, Trevor
MySQLHotCopy - No tables to hot-copy HUH?!
I have a problem using mysqlhotcopy. Everything was fine until I recently moved to a different server. Old one was running mysql 4.0.15 on FreeBSD 4.8, new is mysql 4.0.16 on FreeBSD 4.9. The error returned is No tables to hot-copy at /usr/local/bin/mysqlhotcopy line 379. I ran w/ --debug and here is the result... mysqlhotcopy drew /storedarea/drew -u alloweduser -p notpostedhere --debug Filtering tables with '(?-xism:.*)' $VAR1 = [ { 'index' = [], 'src' = 'drew', 'raid_dirs' = [], 'tables' = [], 'files' = [ 'homework.MYD', 'homework.MYI', 'homework.frm', 'teacher.MYD', 'teacher.MYI', 'teacher.frm', 'users.MYD', 'users.MYI', 'users.frm' ], 't_regex' = '.*', 'target' = '/storedarea/drew' } ]; No tables to hot-copy at /usr/local/bin/mysqlhotcopy line 379. Here is a show tables from the terminal... mysql show tables; ++ | Tables_in_drew | ++ | homework | | teacher| | users | ++ 3 rows in set (0.00 sec) I would greatly appreciate some help here. Thanks. Lewis -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
problem using MySQL++ API
hello, I am using mysql++ API and it is giving an error - The procedure entry point mysql_connect could not be located in the dynamic link library LIBMYSQL.dll any solutions, Best Regards - Pawan Have A Nice Day
Re: odbc 3.51.06
dear mysql team, i was trying to save a file in mysql now can u please help me with an alternative that i save the file name in the database and how to retrieve back prathima rao - Original Message - From: Prathima Rao To: [EMAIL PROTECTED] Sent: 06/12/2003 9:23 AM Subject: odbc 3.51.06 dear mysq team, i have myodbc 3.51.01 version now how do i upgrade to latest version 3.51.06 please help regards prathima rao
Character escaping
I have searched the archives for a solution to my problem and also the FAQ and the mysql documentation but can't seem to resolve it. I am exporting a tab delimited file from FileMaker Pro 5.5 using Mac OS 10.3. I am uploading the file to my hosted server running RedHat Linux 7.2. I am then importing the file to a mysql (4.0.15-standard) table using this code (Perl DBI). $sth = $dbh-prepare (qq{LOAD DATA LOCAL INFILE '$file_to_load' REPLACE INTO TABLE Listing_Data FIELDS TERMINATED BY '\t' ESCAPED BY '\' LINES TERMINATED BY '\r' IGNORE 0 LINES}); The problem is that apsotrophy (') and quote () characters do not escape properly - I am getting (Õ) and (Ó) characters instead. I have tried a test of escaping the text e.g. Johnson\'s Rd. - but it doesn't seem to make it through the import. Have also tried running the text through a Perl substitution on the server $line =~ s/(['])/\\\$1/g; this escapes the characters in the text file but they still appear incorrect in the mysql table. The default character set for the database is latin1. This is likely something simple but I've spent too much time on it with no results - hope somebody can help - thanks. Bob MacIsaac -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]