Operations of PhpMyAdmin
There are several operations; one can perform on database separate table.
Database operations
Select a database and click on its operation section, here you can find all possible steps which you need to apply on database.
Firstly create new table, enter name of table and number of fields under current database and click on “GO” button.
Second step allows you to rename database. However, due to lack of freedom of users, accessing cannot be performed directly through PhpMyAdmin. If users want to rename the database, they have to create new MY SQL database, export database tables and import them in new database. Old database has to be removed from cPanel and MY SQL database. We provide cheapest web hosting in india
Same procedure has to be followed with Copy database. The one major difference with this option is one should not delete the existing data from database.
The last step includes changing Database collation. Select the file from drop – down menu and click “GO” button to modify the data.
Database Table Operations
Click on “Operation” Button from Database Table to perform the operations.
The text Alter table order by allows you to modify the order list of table record. It can be either ascending or descending depending upon the criteria of sorting. Click GO button to proceed further.
The option move table allows you to move table with a new name either in current database or under different database.
In the section of Table Rename, one can do several functions like- renaming of table; insert comments, change storage engine and collation. In addition to all these functions, it allows its users to use the pack keys option which is effective only with MyISAM tables. It mainly packs the keys, When DEFAULT choice is selected. The main role of storage engine is packing of only long CHAR, VARCHAR, BINARY and VARBINARY columns. When the numbers selected is 1, columns are packed along with the strings. But, 0 disables the packing of keys.
There are two check boxes located there. Once check sum option is activated, checksum is calculated. The option delay_Key_write gives the updates faster, as they are not flushed to disk till table is closed. We provide ecommerce web hosting india
With the help of copy Table option, one can copy the table with a new name either in current database or in another database.
Under the section of Table Maintenance, you can find several options which will help in maintaining database table.
Check table – verify the Table and its views, find errors and problems.
Analyze table – analyse and store key distribution of table, which is further used by JOIN operations and for taking decisions of index which is to be used in Table query.
Repair table – repairs a corrupted table.
Optimize Table – optimization is required, whenever you have to change or modify the database from the table. It will recycle the used space, defragment the data file, remove overheads and sort out the indexes.
Flush table – clears and reloads internal cache linked with table.