RE: Looking for free MySQL Administrator
I'm looking for a MySQL administrator for 4.x/5.x that will allow me to Any suggestions? TIA http://www.webyog.com/ Regards, Rithish. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Looking for free MySQL Administrator
Check out http://www.mysql.com/products/tools/ for some good stuff... Raj Mehrotra [EMAIL PROTECTED] -Original Message- From: Rithish Saralaya [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 23, 2006 1:21 PM To: mysql@lists.mysql.com Subject: RE: Looking for free MySQL Administrator I'm looking for a MySQL administrator for 4.x/5.x that will allow me to Any suggestions? TIA http://www.webyog.com/ Regards, Rithish. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Looking for free MySQL Administrator
there is also a nice tool for Mac OSX called CocoaMySQL. http://cocoamysql.sourceforge.net/ George Law -Original Message- From: Rajesh Mehrotra [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 23, 2006 3:58 PM To: Rithish Saralaya; mysql@lists.mysql.com Subject: RE: Looking for free MySQL Administrator Check out http://www.mysql.com/products/tools/ for some good stuff... Raj Mehrotra [EMAIL PROTECTED] -Original Message- From: Rithish Saralaya [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 23, 2006 1:21 PM To: mysql@lists.mysql.com Subject: RE: Looking for free MySQL Administrator I'm looking for a MySQL administrator for 4.x/5.x that will allow me to Any suggestions? TIA http://www.webyog.com/ Regards, Rithish. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Looking for free MySQL Administrator
At 11:57 AM 5/20/2006, John Hicks wrote: mos wrote: At 10:10 AM 5/20/2006, Keith Roberts wrote: http://www.phpmyadmin.net/home_page/index.php I think phpmyadmin will allow you to make changes to multiple columns at once. Sorry, I should have mentioned I was looking for a MySQL Administrator running on Windows. Going through PHP seems like a round about way of accessing the database since I don't have PHP running and the database is not on the web. It's running on the local machine. I suppose I could install Apache and PHP and modify the database through a browser, but it seems a bit awkard. If it's running on your own box, why not use the 'mysql' client sql-command-line utility? A single 'alter table' query can contain multiple 'change column' and 'modify column' phrases. --J Sure, I've done that in the past for smaller tables. But it is too easy to make a mistake in defining the column definition(s) and then it's another 30 minute wait for the table to become available again. Someone mentioned SqlYog and it indeed works just fine. It's free too. :) Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Looking for free MySQL Administrator
Why am I suddenly getting huge volumes of mail about SQL? What forum is this, and how do I get out of it? ++ Phil Robbins Auckland New Zealand ++ _ Find the coolest online games @ http://xtramsn.co.nz/gaming -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Looking for free MySQL Administrator
In the last episode (May 22), Phil Robbins said: Why am I suddenly getting huge volumes of mail about SQL? What forum is this, and how do I get out of it? This is a MySQL mailing list. To unsubscribe, click on the link at the bottom of the email right after the words To unsubscribe: :) -- Dan Nelson [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Looking for free MySQL Administrator
I'm looking for a MySQL administrator for 4.x/5.x that will allow me to make multiple changes to a table structure without reloading the data after each change. The problem is I may have to change 5 columns on a 10 million row table. As it stands now with the administrator I'm using, it will reload the table after each change (very slow because it means 5 reloads-1 for each column). So I need to batch the 5 table changes then have it alter the table. (Of course I could use Alter Table with multiple columns but if I make a mistake, there goes data for 10 million rows-Ouch!) Any suggestions? TIA Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Looking for free MySQL Administrator
http://www.phpmyadmin.net/home_page/index.php I think phpmyadmin will allow you to make changes to multiple columns at once. For any major changes to a database such as you describe, if you have the disk space, I would advise copying the database and performing your changes on the copy, just in case you do make an irreversible mistake. At least you will still have the original tables to work with again, and not loose your database. As a matter of interest, how large is the database in MB's or GB's? Once you are sure you know EXACTLY what you are doing to your database, then it should be safe to work on the live database, and perform the changes to that. Just my 2c Kind Regards Keith In theory, theory and practice are the same; in practice they are not. On Sat, 20 May 2006, mos wrote: To: mysql@lists.mysql.com From: mos [EMAIL PROTECTED] Subject: Looking for free MySQL Administrator I'm looking for a MySQL administrator for 4.x/5.x that will allow me to make multiple changes to a table structure without reloading the data after each change. The problem is I may have to change 5 columns on a 10 million row table. As it stands now with the administrator I'm using, it will reload the table after each change (very slow because it means 5 reloads-1 for each column). So I need to batch the 5 table changes then have it alter the table. (Of course I could use Alter Table with multiple columns but if I make a mistake, there goes data for 10 million rows-Ouch!) Any suggestions? TIA Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Looking for free MySQL Administrator
At 10:10 AM 5/20/2006, Keith Roberts wrote: http://www.phpmyadmin.net/home_page/index.php I think phpmyadmin will allow you to make changes to multiple columns at once. Sorry, I should have mentioned I was looking for a MySQL Administrator running on Windows. Going through PHP seems like a round about way of accessing the database since I don't have PHP running and the database is not on the web. It's running on the local machine. I suppose I could install Apache and PHP and modify the database through a browser, but it seems a bit awkard. For any major changes to a database such as you describe, if you have the disk space, I would advise copying the database and performing your changes on the copy, just in case you do make an irreversible mistake. Its not a production database and I have backups. All of the data can be regenerated if needed. At least you will still have the original tables to work with again, and not loose your database. As a matter of interest, how large is the database in MB's or GB's? Pretty small, around 44gb. I had some tables that had 100 million rows in it now its down to 34 million rows. I had tried for 500 million rows in one table but had to split it into smaller tables because the index could not be built (kept running out of memory). Mike On Sat, 20 May 2006, mos wrote: To: mysql@lists.mysql.com From: mos [EMAIL PROTECTED] Subject: Looking for free MySQL Administrator I'm looking for a MySQL administrator for 4.x/5.x that will allow me to make multiple changes to a table structure without reloading the data after each change. The problem is I may have to change 5 columns on a 10 million row table. As it stands now with the administrator I'm using, it will reload the table after each change (very slow because it means 5 reloads-1 for each column). So I need to batch the 5 table changes then have it alter the table. (Of course I could use Alter Table with multiple columns but if I make a mistake, there goes data for 10 million rows-Ouch!) Any suggestions? TIA Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Looking for free MySQL Administrator
mos wrote: Sorry, I should have mentioned I was looking for a MySQL Administrator running on Windows. Have you tried the MySQL Query Browser free download from mysql.com? I use it and it lets me change records and does not reload the table unless I tell it to. I'm not sure if it has any limitations on how many rows it can fetch at once. I just did a select * from my largest table, and in 100 seconds it said it returned 890,000 rows, don't know how to verify it really has that many rows displayed in the query browser, but I don't know why it wouldn't. -- Chris W KE5GIX Gift Giving Made Easy Get the gifts you want give the gifts they want One stop wish list for any gift, from anywhere, for any occasion! http://thewishzone.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Looking for free MySQL Administrator
mos wrote: At 10:10 AM 5/20/2006, Keith Roberts wrote: http://www.phpmyadmin.net/home_page/index.php I think phpmyadmin will allow you to make changes to multiple columns at once. Sorry, I should have mentioned I was looking for a MySQL Administrator running on Windows. Going through PHP seems like a round about way of accessing the database since I don't have PHP running and the database is not on the web. It's running on the local machine. I suppose I could install Apache and PHP and modify the database through a browser, but it seems a bit awkard. If it's running on your own box, why not use the 'mysql' client sql-command-line utility? A single 'alter table' query can contain multiple 'change column' and 'modify column' phrases. --J -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]