Re: How thread-safe is mysql_real_connect()?

The Windows DLL is thread safe. You do not have to call my_init() and my_thread_init() because Windows DLLs receive events when they are attached to a new process and when they are attached to a new thread in a process. This is one of the nicer features of Windows shared libraries. Other

Re: Non-linear degradation in bulk loads?

Jon Frisby wrote: Everyone, We're trying to do some bulk data loads on several different tables (on several different machines, using several different techniques) and seeing dramatically worse-than-linear performance. We've tried the bulk-INSERT syntax, and the LOAD DATA INFILE syntax. We've

Re: databse design and table join problems

Hi, Ok, if you do not recommend a big ( about 20 columns ) table, how can I do the join then and how do I add to each customer with the same street name, street number, block of flats number and flat number, an id that will help me join them ? I need to be able to see a customer even if

Re: MySQL Hangs

Related: http://lists.mysql.com/mysql/44164 No solutions mentioned here. Slack 10.1 is booting and once the newly installed MySQL Standard 4.1.14 starts up with: Starting mysqld daemon with databases from /usr/local/mysql/data The system hangs and is dead to the world. I will need some time

RE: [SPAM] - Query help - Bayesian Filter detected spam

You might try UNION with the 1st statement pulling all products with groupid = 0 and the 2nd pulling 1 product with groupid 1. -Original Message- From: John Nichel [mailto:[EMAIL PROTECTED] Sent: Monday, October 10, 2005 3:31 PM To: MySQL List Subject: [SPAM] - Query help - Bayesian

Re: Help on writing a sql statement

(my response bottom-posted. See below - SG) Imran [EMAIL PROTECTED] wrote on 10/10/2005 09:16:13 PM: Hi Shawn .. Thanks for the offer. I am attaching the info that you requested. mysql SHOW CREATE TABLE salesmaster\G; *** 1. row ***

Re: How thread-safe is mysql_real_connect()?

Jeremiah Gowdy [EMAIL PROTECTED] wrote on 10/11/2005 03:08:40 AM: The Windows DLL is thread safe. You do not have to call my_init() and my_thread_init() because Windows DLLs receive events when they are attached to a new process and when they are attached to a new thread in a process.

Re: Lost .frm files

Hello. Maybe this will help, if you're using MyISAM tables. Create a table with the same definition as a table from the backup has. Remove a new data file, and put a data file from the backup instead of it. Then use REPAIR. I have changed the OS on my database server. At that time, I

Re: How do you set a Primary Key when uploading data into a table?

Hello. The Id row gets values of 99897, and then increments by one. Please, send the output of: SHOW CREATE TABLE sic_codes; Probably you don't have auto_increment attribute in the Id definition. Bill Abel wrote: How do you load data into a table and generate a primary key

Re: Relocation of database store

Hello. I want to place my database on a NAS drive. Usually it is not recommended to use network filesystems, due to high performance penalty. I'm trying to relocate the database files for MySQL 4.1 I've seen two primary techniques for doing this: Have a look here as well:

Re: Suppress table header when using ODBC

Hello. I am using a desktop program that imports data from a mysql What program? for one little glitch: it adds one extra row at the beginning of the dataset with the names of the columns in it. I need for that Does you program show column names in the numeric fields?

Re: SOCKET directory

Hello. However, when I try to connect I get the error: Have a look here: http://dev.mysql.com/doc/mysql/en/can-not-connect-to-server.html Barbara Deaton wrote: With MySQL 4.0 when I wanted to run my application on any of the unix = boxes I had to set the MYSQL_UNIX_PORT

Re: Charset issue

Hello. Chinese can't be displayer propely. What client do you use to connect to MySQL Server? Check that it supports Chinese. I don't know Chinese and can't suggest what character to use. But, certainly, you should choose one from:

Re: Out Of Memory problems: One MySQL user, 86 minutes sleeping

Hello. 1981 mysql 16 0 72064 42m 6172 S 0.0 8.5 0:03.53 mysqld 1982 mysql 20 0 72064 42m 6172 S 0.0 8.5 0:00.00 mysqld 1983 mysql 17 0 72064 42m 6172 S 0.0 8.5 0:00.00 mysqld 1984 mysql 16 0 72064 42m 6172 S 0.0 8.5 0:00.00 mysqld

Re: Out of memory (Needed 8164 bytes)

Hello. the problem is that after around 160,000 rows inserted with success , then i get Out of memory (Needed 8164 bytes) error many times. Does your program report this error or MySQL Server? Can someone give me an advice with some optimization or if something is wrong in mysql

RE: SOCKET directory

Thank you for the link. I understand that I need a mysql.sock file, what I don't understand is that I used to get one when I installed MySQL. When I look through all my 4.0.x mysql directories I see a socket directory that contains a mysql.sock file. With my 4.1 install I do not see this

Re: SOCKET directory

Barbara Deaton wrote: Thank you for the link. I understand that I need a mysql.sock file, what I don't understand is that I used to get one when I installed MySQL. When I look through all my 4.0.x mysql directories I see a socket directory that contains a mysql.sock file. With my 4.1

RE: SOCKET directory

The sock file is not a permanent file. It is a socket descriptor that should only exist if the MySQL server is running and if the server is configured to supports socket-type connections. Most of the default installations DO NOT start the server as part of the installation process. That way

RE: SOCKET directory

Wow, totally didn't get that from the article. Thanks so much everyone for the explanation and taking the time to write. Time to recheck my servers. -Barb. From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 11, 2005 10:37 AM To:

Re: MySQL Hangs

Velu Shk wrote: Related: http://lists.mysql.com/mysql/44164 No solutions mentioned here. Slack 10.1 is booting and once the newly installed MySQL Standard 4.1.14 starts up with: Starting mysqld daemon with databases from /usr/local/mysql/data The system hangs and is dead to the world. I

Append one table to another?

How do I append one table's contents to another? Both have identical structure. Problem is I don't have shell access, only phpAdmin or a PHP file I write upload myself. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Problem compiling MyODBC - looking for sql.h file

I posted this on the ODBC list, but there is not much traffic there and no one replied. Hopefully someone here has dealt with this. I am setting up ColdFusion to access a MySQL 4.1.x database. This required new MyODBC drivers to be installed on the system for ColdFusion. After a lot of trial

Re: databse design and table join problems

Cristi, Ok, if you do not recommend a big ( about 20 columns ) table, how can I do the join then and how do I add to each customer with the same street name, street number, block of flats number and flat number, an id that will help me join them ? Oh, you mean get all the _customers_

RE: How thread-safe is mysql_real_connect()?

Wow, thats good to know. Thanks Jeremiah. It is a little strange that the documentation doesn't mention that this behavior is different under windows and leads one to believe that calling mysql_thread_init/end is still neccesary. John From: [EMAIL

Re: Append one table to another?

At 7:57 -0700 10/11/05, Brian Dunning wrote: How do I append one table's contents to another? Both have identical structure. Problem is I don't have shell access, only phpAdmin or a PHP file I write upload myself. If the tables are identical, you can do this: INSERT INTO t2 SELECT * FROM

Re: Problem compiling MyODBC - looking for sql.h file

Ryan Stille wrote: I posted this on the ODBC list, but there is not much traffic there and no one replied. Hopefully someone here has dealt with this. I am setting up ColdFusion to access a MySQL 4.1.x database. This required new MyODBC drivers to be installed on the system for ColdFusion.

Re: Append one table to another?

Brian How do I append one table's contents to another? Both have identical structure. Problem is I don't have shell access, only phpAdmin or a PHP file I write upload myself. How about INSERT into tbl1 SELECT * FROM tbl2 PB -- No virus found in this outgoing message. Checked by AVG

Re: Help on writing a sql statement

Hi Shawn: Thank you very much for your solution. It certainly helped me in understanding SQL a whole deal more. I Have one followup question as to the proposed solution, This query will be used in a multi-user situation and the logon to the database will be the same user (a web based app) ...

Re: Append one table to another?

Hi Brian! How do I append one table's contents to another? Both have identical structure. Problem is I don't have shell access, only phpAdmin or a PHP file I write upload myself. You can do it this way: INSERT INTO table1 SELECT * FROM table2; If you need to have more

Re: Help on writing a sql statement

Will you have name collisions with the same temporary table names used from different connections? Nope. Temporary tables and user-defined (@-variables) are connection-specific. Even if the same username/password combination is used to create several connections, each connection will have its

concat() function

hello, my friends, the query option 1 return the right value, the query option 2 not. Why concat function make the difference? *nloc_num,ins_numero and ins_digi are decimal(3,0) / option 1 .- select max(bi_num) as num from b_inmuebles

Re: Append one table to another?

INSERT into tbl1 SELECT * FROM tbl2 Thanks to both of you, but this is not working. Since one of the fields is a primary key that's duplicated in both tables (both tables have records numbered 1, 2, 3...), it won't allow the duplicate entries. Fortunately I do not need those primary key

Re: Help on writing a sql statement

Hi Shawn: I tried to run the sequences as you suggested in MySql Query Browser. I ran the first part with the create temp table then I ran the second select to see the result but when I tried the second SQL to get the created rows I get the message 'Table .tmpTotals doesn't exist' where

Re: Non-linear degradation in bulk loads?

Jon, my guess is that the inserts to the UNIQUE secondary index cause the workload to be seriously disk-bound. Two solutions: 1) sort the rows to be inserted on the key 'email' before inserting. 2) Or: http://dev.mysql.com/doc/mysql/en/innodb-tuning.html If you have UNIQUE constraints on

