| Home \ FAQ |
Frequently Asked Questions
|
Q: I tried to make a foreign key relation between two tables, but i get this error message :
[MySql Server DMO Eror][ErrNo:1005][Description: Can't create table './f2h9/#sql#51bb_3939.frm' (erno:150)] |
A: For the present MySQL *4.x only* supports foreign keys. Also this version of MySQL supports foreign keys for InnoDb tables only. Full support for all table types will be available in MySQL 5 as MySQL developers said. Database Explorer for MySQL shows the "Foreign Key" button on Table Editor pane if a table supports foreign keys.
How to enable foreign keys.
1. Be sure that your MySQL server supports foreign keys. (it is required 4.x version)
2. Be sure that the "have_innodb" server variable is "YES" (to do it, execute "show variables" SQL statement on the Query Builder for MySQL)
3. Change type of tables that you need to "innodb"
4. Be sure that primary and referenced columns don't allow NULL values
|
Q: When i try to create relationships between tables in the Diagram view, it says:' Table x does not support foregin keys'! |
A: MySQL supports foreign keys for InnoDb tables only. Please be sure that your table type is InnoDb
|
Q: I am evaluating your Tracer. Is it possible to trace SQL statement sent by other applications than yours? |
A: Most Windows applications working with MySQL use libmysql.dll as client API. SQL Toolkit for MySQL Developer Edition installer copies two libraries( libmysql.dll and libmysqlcore.dll) to the %SYSTEM32% folder("c:\winnt\system32" typically).If you want to trace an application using libmysql.dll, please be sure that the application uses %SYSTEM32%\libmysql.dll. We recommend you to find other copies of libmysql.dll and rename them as "~libmysql.dll", for example. In this case you can return to old versions of libmysql.dll if something will be wrong.
|
Q: Any application that directly interfaces MySQL via it's API however, will not be traced? |
A: Applications that directly connect to MySQL will not be traced as MySQL does not support this feature on server-side(as MS SQL Server, for example).
|
Q: We have MySQL setup on a Linux Box. I need to perform queries and wondered if SQL Toolkit for MySQL works on a Windows box to Query the database on the linux box. |
A: SQL Toolkit for MySQL package is a Windows application family; it supports MySQL servers running on any platform (Windows, Linux, FreeBSD, commercial UNIX etc).
|
Q: I am writing you just to verify that if I make a purchase now, I will receive free product upgrades in the future. Am I correct? |
A: Yes, you are. We provide regular upgrades of our software for registered users. All registered users of an early version of our products can upgrade to the newest version free of charge
|
Q: It would be very nice if there was a feature to turn off all the confirmation prompts, so that you dont have to answer them each time you start/stop MySql server. |
A: To suppress the confirmation prompts, open the "Options" dialog and put off "Verify service control action" check box.
|
Q: How to do export the results of a sql query into a microsoft excel file? |
A: To export data from Query Builder for MySQL to an Excel file:
1. Execute your SQL query
2. Switch to tab with the results
3. Right-click the data grid and select "Export to Excel..."
- or -
Select target cells, copy to clipboard (Ctrl+C) and paste into Excel (Ctrl+V)
|
Q: I have purchased mysqltools, please let me know how to use the diagram |
A: The Diagram Editor is a visual tool allowing you to design and visualize a database. To visualize a database, you can create one or more diagrams illustrating some or all of the tables, columns, keys, and relationships in it.
|
Q: Is it possible to relationships tables in the diagram editor, just like in Microsoft Sql Server? |
A: Exactly! We plan to visualize foreign keys on the Diagram Editor in the future.
|
Q: I was trying now the backup, and I'm receiving this error message:"Cannot backup system table 'sys__backup_options' Failed copying .frm file: errno = 2" |
A: We think you are trying to backup a database on REMOTE mysql server. In this case Database Explorer for MySQL doesn't create a folder to backup the database (we can create folders on 'localhost' only) or the backup path is invalid. Please be sure that the backup folder already exists.
|
Q: I have been creating a small test database on my home machine and I wanted to know if there was a way for me to export the table to an *.sql file that I can just open in a text editor and run as a query on my production database. |
A: How to export table data to *.sql?
1. Run Query Builder for MySQL and connect to your database
2. Select the table from Object Browser tree.
3. Right-click here to open context menu and select "Data".Then a script with "insert" statements will be stored to the SQL editor.
4. Click "Save as" button on the toolbar to save the script to a file.
|
Q: I am interested in your libMySQL product, as a link between my VB projects and a MySQL database, as I really do not want to use ODBC. Is there any charge for distribution of this library, and any documentation available for the functionality that it supports. |
A: I. About libmySQL.dll
libmySQL.dll is a freely distributed library included in MySQL installation on Win32. If you have downloaded MySQL for Win32, you can find it in %MYSQL%\lib folder.libmySQL.dll is not our product, it is a product of MySQL AB. II. libmySQL and VB
If you use VB, we recommend you the myvbql.dll library. This is a VB interface for MySQL under GNU Library General Public License.Contact with myvbql.dll developer Eric Grau about using myvbql.dll.
If you don't want to use myVBql.dll, you need to install MySQL on Win32 and create function declarations for %MYSQL%\include\*.h C-header files.
III. Documentation.
You can download Books Online for MySQL. Read the chapter 8.4 "MySQL C API".
|
Q: I downloaded a version of MYSQLTOOLS but cannot run it as it apparently has to be registered. Please advise on how this happens and what the evaluation period is. |
A: This problem may be caused by the following things:
1. you have installed previous version of SQL Toolkit for MySQL and its evaluation period has expire.
2. evaluation period has expire.
3. the system date on your computer was changed after installing of SQL Toolkit for MySQL.
The evaluation period is 30 days.
|
Q: I don't know how to use mysql, could you send me an example? |
A: You can get a lot of information on the www.mysql.com. Also we would like to recommend you to read the following book: "MySQL" of Paul DuBois, this is the best book about MySQL.
|
Have a question that is not answered here?
|
To put the question, go to Support page or send e-mail directly to our support service
|
