![]() Even when I remove the commented out lines (whose purpose is to create spatial / geometric fields for MySQL versions 5.7.5+), I still get an error, which tells me the address table cannot be created. I get an error about geometry (which is due to a commented out line in the SQL). I also had to temporarily change MySQL's maximum import size (using a line of SQL I found online): ![]() When I imported the files, I had to untick the box that said "Allow the interruption of an import in case the script detects.". A nice-to-have, but not critical in creating a database. mwb file, which is only useful if you have MySQL Workbench installed, at which point it supplies you a database diagram. I imported the schema file and then the data file, ignoring the. sql files delete and re-create the database anyway. I did not create a database called Sakila and then populate it: the. ![]() The first time I downloaded the sakila database, I did it via phpmyadmin using Import at the Server level. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |