Skip to main content

Avoid Id clashes in MySQL after rollback and resync

Main navigation

  • Home
  • Information index

User account menu

  • Log in

Useful links

  • Curated dev resources
  • Roleaf - web hosting
  • Archive.org
  • Repair Wiki
  • Repair Preservation Group
  • Project Farm - detailed product comparisons
  • Tyre Reviews
  • 6 Months Later - reviews
  • Compari.ro - compare prices
  • Pricy - compare prices
  • Recorder
  • Threat Interactive YT - proper 3D optimization
  • Windows 10 Debloater
  • 12ft.io - remove popups
  • Cultist's network power supply tier list
  • Passmark - CPU's
  • Passmark - GPU's
  • SSD tier list by VEXICUS
  • GamersNexus - top-notch tech journalism
  • Windy weather
  • Mermaid diagram tool

Powered by

Drupal Litespeed MySql PHP Javascript Search API Paragraphs
Description

AUTO_INCREMENT values in MySQL can be modified. So, after a rollback...

Steps
  1. set AUTO_INCREMENT id to the next proper ID according to the new content
  2. reimport / resync new content back into the older restored site maintaining ID's
Tags
  • Database
  • Data export
  • Data import
  • Solution

Recently posted

more

Regex to search for "$form" with a maximum of two array indexes, the last of which is optional

Fix for "A colon cannot be used in an unquoted mapping value"

Zip folder excluding subfolders

Regular expression for matching part of a string after the last slash

Config git to ignore file permissions (project-level)

Install specific version of PhP with common packages

  • Loading more...