Re: Append one table to another?

At 9:00 -0700 10/11/05, Brian Dunning wrote: INSERT into tbl1 SELECT * FROM tbl2 Thanks to both of you, but this is not working. Since one of the fields is a primary key that's duplicated in both tables (both tables have records numbered 1, 2, 3...), it won't allow the duplicate entries.

Re: Append one table to another?

On Oct 11, 2005, at 8:24 AM, Jose Miguel Pérez wrote: INSERT INTO table1 (field1, field2) SELECT field1, field FROM table2 Jose's solution worked perfectly. Thanks everyone, sorry for being so dense today. :) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Re: Help on writing a sql statement

The CREATE TABLE ... SELECT ... command is all one command. You weren't supposed to break it up. Sorry if I didn't make that very clear (my fault!!). You should probably be on a SCRIPT tab not a QUERY tab if you are running this through QueryBrowser in order to execute more than one statement

Re: Suppress table header when using ODBC

Gleb Paharenko wrote: Hello. I am using a desktop program that imports data from a mysql What program? Printbench Pro for one little glitch: it adds one extra row at the beginning of the dataset with the names of the columns in it. I need for that Does you program show column

Temp table full (I think) -- how do I fix this?

Hi, I have a job runnning that's modifying a column on a 15-million-row table and is throwing out the following error: Output: Replication Error 1114, slave: replicatenj07, error: Error 'The table '#sql-5303_3c' is full' on query. Default database 'customer__upgrade'. Query: ALTER TABLE

