17487 Posts in 4473 Topics by 1978 members
|Go to End|
15 October 2008 at 11:07pm Last edited: 15 October 2008 11:15pm
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.
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.
15 October 2008 at 11:25pm
Just saw this link: http://www.silverstripe.co.nz/site-builders-forum/reply/115620
But i think that's too late for me. Will i have to change all the tables manually? please no!
15 October 2008 at 11:27pm Last edited: 15 October 2008 11:30pm
Try exporting a structure of a correct table in SQL and importing it onto your one.
16 October 2008 at 12:31am
Sorry... I'm not sure what you mean.
|Go to Top|