backup duplicating db tables?

Involved Joined: Apr 22, 2006 Posts: 356

I have another odd issue. That seems to be my luck these days Rolling Eyes

.
Anyhow, after restoring my site from a days previous cpanel backup, I now find that some db tables have been doubled or even tripled. I had this before and thought it was a bug in the Nuke League module that I use but it happend again and not only to that module but to the nuCalendar module's tables as well.

What would cause this? Is there an easy way to get back to the original structure?

Posted: Thu Oct 19, 2006 3:00 pm

Do you mean that there is two (or three) copies of the data in each table -- not that there are two or three copies of each table? I guess it must be the former but please confirm.

Normally, you would want to do a drop of all the tables before restoring a backup. The backup is likely to have a create table for each table and then a bunch of insert statements to reinsert the data. So without a drop I guess it's possible to reinsert the data several times.

Take a look at how your dump file is structured if you get a chance.

To fix it, first confirm all this and then probably you are going to need to do a drop before you restore. If you have phpmyadmin you can use it to select all the tables and drop them. If not you might need to add the drop table statements manually, e.g.,

Code:

DROP TABLE IF EXISTS `nuke_authors`;


CREATE TABLE IF NOT EXISTS `nuke_authors`

for each table.

Posted: Thu Oct 19, 2006 3:08 pm

here is an example of what it did to the calendar table.

say there was a table with 12 rows of data, it had all twelve rows listed 2 or three times. IE 1data, 2data,3data etc, 1data, 2data, 3data, etc, 1data, 2data, 3data.

I understand to drop the tables, as I did not know that before, but why would it only duplicate some of them and not all of them?[/code]

Posted: Thu Oct 19, 2006 3:25 pm

actually I am using cpanel backup so it restores everything itself, I do not have to use the phpmy admin function. At least that is what I would think.

Posted: Thu Oct 19, 2006 3:39 pm

got it back to normal. thanks.

Posted: Thu Oct 19, 2006 5:27 pm

Congrats. FWIW, if a field is key and unique then an insert won't duplicate the record it's in. That could account for what seemed like anomalous results. The records that were duplicated or triplicated probably didn't include keys and those that weren't probably did. Just a guess.