MySQL

For all things BigCommerce.. Chat, sharing ideas, links to tips and ways to make things work.
Post Reply
Iamdbat
Posts: 66
Joined: Sun Oct 18, 2009 1:47 am

MySQL

Post 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?
Tony Barnes
Posts: 744
Joined: Thu Jun 18, 2009 8:59 am

Re: MySQL

Post 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
Iamdbat
Posts: 66
Joined: Sun Oct 18, 2009 1:47 am

Re: MySQL

Post by Iamdbat »

Thanks Tony - I'll have a look at that
Post Reply