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 twi
> 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
> tempor
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 ibdat
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 ver
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
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, d
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 n
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 arc
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
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 idea
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,
>
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.
>>
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: Er
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-r
[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 r
[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 h
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 it
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:
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 inc_perfo
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 na
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 a
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
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. For
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
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 =s
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 va
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_inmueble
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
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 co
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) ... Sin
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 A
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. A
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 t1
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 PROTECTE
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 _customer
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 an
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:http://lists.mysql.com/[E
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 wi
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: Barbar
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 y
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 ins
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 fi
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
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
T
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:
http://dev.mysql.com/doc/mysql/en/charset-asian-sets.
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 environm
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?
Ge
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:
http
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 whi
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
"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 proce
(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 ***
>
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 Fil
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
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
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 d
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 than
57 matches
Mail list logo
