Help On Line MySQL Connectus 0.4.0
Index
>>MenuFile
>>MenuOptions
>>MenuHelp
>>Plug-in
>>Query | Modification window
>>Table window
>> Tree>> Log window
Here you have to insert your user name and password to log in .
If you didn’t previously choose a password let it blank and press OK button.
If your user name or password are incorrect ,or you don’t have the necessary
privileges to access the selected DB, a message window will appear.
By clicking here you can log out the current connection.
This command doesn't invalidate cache, and this feature is usefull
if you use a remote connection: you can do a remote query ,
disconnect from the Internet and then re-lunch the query and get
the same results. In local connection if you need to invalidate cache
go to Menu Help->About and click Invalidate Cache button and then
(it's a good idea but not necessary) press Run GC (Garbage Collector).
Choosing this voice will appear a window in which you can insert a query
text and execute it.
Updein is a shorthand for Update/Insert/Delete . In this window you can
write and execute your modifications.
Here you can open a file in which there is the text of a query. The file should be
with ".qry" extension but you can always load a ".txt" , an extentionless file
or however a file where a text is present.
Like Open query but for insert/delete/update with ".mod" extension.
Open a table with ".dat" extension. If file is corrupted an error message
will be shown.
Open a file .txt in which table data are present and ask you what
table to populate in the current connection.
Open a file .txt in which table data are present and ask you what
table to create & populate in the current connection. Remember that
all the 2 txt files are needed to build the table.
This feauture allows you to load and execute a script file in a single step.
A well formed script file is as down here:
HOST->ip or hostname
USER->username
PASSWORD->password
DBNAME->dbname
If you try loading a bad formed script this will be rejected and no connection made.
You may not to write the dbname , the program will show you that you didn't insert it but the
connection will be regularly enabled.
Example of a well formed script for local connection:
HOST->localhost
USER->root
PASSWORD->firestorm
DBNAME->store
Remenber you can't change the order in which fields are written, so password can't
came before host et cetera.
Pressing this button a dialog window will be shown asking you the name of the
DB you want to connect. If you're not logged in an error message will be
shown.
Show databases present in the system accordingly to the access privileges of the user.
If the user is not logged in, a error window will be thrown .
Show relations present in the db accordingly to the access privileges of the user.
If the user is not logged in, a error window will be thrown .
Exit the program and save current settings if AutoConfig is enabled.
Here you can choose the desired plug-in to load.
If you want to add a plug-in simply put it in plug-in directory
in mysqlconnectus installation directory.
Selecting this option the program will be set in a ms windows fashion. If this theme
is not present on your sdk , the program won’t change its appearance.
This will set the program in a Motif fashion. If this theme
is not present on your sdk , the program won’t change its appearance.This are a collections of styles available in every Java sdk provided Swing framework (1.4 or above).
A set of amazing themes with which you can custom your program.
This feature allows you to choose if you want that the program would remember or not
your preferences selected in the running instance of the program.
Preferences are : running theme , and last selected script file.
For instance imagine you open the program then load a script and change theme
to Motif style : if autoconfig is enabled on the next start of the program Motif style
will be applied and the connection script will be automatically loaded.
This feature is based on config.txt file in \bin .
If config.txt is corrupted or an invalid fields is written or is absent an error message will be displayed ,
default parameters will be applied and when you choose exit to quit the program config.txt
will be fixed up.
This html page will appear.
About the program author contact and system info.
Here you can choose to run garbage collector ,
invalidate cache ,see the current and old log file and read
the GPL license agreement .
With this button you can delete the current shown messages.
In this window you can insert your query | modification text.
By clicking right button you'll be prompted to a menu
in which you can choose to print ,cut,copy or paste the
selected text. If you choose print and there is no
selected text all the doc will be printed. The cut,paste,copy
features are at OS level and not internal so you can cut and paste
between other applications.
D&D is enabled: try dragging an underlined text from a query | mod. window
and dropping it in another query | mod. window
This button will reorder your query text . ( Available since ver. 0.2 )
The caret is changed red -->> blue color indicating that the query has been reordered
at least once.
WARNING : This is only an alfa version feauture so,if you found any unrecognised word
or in general an error , put one or more spaces between the uncorrect words then
press "Well form" button again. Now correctness of recognition is granted only for query
and modifications and partial for tables,views,triggers,assertions,procedures,functions
absent for PSM and transactions.
Pushing this button the query will be executed and the results shown.
If no DB has been previously selected an error window will appear.
If any other SQL error is present in your query this will been shown by a
message window that will inform you of your error. When a query
is execute the results are cached. So if you lunch again the same query
the cached results will be shown (you can see on the shell if the
last loaded results were from db or cache and the time to get results ).
If you make a changing to your db with Mod window, no matter ,
the cache will be automatically invalidated.
If you do a modification to the db with an external program be care to
invalidate cache with about window before executing a query.
A file choosing window will appear and there you can save your query.
Cancel the text and caret color is set to red indicating that the text is not reordered .
By pressing this button you can print your table.
As you push this button a dialog window will appear asking you about
the columns spacing size. If you choose to close the window 90 dots will
be applied . If you don't have a printer an error message will be shown.
Here you can save your table in a .dat file.
Here you can export table contents into a txt file. Please be care to
save with txt extension , differently import feature won't work.
When you save , 2 files txt are created.
1) "filename.txt"
2) "filename@metadata.txt"
The first contains real data. The second contains metadata like fields format.
If you want to use import (Menu File) feature you only need the first file.
If you want to use create & import (Menu File) feature you need
both the files.
Two files are saved and not one to ensure compatibility with a MySQL
command (SEE ImportTable.java for more detail).
Here you can export the table to db in two ways:
1) Populate existing table: transfer data from the shown table to a table
in the db in the current connection.
2)Create and populate table: create a table in the currently connected db
and populate it with current shown data. This is usefull if you exchange .dat
file and want to create and populate a table in your db.
By double clicking on folders you can directly connect to your DBs.
By double clicking on relations a "SELECT * FROM relation" query
will be performed and the results shown.
D&D is enabled : try dragging a db and dropping it in a query window.
For
more information look at \MySQLConnectus\Docs\Index.htm