Page 1 of 1

MySQL

Posted: Tue Dec 29, 2009 6:04 am
by Iamdbat
Has anyone played around and integrated changes to their MySQL Database and not lost sleep?

Is it easy? - I'm aware of PHPmyadmin BTW

Did you sweat it and made mistakes? - Could you roll back on any mistakes?

I've played around with microsoft access for a time but I'm in unsure territory with mysql

I've downloaded it and installed it but I don't know how to use it

Any suggestions?

Re: MySQL

Posted: Mon Jan 04, 2010 12:55 pm
by Tony Barnes
Do you have MySQL workbench? http://dev.mysql.com/downloads/gui-tools/5.0.html

I use MySQL adminstrator, etc, but it looks like they've recently upgraded to the above. Very easy to use - if you're doing anything "scary" just run a DB backup - you can then restore anything you do or don't want to.

So long as you back-up first, then worst case you need to restore to remove any cock ups. As typically SQL statements simply fail to run rather than half running and making a mess, it's fairly fool-proof anyway

Re: MySQL

Posted: Tue Jan 05, 2010 4:48 pm
by Iamdbat
Thanks Tony - I'll have a look at that