Re: Temp table full (I think) -- how do I fix this?

Walt Weaver wrote: Hi, I have a job runnning that's modifying a column on a 15-million-row table and is throwing out the following error: Output: Replication Error 1114, slave: replicatenj07, error: Error 'The table '#sql-5303_3c' is full' on query. Default database 'customer__upgrade'.

query help

lets say i have two tables: module - VARCHAR module_name INTEGER module_id module_config INTEGER module_id VARCHAR config_name VARCHAR config_value config item names and values are rather arbitrary and depend on the module. each module can have zero to many config

Re: query help

[EMAIL PROTECTED] wrote: lets say i have two tables: module - VARCHAR module_name INTEGER module_id module_config INTEGER module_id VARCHAR config_name VARCHAR config_value config item names and values are rather arbitrary and depend on the module. each module can

Re: query help

[EMAIL PROTECTED] wrote on 10/11/2005 01:27:12 PM: lets say i have two tables: module - VARCHAR module_name INTEGER module_id module_config INTEGER module_id VARCHAR config_name VARCHAR config_value config item names and values are rather arbitrary

Re: Temp table full (I think) -- how do I fix this?

Thanks, as it turns out the solution to the problem was a bit more mundane: we ran out of disk space on the partition the tables are on. :) --Walt On 10/11/05, walt [EMAIL PROTECTED] wrote: Walt Weaver wrote: Hi, I have a job runnning that's modifying a column on a 15-million-row table

