How do you add a prefix to an existing drupal database for single site use? I have a drupal 7 site running on a webserver, it is currently using a database that was created with out a prefix.

I am attempting to restore that database to a new drupal instance from a shared hosting provider. I am using the Backup and Restore Module to move the database.  One thing I have no apparent control of is that their "quick install script" creates a new drupal database with a "drupal_" prefix.

Do I need to convert my existing database to have that prefix, because as it seems now my migrated changes are not even being read since it probably has both sites data sitting side by side, and the  database information I want to be reading  entries  from don't have the prefix? Is that reasoning correct? If so how do I convert my Drupal database to the same one but now with the necessary prefix applied throughout?
If you have phpMyAdmin the simplest way is to:


go to the "Structure" tab (where there is the list of tables).
select all the tables (with the "Check All" checkbox at the end of the list)
in the dropdown list close to the "Check All" select the action "Add table prefix" (or "Replace table prefix" if that is the case)
insert the prefix, press the button and let it do all the work.


After that remember to specify the prefix in the site\default\settings.php

array (
  'database' =&gt; 'sample_drupal_db',
  'username' =&gt; 'sample_drupal_usr',
  'password' =&gt; 'sample_drupal_pwd',
  'host' =&gt; 'localhost',
  'port' =&gt; '',
  'driver' =&gt; 'mysql',
  'prefix' =&gt; 'prefix_', // &lt;&lt;== prefix here
),