Anope Support > 2.0.x/1.9.x Support

Using MYSQL for storage

(1/1)

rabbit:
Hello,

I have inherited an IRC server running Anope 2.0.7 with Inspircd 2.0.27.  This is a very busy server and uptime is imperative.  Also, I am very much a noob to IRC servers so the last 6 months has been a deep dive for me.

I need some help in getting our server to store it's data in MYSQL.

The first thing I noted is that m_mysql was not configured and loaded, this has been corrected, note that there was some data in some tables already prior to enabling this module.

The db_sql_live module is loaded and some tables have data whilst others do not.  For example anope_db_BadWord is populated with data but anope_db_Memo is empty as is anope_db_XLine.

What is the correct procedure to get the mysql database initially loaded and then used from that point on.  I have read up on using the import tag in conjunction with db_sql, is it as simple as restarting Anope with the db_sql and import tag=true to reload the mysql database and then changing to db_sql_live and import = false. 

Is an /os update & /os reload all that is required or do I need a service restart.

I am not sure how the data got into this state, it's almost like someone previously has attempted this and reverted the settings. There were some side effects to enabling db_mysql, a few operators mentioned that their greet had reverted to an older version.

Any advice would be greatly appreciated.



Navigation

[0] Message Index

Go to full version