Thread: Transfering, Importing, and PostgreSQL
|New topic Reply||Page: 1|
|New topic Reply||Page: 1|
06/19/10 6:56 PM
Decided to go with Mango Blog after looking at several of the ones available for ColdFusion and so far I'm quite loving it. I redid my ColdFusion tutorial type-site using it, but I have three questions.
1) I want to change where that site is hosted (from my work's servers to my own paid for hosting). In trying to transfer my testing the blog on my local machine to the server, I found it very difficult to move it, and wondered if anyone might have advice or can point me to the proper way to move the site from the current server to the other. Simply copying the files and DB doesn't seem to work.
2) I would love to redo my anime/manga blog using Mango Blog as well, but I found the code difficult to read and just could not figure out the proper way to import the existing entries due to the strange way the entry IDs and what not are handled. I know there are 1 or 2 transfers for things like Blogger, but is there any documentation on just a general way of importing entries from any existing blog system?
3) Any thoughts of adding PostgreSQL support in the future? I prefer using it over MySQL when possible :-) I could probably redo the queries as needed myself, but that would just be broken on update, so built in support would be great.
07/01/10 9:48 AM
1) Besides copying the files, you'll also need to have the datasource setup. If the datasource information changed, you'll also need to make changes to the config.cfm file. If the URL or base path also changed, you'll need to change that in the database.
2) There is no documentation for that. But if you tell me where you are stuck, I can help you.
3) I use pretty standard SQL that works in both MySQL and MSSQL. Have you tried running it?
07/05/10 9:39 AM
1 & 3) Looks like it all moved over no problem. Yay! I did try converting it to PostgreSQL, and wrote a creation script for a PostgreSQL DB, but it was too much trouble trying to get the MySQL DB data imported to PostgreSQL so I just decided to stick with MySQL for now.
For 2, I couldn't figure out how to get any of it done. Since it isn't use the usual method of doing an auto increment ID, I couldn't just pull from the old and insert into the new, and I was having a hard time figuring out how the IDs were being done so I could just loop the old and insert into the new.
07/05/10 10:09 AM
For 2, you don't need to create new ids, just use the ones there. Since it is not using auto-increment, it is even easier to maintain relational integrity when importing.
08/06/10 8:16 PM
Finally got the blog designed and tried to do the import. I was able to write the queries to copy over my existing blog's content to the:
tables. Everything looks good when I look at the database, but when try to load my blog, I get: "Category '3' was not found". Category 3 is in the table, and the ties are all there, so really confused as to what happened. I tried clearing the cache, but still no go?
08/07/10 9:04 PM
Got the categories fixed, though not entirely sure how. I was able to load the category page, which didn't show any of my imported cats. I deleted one of my test categories from when I set up the blog, and that fixed everything. Odd...
I'm looking now at importing the old comments from my previous blog. Mango's table has a field for "author_id"...it should be fine if this is blank except for my own comments, right?
08/07/10 9:05 PM
That is correct.