Support Forum
Support Forum
Offline
Hi I did a move to a new host and the db import seems to have been missing some ALTER TABLE statements.
Now it has been a day and I do not want to go back to an older backup if possible so I thought about doing the SQL Alter Table part from an older backup in PHPMyadmin SQL area but on many items I get errors like #1068 - Multiple primary key defined
Is there any way to do it?
Best regards
Bo
Offline
you can always adjust the keys from within phpmyadmin or other db tool...
but not much info here to provide more... what keys are missing? what keys are duplicate?
you can look in our db schema file to see what we set up.... simple-press/sp-startup/install/sp-schema.php
Visit Cruise Talk Central and Mr Papa's World
Offline
Careful now - that file is just for the changes that were consolidated in version 5.5.1 upgrade so I ma not sure what it may or may not tell you.
As Steve said - the bottom line is that you haven't really given us enough information to know what has happened yet alone what may or may not need fixing...
So can you provide some detail?
 |
YELLOW
SWORDFISH
|
All RSS1 Guest(s)