LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 09-28-2004, 05:14 AM   #1
todd24
LQ Newbie
 
Registered: Sep 2003
Distribution: SuSE 9.1
Posts: 6

Rep: Reputation: 0
mysqlcc syntax.txt file missing


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
 
Old 09-28-2004, 05:26 AM   #2
todd24
LQ Newbie
 
Registered: Sep 2003
Distribution: SuSE 9.1
Posts: 6

Original Poster
Rep: Reputation: 0
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...
 
Old 10-04-2004, 08:39 PM   #3
matthewk
LQ Newbie
 
Registered: Oct 2004
Distribution: SuSE
Posts: 1

Rep: Reputation: 0
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.
 
Old 10-04-2004, 11:37 PM   #4
todd24
LQ Newbie
 
Registered: Sep 2003
Distribution: SuSE 9.1
Posts: 6

Original Poster
Rep: Reputation: 0
Hi matthewk

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

 
Old 11-01-2004, 12:29 AM   #5
FreakboY
Member
 
Registered: Jun 2002
Location: TX, USA
Distribution: Slackware
Posts: 385

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

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

Last edited by FreakboY; 11-01-2004 at 12:47 AM.
 
Old 11-01-2004, 01:13 AM   #6
megaspaz
Senior Member
 
Registered: Nov 2002
Location: Silly Con Valley
Distribution: Red Hat 7.3, Red Hat 9.0
Posts: 2,054

Rep: Reputation: 46
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.
 
Old 11-01-2004, 08:29 AM   #7
FreakboY
Member
 
Registered: Jun 2002
Location: TX, USA
Distribution: Slackware
Posts: 385

Rep: Reputation: 32
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!
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Txt extension file translation UltraSoul Solaris / OpenSolaris 3 05-21-2005 11:11 AM
c++ writing to a .txt file xemous Programming 8 09-01-2004 10:57 PM
How to convert a txt file to be a db file in Redhat linux 9? winnie Linux - Newbie 3 06-27-2003 08:33 AM
how to edit a txt file through console safrout Linux - Newbie 5 01-31-2003 07:39 PM
txt file to html > right forum ? saavik Programming 7 04-16-2002 08:42 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 06:29 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration