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
The transferred book may appear to be loading all of its media just fine—and it will continue to do so, as long as the media still exists in its original location. As soon as that media is deleted or moved, however, it still stop loading in your book. Consequently, you may want to move the physical media from the source book’s folder to the destinations book’s folder to reduce your project’s potential points of failure. 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.