I have successfully exported my localhost database to import onto the live webserver. I noticed however that when i imported the database, the fields and tables were named different hence adding them to the table and not replacing as they should be.
i.e.
localhost: 'editablecheckbox' - collation 'latin1_swedish_ci'
host: 'EditableCheckbox' - collation 'utf8_general_ci'
How do I change the localhost database fields to match? I noticed that i could go into each field and change the collation and rename the label but there must be an easier way.
Any suggestions?
Thanks