Creating New Database

If you want to start working with DBACentral for MySQL by creating a new MySQL database, you can do by various means.

You can create a new blank database, or import the existing database to your server. Use the New item group of the Getting Started pane for these purposes.

To create a blank database click the Create a new database... item and follow the steps of the Create Database Wizard. This wizard will prompt you for the database name and for the connection properties of your MySQL server.

You can also create you database by importing database structure and data from other source - MS Access database, another MySQL database, or ADO compatible database.

Click the appropriate item at the Getting Started pane and follow the steps of the Import Database Wizard.

Yet another way is to create a database by executing the SQL script, which contains database table definitions and, possibly, table values as a set of CREATE TABLE and INSERT statements.

This can be done in two ways:

select the Tools | SQL Executor item to open the SQL Executor window, then load a script from the file (the Load SQL button ) and click the Execute SQL button .
select the Tools | Administration Tools | Restore Database item, select the SQL Restore Format and set your script file as a Restore Source within the Restore Database Wizard, then follow the other steps of the wizard.