what do yo get when you run "show slave status" on the slave?
are you replicating the database you are modifying?
Isart Montane
On Tue, Jun 23, 2009 at 7:29 AM, sangprabv wrote:
> I have configured mysql replication and test to insert some records.
> Both nodes synchronized but
Hi Jason,
if you run mysql with -f it will ignore any errors and continue importing
cat aac.sql | mysql -f -u root AAC
Isart
On Wed, Jun 17, 2009 at 8:59 PM, Jason Novotny wrote:
> Hi,
>
> I'm trying to import a dumpfile like so:
>
> cat aac.sql | mysql -u root AAC
>
> It all runs fine unti
I agree with Per, I use utf8 and it works fine for me, even with Chinese
characters
On Fri, Jun 12, 2009 at 8:40 AM, Per Jessen wrote:
> PJ wrote:
>
> > Let me put it this way, I am not having the problem. The problem seems
> > to be withthe way that character encoding is set up on the internet
Hi,
I'm not having any problem on my local computer
mysql> select text,text2 from table1 order by text2 desc;
+--+---+
| text | text2 |
+--+---+
| a| 1 |
| �| 0 |
+--+---+
mysql>select text,text2 from table1 order by text2 desc;
+--+---+
| text | t
Hi,
any message on the error log? Have you tried restarting the mysql server?
On Tue, May 26, 2009 at 7:24 PM, PJ wrote:
> Hydro Quebec just f***ed my server just as I was booting up three
> machines; XP is ok, FreeBSD 7.1 is the one with mysql problem, FreeBSD
> 4.10 - don't know, but boots ok
I've been using phpmyadmin as a MySQL GUI for some time and worked great for
me.
www.*phpmyadmin*.net
Isart
On Tue, Jun 9, 2009 at 8:57 PM, Daevid Vincent wrote:
> SQLYog by Webyog is the best mySQL GUI client for Windows. Hands down. not
> even a question. I've used them all I think.
>
> ht
have you checked with myisamchk?
On Thu, Nov 13, 2008 at 4:09 PM, Jed Reynolds <[EMAIL PROTECTED]> wrote:
> Application in php 5.1.6.I'm running MySQL version 5.0.45 on CentOS5 using
> a HP DL380 with 8G ram and 15krpm raid10 disks. Tables are myisam.
>
> I'm seeing errors in my application wher
Hi Daevid
If you are using a foreign key you can set the reference as "cascade"
and when a row is deleted from feed it will be deleted from feed_tag.
http://dev.mysql.com/doc/refman/5.0/en/innodb-foreign-key-constraints.html
If you don't like it you can delete it easy with a query like this
del
