P psalm91 Verified User Joined Sep 20, 2015 Messages 168 Nov 28, 2022 #1 I restored my whole site from a backup but it seems I have old entries still in my database Is this normal? When you restore a site from back does not database simply replaced?
I restored my whole site from a backup but it seems I have old entries still in my database Is this normal? When you restore a site from back does not database simply replaced?
zEitEr Super Moderator Joined Apr 11, 2005 Messages 15,396 Location www.poralix.com Nov 28, 2022 #2 MySQL dumps contain Code: DROP TABLE IF EXISTS `table`; statements. Existing in a backups tables are to be cleared. If you created tables in between of backup creation and restoration times, then they might be left intact.
MySQL dumps contain Code: DROP TABLE IF EXISTS `table`; statements. Existing in a backups tables are to be cleared. If you created tables in between of backup creation and restoration times, then they might be left intact.
Zhenyapan Verified User Joined Feb 23, 2018 Messages 2,449 Location UA Nov 29, 2022 #3 @zEitEr answered you - yes, because it contains DROP TABLE IF EXISTS `table`; if you somehow replace this in mysqlbackup - it will not replace data.
@zEitEr answered you - yes, because it contains DROP TABLE IF EXISTS `table`; if you somehow replace this in mysqlbackup - it will not replace data.