Advanced Search

Return to Snippet

Revision: 10815
at January 14, 2009 13:42 by rowntreerob
Initial Code 
mysql -u root snappsv2tst -e "show table status \G;"  | grep 'Name:' | sed 's/^\(.*\)/ALTER TABLE \1/' snappsv2_engine_alter.sql | sed 's/$/ ENGINE=INNODB;/' > snappsv2_engine_alter.sql

mysql -u root dbname < snappsv2_engine_alter.sql
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
convert mysql engine to innodb

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
mysql

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
Bash