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 of your Web server.
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 >

© 2006 by popux.com