Hi win.a,
I tried with another user the problem still persists. I am getting same
error for another user as well.
--
Regards,
Manasi Save
On Tue, 7 Sep 2010 11:41:35 0800, win.a wrote:
use another user and dump the data ,eg the root .
mysqldump -uroot -p --al-databases
I'm not sure but you might try with sql_mode set to ANSI. Otherwise try the
dump
remotely from a Linux box.
Regards,
Nitin
From: Manasi Save manasi.s...@artificialmachines.com
To: win.a win@gmail.com
Cc: mysql@lists.mysql.com mysql@lists.mysql.com
Sent:
Hi
I've the following query :
SELECT total_team_rating, my_teams_id
FROM
(SELECT players.teams_id AS my_teams_id, SUM(players_master.rating) AS
total_team_rating
FROM players
INNER JOIN players_master ON players.players_id = players_master.players_id
WHERE players.worlds_id = 1 AND
Hello all, I am trying to REPLAY the mysqld.log file from a production 5.1.4
server onto a QA server with 5.5 running and was wondering if there is an easy
way of replaying the mysqld.log file? Just want to make sure all of the kinds
of inserts, updates, selects and deletes work just as well
Try using a mysqldump.
- Reply message -
From: ext Nunzio Daveri nunziodav...@yahoo.com
Date: Wed, Sep 8, 2010 19:25
Subject: Replaying the mysqld.log file from production onto QA???
To: mysql@lists.mysql.com mysql@lists.mysql.com
Hello all, I am trying to REPLAY the mysqld.log file from
I am curious about something.
I have a glue or hanging table like so:
CREATE TABLE `fault_impact_has_fault_system_impact` (
`id_fault_impact` int(10) unsigned NOT NULL,
`id_fault_system_impact` smallint(5) unsigned NOT NULL,
KEY `fault_impact_key`