Re: import database

2011-10-10 Thread Jon Siebert
.here is one way http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html On Mon, Oct 10, 2011 at 4:47 PM, Jessica Bela wrote: > Hi all, > how I can import in my PC a database Mysql that has been created in > another PC and with other tools?

Re: Concerned : Developer getting There is no 'root'@'%' registered error message

2011-08-17 Thread Jon Siebert
Perhaps he could make the stored procedure functional by creating a user with the EXECUTE permission (somebody please fell free to correct me if I am mistaken) if it is to be used to execute a stored procedure. You don't want someone to attempt using the 'root' username with a typical 'mysql' passw

Re: does mysql support master to master replication

2011-08-02 Thread Jon Siebert
I had seen a discussion here as well, but honestly did not test it. It may be of help. http://www.linkedin.com/groupItem?view=&srchtype=discussedNews&gid=72881&item=60056153&type=member&trk=eml-anet_dig-b_pd-ttl-cn On Wed, Aug 3, 2011 at 1:10 AM, Angela liu wrote: > Hi, Folks: > > Does mysql su

Re: does mysql support master to master replication

2011-08-02 Thread Jon Siebert
MySQL, to my knowledge, supports only Master to Slave replication- as well as Master-slave-slave replication. http://dev.mysql.com/doc/refman/5.0/en/replication.html On Wed, Aug 3, 2011 at 1:10 AM, Angela liu wrote: > Hi, Folks: > > Does mysql support master to master replication, or master to

Re: How to view Query Execution time

2011-08-01 Thread Jon Siebert
http://dev.mysql.com/doc/refman/5.1/en/query-log.html information on query log may become useful for you in the future. Also, search the slow query log, which also may help you in the future On Mon, Aug 1, 2011 at 11:54 AM, Prabhat Kumar wrote: > you can also use EXPLAIN, which will give you much

Low priority write

2011-07-09 Thread Jon Siebert
Low Priority Lock Hello was wondering if anybody would have some input: This will be on the same table. Client (A) acquires a READ lock; immediately thereafter a large amount of clients wait for a read lock as well, and client(B) requests a LOW PRIORITY insert. Another surge of clients reques