- Right click the Windows Start button and click ‘Run’
- Type ‘services.msc’ and click OK
- Under the column ‘Name’ find ‘MySQL’
- Right click on MySQL and click ‘stop’
- Insert the flash drive containing your backup
- Run Windows Explorer
- It is the manilla envelope on your task bar
- Locate your flash drive in the left pane
- Right click on your latest backup folder
- It will be ‘data’ with the latest date
- eg data_01312025
- Click ‘Copy’
- You may have to click ‘Show more options’ to find ‘Copy’
- In the left pane click on your C: drive
- It is under ‘This PC’
- OS (C:) or Windows (C:) etc.
- Under C: locate ‘Program Files (x86)’
- Older versions of Windows will only have ‘Program Files’.
- Under ‘Program Files (x86)’ locate the ‘MySQL’ folder
- ‘Program Files’ ‘if you don’t have ‘Program Files (x86)’
- Under ‘MySQL’ locate ‘MySQL Server 4.1’
- Double click on ‘MySQL Server 4.1’ to open the folder
- You will see a folder named ‘data’
- That is your current data base
- Right click on or in the ‘MySQL Server 4.1’ folder and paste
- Paste your backup into this folder
- Rename your current ‘data’ folder
- Right click the current ‘data’ folder
- Rename it ‘data_old’ or anything else
- Right click on the backup you just pasted into the folder
- Rename it ‘data’ (without apostrophes)
- Return to the services window
- services.msc above
- Right click on ‘MySQL’
- Click ‘start’
- Your restore is complete