Anope IRC Services

Please login or register.

Login with username, password and session length
Advanced search  

News:

Pages: [1]   Go Down

Author Topic: Migrate from .db to MySQL  (Read 5961 times)

0 Members and 1 Guest are viewing this topic.

george h

  • Anope User
  • Offline Offline
  • Posts: 5
Migrate from .db to MySQL
« on: May 27, 2012, 10:34:30 PM »
Hi all, I am upgrading from a slightly older version of Anope using .db files to the latest 1.8.7 using MySQL. Does anyone have any idea how I might convert the .db files to MySQL records or something, or is there a tool provided to do that?

I don't know what structure you use for the db files but I don't recognise it as anything classic like sqlite. I also am worried the structure might have changed from the version I moved from.
Logged

katsklaw

  • Supporter
  • Anope User
  • Offline Offline
  • Posts: 537
Re: Migrate from .db to MySQL
« Reply #1 on: May 27, 2012, 10:40:58 PM »
All you have to do is:

1. import the data tables
2. insure Anope is compiled and running with mysql support
3. your mysql db information is in services.conf correctly

Then on IRC type: /os set sql on then /os update. The data will be dumped to mysql in a read only mode as 1.8 and older versions do not use live sql so you are not "migrating" you are simply dumping data, Anope will always use the FFF databases regardless.

There is more information on docs/MYSQL.
Logged
Pages: [1]   Go Up
« previous next »