• Johanv
  • Junior Member
  • Offline
  • Registered: 2005-01-13
  • Posts: 2

Topic: Convert phpBB, Win, Access db -> PunBB, Linux, mySQL db

Hi,

I'm wondering if it's possible to convert a access database to a mysql database...

Thanks in advance!

/Johan

2 Reply by Paul

  • Paul
  • Senior Member
  • Offline
  • From: Wales, UK.
  • Registered: 2003-08-13
  • Posts: 3,089

Re: Convert phpBB, Win, Access db -> PunBB, Linux, mySQL db

Yes. There are utilites to do it. I don't know whether any of them are free but some have free trials. Google on Access to mySQL

  • Johanv
  • Junior Member
  • Offline
  • Registered: 2005-01-13
  • Posts: 2

Re: Convert phpBB, Win, Access db -> PunBB, Linux, mySQL db

I found one like that, but arent the databases constructed differently... different names on fields etc...

/Johan

4 Reply by buzzkill (edited by buzzkill 2005-01-13 21:15)

  • From: Rochester, NY USA
  • Registered: 2005-01-05
  • Posts: 173

Re: Convert phpBB, Win, Access db -> PunBB, Linux, mySQL db

The conversion probably handle all of that.  Its not going to rename the tables, just take them from one format and convert them into another.  If you are refering to taking another board that uses Access and converting it to punbb which uses MySQL, PostgreSQL, and SQLite, than your first step would be to get it converted from access to one of the three that punBB suports.  After that, someone would have to create, or add onto the existing migration tool that will take the data in the other board database and migrate it to punBB schema.  The two key terms are Convertions and Migration. 

Migration = move table data from one MySQL database to another table structure using MySQL (Migrate from phpBB to punBB)
Convertion = change from one database language to another database language. (convert MS Access to MySQL)