Expected IF NOT EXISTS or valid table name but "'" found

I’m trying to import a MySQL dump but run up against the error
Expected IF NOT EXISTS or valid table name but " ’ " found.
on the first create table line. Can someone explain why this is not working? The dump is regularly used to recreate the database structure in other environments and only generates this error in dbdiagram.io
Thanks.

CREATE TABLE ‘address’ (
‘a_id’ int(11) unsigned NOT NULL AUTO_INCREMENT,
‘a_line1’ varchar(75) COLLATE utf8_unicode_ci DEFAULT NULL,
‘a_line2’ varchar(75) COLLATE utf8_unicode_ci DEFAULT NULL,
‘a_city’ varchar(60) COLLATE utf8_unicode_ci DEFAULT NULL,
‘a_acid’ int(11) unsigned DEFAULT NULL,
‘a_postcode’ varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL
)

1 Like