17488 Posts in 4473 Topics by 1978 members
|
Page:
1
|
Go to End | |
| Author | Topic: | 1183 Views |
-
Variations in localhost and host databases
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.
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
-
Re: Variations in localhost and host databases
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!
-
Re: Variations in localhost and host databases
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.
-
Re: Variations in localhost and host databases
16 October 2008 at 12:31am
Hi Piklets,
Sorry... I'm not sure what you mean.
| 1183 Views | ||
|
Page:
1
|
Go to Top |
