Python Removes the old "[vc_]" shortcodes found in the db during migrations. If other shortcodes not specific to vc_* are preset, the regex pattern will need to be updated.

remove_vc_shortcodes.py

# Python script to find-replace an exported DB
# For use when the php version timeout's or exceeding memory limits
# export db you want to update, rename it to backup.sql
# place backup in same dir as this script
# run script
# import the out.sql file

import re
from pprint import pprint


pattern = r'\[/?(vc_.*?)\]'
db = None


# Assumes there is a sql file called "backup" in this dir
with open('backup.sql', 'r') as sql:
	db = sql.read()
match = re.findall(pattern, db)
print(f"Found: {len(match)} matching shortcodes")


print("Running Replace")
res = re.sub(pattern, '', db)


with open('out.sql', 'w') as sql:
	print("Writing new db")
	sql.write(res)