[support] recovering from private mode download

[William Smith]

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:
UPDATE `table_name` set columnname = replace(columnname, 'search',
'replace‘')

Where table_name, columnname, 'search' and 'replace' are the values
appropriate for your situation.

But don't forget to backup first! ;)

On Wed, Mar 11, 2009 at 7:52 PM, simone-www.io-lab.org <cimo75 at gmail.com>wrote:

> hi
> seems to me very reasonable.The only work i did on databases before
> was only changing some prefixeson tables, i never changed any data as
> values in a table.
> What i would do is downloading the "files" table, open it on a text
> editor and do a search for that string and eventually replace the
> values (links).
> Is there a smarter way to work with tables? For example: i am sure
> that phpmyadmins has got some useful tool.
> Simone
>
> On Wed, Mar 11, 2009 at 11:34 PM, Cog Rusty <cog.rusty at gmail.com> wrote:
> > On Wed, Mar 11, 2009 at 5:00 PM, simone-www.io-lab.org <cimo75 at gmail.com>
> wrote:
> >> Hi
> >> i ve changed the download mode from private to public and, as supposed
> >> to be, i experience some weirdness on my site s images
> >> For example the avatar on forum sometime will disappear and the RSS
> >> feed image has disappeared.
> >> Is there a common way to get back to normality?
> >> Simone
> >>
> >> --
> >> .wmv , .wma , .pps along with all proprietary Windows formats won t be
> >> accepted and/or viewed....
> >
> >
> > A good start for solving the problem in the database would be:
> > - check the file paths in the "files" table.
> > - make a general string search in all your database, including the
> > content, for "system/files" and fix it.
> > - clear all caches.
> >
> >> --
> >> [ Drupal support list | http://lists.drupal.org/ ]
> >>
> > --
> > [ Drupal support list | http://lists.drupal.org/ ]
> >
>
>
>
> --
> .wmv , .wma , .pps along with all proprietary Windows formats won t be
> accepted and/or viewed....
> --
> [ Drupal support list | http://lists.drupal.org/ ]
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.drupal.org/pipermail/support/attachments/20090311/6f3e7385/attachment-0001.htm>