Re: import database
.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 jessicabel...@yahoo.comwrote: 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
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' password to be granted ALL PRIVILEGES. Just my opinion. On Wed, Aug 17, 2011 at 9:54 AM, Johnny Withers joh...@pixelated.netwrote: It would allow anyone from anywhere to access your server as root with full access to all databases using the password 'mysql'. Not very secure. I don't recommend having a root@% defined. On Aug 17, 2011 8:50 AM, Brent Clark brentgclarkl...@gmail.com wrote: Hiya Thank you so much for replying. I really appreciate it. I know the answer (well I think I do :) ), but im still going to ask. What is the risk if do the GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'mysql' WITH GRANT OPTION; To satisfy the developer. Thank you again. Brent On 17/08/2011 15:42, Johnny Withers wrote: Change the definer to one of your registered root accounts. Root@127or root@localhost. On Aug 17, 2011 8:39 AM, Brent Clark brentgclarkl...@gmail.com mailto: brentgclarklist@gmail.c...
Re: does mysql support master to master replication
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 yyll2...@yahoo.com wrote: Hi, Folks: Does mysql support master to master replication, or master to slave replication on;y? I did not find the answer in MySQL manual, but found some discussion over the internet. Does anybody know? if so, anybody has implemented master to master replication in production? Thanks Angela
Re: does mysql support master to master replication
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=discussedNewsgid=72881item=60056153type=membertrk=eml-anet_dig-b_pd-ttl-cn On Wed, Aug 3, 2011 at 1:10 AM, Angela liu yyll2...@yahoo.com wrote: Hi, Folks: Does mysql support master to master replication, or master to slave replication on;y? I did not find the answer in MySQL manual, but found some discussion over the internet. Does anybody know? if so, anybody has implemented master to master replication in production? Thanks Angela
Re: How to view Query Execution time
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 aim.prab...@gmail.comwrote: you can also use EXPLAIN, which will give you much more details. http://dev.mysql.com/doc/refman/5.5/en/execution-plan-information.html http://www.techiequest.com/mysql-visual-explain-hierarchical-view-of-query-execution-plan/ On Sun, Jul 31, 2011 at 11:45 PM, Suresh Kuna sureshkumar...@gmail.com wrote: Usually, at the end of the query running it displays the time how much it took. Or else enable the profiling and run the query to check the exact time it took for execution at all levels. On Mon, Aug 1, 2011 at 12:11 PM, Adarsh Sharma adarsh.sha...@orkash.com wrote: Dear all, I want to know how much time did it take to run a sample query. In postgresql, we enable timing by \timing command. Is there is any way to enable in Mysql Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?** unsub=sureshkumar...@gmail.com http://lists.mysql.com/mysql?unsub=sureshkumar...@gmail.com -- Thanks Suresh Kuna MySQL DBA -- Best Regards, Prabhat Kumar MySQL DBA My Blog: http://adminlinux.blogspot.com My LinkedIn: http://www.linkedin.com/in/profileprabhat
Low priority write
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 request read locks as client(C) requests a INSERT lock. The last of the read locks are finished selecting. Does client (B) or (C) acquire their lock first? Will it go by priority or in order which the requests were received. I could not find documentation in forums or MySQL reference regarding this. Thanks!
