Yes phpmyadmin can do a search across the entire DB. You can also do a search and replace on a table by executing the following:<br>UPDATE `table_name` set columnname = replace(columnname, 'search', 'replace‘')<br>
<br>Where table_name, columnname, 'search' and 'replace' are the values appropriate for your situation.<br><br>But don't forget to backup first! ;)<br><br><div class="gmail_quote">On Wed, Mar 11, 2009 at 7:52 PM, <a href="http://simone-www.io-lab.org">simone-www.io-lab.org</a> <span dir="ltr"><<a href="mailto:cimo75@gmail.com">cimo75@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">hi<br>
seems to me very reasonable.The only work i did on databases before<br>
was only changing some prefixeson tables, i never changed any data as<br>
values in a table.<br>
What i would do is downloading the "files" table, open it on a text<br>
editor and do a search for that string and eventually replace the<br>
values (links).<br>
Is there a smarter way to work with tables? For example: i am sure<br>
that phpmyadmins has got some useful tool.<br>
<font color="#888888">Simone<br>
</font><div><div></div><div class="h5"><br>
On Wed, Mar 11, 2009 at 11:34 PM, Cog Rusty <<a href="mailto:cog.rusty@gmail.com">cog.rusty@gmail.com</a>> wrote:<br>
> On Wed, Mar 11, 2009 at 5:00 PM, <a href="http://simone-www.io-lab.org" target="_blank">simone-www.io-lab.org</a> <<a href="mailto:cimo75@gmail.com">cimo75@gmail.com</a>> wrote:<br>
>> Hi<br>
>> i ve changed the download mode from private to public and, as supposed<br>
>> to be, i experience some weirdness on my site s images<br>
>> For example the avatar on forum sometime will disappear and the RSS<br>
>> feed image has disappeared.<br>
>> Is there a common way to get back to normality?<br>
>> Simone<br>
>><br>
>> --<br>
>> .wmv , .wma , .pps along with all proprietary Windows formats won t be<br>
>> accepted and/or viewed....<br>
><br>
><br>
> A good start for solving the problem in the database would be:<br>
> - check the file paths in the "files" table.<br>
> - make a general string search in all your database, including the<br>
> content, for "system/files" and fix it.<br>
> - clear all caches.<br>
><br>
>> --<br>
>> [ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]<br>
>><br>
> --<br>
> [ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]<br>
><br>
<br>
<br>
<br>
</div></div>--<br>
<div class="im">.wmv , .wma , .pps along with all proprietary Windows formats won t be<br>
accepted and/or viewed....<br>
</div><div><div></div><div class="h5">--<br>
[ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]<br>
</div></div></blockquote></div><br>