Menu
Is it possible to restore table to last time with data if all data was deleted accidentally.
500
No this is not possible. The only solution will be to have regular backups.
A SELECT statement begins with the SELECT keyword and is used to retrieve information from MySQL database tables. You must specify the table name to fetch data from—using the FROM keyword—and one or more columns that you want to retrieve from that table. A keyword is a word that is part of the SQL language.
There is another solution, if you have binary logs active on your server you can use mysqlbinlog
generate a sql file with it
mysqlbinlog binary_log_file > query_log.sql then search for your missing rows. If you don't have it active, no other solution. Make backups next time.
109
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
