Re: MySQL Administration Tools
At 11:19 -0800 1/22/04, David Blomstrom wrote: I'm using a preconfigured package that includes PHPMyAdmin, which seems to be a pretty good program. However, I just read that similar programs are available, including MySQL Control Center, EMS MySQL Manager, urSAL, PremiumSoft MySQL Studio and MySQLGUI. I just wondered if there might be some advantage to having two or more such programs installed. Would working with MySQL through two different interfaces give you a different perspective, making it a little easier to understand? Or are there particular strengths each program has? Also, would different MySQL administration tools conflict with each other? If you created a new database with phpMyAdmin, would it be recognized by MSQL Control Center? Could you work on MySQL with both programs on at the same time? I just wondered if there might be some advantage to having two or more suchprograms installed. Would working with MySQL through two different interfaces give you a different perspective, making it a little easier to understand? Or are there particular strengths each program has? I believe so, as you get different persectives from different interfaces. As far as easier to understand, I think that's relative to one's current understanding -- certainly different people prefer different tools. Many of the programs attempt to provide the same basic functionality, but certainly most have some key strengths -- a tool like urSQL, for example, isn't as strong at administration, as it's geared more toward SQL development, query testing, and ad hoc queries. Also, would different MySQL administration tools conflict with each other? No, I'm not aware of any conflicts between MySQL tools and it doesn't seem likely that there would be. If you created a new database with phpMyAdmin, would it be recognized by MSQL Control Center? Definitely. The database creation is handled at the MySQL server and is independent of the tool. Could you work on MySQL with both programs on at the same time? This should also be possible. However, you might want to be careful with updates and deletes as one program could easily overwrite a previous update or incorrectly identify a row (e.g. when a value of a where clause changes). -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL Administration Tools
I'm using a preconfigured package that includes PHPMyAdmin, which seems to be a pretty good program. However, I just read that similar programs are available, including MySQL Control Center, EMS MySQL Manager, urSAL, PremiumSoft MySQL Studio and MySQLGUI. I just wondered if there might be some advantage to having two or more such programs installed. Would working with MySQL through two different interfaces give you a different perspective, making it a little easier to understand? Or are there particular strengths each program has? Also, would different MySQL administration tools conflict with each other? If you created a new database with phpMyAdmin, would it be recognized by MSQL Control Center? Could you work on MySQL with both programs on at the same time? Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Administration Tools
At 11:19 -0800 1/22/04, David Blomstrom wrote: I'm using a preconfigured package that includes PHPMyAdmin, which seems to be a pretty good program. However, I just read that similar programs are available, including MySQL Control Center, EMS MySQL Manager, urSAL, PremiumSoft MySQL Studio and MySQLGUI. I just wondered if there might be some advantage to having two or more such programs installed. Would working with MySQL through two different interfaces give you a different perspective, making it a little easier to understand? Or are there particular strengths each program has? Also, would different MySQL administration tools conflict with each other? If you created a new database with phpMyAdmin, would it be recognized by MSQL Control Center? Could you work on MySQL with both programs on at the same time? Yes on both counts. -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com MySQL Users Conference: April 14-16, 2004 http://www.mysql.com/uc2004/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Administration Tools
On Thursday 22 January 2004 02:19 pm, David Blomstrom wrote: I'm using a preconfigured package that includes PHPMyAdmin, which seems to be a pretty good program. However, I just read that similar programs are available, including MySQL Control Center, EMS MySQL Manager, urSAL, PremiumSoft MySQL Studio and MySQLGUI. I just wondered if there might be some advantage to having two or more such programs installed. Would working with MySQL through two different interfaces give you a different perspective, making it a little easier to understand? Or are there particular strengths each program has? All should support what MySQL offers. Whether they do or not is another question. Use what you find most useful. Also, would different MySQL administration tools conflict with each other? No. If you created a new database with phpMyAdmin, would it be recognized by MSQL Control Center? Yes Could you work on MySQL with both programs on at the same time? Yes Thanks. You're welcome. James -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Administration Tools
At 13:34 -0600 1/22/04, Paul DuBois wrote: At 11:19 -0800 1/22/04, David Blomstrom wrote: I'm using a preconfigured package that includes PHPMyAdmin, which seems to be a pretty good program. However, I just read that similar programs are available, including MySQL Control Center, EMS MySQL Manager, urSAL, PremiumSoft MySQL Studio and MySQLGUI. I just wondered if there might be some advantage to having two or more such programs installed. Would working with MySQL through two different interfaces give you a different perspective, making it a little easier to understand? Or are there particular strengths each program has? Also, would different MySQL administration tools conflict with each other? If you created a new database with phpMyAdmin, would it be recognized by MSQL Control Center? Could you work on MySQL with both programs on at the same time? Yes on both counts. Whoops, there are three counts, not two. The answers are no, yes, yes. :-) -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com MySQL Users Conference: April 14-16, 2004 http://www.mysql.com/uc2004/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Administration Tools
At 02:19 PM 1/22/2004, David Blomstrom wrote: I'm using a preconfigured package that includes PHPMyAdmin, which seems to be a pretty good program. However, I just read that similar programs are available, including MySQL Control Center, EMS MySQL Manager, urSAL, PremiumSoft MySQL Studio and MySQLGUI. I just wondered if there might be some advantage to having two or more such programs installed. Would working with MySQL through two different interfaces give you a different perspective, making it a little easier to understand? Or are there particular strengths each program has? Also, would different MySQL administration tools conflict with each other? If you created a new database with phpMyAdmin, would it be recognized by MSQL Control Center? Could you work on MySQL with both programs on at the same time? Thanks. I have both PHPMyAdmin MySQL Control Center Installed, and use both. Each program has a slightly different interface and method of access the databases, tables, and configuration information. Two big differencesall interfaces must be able to directly access the SQL Server. The thing about the PHPMyAdmin is that you install it on a web server that has access to the MySQL server. I have my SQL server behind a firewall and no one outside of the local LAN can access the SQL server. So when I am out of the office and need access to the SQL databases/server, I always use PHPMyAdmin. I have one machine with secure access setup running PHPMyAdmin that I access from the Internet, then use PHPMyAdmin on the Web Server to access and work on the mySQL Server. Patrick J. Shoaf, Systems Engineer mailto:[EMAIL PROTECTED][EMAIL PROTECTED] Midmon Internet Services, LLC 100 Third Street Charleroi, PA 15022 http://www.midmon.com Phone: 724-483-2400 ext. 105 or888-638-6963 Fax: 724-489-4386 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
