Migrate a schema structure from one server to another MySQL
If You already use MySQL Workbench, You can use menu:
Database -> Synchronise with any Source

Before apply changes it show You script, which You can copy and if need edit
You can test it on copy of databases

Also there are many other tools:


Navicat
SQLyog
dbSchema
and etc


example of script:

ALTER TABLE `test_db`.`company1_name` 
ADD FULLTEXT INDEX `Company1_name` (`Company1_name` ASC)