Need DB Advice
I am completely database illiterate. I needed a database built for my fire department website and I went with the site "Freelancer" to enlist someone to build it for me. They built it and it worked beautifully. Was able to have all members of department in there and allow sorting by name, start year, rank, station assigned to etc. They also created a password protected interface to access the control panel of the DB to enter and edit data
After about a week all of the data disappeared. Of course I did not have it backed up so i had to re-enter all the data for 120 people ! I got smart and backed it up. About a week later all data was gone again. I reached out to the freelancer that built it and they restored data (of course they asked for payment to do additional work) but I informed him the database is not working up to my expectations as it is dumping the data.
About 2-3 weeks went by with everything being well and yesterday the data was all lost again.
I reached out to the guy again and he requested root access in to my server (I have a VPS) and I obviously do not feel comfortable with providing access. I at first was worried this may be a little ploy of them dumping the data to get more work from me and get more money. I have changed the cpanel password after he logged in to design the DB but not sure if something shady is going on.
Can anyone provide input on what my next course of action should be to find out why the DB is losing its data?
Have something to add? We’d love to hear it!
You must have an account to participate. Please Sign In Here, then join the conversation.