User manual MYSQL MAESTRO
DON'T FORGET : ALWAYS READ THE USER GUIDE BEFORE BUYING !!!
If this document matches the user guide, instructions manual or user manual, feature sets, schematics you are looking for, download it now. Diplodocs provides you a fast and easy access to the user manual MYSQL MAESTRO. We hope that this MYSQL MAESTRO user guide will be useful to you.
Manual abstract: user guide MYSQL MAESTRO
Detailed instructions for use are in the User's Guide.
[. . . ] MySQL Maestro
User's guide
Copyright © 2002-2009 SQL Maestro Group
I
MySQL Maestro Help
Table of Contents
Foreword 0
I Welcome to MySQL Maestro!
1 Installation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 Registration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3 License Agreement . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4 System. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . [. . . ] Moreover, all the objects that are source of data need unique names among themselves. You can use any identifier 339 that is allowed by MySQL server.
Engine Here you can change the table type. InnoDB Transaction-safe tables with row locking and foreign key support (since MySQL version 3. 23. 44 only) Transaction-safe tables with page locking. The storage engine accesses data in tables of remote databases rather than in local tables. Its purpose is to serve as an example in the MySQL source code that illustrates how to begin writing new storage engines. The engine stores data in text files using comma-separated values format. The BLACKHOLE storage engine acts as a "black hole" that accepts data but throws it away and does not store it. The ARCHIVE storage engine is used for storing large amounts of data without indexes in a very small footprint.
Berkeley_db ISAM
MEMORY (HEAP) MRG_MyISAM GEMINI
FEDERATED
EXAMPLE
CSV BLACKHOLE
ARCHIVE
Connection (only for FEDERATED tables) Specify here a connection string that indicates to the FEDERATED engine how to connect to the remote server. The general form of the connection string is as follows: scheme://user_name[:password]@host_name[:port_num]/db_name/tbl_name
© 2009 SQL Maestro Group
Database Object Management
109
Only mysql is supported as the scheme value at this point; the password and port number are optional. Here are some example connection strings: CONNECTION='mysql://username:password@hostname:port/database/tablename' CONNECTION='mysql://username@hostname/database/tablename' CONNECTION='mysql://username:password@hostname/database/tablename' The use of Connection for specifying the connection string is non-optimal and is likely to change in future. Such applications are likely to need modification if the format for specifying connection information changes. Insert method (Only for Mrg_MYISAM tables) You can optionally specify an Insert method option if you want inserts for the Mrg_MYISAM table to take place in the first or last table of the UNION list. Use a value FIRST or LAST to cause inserts to be made in the first or last table, respectively. If you do not specify the option or if you specify it with a value NO, attempts to insert rows into the Mrg_MYISAM table result in an error. Union tables (Only for Mrg_MYISAM tables) Creates a collection of identical MyISAM tables as one. Check sum Maintains a checksum for all rows (makes table a little slower to update but makes it easier to find the corrupted tables). Avg row length Use the option in case your table is larger than 4GB and your operating system supports large files among with Max rows options. Partition type (since MySQL 5. 1. x)
© 2009 SQL Maestro Group
110
MySQL Maestro Help
The field displays the type of current table partitioning type. Auto increment (only to integer types) Specify a special counter called the auto-increment counter that is used in assigning new values for the column. With MySQL Maestro you can also analyse, check, repair and optimize your tables. To open the Reorder fields window, use the appropriate link of the popup menu or at the Navigation bar.
To apply the changes, select the Apply Changes item in the Navigation bar or use Ctrl +F9 or Ctrl+F7 shortcut keys. It is also possible to modify object properties without opening the object editor: use the
© 2009 SQL Maestro Group
Database Object Management
111
Object Properties item of the popup menu of the selected object from the explorer tree. [. . . ] To run the wizard, select the Tools | Options main menu item and click Export Settings in the Options 291 dialog. · · · · Specifying destination file to save settings to Specifying settings categories to save 330 Select database profiles to save 331 Saving settings 331
329
9. 4. 1
Specifying destination file
Specify a *. reg file to extract MySQL Maestro setting to.
© 2009 SQL Maestro Group
330
MySQL Maestro Help
9. 4. 2
Selecting setting categories
The options of this step specify the information saved to the result file, e. g. Database profiles 86 , Application options 292 , etc.
© 2009 SQL Maestro Group
MySQL Maestro Options
331
9. 4. 3
Selecting database profiles
Select database profiles to save their settings by moving them from the Available Databases list to the Selected Databases one.
9. 4. 4
Saving settings
Click the Ready button to start the extracting. The process log is displayed in the Export log box.
© 2009 SQL Maestro Group
332
MySQL Maestro Help
© 2009 SQL Maestro Group
Appendix
333
10
Appendix
Please take the following Appendix information into consideration: · Identifiers 339 · Data formats
340
© 2009 SQL Maestro Group
334
MySQL Maestro Help
10. 1
Specifying WHERE condition
MySQL Maestro provides the Filter Builder dialog to facilitate creating WHERE condition. [. . . ]
DISCLAIMER TO DOWNLOAD THE USER GUIDE MYSQL MAESTRO
Click on "Download the user Manual" at the end of this Contract if you accept its terms, the downloading of the manual MYSQL MAESTRO will begin.