Security Reminder
Local does a pretty good job of scrubbing private info from the logs and the errors it produces, however there’s always the possibility that something private can come through. Because these are public forums, always review the screenshots you are sharing to make sure there isn’t private info like passwords being displayed.
Thanks for sharing logs, @DJS. They show that MySQL could not handle some of the SQL files in your .tar.gz backup file:
Error: Local was unable to import the following SQL files:
- /app/sql/avatar.sql
- /app/sql/crawler_blacklist.sql
- /app/sql/crawler.sql
- /app/sql/img_optm.sql
- /app/sql/img_optming.sql
- /app/sql/url_file.sql
- /app/sql/url.sql
The import errors mention SQL syntax that may have been generated with a different version of MySQL. (For example, “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 ‘id bigint(20) unsigned NOT NULL AUTO_INCREMENT,\n url varchar(1000) NOT NULL’”.)
You could try extracting the .tar.gz file, removing those SQL files, recompressing the archive and importing it into Local again. (You would lose the data in those files, but it may give you a site you can work with locally.)
Thanks Nick – good of you to give such a detailed answer. I’m not a techie at all and just trying to make my wife’s old website that we have backed up available for content scaping.
I have extracted the file per attached screenshot.
