Drupal - sql command to help when moving the root file folder

Sometime you need to move the 'files' ( /site/all/files ) folder for drupal.
When this happens you also need to amend the database, the following is a quick and easy sql command that will do that for you.

UPDATE files SET filepath=REPLACE(filepath,'sites/all/files','sites/mywebsite.co.uk/files');



»
  • share

Post new comment

  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd>
  • Lines and paragraphs break automatically.
  • You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>, <c>, <cpp>, <drupal5>, <drupal6>, <java>, <javascript>, <php>, <python>, <ruby>. The supported tag styles are: <foo>, [foo].

More information about formatting options

Type the characters you see in this picture. (verify using audio)
Type the characters you see in the picture above; if you can't read them, submit the form and a new image will be generated. Not case sensitive.
Bg