More Related Content
What's hot (13)
Viewers also liked (11)
Similar to MySQL Tools And Gui (20)
Recently uploaded (20)
![Fast Screen Recorder v2.1.0.11 Crack Updated [April-2025]](https://cdn.slidesharecdn.com/ss_thumbnails/dataanalysisforbusiness-250322061148-eeff8a831-250401123246-f36be9ca-250401141614-87b01766-thumbnail.jpg?width=560&fit=bounds)
MySQL Tools And Gui
- 2. OVERVIEWThe mysql enterprise serverThe mysql administratorThe mysql query browserThe mysql migration toolkit
- 3. The mysql enterprise serverThe mysql enterprise server is a subscription based serviceIt contains:Mysql server software: which is a distribution of MYSQL server.MYSQL enterprise monitorProduction support
- 4. Steps to install mysqlgui toolsGoto www.Click on Choose your host operating systemDownload and install gui tools,It includes the mysqladministrator,querybrowser,migration toolkit and
- 5. THE MYSQL ADMINISTRATORMysql administrator is a program for performing various adminitrative tasks such as monitering, starting and stopping mysql server and to perform backups and maintain various user connections.Once the mysqladminitrator starts it opens up a connection dialog.Specify the mysql server and all the other details.To use the newly setup server on the same machine user serverhost as ¡±localhost¡± and user as ¡°root¡±Mention your password and click ok.
- 7. To set advanced options click on ¡°details¡±Run mysql in configure_service mode when you have to start mysql server within administrator orWhen you have to run on multiple servers.To switch to configure_service mode:press and hold CTRL key,then the cancel button changes to SKIP button, click on SKIP.
- 8. Main window of mysql administrator
- 9. Sidebar has the options:Server information: information about the adminstrtor you are running and about the mysql server you are connected to.Service control:start and stop service,themysql administrator and the mysql server you are connected to and its configure serviceStartup variable: configure the startup variables.Server connections: view or kill the threads or user connections
- 10. User administrtion:add new user or delete existing userHealth: graphical representation of hit_rate,key_efficiency and hierarchy of system and status variables.Replication status:visual overview of mysql master and slave replicationsBackup:create backup projects or perform backupsRestore:restore the backup filesCatalogs:list of catalogs
- 11. THE MYSQL QUERY BROWSERIt¡¯s a tool for creating, executing,editing and optimizing queries in graphical environment.On starting the query browser a connection dialog opens up. Enter the details and your schema.
- 12. Query browser main window
- 13. Query browser main windowQuery tool bar: query area,all your typed queries or automatically generated qeries are present here, execute them using execute button.Use buttons:EXECUTE(CTRL+ENTER) to executeEXECUTE IN NEW TAB(CTRL+SHIFT+ENTER)SPLIT TAB AND EXECUTE(CONTRL+ALT+ENTER)Advanced tool bar: below the query tool bar is advanced tool bar, it has the execute, compare, explain and other buttons to for transaction, query management and query building.
- 14. Result area: the result is displayed here. to manipulate the result area right click and select the required manipulation.Use F12 key to maximise the result area.Object browser: database browser has all created the schemas,tables. They can further edited and viewed.Information browser: it has the online help for syntaxes,explanation of funtions and params used for querying.
- 15. The mysql migration toolkitIt¡¯s a graphical tool used to migrate data and schema from various relational database systems to mysql.Toolkit is available only for windows.Migration from external rdbms includes the following steps:1.source/target selection: specify the source and target.
- 16. 2.Object selection: select different objects like tables, views etc3.Object mapping: choose methods for mapping the objects.4.Manual editing: manually edit the new objects5.schema creation: a new transformed object is created on the target MYSQL server.
- 17. 6.Data mapping: specify changes foe the data if any.7.Bulk transfer: transfers the server from source to target.8.summary: summary report of the whole migration process is created.
- 18. On mysql migration toolkit welcome screenClick on next and Choose either direct migration if the mysql toolkit is installed on both source and target machinesOtherwise choose agenda based migration. choose the required database system.can be any one of ms access server,mssqlserver,oracle database server,mysql database server based on the user requirement.To save click on ¡°+¡± and enter the name of the connection and click ¡°OK¡±
- 19. On the target database screen choose mysql server.After selecting the source and target database servers choose the schema you want to migrate.Once the reverse engineering process is completed, choose the number of objects(tables and views) to migrate.On the object mapping screen, choose migration method as generic.Once the meta migration is successful, on manual editing screen select the object and click on details button to edit sql statements.
- 20. Choose one of the object creation options.Once object creation is completed successfully. on data mapping options screen, you have options either to directly migrate the data on target or create a script file.Data will be converted into MYSQL compatible format and migrated to target file successfully.Summary screen shows the entire migration summary.Save the migration.
- 21. Applications of mysqlgui tools:1.Gui tools provide a suite for desktop applications.2.Provides graphical user interface which makes things easier.3. It becomes easy to tune up servere settings ,edit databases and perform backup and recovery .4.Provides convenient server browsing and object creation becomes simple and easy.
- 22. Visit more self help tutorialsPick a tutorial of your choice and browse through it at your own pace.The tutorials section is free, self-guiding and will not involve any additional support.Visit us at www.dataminingtools.net