Using dbtng_migrator to transfer from sqlite to mysql

Download and install DBTNG MIGRATOR module: http://drupal.org/project/dbtng_migrator

Configure your ../sites/default/settings.php as following:

$databases = array (
'default' =>
  array (
    'default' =>
      array (
        'database' => 'sites/default/files/.ht.sqlite',
        'driver' => 'sqlite',
        'prefix' => '',
      ),
    ),
);

 

 $databases['mysql']['default'] = array(

   'driver' => 'mysql',

  'database' => 'databasename',

  'username' => 'username',

   'password' => 'password',

  'host' => 'localhost',

  'prefix' => '',

);

Good luck! ;)