| 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:

- To get the username and e-mail list of all users of your program ordered by signup time simply enter:
  `select Username,E_Mail from GPTE_Members order by Signup_Time`
- To get a list of number of users by country in descending order, enter:
  `select count(*) as Numb,Country from GPTE_Members group by Country order by Numb desc`
- To get a list of users who have e-mail with the domain bad_domain.com, enter:
  `select Username,E_Mail from GPTE_Members where E_Mail like '%\@bad_domain.com' order by Username`
- To give 100 points bonus for users with more than 12 months since signup, enter:
  `update GPTE_Members set Points = Points + 100 where unix_timestamp(Signup_Time) < unix_timestamp(now() - interval 12 month)`
- To disable the turing number check for the user foo_user, enter:
  `insert into GPTE_Non_Turing_Number_Users values ('foo_user')`
- To list the IP number of the last 25 visitors of your site, enter:
  `select distinct IP from GPTE_Online_Visitors order by Action_Time desc limit 25`
- To list the top 5 selling advertising packages, enter:
  `select Name,count(*) as The_Sum from GPTE_Shopping_Box group by Name order by The_Sum desc limit 5`
- To list the last 10 deleted users, enter:
  `select Username,E_Mail,Signup_Time,Unsubscribe_Time from GPTE_Deleted_Users order by Unsubscribe_Time desc limit 10`
- Etc, etc...

< prev | up | next >
© 2005 by popux.com