mysqlcc syntax.txt file missing

todd24 · 09-28-2004, 05:14 AM

Hi,

Recently I started using mysqlcc to administer mysql. I tried to create a new table within a new database and it comes up with an error:

"Could not load Field Types. Please select the location of the Syntax File in 'Options -> Sql Editor' and re-open this dialog."

Under 'Sql Editor' the 'Syntax File' is '<home>/syntax.txt'. This file isn't in my home filesystem.

Also I've had a look throughout my filesystem to no avail and checked other web faq's for some clues... please help!

Thx

todd24 · 09-28-2004, 05:26 AM

Actually I just did the search as root and the syntax file was under the '/usr/share/mysql/' filesystem.

I just changed the path for the Syntax File and it worked fine. Sorry about creating the thread! Hopefully someone else will find it useful...?

Cheers...

matthewk · 10-04-2004, 08:39 PM

My syntax.txt was in /usr/share/mysqlcc on SuSE 9.1.

Note that you can't run a query, create a table or do anything that references that file until you change the settings or copy it to the default location.

Also, it seems best to copy that file to (1) a shared area used by the team (part of cvs perhaps) or (2) your home folder somewhere atleast so that it can be customized without affecting others.

todd24 · 10-04-2004, 11:37 PM

Hi matthewk

Thanks for the reply and the tip about using the file in a personal directory for customisation...

FreakboY · 11-01-2004, 12:29 AM

can't find it under those two directories....
i'm running slackware 10 any ideas!??

can you send it over!?? ferdna "at" yahoo.com

megaspaz · 11-01-2004, 01:13 AM

where did you untar mysqlcc? it should be in the install directory (this is if you downloaded the precompiled binary tarball from mysql's main site).

anyhoo, try these set of commands:

as root (su):
[prompt] # updatedb

wait for that to finish and then as any user:

[prompt] $ locate syntax.txt

look for the file path that has mysql in the filepath. copy that file path down and put in the mysqlcc option.

FreakboY · 11-01-2004, 08:29 AM

Thanks dude...
I hva slackware 10 running... and i got the package
from linuxpackages.net ... and that file is missing...
so what i did is download the tar from mysql.com and
just copy that file to my home directory...

Thank You for you reply!