GPTEngine logo End User Documentation
< prev | up | next >

3.1.5 - MySQL® Admin


In this session you can manage your database and perform MySQL® tasks.

MySQL® connection info

Here you can view some information about your current MySQL® connection.
Connection ID is the thread ID for the connection. Every connection has its own unique ID.
Client version is the MySQL® server version.
Current user is the username used to create the current connection.
Current database is the database from which you are running GPTEngine.
Tables in database lists all tables in current database.

To connect to MySQL®

These are the information needed to connect to your database.
Username and password are used to connect to your MySQL® server.
Database host is the host of your database server (we recommend you to not use a remote MySQL® server, so leave this as localhost).
Database name is the name of the database in which GPTEngine™ is installed on.

Database operations

From this field you can perform several MySQL® tasks.
Use the make backup of GPTEngine™ tables into file to make a backup of the all GPTEngine™ data into a specified file at disk (you will need world writing permission for that file).
Restore GPTEngine™ tables from file will restore the MySQL® data from the specified file at disk.
Enter a MySQL® query, in the hands of an experienced administrator, can be the most powerful tool for your program. Use this to enter any type of MySQL® query, the only limitation is that you cannot execute multiple queries in a single query string.
Below are some examples of smart usage of MySQL® queries from the Admin:

< prev | up | next >

© 2005 by popux.com