Nancy, not a big deal. Besides using some clever regex, you could just download the DB, open in a "robust" text editor (BBEdit?), and search/replace away those prefixes... then upload to replace.
Change your settings.php DB connection to exclude the prefix. After that, it's best to use Drush to rebuild the registry, clear cache, etc.
Kevin
On Fri, Nov 8, 2013 at 12:39 PM, Nancy Wichmann nan_wich@bellsouth.netwrote:
I have inherited a site that was built in India. Looking at the database, I see that they used a database prefix. No, I have no idea why.
There is a little bit of data in the non-prefixed tables, although what I have looked at seems to be garbage. For example, the non-prefixed node table is empty.
Does anyone know an easy way to get rid of the prefix? Are there any dangers in the straight-forward manual process?
*Nancy*
-- [ Drupal support list | http://lists.drupal.org/ ]