By djhomeless on

Hi There,
Just created a new site with the 4.5.0 RC and it looks great! I'm very pleased with the changes made since 4.3.

One question, I created the site on a new URL on the same server I had a previous Drupal installation. Both instances point to the same MySql server (but different database names). Now, is there an easy way to migrate the content from the one database to another? I did try pointing the new Drupal instance, to the old Drupal database, then running the updata.php file, but unfortunately I got a lot of errors when running the upgrade sql script (I did manually add the missing tables as instructed).

At the end of the day, I don't care what happens to the old install, I'm just trying to migrate the few blog postings and stories I produced (no user data to worry about).

Thanks in advance!

Geoffrey

Comments

Jhef.Vicedo’s picture

Jhef.Vicedo commented

Folow the instructions here carefully and you will have a smooth transition. This is the easiest and safiest way.

Good luck!

Work smarter, not harder!
jeff_vicedo@yahoo.com

jhefmv [at] gmail [dot] com
Work smarter, not harder!

djhomeless’s picture

djhomeless commented

I did follow the upgrade procedure as I mentioned in the original post. I also disabled all custom modules, however I did forget to disable my theme. I'll give this a try and report back.

thanks!

Geoffrey

djhomeless’s picture

djhomeless commented

Hmm,
Didn't realise that disabling themes and modules didn't apply to me as I was dealing with a new installing/existing database.

I ran the upgrade script manually and it seemed to work. The site loaded fine but I started seeing odd behaviour. For instance, I can input a new category item, but the page will load blank ie no category item. I checked the vocabulary table in the database and it did indeed record the new item.

Any ideas? I've gone over the data schema for a new install and my existing database, and I'm not missing any tables. I've even pointed Drupal to a fresh database and can confirm adding a category works there.

Any ideas? To restate, I have a totally fresh install of 4.5 on a new domain, but I have pointed to an old Drupal database so I can keep my old content.

Thanks in advance,

Geoffrey

Jhef.Vicedo’s picture

Jhef.Vicedo commented

I have a totally fresh install of 4.5 on a new domain, but I have pointed to an old Drupal database so I can keep my old content.

What do you mean by old Drupal database? Is it the "old" one you used before? Or the one you run the update script against with?

My suggestion is that have a back-up file of your "old" database. Once you did that, run the update script(update.php) against it, overwriting the entire DB. Point Drupal to the newly update DB. Don't worry, your old content will not be lost. But you can always revert to your back up DB if there are problems with the new one.

Please let me know if I helped. Thanks

Work smarter, not harder!
jeff_vicedo@yahoo.com

jhefmv [at] gmail [dot] com
Work smarter, not harder!

djhomeless’s picture

djhomeless commented

Thats basically what I've done now. My MySql database has two db's, one fresh Drupal, and one Drual thats been updated from 4.3. When I point my installation to the fresh one, everything works fine. When I point it to the updated one, I can't add categories.

If there was a way to migrate just the content I created from the updated one to the fresh one, then I would just blow out the old one. I have tried exported all the node tables, but I believe I need to do a few more tables to get it right.

Thanks again,

Geoffrey

djhomeless’s picture

djhomeless commented

Now I've tried exporting the entire database, and re-import cleanly. I still get the same problems.

Does anyone have any advice here? All I want is to keep my original content. If one was to do that, which tables would I need to keep? They were all blog posts.

Otherwise, does anyone have an idea why adding a category would fail? As I posted earlier, I can confirm the catergories are getting written to the database.

Sorry,

Geoffrey