Search code examples
mysqlimportphpmyadminmampdatabase-restore

importing mysql database using mamp, phpMyAdmin

I am trying to copy a MyIsam dataBase from my a remote server to my local machine for testing. I am using phpMyAdmin on the remote server. I select the database and then export. When I try to import (using mamp, phMyAdmin) I get the following error message Error SQL query:

CREATE TABLE IF NOT EXISTS `assignments` (
`uid` int( 11 ) default NULL ,
`rid` int( 11 ) default NULL ,
`semester` varchar( 255 ) default NULL ,
`year` int( 11 ) default NULL
) TYPE = MYISAM ;

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax
to use near 'TYPE=MyISAM' at line 6

Please Help!

Thanks

Solution

  • Try the trick proposed by Reza (Type=InnoDB) but I use MAMP on local machines and it can support either InnoDB/MyISAM… Which version of MAMP do you use ? (I use the free one)