By flocki on

Hi everybody!
I'm new to drupal and in the process of setting up a Durpal 7 website. I have started on a private server using sqlite as the database for the initial site development.

Since I get frequent Fatal errors because of sqlite locking issues (especially when more users access the site @see http://drupal.org/node/1120020 ) I wanted to migrate to mysql as the database backend.

I have tried various strategies so far.
My first attempt was to use the

dbtng_migrator

but that didn't do the trick.

Then after reading some comments about moving a drupal site to a different server I have created a dump of my sqlite database, and imported to mysql (after some editing of course).

Now I'm having issues with character encoding (umlauts), and the cache is somehow broken (the serialized data is incomplete).

Has any of you had experience migrating from sqlite to mysql?

best,
flocki

⋅ Categories: Drupal 7.x

Comments

flocki’s picture

flocki commented

Ok, I got it working now. For those having similar issues, the cache.data column was of type blob and not longblob.

And I fixed the character encodings with mysql --default-character-set=utf8

charoite’s picture

charoite commented

I am trying to do the same thing myself of migrating a SQLite database on my local machine to a SQL file that I can copy to an online server.

The DBTNG migrator module wasn't very helpful or clear for me either.

What steps did you do to convert your SQLite database to SQL?
I am using a macbook and can't even find the .ht.sqlite database in the path the settings.php files says it is in.

Any help would be appreciated

nerdoc’s picture

nerdoc commented

I need the same - could you tell us how you did it?