User65 Posted January 30, 2015 Posted January 30, 2015 Hello, I am a complete newby... and trying importing ***.sql into the database (phpMyAdmin)After selecting “go” i receive the below error: ErrorSQL query:CREATETABLE`gcm_messages` (`id` int( 11)NOTNULLAUTO_INCREMENT ,`gcm_regid` text NOTNULL ,`message` text NOTNULL ,`data` int( 11)NOTNULL DEFAULT'0',`created_at` timestamp NOTNULLDEFAULT CURRENT_TIMESTAMP ,PRIMARYKEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=77 DEFAULT CHARSET= latin1;MySQL said: #1005 - Can't create table '***_***db.gcm_messages' (errno: -1) (Details...) I did the same on my local PC and worked without any error. Can someone point me to the right direction? Thanks a lot!
wolstech Posted January 30, 2015 Posted January 30, 2015 ENGINE=InnoDB Change the engine to MyISAM and it'll work. We do not support InnoDB due to server damage last year.
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now