Help on Drupal table prefix I just installed Drupal 7 and made some content and configuration.

After that, I just realized I did not put any table prefix on installation.

My problem is:

Is there anyone here that knows the SQL to add table prefix on Database drupl?

Example


current table: variable
must be: drupal_variable


I want to change all my table and add prefix.
If you have access to phpMyAdmin, you can do that manually following this steps:


Login to PhpMyAdmin
Select all drupal tables
With selected: Replace table prefix 
From: {empty}, To: yourprefix_
in settings.php (sites/default/settings.php) change in the database configuration: 'prefix' =&gt; '', to 'prefix' =&gt; 'yourprefix_',
Run cron.