Accidentally delete a table from the database

[new_user_to_infinity]

Website URL

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)

[EuropeanRat]

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.

[new_user_to_infinity]

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.

[wasik405]

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.

@Admin

Backup your databases

You can download database backups through phpMyAdmin.

1. Login to the control panel of your account.
2. Click the phpMyAdmin button.
3. Click the Connect Now button next to the database you would like to download.
4. Go to the Export tab.
5. Click the Start button.

[Greenreader9]

@new_user_to_infinity

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.

@EuropeanRat

you can try making 2 databases with the same content,

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.

[new_user_to_infinity]

Thank you for the advice!

[new_user_to_infinity]

Thank you very much!

[hacxxx]

No way to restore it.