I'm trying to import a sql db using phpmyadmin it gives me
#1036 - Table 'wo_nf3_actions' is read only
I read somewhere that changing table storage engine might work but still I'm getting the same error. Any help would be really appreciated. Thanks in advance
besides Mario Giambanco the point of the local file permission with the wrong user. the database starts itself in read only if it crashed sometimes.
And you can check the global variables dev.mysql.com/doc/refman/5.7/en/replication-solut…
where it can be set to read only.
j
stuff ;)
Purvi Barot
Software Engineer
Before Importing date execute the below query to set identity insert on:
SET IDENTITY_INSERT TableName ONThen do the import operations. After importing date execute the below query to set identity insert off:
SET IDENTITY_INSERT TableName OFF