How to Delete a Session Cache From MySQL in Drupal

Websites built using the Drupal platform rely on a database to store website settings and content. To delete a session cache of stored data on your database, access your MySQL database using the phpMyAdmin tool on your Web hosting server. PhpMyAdmin contains a SQL command prompt that allows you to run commands, including the command to delete a session cache.

Instructions

1. Log in to the cPanel account of your Web hosting server.

2. Double-click the “phpMyAdmin” logo under "Databases." A list of your databases appears.

3. Click the name of the database, located on the left side of the page, that you want to delete the session cache from.

4. Click the “SQL” icon. The SQL command prompt launches.

5. Type the following commands in the SQL command window:

   [mysql]
   DELETE FROM cache;
   DELETE FROM cache_filters;
   DELETE FROM cache_menu;
   DELETE FROM cache_page;
   DELETE FROM watchdog;
   [/mysql]

6. Click “Go.” The cache sessions are removed from your Drupal MySQL database.