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! ;)