So, as a followup, I ran mysqldump on the actual server (with the output
directed over AFP to another machine on the network) -- as opposed to running
mysqldump on the destination server and connecting to the databases over TCP/IP
(both are running 5.1.39 PPC 64-bit). *That* dump file imported
It's just odd, because that error was on 5.0. I'm running 5.1.39 -- surely
enough time for the MySQL devs to fix it right?
Could it be with extended inserts that the max statement length is greater than
the default 16MB max allowed packet? I'm increasing that value to 256 MB and
going to try
There is a bug in mysqldump that prevents mysql from version 5.0.80 from
importing dumps from a old version of mysqldump.
I had this verified by MySQL support.
You can have a look at this bug: http://bugs.mysql.com/bug.php?id=41486
Cheers
Claudio
2009/11/21 René Fournier m...@renefournier.com
Except that, in my case, both machines are running 5.1.39. Mac OS X PPC
64-bit. I tried importing another, different dump file of the same database,
and this time mysql returned a different error:
Sat Nov 21 13:16:20 -- Minas-Tirith :: mysql -u root -p dump_file.sql
Enter password:
ERROR
Have you tried dumping that table manually using mysqldump on the command line
to confirm it's not an issue with automysqlbackup?
Regards,
Gavin Towey
-Original Message-
From: René Fournier [mailto:m...@renefournier.com]
Sent: Friday, November 20, 2009 8:31 AM
To: mysql
Subject: Strange
...@renefournier.com]
Sent: Friday, November 20, 2009 8:31 AM
To: mysql
Subject: Strange problem with mysqldump / automysqlbackup (ERROR 1300)
I've been using automysqlbackup 2.5 for years on a particular database, and
it's always performed great. Recently, however, I've become encountering
problems when
liaojian_163 schrieb:
hi,all.
In my mysql server,I have a strange problem.
can someone help me?
Thank you.
mysql select id,classid,newstime from phome_ecms_zhichang where classid=41
and id 2500 order by id desc limit 10;
+--+-+-+
| id | classid
, 2008 2:11 PM
Subject: Re: a strange problem
liaojian_163 schrieb:
hi,all.
In my mysql server,I have a strange problem.
can someone help me?
Thank you.
mysql select id,classid,newstime from phome_ecms_zhichang where classid=41
and id 2500 order by id desc limit 10
liaojian_163 schrieb:
thank you Sebastian!
I have re-created the table.there are not any problems in the table.
if the table is new,need to rebuild de indexes?
no
--
Sebastian Mendel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
hi,all.
In my mysql server,I have a strange problem.
can someone help me?
Thank you.
mysql select id,classid,newstime from phome_ecms_zhichang where classid=41
and id 2500 order by id desc limit 10;
+--+-+-+
| id | classid | newstime
Not knowing your msqyl version, perhaps it's the form of your LIMIT clause.
try LIMIT 0,10 instead.
Phil
2008/4/22 liaojian_163 [EMAIL PROTECTED]:
hi,all.
In my mysql server,I have a strange problem.
can someone help me?
Thank you.
mysql select id,classid,newstime from
I don't think that the limit cause the stange problem.
thank you anyway.
- Original Message -
From: Phil [EMAIL PROTECTED]
To: liaojian_163 [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Wednesday, April 23, 2008 3:46 AM
Subject: Re: a strange problem
Not knowing your msqyl version
This is correct.Thank you very much.
But I also why I wrote is wrong on linux and right on windows.
You can tell me answer if you have time.thanks.
On Jan 19, 2008 12:47 AM, Baron Schwartz [EMAIL PROTECTED] wrote:
Hi,
On Jan 18, 2008 3:50 AM, Moon's Father [EMAIL PROTECTED] wrote:
My test
My test is as follows:
mysql select g_id from t group by g_id order by g_id desc limit 0,1;
+--+
| g_id |
+--+
|6 |
+--+
1 row in set (0.00 sec)
mysql select g_id from t group by g_id order by g_id desc limit 0,1 into
@tmp_id;
Query OK, 1 row affected (0.00 sec)
mysql select
Hi,
On Jan 18, 2008 3:50 AM, Moon's Father [EMAIL PROTECTED] wrote:
My test is as follows:
mysql select g_id from t group by g_id order by g_id desc limit 0,1;
+--+
| g_id |
+--+
|6 |
+--+
1 row in set (0.00 sec)
mysql select g_id from t group by g_id order by g_id
What does SHOW CREATE TABLE give you?
-Sheeri
On 3/11/06, Holger Sunke [EMAIL PROTECTED] wrote:
Hallo,
is there a way of maintaining Memory tables or rebuilding indexes?
I have a big memory table with about 300k rows, 12 Attributes, 7
BTREE-Indexes and a PRIMARY KEY (Hash index).
Now
Grzegorz Paszka [EMAIL PROTECTED] wrote:
Hi.
I use MySQL 4.0.17 from rpm.
When I want insert new row by perl script to one of my table I get such error :
DBD::mysql::st execute failed: Duplicate entry '- Modified the spec file provided by
...' for key 3
Table looks :
mysql desc
A little explaination:
We've got two servers, e450 (3.23.47) and 1U (4.0.14). These two
machines have a private connection between them (192.168.0.1 and
192.168.0.2).
The e450 is the master server, and the 1U has a copy (no replication)
of some basic data, so it can run server-intensive pages.
Is anything being logged in the error log?
-Original Message-
From: Eric Anderson [mailto:[EMAIL PROTECTED]
Sent: Friday, November 07, 2003 11:16 AM
To: [EMAIL PROTECTED]
Subject: Very strange problem
A little explaination:
We've got two servers, e450 (3.23.47) and 1U (4.0.14
Is anything being logged in the error log?
Nope.
My 'wait_timeout' was set to 120 seconds, I reduced that down to 60
seconds but I don't think that will help because once it gets stuck in
this blocked thread thing, it never recovers.. any subsequent
connections never actually process, until the
On Fri, Nov 07, 2003 at 09:16:03AM -0800, Eric Anderson wrote:
A little explaination:
[snip]
The threads connecting from the 1U (192.168.0.2) all start to block up
as expected, but when the length query on the e450 stops running, the
threads from the 1U stay blocked, and all NEW threads
, most of the time web users do not understand that for every time
they hit reload their wait time is going to increase.
-Original Message-
From: Liu Haifeng [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 18, 2003 7:23 PM
To: [EMAIL PROTECTED]
Subject: Strange problem on the difference
Millions of thanks!
Now it's working perfectly!!!
Once again MS bugs...
Regards
Juha
-Alkuperäinen viesti-
Lähettäjä: Terence [mailto:terencel;sunway.edu.my]
Lähetetty: 23. lokakuuta 2002 4:54
Vastaanottaja: Morsky Juha; [EMAIL PROTECTED]
Aihe: Re: Strange problem with MySql IIS ASP
, October 21, 2002 7:39 AM
Subject: Strange problem with MySql IIS ASP
Hi All!
I've Select like this:
SELECT ExpDepDate, ActArrDate FROM oceandata
It works beautifully
But When I modify it like this
SELECT ExpDepDate, ActArrDate, Count(Ref) as NoOfRefs FROM oceandata
I'll get nothing, just
I had the same problem. It's in your connection, somehow ASP doesnt retrieve
the results when doing a select and count, so you need to use a connection
like this:
dim myConn
Set myConn= Server.CreateObject (ADODB.Connection)
myConn.ConnectionString =
]
Sent: Wednesday, July 03, 2002 10:21 PM
Subject: Re: TCP TIME_WAIT strange problem ( LINUX mysql 3.23.49 )
Hi,
What is written in err.log (/var/lib/mysql) ?
nothing :(
something like
mysql started and ready for connection
I think you have some problems with network (switch or hub).
Euh
Hi list,
I've got lots of troubles with one of my mysql dedicated server.
The problem occurs time to time ( during peac or idle time ).
In fact mysql seem not to answer all connections.
Netstat show several connections TIME_WAIT and show process_list only show
1 ou 2 queries running ...
But on
]
[EMAIL PROTECTED]
- Original Message -
From: David BORDAS [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, July 03, 2002 7:03 PM
Subject: TCP TIME_WAIT strange problem ( LINUX mysql 3.23.49 )
Hi list,
I've got lots of troubles with one of my mysql dedicated server.
The problem
|
| Uptime | 132998 |
+--++
111 rows in set (0.00 sec)
Thanks
David
- Original Message -
From: David BORDAS [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, July 03, 2002 7:03 PM
Subject: TCP TIME_WAIT strange
In the last episode (Jul 03), Mike Hall said:
FreeBSD 4.5-STABLE with LinuxThreads 2.2.3. and MySQL 3.23.51. Duel
PIII 1Ghz with 1G of RAM. All from source.
Compiled okay and came through super-smack and crash-me tests okay.
But a few hours later, for no reason, MySQL decided to look at
Hi,
I am new to this list. i could find solution to this problem on the net.
i have a RH7.1 512Mb single intel processor. I have installed
mysql-3.23.49a-max (binary). I have included the mysql.server script in
the init dir and created links to it in rc6, rc5,rc3 and rc1 dir.
I have
On Fri, May 03, 2002 at 11:04:29AM +0530, TP R Murthy wrote:
I have created only one database with 18 tables. Only one of these tables
is MyIsam table. rest are BDB tables. When the server is up, it works
fine. but when i reboot the machine, few of the tables loose all the
records they
Hi,
I do commit alright. This doesn't happen often. i insert into the tables
from a java web app. The db and the data in it is fine when i stop and
restart the web server(tomcat). sometimes when i restart the machine,
data is all intact.
I was using the mysql 4 max before. Same thing
On Sun, Sep 02, 2001 at 02:01:36AM +0200, Daniel Urstöger wrote:
Hiya !
I am not new with mysql, but I guess my experience is not enough for that
kind of problem ;)
mysql runs fine now the last 3 weeks, but now I am running into problems.
I want to restart mysql with the
On Wed, May 30, 2001 at 07:55:28PM +, [EMAIL PROTECTED] wrote:
I am not sure if I am doing something wrong in mySQL, but I have
tested the following in Microsoft SQL, Access and Oracle it works
fine in those environments, but unfortunately, it does not work in
mySQL.
I have a simple
35 matches
Mail list logo