SQL Partial Imports - Users
 

My sites have really been hit hard this year by hackers and it has really worn me down to a point where I am tired of putting tons of effort into retrieving them back completely to where they were before attacks, but I have a question regarding importing partial SQL files into my vBulletin database.

This last attack was my forums and to get around all the malicious script uploaded into and overwriting my files, I did a fresh install and imported a bit older database that I thought was good. Things aren't bad accept some users had corrupted member information and through repairing the database etc. some are missing. I however have a user only vBulletin export SQL file that I would like to just import into the database, but through MySQL I get errors or time outs. Should be over 25,000 users in the file maybe that is big for uploading into a database, not certain.

The file was an export from MySQL of my user data, so I thought it would import right in, but it isn't seeming to work.

File Imports report:


If I run a Query I get:



So if anyone could help me with suggestion on if this can be done I would appreciate it, I am an architect not a server or database expert. I am just trying to get things working and house keeping done before everything is moved to a new server I am purchasing.

Thanks in advance for your time and help.

Russell

Hi Russel, I think this is because you already have an existing User table, so it isn't importing. My guess would be that you need to first delete/truncate the entire user table, and then import the other one.

Of course, back up before attempting that!

Thank you, I was hoping there was some syntax I could use to just update missing data. I guess not, thank you for your help.

Regards,

Russell

You could but it might be more complicated. You'd need to import the data into a temporary table (i.e. temp_user) and run a query like the following:

squidsk, thank you very much, very helpful!