By jfmoore on

My main Drupal installation is at:
mysite.com/public_html/drupal

I had a site installed at:
mysite.com/public_html/drupal/sites/mysite.com.go

I am trying to move it to:
mysite.com/public_html/drupal/sites/newdomain.com
with a new database

Before I exported the mysite.com.go database, I cleared the cache and turned off "clean urls". Then, I exported it.

I opened the exported db in Notepad ++ in order to look at it. In the nodes_revision table, articles are stored. I looked at the articles, and all of the images contained in them are hard-coded to mysite.com.go, like:

<img align="right" alt="Boo y''all!" src="/go/sites/mysite.com.go/files/mysite.com-admin/boo-yall-125x125.jpg" />
(I guess this one is this way, because it is referencing the sub-directory, "go", created by Drupal, but I don't know)

etc.

In the articles that I read regarding moving Drupal to a new domain, no one said anything about hard-coded links and what to do (search & replace?) about them. Surely they had images, too.

I've been using Drupal for a couple of years, now, and still feel like a noob. Any suggestions will be appreciated.

⋅ Categories: Drupal 6.x

Comments

benmalen’s picture

benmalen commented

Search and replace for your SQL dump normally does the trick.

jfmoore’s picture

jfmoore commented

I hate mucking around in the database, but I guess I'll give it a try. I don't remember having this problem with Xoops, but maybe I did and just don't remember.

Thanks.

jfmoore’s picture

jfmoore commented

I did a search and replace on the files and node_revisions tables, but the articles still contain links to the old directories. I know it's not a browser issue, because I went to a browser on another machine that has not ever visited this site before, and it has the same problem.

Even though I do not have Drupal cache enabled (and, anyway, I emptied it on the performance page), the following tables contain records:

cache - 5 records
cache_content - 2 records
cache_filter - 41 records
cache_menu - 57 records
cache_views - 13 records

Also, when I do a search in PhpMyAdmin for "myoldsite.com.go" (the sub-dir where the site was located), I find the following:

cache_filter - 29 matches
cache_menu - 13 matches

Could the problem be in one or more of these tables, and, if so, what to do?

Bent Aarup’s picture

Bent Aarup commented

Solution to: Images disappear when moving site to/from a subdirectory.