Historic database set up issue - help!

0 votes

I'm not amazingly tech savvy, so would appreciate any help anyone can give me on getting the historic database set up.

I've followed the MySQL set up , downloaded and unzipped the historic data file and gotten as far as Run SQL script, but then am instantly getting the message screens below every time.  Any ideas where I might have gone wrong?

Error executing SQL script - sequence item 6:expected str instance, bytes found

Thanks in advance

Doug

asked Jan 30, 2021 by coolbeanio Plater (120 points)

1 Answer

0 votes

Hi,

It looks like this may be caused by an issue in the latest version of MySQL Workben, since achother user reported exactly this error within the last few days.   The good news is that you. don't have to use MySQL Workbench to install, although usually (not now!) it's more convenient. 

If you're familiar with the command line, you should try this — from the directory where you've unzipped your SQL:

mysql  -u <username> -p<password> <databasename> < historic_data.sql

where username, password and databasename are the ones you chose when you created the schema. There should be no space between the -p and the beginning of the password.

You will also need to make sure that the command "mysql" at the command line is going to the path of the mysql programs, otherwise your system won't recognize this command.   (NB. You can also find all the command line installation instructions in our original version of the manual on the site. ) 

Hopefully this sorts out the problem but if you're still having issues please contact us directly using the "Contact Us" form on the site and we can troubleshoot your local installation if you let us know what errors you're getting - we'll need to know what OS you're on as well of course.

answered Jan 31, 2021 by colin Frankel (19,320 points)
Thanks for such a prompt answer. Will try this and let you know.
No problem - note also it is probably worth seeing if you can install a previous version of MySQL Workbench (not the latest) and get that working with the default install instructions - we tested previously on 8.0.20 which you can still download here:

https://downloads.mysql.com/archives/workbench/
Hey there - would just like to add that I had the same issue on macOS Big Sur. I deleted MySQL Workbench in Applications > reinstalled version 8.0.20 as per the above comment and got it working. You can just pickup where you left off in the help guide.
Thanks for the feedback!
...