This website is deprecated, and remains online only for historic access to old issues and docs for historic versions of Virtualmin. It has been unmaintained for several years, and should not be relied on for up-to-date information. Please visit www.virtualmin.com instead.

BACKING UP MySQL

2 posts / 0 new

Topic locked

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.

#2 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