I have been running a MySQL database on a Windows desktop which has lately started to have hardware issues.
Access to the database is from IRC (Internet Relay Chat) through an Eggdrop script. The script adds data to the database from text that is said in an IRC Chat room. Other functions are to search the DB and return the results into the IRC Channel that it was requested from.
Lastly, data can be removed or edited from IRC upon command.
I require someone to perform the following duties;
-Install MySQL (and any other relevant software) on the dedicated service I provide.
-Import the Database and rectify or resolve any issues.
-Create software that will perform the function of the Eggdrop scripts but from the dedicated server. Software will require the following;
--Connect to an IRC network
--Join Channels (some are protected by channel keys)
--Listen to commands said in the channel and add relevant data to the DB
--Remove data upon command
--Listen to other IRC networks / channels for commands to search the DB and reply in that channel with the results of the search.
The current setup also responds to commands from another database to check for missing data from the other database and send the missing data over. Likewise, my database contacts the other for any missing data and receives it.
I can provide the current Eggdrop TCL file to the winning bidder for reference for what I require the final product to do.
Potentially a further project would be to manage the database from a website also for the winning bidder.
9 freelancers are bidding on average $375 for this job
I can help you move database(s) from Windows to Linux. As for further required scripting - I have not programmed/scripted with Python. But I have extensive experience on MySQL/Linux + Windows migration to Linux
I have 6+ years experience with database development (Informix/MySQL/Postgres) UNIX scripting (in particular TCL/Bash/Python) and system administration (Linux/Solaris). This should be very straightforward for me.
I have experience migrating and managing production Linux MySQL databases, experience interacting via a Linux box to IRC via quasselcore, and experience managing my own Linux server.