Tudásbázis

Optimizing MySql Database

1. In the phpMyAdmin homepage, select the database you want to optimize.

2. An expanded list of tables will appear on the left and wider in the right pane.

3. Check the table(s) you wish to optimize.

4. Click the dropdown menu at the bottom that says With selected and look for Table Maintenance.

5. Select Optimize Table from the list.

6. A confirmation prompt will appear.

 
  • 0 A felhasználók hasznosnak találták ezt
Hasznosnak találta ezt a választ?

Kapcsolódó cikkek

SQL injection

SQL injection is an attack where malicious code is passed to an SQL Server for execution. The attack can result in unauthorized access to confidential data or the destruction of critical data....

MySQL Database Limit

There is no limit for the size of databases. MySQL is only limited to the size of your cPanel's disk space. As long as there is still some free space in your cpanel disk, you are good to go.

MySQL Variable Types

MySQL database has three (3) main data types: text, numbers and dates/times. Text Types CHAR( ) A fixed section from 0 to 255 characters long. VARCHAR( ) A variable section from 0...

cPanel MySQL Database Wizard

This instructions guides you through the setup of a MySQL® database, user accounts, and user privileges. We recommend that you use this wizard to create your first database and user. To create...

phpMyAdmin Glossary

phpMyAdmin is a free open source tool written in PHP language. This tool handles the administration of MySQL and MSSQL over the web, performing various tasks such as creating, modifying or deleting...