Scalar 2 User's Guide

Transfer physical media, too, and rewrite URLs after you've used the Transfer tool

The Scalar book Transfer tool is kept in the Dashboard's "Import/Export" tab.  It allows authors to move Scalar books from one place to another.  Most often, this transfer is across servers, moving a source book under one domain to a destination book on another domain.  However, while all a book's pages and relationships will be transferred, including media-pages, any physical media that was uploaded to the source book will not be physically copied to the destination book, even if it's on the same server.  If you have pages that connect to uploaded media, the result in the destination book will be media-pages where the URLs point to the media in the source book:
Source book media-page
   URL points to media in the source book's folder on server
Destination book media-page
   URL points to media in the source book's folder on the source book's server

Consequently, you may want to move the physical media from the source book's folder to the destination's book's folder.  You can accomplish this via FTP, as you would any file transfer.  After physically transferring the media, the last step is to update the URLs of the destination book's media-pages to point to the media now present in the destination book's folder on the new server. There is no "built-in" way to do this in Scalar, but it can be accomplished by running a few queries in MySQL.  

Also, a problem might exist that hyperlinks that were created in the text content of the source book's pages might continue to point to pages in the source book instead of the new pages in the destination book.  The MySQL described below will correct this problem as well.

First, open up phpMyAdmin on your destination server or the MySQL command line.  If in phpMyAdmin you can then select the database and click over to the "SQL" tab where you can run custom queries.  Go ahead and run the below set of queries:

That's it!  You should notice that the destination book's media-pages now point to the physical media on the destination server.  In which case, the source Scalar book can be safely removed.

This page has paths:

This page references:

  1. Rewrite physical media SQL script