WordPress.org

1. lastt
   Member
   Posted 6 years ago #

   Hello,
   I had a user deleted and would like to put all of that user's data back in from a mysql dump I have from the night before that happened. The problem is that there are a lot of duplicate entries in the old sql dump and the current database. Is there a way to ask it to put them in but to ignore or overwrite duplicate entries? As it is, I get a table already exists error when executing: mysql -u username -p dbname > old_backup.sql

   Thanks in advance!

2. MichaelH
   Volunteer
   Posted 6 years ago #

   If I were doing this with phpMyAdmin I'd DROP all the tables in your current database before Restoring your database.

   Additional Info: Database_Description

   ********************
   Welcome to the WordPress Support Forums!

   Please help keep the Forums successful by reading:
   Using the Support Forums

   Also, remember the WordPress Codex and the FAQ pages.

   And, thank you, for letting us know if this information proves useful (or not)!
   ********************

3. lastt
   Member
   Posted 6 years ago #

   Thanks but if I drop it i can only put one sql dump's info back in.

4. MichaelH
   Volunteer
   Posted 6 years ago #

   When I backup my database all tables get backed up so if a restore is necessary I can restore all tables.

5. lastt
   Member
   Posted 6 years ago #

   Same here but I have the problem of overlapping duplicate entries. Thanks!

Topic Closed

This topic has been closed to new replies.