Recent Topics

[1.10.x] Database migration problem

Started by on Apr 27, 2008 – Contents updated: Apr 27, 2008

Apr 27, 2008 05:46    

My b2evolution Version: 2.4.x

Hi all

I want to migrate from version 2.4.0 to 2.4.1
from database at http://vietpost.110mb.com
to http://vietpost.890m.com

both have charset utf-8 encoding
both 2.4.x version are configured according to
http://forums.b2evolution.net/viewtopic.php?t=13366&highlight=utf8

I exported & imported DB using phpmyadmin
Pls see display in http://vietpost.890m.com

Pls advise on backup and restore for multiplingal blogs. Thanks.

Tv

Apr 27, 2008 06:01

Migrating AND upgrading at the same time is not a good idea, but I don't think that is the cause of your issue. Did you try what http://forums.b2evolution.net/viewtopic.php?t=6470 says might help?

I'm sorry but I can offer no real help here. All I know is when I backup and restore comments from ¥åßßå get all messed up and I simply go in and edit each comment to make it right again. Probably if I learn what you need to do I won't have that issue next time?

By the way the "migrate and upgrade" should not be an issue this time because I think the database had no changes from 240 to 241. Normally it is risky though because of database changes. So normally "migrate first then upgrade" or "upgrade first then migrate".

Here's hoping the other thread helps!

Apr 27, 2008 06:47

Thanks EJB for quick response.

I want to try iconv.
How do i know the encoding of my existing database, using phpmyadmin ?
Thanks

Tv

Apr 27, 2008 07:12

hmmm... the post title says [1.10.x] but your post says 2.4.0 and 2.4.1 so I hope this does not include a 1.10.x database because that will absolutely make this much worse.

Anyway I found my encoding via phpmyadmin, but not when I actually selected a database. On the first screen it is there, but once I pick a database I have to click on the top where it says "Server: localhost".

Apr 27, 2008 12:50

AFAIK phpMyAdmin exports database in UTF-8 by default, so when you import your db select File encoding: utf8 .

I had the same encoding problems on MySQL 4 , does the host you exporting db from use MySQL 4? :roll:

Also make sure your new db has the same collation as another one.


Form is loading...

powered by b2evolution free blog software – This forum is powered by b2evolution CMS, a complete engine for your website.