Migrate sqlite database to mysql database in itdb asset management tool

Question

I have downloaded ITDB - IT ITems DataBase application from http://www.sivann.gr/software/itdb.

SQLite database is using in this application. Now I want to migrate this to MySQL database. I have migrated the .db file to .sql file also import the database to MySQL database. Now how to connect it in this existing project any idea?

Can you share some more information, such as: what have you tried so far, has the documentation not helped? — Alex Lynham
– Alex Lynham, Commented May 25, 2015 at 11:18
Thanks Alex. I have fixed the issue by using the following line instead of including .db file in init.php file $dbh = new PDO('mysql:host=localhost;port=3306;dbname=itdb', 'root', 'root', array( PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8")); — Srim
– Srim, Commented May 25, 2015 at 11:26
@Srim Please post your question as an answer and accept it so others can find the solution later. — simbabque
– simbabque, Commented May 26, 2015 at 12:00

Srim · Accepted Answer · 2015-06-01 06:01:55Z

1

I have fixed the issue by using the following line instead of including .db file in init.php file $dbh = new PDO('mysql:host=localhost;port=3306;dbname=itdb', 'root', 'root', array( PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8"));

answered Jun 1, 2015 at 6:01

Srim

5472 gold badges8 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Migrate sqlite database to mysql database in itdb asset management tool

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related