How are you importing the dump into mysql? Importing by piping the dump
file to mysql may broke some chars due to shell.
Have you tried this: (with in mysql client)
SET NAMES UTF8; SET CHARACTER SET UTF8
source /pathto/dump.sql
Cheers,
--Ravi
Sean O'Hara wrote:
Hi All,
I've been googling al
Hi,
If you relay log is lost try out the this :-
Run the Change Master Position script, See the log output from where did the
replication stopped.
So you can start your replication.
Thanks & Regards
Dilipkumar
- Original Message -
From: "Kenji HIROHAMA" <[EMAIL PROTECTED]>
To:
Sen
Hi,
Under my replication environment, what should I do if I lose the
current relay-log file on slave side?
1. one master and one slave replication is working
2. stop the master and the slave
3. remove the current relay log file manually
4. I can't start replication with "start slave" command
the
On Tue, 2006-08-01 at 16:23 -0700, Robert DiFalco wrote:
> I have a table that contains properties that can be associated with any
> table whose primary key is a LONG. Lets say that there is just one kind
> of property. The table looks something like this:
>
> TABLE StringVal
> REF_ID B
ok, here is the schema that I am working with:
CREATE TABLE `cd` (
`id` int(10) unsigned NOT NULL auto_increment,
`user_id` int(10) unsigned NOT NULL,
`title` varchar(100) NOT NULL,
`description` text NOT NULL,
`dt` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM
CREATE TABLE `song
On Wed, Aug 02, 2006 at 12:35:30AM +0200, Martin Jespersen wrote:
> I just ran the following sql (on mysql 4.1.20):
>
> update tbl set col1=col2, col2=col1
I went through this recently with the MySQL folks and the long and
short of it is that the above statement is undefined in MySQL. It may
s
n> http://dev.mysql.com/downloads/
> Look for "older releases"
Thanks but I want an older _build_ of the 5.0 release, not an older
release.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I have a table that contains properties that can be associated with any
table whose primary key is a LONG. Lets say that there is just one kind
of property. The table looks something like this:
TABLE StringVal
REF_ID BIGINT// row to associate property with
TYPE_ID BIGINT
it's a frequent operation based on a where clause
Barry Newton wrote:
At 06:35 PM 8/1/2006, Martin Jespersen wrote:
I just ran the following sql (on mysql 4.1.20):
update tbl set col1=col2, col2=col1
To my surprise, mysql updates col1 via col1=col2 before reading it for
use in col2=col1, s
At 06:35 PM 8/1/2006, Martin Jespersen wrote:
I just ran the following sql (on mysql 4.1.20):
update tbl set col1=col2, col2=col1
To my surprise, mysql updates col1 via col1=col2 before reading it for use
in col2=col1, so I end up with the same value in both columns, which, of
course, was n
I just ran the following sql (on mysql 4.1.20):
update tbl set col1=col2, col2=col1
To my surprise, mysql updates col1 via col1=col2 before reading it for
use in col2=col1, so I end up with the same value in both columns,
which, of course, was not my intention. Thinking about it, this behavi
Howdy all,
We're looking at building a new database server and
I'm looking into strategies for optimizing disk i/o.
Bit of background. We will be running a single
database on this box under MySQL 5.0.15. All of the
tables are INNODB. We have about 130 tables in the db.
I've read that it's a good
http://dev.mysql.com/downloads/
Look for "older releases"
Dan
On 8/1/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
I filed bug #20941 (mysqld seg faults during instance configuration on
XP pro, http://bugs.mysql.com/?id=20941) some time ago and have seen no
real movement on fixing it. I'm d
I would like to withdraw my earlier bug report with the same subject
line. I discovered that an erroneous IP address for the server
machine had gotten into /etc/hosts (due to some IP changes in my
organization). Once the DNS error was resolved, I was able to connect
correctly and fix the password
At 02:37 PM 8/1/2006, Cesar David Rodas Maldonado wrote:
Hello to all!
How can I optimize this query
select * from table where col1 = 5 && col2 = 15;
Put both fields in the same index index. The first index should be the
column with the least unique values (col1 by your example).
If I k
Hello to all!
How can I optimize this query
select * from table where col1 = 5 && col2 = 15;
If I know that col2 I have 15 rows and col1 I have just 100 rows, I
know that because I save that data in another table.
How can I do for search first where is minus number of result?
The two co
On Tue, 2006-08-01 at 17:39 +0530, ViSolve DB Team wrote:
> Hello Prashant,
>
> If you do need the duplicate rows in the final result, use UNION ALL with
> your query. Otherwise you can opt for UNION as UNION is faster than UNION
> ALL.
I have never heard of any evidence of this; in fact, it ma
When I ran version 4, mysql would start as many mysqld process as it
needed. This would vary depending upon how busy it was. As a lay
perosn I will refer to this as the threading model.
I have upgraded to version 5 and notice that no matter what it only
runs 1 mysqld. Everything seems to work
>Description:
I'm sorry This is long, but it's because I've tried hard to fix this
myself; please bear with me.
Last week, for unknown reason, my root password for MySQL wasn't
working. I may have changed it without updating the "/root/.my.cnf"
file. So, I went to the online documentation (whic
Hi All,
I've been googling all morning trying to find info on how to do a
mysqldump of a utf8 encoded database from which I can restore without
corrupting all the non ascii characters. If anyone has any pointers
on this, I'd be most grateful.
Here is my setup. I am building a ruby on rail
I filed bug #20941 (mysqld seg faults during instance configuration on
XP pro, http://bugs.mysql.com/?id=20941) some time ago and have seen no
real movement on fixing it. I'm dead in the water. I can't get MySQL
v5.0 to work on my system. I'd like to try installing an older build
as a stop gap
Hi All,
I am a new to this mailing list. Also to Mysql.
Anybody knows how mysql is installed and used in Integrity RTOS.
Plz fwd if any docs are available.
Thanks,
Regards,
Ravi K
The information contained in this electronic message and any attachments to
this message are inte
Hello Prashant,
If you do need the duplicate rows in the final result, use UNION ALL with
your query. Otherwise you can opt for UNION as UNION is faster than UNION
ALL.
Thanks,
ViSolve DB Team.
- Original Message -
From: "PRASHANT N" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, August 0
we are working on automotive traking solutions and insert our location records
into the mysql database v 4.1.20. If we want search for a particular record,
its taking too long time and mysql is identifying the queries as slow queries.
I have attached the queries.
You've posted this multiple t
hi,
we are working on automotive traking solutions and insert our location records
into the mysql database v 4.1.20. If we want search for a particular record,
its taking too long time and mysql is identifying the queries as slow queries.
I have attached the queries.
How to optimize the attac
hi, Dan Nelson, Jochem van Dieten, and Chris
Thx!
I think I understand it after your replies.
Regards,
Leo Huang
2006/7/30, Dan Nelson <[EMAIL PROTECTED]>:
In the last episode (Jul 29), Jochem van Dieten said:
> On 7/28/06, Dan Nelson wrote:
> >In the last episode (Jul 28), leo huang said:
>
Hi Khaing su yee,
If the character set is not available in your MySQL, then add the particular
character set to MySQL. You must have a MySQL source distribution to use
these instructions.
First, decide whether the character set is simple or complex and then
proceed with it.
/the name of
Hi,
> I am trying to JOIN 2 tables TBL1 and TBL2 on TBL1.fld_id
> = TBL2.fld_id . And finally I filter out the results that
> i need in the where clause using
>
> where TBL1.fld_col = 100;
>
> Running an EXPLAIN shows that it is an impossible where
> condition. This may be because there may be no
Helo all,
I need explanation on EXPLAIN here.
I am trying to JOIN 2 tables TBL1 and TBL2 on TBL1.fld_id = TBL2.fld_id . And
finally I filter out the results that i need in the where clause using
where TBL1.fld_col = 100;
Running an EXPLAIN shows that it is an impossible where condition. This m
29 matches
Mail list logo
