I accidentally deleted a table from the database, is there any way to recovery that table?
I had searched on the internet and in the forum for solutions, I know it could be very difficult, but I still want to ask to see if there is any way.
Additionally, if the deleted table can not be restored, I want to know how to avoid such operations in the future. How could I create a backup of the database?
Error Message
(please share the FULL error message you see, if applicable)
Other Information
(other information and details relevant to your question)
I don’t think there is a way to recreate or restore it (unless you specifically know what was stored in it perfectly). For backups, you can try making 2 databases with the same content, so you can always have a second one in case it happens again.
Thanks for the reply. Do you mean create 2 databases on the Infinityfree MySQL, and write the data to both database? How could the sql operations be applied to both databases, I don’t quite understand that.
Once you drop a table, you can’t recover it, as InfinityFree does not store backups. To prevent this in the future, regularly export your database using phpMyAdmin’s export tool and save it locally.
I would not do this. It does not prevent you from losing your data to corruption or server error. NEVER “backup” something to the same space as the original, that’s not a backup, it’s a copy.
In PMA, click export at the top, then same the generated SQL file in a secure location.