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

Fix recent log messages (dblog) page from throwing error related to getCacheMaxAge()

Allow published status to be set by an API call on node creation (POST) or edit (PATCH) without giving "administer content" permission to user.

Escape binary data to be used in a JSON string

CSS / JS animations and transitions are worsening performance drasticaly!

Example of how to add a new twig theme template option / suggestion

Overwrite label of operator inside exposed view filter

  • Loading more...