BACKING UP MySQL

2 posts / 0 new
Last post
#1 Wed, 08/14/2013 - 20:19
lisandi

BACKING UP MySQL

Your Backup gets written with the keyword TYPE

unfortunately this got removed in MySQL 5.1 and now you would need to use ENGINE. Therfore no MySQL Backup can be imported from another virtualmin DB Server

The keyword TYPE is removed since MySQL 5.1, use

) ENGINE = MYISAM AUTO_INCREMENT =58; instead.

Wed, 08/14/2013 - 23:10
andreychek

Howdy,

After talking to Jamie, he didn't think that would be a problem... he mentions that the use of the TYPE keyword is determined by the mysqldump command. He says that perhaps if you backed up from a system with a really old version of MySQL, it might not be restorable on a very new version.

Are you seeing an error restoring a backup though? If so, I can pass along some details to him so he can look info that further.

-Eric

Topic locked