275824
Visits last 30 days
By Google Analytics
Dreamcoder for MySQL (FREE MySQL Tool) |
|||
FAQ |
 |
 |
 |
|
This is a list of our users' most frequently asked questions. By answering them we hope to clarify any doubts they may have regarding DreamCoder for MySQL. What is DreamCoder for MySQL? DreamCoder for MySQL is a comprehensive tool for developing and managing MySQL database servers. The product has a graphic interface which makes development and administration tasks easier, such as creating users, managing permissions, monitoring users, export data, report generation, graphical building of queries and data synchronization and structure among others. What is the difference between the Freeware and the Enterprise versions? The main difference between the commercial and the freeware versions are the features included. The freeware version has limited functionality. DreamCoder for MySQL Freeware is suitable for beginners and people who do not need advanced options. To learn about features included in these two versions we recommend reviewing the comparison section. It is possible to evaluate DreamCoder for MySQL Enterprise before purchasing? Yes, you can download a 100% functional version of the product and evaluate it for a period of 30 days, plus free access to our technical support channels. Can I manage my hosted database? With DreamCoder for MySQL Enterprise you can manage your databases in different hostings thanks to the connection via SSH tunneling feature. To establish a connection via SSH you first need to confirm that your hosting provider supports such connections. What is SSH tunneling and what is it for? SSH (Secure Shell Hos) is a protocol used to maintain a high security level thanks to the various encryption algorithms it uses in Internet communications in Linux and Unix servers. SSH tunneling creates a direct tunnel between DreamCoder for MySQL and the database server, equivalent to a local connection for practical purposes, but keeping the data traveling over the Internet safe. How do I set up an account for a connection via SSH tunneling? To properly configure an SSH connection you must enter data into the appropriate fields as described below: First enter the basic data for database connection in the "Connection" tab: Login: Username for MySQL database. Password: User's password for MySQL database. Server: Usually this field is usually the local host, but some hostings use different servers for SSH and for the database. If this is the case, you must enter the value of the MySQL database server in this field. Database: In this field you must enter the name of the database to which you are connecting. Port: In this field you must enter the port where the MySQL database server is configured, default is 3306. You don't need to change the remaining fields, just leave the default options. Next you must enter the data for the SSH connection in the "SSH Tunnel” tab: First enable the option to connect via SSH "connect through the SSH shell” Server: Here you must enter the SSH server name or IP address. Port: Here you must enter the SSH server port, 22 by default. Login: SSH Username. Password: SSH user's password. Key: Some hostings require the use of a set of public and private keys. You can generate this set of keys using the option of adding a "new client key". One remains local and the other one must be placed in the appropriate option within your server. Why can't I connect to my local MySQL database server ("Can not connect to MySQL server on localhost")? This is the most common error in MySQL and there are many reasons for it, among which: 1. The MySQL database server was not installed correctly. 2. The database server is not initialized. 3. The database server is running on a different port (not 3306). If my database is on a Linux server and I work on a Windows computer, can I use the DreamCoder for MySQL? Yes, DreamCoder for MySQL is independent of the OS where the MySQL database server is installed, but keep in mind that DreamCoder for MySQL works only in Windows environments. Does the SQL editor have an autocomplete feature? Both the SQL and the stored procedures editors have autocomplete, objects description, open object, format SQL code and many other features to make development easier for editors. The main options available in the editors are: Autocomplete: CTRL + SPACE Object description: CTRL + CLICK Open object: F4 Autocomplete special: CTRL + J SQL code formatting: SHIFT + CTRL + F Can I export my entire database? You can perform a full export of the database, as well as export a group of objects or data. Is there an option to build graphical queries for the database? Yes, DreamCoder for MySQL Enterprise has a modern query builder to easily build more complex queries, without previous SQL language knowledge. Is there an option to graphically build insert, delete or updates for tables? The product has an option to generate code to handle tables, this option can be called from the object browser or from the tools menu "generate SQL table." If I have two equal databases with different records, can I synchronize them? Yes, DreamCoder for MySQL Enterprise has an option for synchronizing data. You can find this option on the Tools menu, "Database Data Synchronization". The only condition is that the tables are physically equal. If I have two different structure databases, can I synchronize them? Yes, DreamCoder for MySQL Enterprise has an option for synchronizing the structure of two databases. You can find this option is available on the Tools menu, "Database structure synchronization”. Can I monitor the users who are connected to my MySQL database server? The product features a sessions monitor where you can view the activity on your MySQL database server in real time. You can also determine which SQL can be run by each user and cancel a connection. I have a table that takes a long time to open, how is this possible? If the table has many columns and these are fields with large values, the product may take some time formatting before showing it on the grid view. To speed up this process you can disable the option "columns best fit", it is available in the interface options, in the grid calling tab. If the table has a large number of foreign keys and the “value list for foreign keys” option is enabled, this can also affect performance. In this case you should only disable this option from the interface options in the call grid tab. I have 1000 records in a table and the product only shows 50, why does this happen? The product always shows records in blocks of 50 in the grid. If you want to view the last record, just press the navigation button called "last." Is there a report where I can see the tables structure? The DreamCoder for MySQL Enterprise has a reports module, among which we have included a report to detail all tables and their structure. Is there an utility to test stored procedures? The Enterprise DreamCoder for MySQL includes a feature for quickly testing stored procedures. You can access this option by right-clicking on a stored procedure and then clicking "test". Can I import data directly from Excel into a table? The Enterprise DreamCoder for MySQL has a large number of options to handle, import and export data. One of them is a procedure by which the user just needs to copy data from Excel and then press the option called "paste records to grid ", available in the grid's advanced options, to insert data into the table in MySQL. The Excel file must include the names of the columns being selected and copied. |
Why DreamCoder
DreamCoder is downloaded over 1 millions time and has accumulated over 10.000 happy customers from over 100 countries in the last 8 years.
Now we are the best database tools availabe 100% free in the world for Oracle , MySQL and PostgreSQL.Community
Join our Community
and help us create better products
- Product Forums