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@gmail.comwrote:
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@gmail.com wrote:
On Wed, Mar 11, 2009 at 5:00 PM, simone-www.io-lab.org cimo75@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/ ]