PhpMyAdmin administration

By | March 8, 2013

Administrative Function of PhpMyAdmin

In Inway Hosting chapter of PhpMyAdmin, you will learn about the function of software, integrated in cPanel.

Administration-01

Enter PhpMyAdmin application, to access its different functions. In the upper section you can locate server Hostname and the entire database will be located on the same server, since software and host name is: local Host. We provide google web hosting India

In this section, you can find all the information related to MY SQL Server, MY SQL client and PhpMyAdmin version.

In the Next step, you can find MY SQL charset, and will know about MY SQL connection collation.

If you want to change language, modify style; convert theme colour and font size or want to locate links to PhpMyAdmin resources, click on right column for changing all the settings.

A new database can be created from your cPanel –   MY SQL Database, but cannot be created directly through cPanel –   PhpMyAdmin. Now you can find the way to locate New Database box. Enter database name in new text field and click on create Database icon. The database name will always start with the name mentioned on cPanel. For e.g. if user name of cPanel is “User “and database name is “Test”, then the actual database name created will be “User_ Test”. For more detail knowledge, you can go through our step to step tutorial notes.

Apart from this, for locating the list of database of your cPanel, you can go through left panel.

The main sections of PhpMyAdmin are as follows:

Databases:

Once you enter local Host, Click on database option to locate the list of databases operated through cPanel user.

Administration-02

One can easily operate and manage, by clicking on selected database.

If you can access the database statistics, you can easily find out used table collation, the number of table, rows, volume of data and indexes, and overall size.

It is suggested, not to add large amount of database on your account, as it may increase load on server.

Status:

On the same page you can find the option “status” click it and see Runtime Information Link. you can get all the information right from last restart related to MY SQL server.

Administration-03

Here you can check out the traffic controlled by MY SQL server and all detail information related to connections like total no. of connection, failed and abrupt, and maximum no. of simultaneous connections, over all queries sent to server and more details

Variables:

Click on the option “Variables” located on My SQL System variable links.

Administration-04

Here, you can check the list of MY SQL server system their variables and values.

Processes:

Just by clicking the option Status, one can visit all the process running under cPanel user.

Administration-05

Charsets:

Charset includes character set and collation link. Here you can find out all the details of charset and collation maintained by My SQL server.

Administration-06

Engines:

The storage Engine link contains a list of engines handled by My SQL server. My ISAM is a default engine. InnoDB is also a very popular storage engine used by database and supports transactions. To know more about storage engines, please visit official documentation.

Administration-07

Export:

In the export segment, one can easily export database table of different formats (like- CSV, PDF, SQL, MS Word, MS Excel, XML and many more…) You can either pick all data’s or can select few of them.

Administration-08

One can add comments on header of exported content and export database structure, data or both of them. You can easily resolve the queries on the screen or can export database files and compress it.

Import:     

In the Import column, one can easily import database table from files located on local computer.

Administration-09

Browse the file from main menu. If selected file will be of large volume My SQL server time out can be reached which may interrupt import action. Continue with the process of data importing by identifying the number of queries to be skipped at the time of beginning. By doing this, one can skip from importing queries and continue without interruption. We provide Entreprise Web Hosting India

Leave a Reply