Re: Temp table full (I think) -- how do I fix this?

Hello. Have a look here: http://dev.mysql.com/doc/mysql/en/full-table.html Walt Weaver wrote: Hi, I have a job runnning that's modifying a column on a 15-million-row table and is throwing out the following error: Output: Replication Error 1114, slave: replicatenj07, error: Error

Re: Suppress table header when using ODBC

Hello. Printbench Pro I haven't found any information while was searching by the 'Printbench' key word at mysql.com (to say the truth I was unable to find a lot of even in Google). So maybe someone other could help. Gerald Taylor wrote: Gleb Paharenko wrote: Hello. I

Re: concat() function

Hello. *nloc_num,ins_numero and ins_digi are decimal(3,0) You're using 1770 for comparison which is not in the type range. In my opinion, for incorrect data you may obtain incorrect answers. Luciano Centeno wrote: hello, my friends, the query option 1 return the right value, the

Aborted connection problems

I seem to be getting heaps of aborted connections, and I can't figure out why. MySQL's error (from mysqld.err, below) is Got an error reading communication packets, but this is a socket link to localhost so that rules out network problems. I simply can't figure it out. Has anyone got any

directory path storage

Can someone pelase explain to me how to store the pathname and the filename in a MySQL database , I need it to loop thru a Folder and grab all pathnames and filesnames within that folder and store it in a MySQL database,, thanks

MySQL and FULL JOIN

Hi, I would like to know if there is a way to do a full join in MySQL and if yes, what version should I use or if there is any other way to get the same result as a full join. I am curently using 4.0.24 on linux. Best regards, Cristian Stoica -- MySQL General Mailing List For list

Re: Aborted connection problems

Just to add to this further, if I reduce max_allowed_packet in my.cnf down to around 16M, then the error changes to Got a packet bigger than 'max_allowed_packet' bytes. However, as you can see from the SQL below, the longest SQL statement I'm executing is around 21 bytes, certainly nowhere

Re: Non-linear degradation in bulk loads?

At 11:41 PM 10/10/2005, you wrote: Hi Jon, Well, may be the next suggestions might help you. Disable Keys does apply to non-unique keys only. So I suggest to focus on your unique Email key. You could do some tests with: a. drop the unique key on Email b. load the various bulks c. after loading,

Re: Aborted connection problems

Hello. I was unable to find reported bugs with similar symptoms for the 5.0 version (hope I haven't missed something). But at the bottom of: http://dev.mysql.com/doc/mysql/en/packet-too-large.html we have these lines: You can also get strange problems with large packets if you are

Re: MySQL and FULL JOIN

Hello. MySQL doesn't support full joins, but you can emulate them. Read through this article: http://dev.mysql.com/tech-resources/articles/mysql-db-design-ch5.html inferno wrote: Hi, I would like to know if there is a way to do a full join in MySQL and if yes, what

Re: Question about innodb, ibdata1

Fredrik, - Original Message - From: Fredrik Carlsson [EMAIL PROTECTED] Newsgroups: mailing.database.myodbc Sent: Monday, October 10, 2005 9:57 PM Subject: Question about innodb, ibdata1 Hi, I'm using InnoDB with tablespaces for almost all tables. The last few week the file ibdata1

RE: Non-linear degradation in bulk loads?

Two solutions: 1) sort the rows to be inserted on the key 'email' before inserting. 2) Or: http://dev.mysql.com/doc/mysql/en/innodb-tuning.html If you have UNIQUE constraints on secondary keys, starting from MySQL 3.23.52 and 4.0.3, you can speed up table imports by temporarily

MySQL Administrator Cron Errors

Hi folks. Downloaded the new Admin for OS X. I set a weekly cron and for some reason, it's emailing my terminal Mail app saying it couldn't load a profile. It's not the address I told it to send it to, and I don't quite get why it can't load a profile. Having just tried to back up my tables