do,
show varaibles like '%tmp%'.
show variables like '%tmp%';
| tmpdir| /tmp/
This is case of your tmp file system, running out space.
You can change this parameter to a different file system having more space,
and then your job should run fine.
regards
anandkl
On 8/26/08, Jerry S
Hi,
We need to add support for time zone to our existing PHP "Board Member"
Extranet applications. Could those of you with experience supporting a time
zone field in your MySQL data tables offer some advice? Would you use a single
field? Would you use just an offset value? How would you rep
Only increase max_allowed_packet is ok.
On Tue, Aug 19, 2008 at 5:49 PM, Warren Young <[EMAIL PROTECTED]> wrote:
> Mad Unix wrote:
>
>>
>> During the update of the MySQL DB (delete/insert), I keep getting the
>> following message
>> Lost connection to MySQL server during query...
>>
>
> By defaul
Use mysqldump on the old version and import the data into new version in my
opinion.
On Fri, Aug 22, 2008 at 1:29 AM, Andy Shellam <[EMAIL PROTECTED]>wrote:
> FYI the manual for 5.0 recommends upgrading to 4.1 first.
>
> "As a general rule, we recommend that when upgrading from one release
> seri
true, but I'm more interested in if the error message I received is
documented behavior or not.
Thanks,
Jim
On Tue, Aug 26, 2008 at 4:11 PM, Rolando Edwards <[EMAIL PROTECTED]>wrote:
> You are better off running it this way:
>
> create table t1 (x int);
> create table t2 (x int);
> create table
You are better off running it this way:
create table t1 (x int);
create table t2 (x int);
create table t3 (x int);
create table t_merge (x int) engine=merge union=(t1,t2,t3);
drop table t1;
drop table t_merge;
create table t_merge (x int) engine=merge union=(t2,t3);
-Original Message-
I have a merge table and dropped one of the tables that was in the union. I
then tried to alter the merge table to use only the remaining tables.
Here is some simple test code representing what I was doing.
create table t1 (x int);
create table t2 (x int);
create table t
Hi,
here my table which stores multiple trees with nested sets:
CREATE TABLE `posts` (
`posting_id` int(11) unsigned NOT NULL auto_increment,
`root_id` int(11) unsigned NOT NULL,
`lft` int(11) unsigned NOT NULL,
`rgt` int(11) unsigned NOT NULL,
`subject` varchar(400) collate latin1_germ
The 5.0 documentation that I have says that you can specify a length for a
TEXT column, and that this will affect the storage space used by the column
data. When I specify TEXT(n), however, n is ignored. It won't be shown in a
SHOW CREATE, nor in any other way.
Is this a feature that came and w
Simple answer: Of course you can. This will bring out the true power of C.
So - YES, you can work with C and MySQL.
In fact, you work with MySQL, much like any other databases/SQL, with
*many*programming languages. For C I suggest you use Google and/or
check out the
following resources:
http://ww
>-Original Message-
>From: news [mailto:[EMAIL PROTECTED] On Behalf Of
>[EMAIL PROTECTED]
>Sent: Tuesday, August 26, 2008 2:36 AM
>To: mysql@lists.mysql.com
>Subject: Re: Huge temporary file
>
>In infinite wisdom "Jerry Schwartz" <[EMAIL PROTECTED]> spoke
>thus:
>> I'm at a loss as to why,
From: Johnny Withers [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 26, 2008 9:37 AM
To: Jerry Schwartz
Subject: Re: Huge temporary file
You are using the defaults then, I'm not sure what they are, but you can
view the location of the temp directory (probably /tmp) and the maximum size
of any
>-Original Message-
>From: news [mailto:[EMAIL PROTECTED] On Behalf Of
>[EMAIL PROTECTED]
>Sent: Tuesday, August 26, 2008 2:36 AM
>To: mysql@lists.mysql.com
>Subject: Re: Huge temporary file
>
>In infinite wisdom "Jerry Schwartz" <[EMAIL PROTECTED]> spoke
>thus:
[JS] My wisdom use to be inf
From: Ananda Kumar [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 26, 2008 12:09 AM
To: Jerry Schwartz
Cc: mysql
Subject: Re: Huge temporary file
what is the value for tmpdir parameter in you my.cnf.
[JS] I don't have one. The /tmp file system is what is being consumed. I
should add that
general log is different from machine.err log, it stores all logs of the db.
On 8/26/08, Jesse <[EMAIL PROTECTED]> wrote:
>
> "tsa" is actually the database. It's running the function "AddSchool()",
> and it appears that something went wrong in that situation. The actual table
> affected insi
"tsa" is actually the database. It's running the function "AddSchool()", and
it appears that something went wrong in that situation. The actual table
affected inside the function is "school", and that table does exist on both
master and slave.
If by "general log", you mean the log named machin
Hi All,
In oracle we have these two bulit in's SQLCODE and SQLERRM, which helps use
to find the error code and error message.
Does mysql also provide any thing like this.
I want to use this in my stored proc to find out if stored proc throws any
exception apart from NO_DATA_FOUND
regards
anandkl
Hi,
You do this with mk-slave-delay from the Maatkit toolkit.
http://www.maatkit.org/tools.html
"This tool implements delayed replication on the slave by sampling
binlog positions, then starting and stopping the slave as needed to
make the slave lag its master by a specified amount. It does not
Hi All,
If we want the replication (slave) to lay by 8 hrs from master, is there any
parameter that i can use in the slave, so that it apply changes happened
only 8 hrs back.
regards
anandkl
19 matches
Mail list logo
