MySQL Forums
Forum List  »  Data Recovery

Database Import Failure
Posted by: Chris Yuen
Date: November 25, 2008 11:25AM

I would like to backup the application database for a photo album (using coppermine v1.4.18) under FreeBSD and then restore the database to a new photo album (using coppermine v1.4.19) under Windows Server 2003 environment.

I can backup the database but fail to restore to the Windows Server 2003 using phpMyAdmin.

It shows me the syntax error.

The database structures for them are quite similar except for the followings:
(1) ENGINE=MyISAM AUTO_INCREMENT=256 DEFAULT CHARSET=latin1 COMMENT='XXX'; (from coppermine v1.4.18 under FreeBSD)
(2) TYPE=MyISAM COMMENT='XXX' (from coppermine v1.4.19 under Windows Server 2003).

Is it possible to replace all "ENGINE=MyISAM AUTO_INCREMENT=256 DEFAULT CHARSET=latin1" to "TYPE=MyISAM" so that I can import the database successfully without any data loss?

Thank you very much!

Options: ReplyQuote

Written By
Database Import Failure
November 25, 2008 11:25AM
November 29, 2008 06:06AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.