Re: import database

2011-10-10 Thread Jim Moseby
>>> Jessica Bela 10/10/2011 4:47 PM >>> Hi all, how I can import in my PC a database Mysql that has been created in another PC and with other tools? Assuming the source and destination are BOTH mysql databases: mysqldump database > export.sql ...creates a file 'export.sql'. Copy it to th

Re: replication between two tables in same database

2011-09-29 Thread Jim Moseby
Sounds like a job for CREATE TRIGGER to me. :) http://dev.mysql.com/doc/refman/5.0/en/create-trigger.html >>> Tompkins Neil 9/29/2011 12:56 PM >>> Hi I've a Innodb and MyISAM table in the SAME database that I wish to replicate the data between the two because I need to use FULLTEXT searchi

Re: SLOW performance over network

2011-09-29 Thread Jim Moseby
Yeah: # host 72.30.2.43 /* yahoo.com */ 43.2.30.72.in-addr.arpa domain name pointer ir1.fp.vip.sk1.yahoo.com. # host 10.1.20.97 /* my windows box */ 97.20.1.10.in-addr.arpa has no PTR record >>> Todd Lyons 9/29/2011 10:26 AM >>> On Thu, Sep 29, 2011 at 7:12 AM, Jim Moseby

SLOW performance over network

2011-09-29 Thread Jim Moseby
mysql Ver 14.12 Distrib 5.0.51a, for debian-linux-gnu (i486) using readline 5.2 Strange, strange problem. Everything was fine yesterday morning, then all of a sudden any query over the network takes a REALLY long time to return. If I log in at the server console, every query is snappy-fast.