I have a WP site that is currently on XAMPP. I’d like to transfer it to Local. Which backup plugins can I use to successfully upload the site/database into a new Local WP site?
I saw an Elementor tutorial that used BackWPup for demonstration purposes. I tried that but it did not work. It failed for unknown reasons when trying to upload the database:
Uh-oh! Unable to import site.
Error: Local was unable to import the following SQL files:
sql file name
In the log file:
ERROR 1064 (42000) at line 23987: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘’ at line 4\n at h. (%%appPath%%\main\importer\Importer.js:1:8277)\n at Generator.next ()\n at a (%%appPath%%\main\importer\Importer.js:1:124)\n at processTicksAndRejections (internal/process/task_queues.js:85:5)",“level”:“error”
I have no idea what caused it and I am extremely hesitant to run the backup again as it took almost 7 hours!
So I am looking for another backup plugin that would work with uploading into Local.
Anything else that would work?