MySQL

For all things BigCommerce.. Chat, sharing ideas, links to tips and ways to make things work.

MySQL

Postby Iamdbat » Tue Dec 29, 2009 6:04 am

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

Re: MySQL

Postby Tony Barnes » Mon Jan 04, 2010 12:55 pm

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

Re: MySQL

Postby Iamdbat » Tue Jan 05, 2010 4:48 pm

Thanks Tony - I'll have a look at that
Iamdbat
 
Posts: 66
Joined: Sun Oct 18, 2009 1:47 am


Return to [BC] Community Support

Who is online

Users browsing this forum: Google [Bot] and 1 guest

cron