Database

Primary keys in Database are essential for many reasons; they maintain entity integrity and help the database work faster when searching or linking data.

Sometimes, the primary keys aren't set for some tables. It's better to create the keys for these tables for better performance and integrity.

The following SQL query list all tables without Primary Key in a specific Database (<database_name>):

To export Database with time-stamped file name in phpMyAdmin, you have to change the parameter  Output: > Save output to a file > File name template from :

@DATABASE@

to :

It is usually not possible to clear the Drupal cache via the site administration or via the command:

 drush cache-rebuild

In this case the only way available is to clear the cache via the database with the command

 TRUNCATE

The question now is which tables should be flushed and which ones are cached?