History Download

MyISAM to InnoDB and latin1 to utf8

Switch from MyISAM to InnoDB and from latin1 to utf8 easy and painlessly.

by humancoder 2 years, 4 months ago and tagged with: bash mysql sed

        
                    #!/bin/bash
mysqldump [database]|sed 's/ENGINE=MyISAM/ENGINE=InnoDB/g'|sed 's/CHARSET=latin1/CHARSET=utf8/g'|mysql [database]

Change style:

Currently 0 comments

To post a comment, you must login.