Are there any good graphical tools (preferably free) for navigating a MySQL database? I find myself doing a lot of the same SQL queries to look at data in the tables. I would imagine there's a GUI for doing this that makes life easier. Any one know of such a thing?
Thanks a lot.
I'm working with a production MySQL database and I would like to:
QUESTION 1: Is this possible? I know (1) is possible because there's some documentation here http://dev.mysql.com/doc/refman/5.0/en/replication.html. But I'm not sure I can get both (1) and (2). I'm asking because I need to write code that accesses the database and since it's a production database used by everyone, there are times that I cannot use the database. I would like to write test programs that use the replicated slave (with non-permanent write access) and when I make sure everything is fine, I will run my program using the master database so the changes are permanent. I would like my writes to show up in the slave so I can make sure the right things are written.
QUESTION 2: Is it possible to replicate the database in pieces easily? The database has a table that is really huge. I think the database is on the order of 4GB. I can only do the replication over the weekend so I don't disturb everyone. But I'm afraid that one weekend's time is not enough to replicate the whole database. So, is there a way to do it piece by piece? Or is there some super fast way to replicate a database?
QUESTION 3: How complicated will it be to setup everything up? I would imagine it will take me a long long time due to inexperience, but suppose I got a DBA to do the work for me, how much trouble am I causing him/her?
Any help will be greatly appreciated! Btw, I very new to MySQL and databases in general so be gentle :)