Saturday, July 8, 2023

Restore xampp database from backup

steps:

stop mysql xampp

1 - create some backup folder "data_1" 

2 - from your current xampp/mysql/data folder move core folders and all files (like 'mysql', 'performance_schema', 'phpmyadmin', 'test'  and all files to new backup folder

3 - from xampp/mysql/backup foder - move all to you xampp/mysql/data folder (so it is like override code folders/files from backup)

4 - from you beckup 'data_1' folder , copy file ibdata1 to /xampp/mysql/data folder

restart mysql


https://stackoverflow.com/questions/18022809/how-to-solve-error-mysql-shutdown-unexpectedly

Restore xampp database from backup

steps: stop mysql xampp 1 - create some backup folder "data_1"  2 - from your current xampp/mysql/data folder move core folders an...