Modcraft - The community dedicated to quality WoW modding!

Wrath of the Lich King Modding => Serverside Modding => Topic started by: Benji_kun on April 04, 2013, 09:29:48 pm

Title: [QUESTION] What Database editor do you recommend for mac?
Post by: Benji_kun on April 04, 2013, 09:29:48 pm

Hi everyone,

I'm Benji an Admin and part time Developer on JutsuONLINE. I've been using Heidi SQL to make changes in our database but I also want to be able to make changes from my macbook. I tried using DbVisualizer and I can connect fine until I try to open the "Data" tab and I get this error;

An error occurred while performing the operation:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"jo_world"."item_template"' at line 1

If anyone could tell me what I'm doing wrong or recommend a better DB Editor I'd appreciate it greatly.

Thanks, Benji

Title: Re: [QUESTION] What Database editor do you recommend for mac
Post by: schlumpf on April 05, 2013, 12:33:31 am

Without posting the actual query, nobody will be able to help you.

Title: Re: [QUESTION] What Database editor do you recommend for mac
Post by: Benji_kun on April 05, 2013, 01:05:58 am

I actually figured out what I had done wrong now but I am having another issue that will undoubtably have a really simple answer making me feel quite stupid but here it goes anyway.

In Heidi SQL when you want to manipulate a value, you simply double click it and type in the new value, job done. However in DbVisualiser it doesn't seem to let me do this. I double click a field, I try typing in it when it's selected and I try right-clicking to see if there is an option to edit value but I really can't work it out.

Sorry for the noob question but any help would be appreciated or an alternative to DbVisualiser that I can use on mac.

Title: Re: [QUESTION] What Database editor do you recommend for mac
Post by: schlumpf on April 05, 2013, 01:22:15 am

Phpmyadmin fulfilled my complete GUI needs. Else, just use the command line and learn SQL.
I never had any other GUI and disliked most of those being suggested in guides. They tend to be horrible.

Title: Re: [QUESTION] What Database editor do you recommend for mac
Post by: iindigo on April 05, 2013, 01:53:03 am

I've always liked Sequel Pro (http://www.sequelpro.com/), which is free, extremely stable, feature-rich, and has a native Cocoa UI (a real rarity for database software on OS X).

Title: Re: [QUESTION] What Database editor do you recommend for mac
Post by: Steff on April 05, 2013, 12:07:39 pm

I simpe use phpMyAdmin for working with DB.
No system place or other requirements.
Only for making backups on the server I use HeidiSQL

Only importand is. USE A GOOD PASSWORD if you give access from outside and DONT name the folder phpmyadmin.

Also if you have a fixed IP adress you can set this in the outside admin user to restrict access. Dont change the normal admin. Create a new mySql user for this.

Title: Re: [QUESTION] What Database editor do you recommend for mac
Post by: Benji_kun on April 05, 2013, 01:20:46 pm

I just downloaded Sequel Pro and I have to say it's exactly what I was looking for and very similar to what I have been using Heidi for so thank you iindigo.

I will definitely have a look at using phpmyadmin and learning some more SQL in the future, thank you for the advice Steff and schlumpf.