 | | | MySQL General | | Ratheesh K J schrieb
> Hello all
>
> I issued a create table statement on the master for a table which was not present on the master but present on the slave.
> I did this purposely to see the errorHello all
I issued a create table statement on the master for a table which was not present on the master but present on the slave.
I did this purposely to see the error on slave.
I am a newbie to [snip]
Try
replace(replace(dealerLong '\n ' ' ') '\r ' ' ')
[/snip]
Didn 't work perhaps because they are hidden. I ended up taking the long
road
update table set foo replace(HEX(foo) '0D ' ' 'Try
replace(replace(dealerLong '\n ' ' ') '\r ' ' ')
Jay Blanchard wrote
> I did some googleing and some other searching now I am looking for a
> cure all. I have a column into which it appears tThis has been asked for many many times on this list not sure why mySQL AB
doesn 't just release a command line tool like a 'mysql diff ' and also a
'mysql lint '. The lint one should be totally trivialBryan Cantwell wrote
> I have Mysql 5.0.45 using innodb tables.
> Occasionally I get corrupted tables. I can go into Mysql administrator
> gui and see the bad table and I can repair the index or whaI have Mysql 5.0.45 using innodb tables.
Occasionally I get corrupted tables. I can go into Mysql administrator
gui and see the bad table and I can repair the index or whatever is
wrong from the gui.Hi Jay
Try this
http //www.xaprb.com/blog/2006/04/14/bad-character-data-in-mysql/
Baron
Jay Blanchard wrote
> I did some googleing and some other searching now I am looking for a
> cure all. II did some googleing and some other searching now I am looking for a
cure all. I have a column into which it appears that a carriage return
has been inserted and it is mucking about with some queries > Hopefully that 's enough info for you to decide whether you read it right.
> But it looks like your slave had some issue with that. Do you have a lot
> of privileges? One of the Google engineers Jesse wrote
> > What is the event at that position in the binlog? Use the mysqlbinlog
> > tool to see or on the master you can run SHOW BINLOG EVENTS (check
> > the manual for the full syntax).
>
> > What is the event at that position in the binlog? Use the mysqlbinlog
> tool to see or on the master you can run SHOW BINLOG EVENTS (check the
> manual for the full syntax).
If I 'm reading thisJesse wrote
> > I can 't think of anything other than looking deeper into the MySQL log
> > files. I 'm not sure where those are on Windows but I imagine it 's
> > not all going to the event log. Mayb > I can 't think of anything other than looking deeper into the MySQL log
> files. I 'm not sure where those are on Windows but I imagine it 's not
> all going to the event log. Maybe there is sometIt seems that way to me too Baron.
I actually did a test using Navicat and intput
a test debit into the table directly. It took the
amount 150.49 without any problem nor did it
round it off to Hi Jesse
Jesse wrote
> I posted this message on the Replication list but have got no
> responses so I figured I 'd try here.
>
> I just set up Replication recently with a Web Server 2003 serverHi Jesse
Jesse wrote
> I posted this on the Replication list but have received no reply so I
> figured I 'd try here.
>
> When the databases get out of sync during replication what is the best I posted this on the Replication list but have received no reply so I
figured I 'd try here.
When the databases get out of sync during replication what is the best way
to re-sync them on a WindowsI posted this message on the Replication list but have got no responses
so I figured I 'd try here.
I just set up Replication recently with a Web Server 2003 server being the
master and a Windows Hi Rick
(I 'm CCing the list in again -- keeping the discussion on-list lets
everyone see it and potentially solve their own problems by searching
archives in future).
It looks to me like it oughtVery well Works thanks.
-----Mensaje original-----
De Ananda Kumar [mailto anandkl@(protected)]
Enviado el lunes 01 de octubre de 2007 13 16
Para informatica@(protected)
CC mysql@(protected)can u please give sample data.
If the same city has more than one order_id then you could use this
select city count(*) "total " from table group by city order by total desc
limit 10
regards
anandHi all
I have a table with ordes and i want to know the top 10 Citys have the most
ordes. This is my table
Order_id City
Need count the rows where haver the most similar text y the columHi Baron
The answers are as below
I have not upgraded the server. Done tuning on my.cnf on innodb parameters.
No i have not change the storage engine from MYISAM to INNODB
Regards
Krishna
On 9/2
--- Krishna Chandra Prajapati <prajapatikc@(protected) > wrote
> Hi All
>
> Is there is any script or tool that can diagnostic the mysql. It can check
> for the errors give suggestion give reportsI 'm running Apache/MySQL/PHP5 on a CentOS 5 server and have started to get
some strange date and time inconsistencies between OS time and MySQL time
( "now() ").
1. MySQL Time
[proton200@(protected)Hi All
There are many user accessing the production server and making a lots of
mistake running wrong query (It occurs by mistake if they don 't pay
attention) . There is any tools or script which cHi All
Is there is any script or tool that can diagnostic the mysql. It can check
for the errors give suggestion give reports and send emails.
It can check the mysql system variables and give suggHello David
David Schneider-Joseph wrote
> Hi all
>
> What do you know about the effect of conflicting slave server IDs on the
> master in general? And specifically are you aware of any issuesHi
I use mysql-5.0.45 on opensuse 10.2 linux x86.
The following reproducably breaks replication
node A is master
node B is slave
A mysql > use anydb
A mysql > drop view asdasdasd
ERROR 1051 (42S0 |
|
|
