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 O
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
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
> It's just odd, bec
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 ag
> From: René Fournier [mailto:m...@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
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: St
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 trying to re-import one of its dumped sql files. (Not sure if it
matters, but the database file in question is large and growing -- a
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:http:
ednesday, April 23, 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_e
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;
> +--+-
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:
Sent: Wednesday, April 23, 2008 3:46 AM
Subject: Re: a strange problem
>
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>
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 | ne
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:
> > M
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 orde
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
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).
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 i'm doing many many Updates (and a little number of inserts) on this table
that also do effect indexed
Hi,
i have a little mistake during an interrogation...
if i do
SELECT Cell_line FROM Mutations Where Cell_line='NCI-H63';
it returns a lot of results , all NCIH63 , and this is correct...
but if i do :
SELECT DISTINCT Cell_line FROM Mutations Where Cell_line='NCI-H63';
it return empty resu
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>
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 spak;
+--++--+-+-
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 thread
> 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 t
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).
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.
dy
running, 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 dif
Hi,
I am coding a cgi program to query the records from the mysql tables. When
I execute the sql query (which is a join operation on two tables) in the
mysql shell, the results are shown correctly. However, if I use cgi script
to execute the same query, the web browser just crashed after a while
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
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 =
"Driver={MySQL};SERVER=xxx.xxx.xxx.xxx;DATAB
IL PROTECTED]>
Sent: Monday, 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 NoOfRe
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 a empty screen with a browser!
I'm using Ultradev to create this and whe
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, (TO_DAYS(ActArrDate)-TO_DAYS(ExpDepDate)) as
Act_Est FROM oceandata
I'll get nothing, just a empty screen with a browser!
I'm using U
Stephen Sokalski wrote:
>
>
> Stephen Sokalski wrote:
>
>> I'm running this on a RAQ.
>>
>> Here is the problem. Something very strange has happened to my older
>> version of mysql (3.23.37).
>>
>> Not only can I not get it to shut down with
>> "/usr/share/mysql/mysql.server stop" but even if
CTED]>
Cc: "Gelu Gogancea" <[EMAIL PROTECTED]>
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 :(
> somethin
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
<[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.
PROTECTED]
[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
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
Okay:
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 /var/tmp instead of
/usr/local/mysql/var for the
Hi,
i've got a really strange problem with a request using multiple left join
and order by :
Here is the first sql query :
i display two columns of my table CV and one column of table ANNOTATION_CV
SELECT ID_CV,
TITRECV,ANNOTATION_CV.ANNOTATION_CV
FROM CV
LEFT JOIN CV_POSE ON CV_POSE.
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 happene
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 th
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 create
Hi,
I work with a rel. 3.23.36 of MYSQL and I have found this problem:
I have two tables named t_payments and t_payment_lang; these are their
descriptions and data:
t_payments (description):
+-+---+--+-+-+
+
| Field | Type
Hi,
When i use the mysqlclient to view some data from the table KLASSEN i get
some strange partially missing data.
like this:
select DISTINCTROW * from KLASSEN where KlasseID='Y_FILTER' order by
Kenmerk;
+--+-+--+
| KlasseID | Kenmerk | O
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 /etc/rc.d/ini
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 /etc/rc.d/init.d/mysql stop skript, but it
doesn´t done so ..
Killing mysqld with pid
kill
When submitting a form to insert/replace data into my database with
values loaded from the previos page I show that everything is entered
except for these fields: Why? I am using version mysql-3.23.32-1.7
| Field| Type | Null | Key | Default |
Extra |
rating
Hi,
there is somethng strange in installing mysql using my own made
charset. Configuration and compilation is going ok. But after that
I can't use mysql not as root not as aother user... When I do
safe_mysqld --skip-grant & all is Ok (logical) I can change
privileges make drop datab
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 sim
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 query, such as:
select name, count(*) from tbl_users group by name;
In t
Hi!
> "Peter" == Peter Zaitsev <[EMAIL PROTECTED]> writes:
Peter> Hello ,
Peter> Few time ago I've started to get the following problems, which several
Peter> times allready lead to data lost for me.
Peter> Here is the example:
Peter> I found the followings in my application error log:
Hello ,
Few time ago I've started to get the following problems, which several
times allready lead to data lost for me.
Here is the example:
I found the followings in my application error log:
Query - #1017 [opal.local] - Can't find file: 'g04stat_languages.MYD' (errno: 2)
select visitors,loa
53 matches
Mail list logo
