Roll back sql queries on phpbb boards - mysql?

I deleted accidentally some messages on my phpbb boards that use mysql underneath for database, is there anyway i can roll back these queries and get back my messages?

Those messages are now very important, the police is asking for them, since they were someone1 posting some personal info in public, that i had to delete (and i did) but by mistake i didnt fully back up it first.

is there any way?

haven't touched a thing ever since. there are cache in phpbb i guess. but i dont know how to solve this mess!
LVL 1
celticianAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

gr8gonzoConsultantCommented:
Not unless you have binary logging turned on.
0
arnoldCommented:
fad have them going back to hen those posts were made (just to be clear).
Depending on access to your site and the pragma directives in use, you might be able to use the web.archive.org.


Do you have any backups prior to the delete? Do you have an offline/replication DB server? You might have a copy on a development platform.
0
celticianAuthor Commented:
Where do i check if binary is turned on?

thanks.
0
The Five Tenets of the Most Secure Backup

Data loss can hit a business in any number of ways. In reality, companies should expect to lose data at some point. The challenge is having a plan to recover from such an event.

arnoldCommented:
Binary logging is set in /etc/my.cnf
Bin-log directive
Look in /var/lib/mysql you would have .bin files.

What was the timeframe between the post and the deletion?

For future practice, I would think the PHPBB has the option of marking the post such that it will not display rather than having to be deleted out right.
0
celticianAuthor Commented:
This is shared hosting, i dont have access to such folders, only to the phpbb folders
0
gr8gonzoConsultantCommented:
Ask your hosting company for the logs.
0
arnoldCommented:
Check with the hosting company if they have a backup.
do you have phpmyadmin or any other tool that allows you to adminiter the mysql?
run show variables query and look for log-bin

show variables where variable_name=log-bin;
see if it is set to ON.
0
celticianAuthor Commented:
I do have mysql admin option (phpmyadmin), however my hosting company does not have a back up. Where can i check such thing on phpmyadmin?
0
arnoldCommented:
In phpmyadmin you have the option to back the data to your local system.
But this is what you would have to implement for future, along with checking whether the PHPBB has a column that indicates the record is deleted and should not be displayed.

Based on the information, the record is done and gone.
0
gr8gonzoConsultantCommented:
I'd agree. It sounds like the record's gone. Unfortunately, that's sort of the intention of the way databases handle deletes. It doesn't have safeguards in place unless you turn them on because every safeguard will reduce performance.

If it's significant enough for the police for some case, they could potentially get the physical hardware from the hosting company and run forensics on it to try and recover data, but that's very unlikely to happen, and the chances dramatically decrease over time as new data is written to the drives.

At this point, you can learn from this experience and make regular backups. My guess is that you're on a cPanel-based system, so you should be able to set up a cron job to create daily or hourly snapshots of the database.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
celticianAuthor Commented:
I dont think the police will do such thing as the case is so minor (some insults ind a board and a phone number published...) thanks anyway! i couldn't get the log back, anyway hte police hasn't contacted me yet and i was able to get the IP elseway as this moron posted more and more posts with the same thing from the same IP...
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
MySQL Server

From novice to tech pro — start learning today.