<div dir="ltr">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.<div>
<br></div><div>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.</div><div><div><br></div><div>Kevin</div></div></div><div class="gmail_extra">
<br><br><div class="gmail_quote">On Fri, Nov 8, 2013 at 12:39 PM, Nancy Wichmann <span dir="ltr"><<a href="mailto:nan_wich@bellsouth.net" target="_blank">nan_wich@bellsouth.net</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div><div style="font-size:12pt;font-family:arial,helvetica,sans-serif"><div><span>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.</span></div>
<div style="font-style:normal;font-size:16px;background-color:transparent;font-family:arial,helvetica,sans-serif"><br><span></span></div><div style="font-style:normal;font-size:16px;background-color:transparent;font-family:arial,helvetica,sans-serif">
<span>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.</span></div><div style="font-style:normal;font-size:16px;background-color:transparent;font-family:arial,helvetica,sans-serif">
<br><span></span></div><div style="font-style:normal;font-size:16px;background-color:transparent;font-family:arial,helvetica,sans-serif"><span>Does anyone know an easy way to get rid of the prefix? Are there any dangers in the straight-forward manual process?<span class="HOEnZb"><font color="#888888"><br>
</font></span></span></div><span class="HOEnZb"><font color="#888888"><div> </div><div><font color="#ff007f" face="bookman old style, new york, times, serif" size="4"><i><b>Nancy<br></b></i></font></div></font></span></div>
</div><br>--<br>
[ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]<br></blockquote></div><br></div>