sorry for resurrecting an old thread but ant to drop some updates that drove me nuts, the solution was a lot of typing so pasting here.
-
if exporting dump from windows i have to convert to unix eol. open in notepad++ edit> EOL > convert unix
-
rename all the tables. here is sql you can import or copy paste
-- convert from windows mysql db to unix, change the damn table case
-- ALTER TABLE exampletable RENAME TO new_table_name;
-- change db name **************
USE of_pooters;
ALTER TABLE ofbookmark RENAME TO ofBookMark;
ALTER TABLE ofbookmarkperm RENAME TO ofBookMarkPerm;
ALTER TABLE ofbookmarkprop RENAME TO ofBookMarkProp;
ALTER TABLE ofconparticipant RENAME TO ofConparticipant;
ALTER TABLE ofconversion RENAME TO ofConversion;
ALTER TABLE ofextcomponentconf RENAME TO ofExtComponentConf;
ALTER TABLE ofgroup RENAME TO ofGroup;
ALTER TABLE ofgroupprop RENAME TO ofGroupProp;
ALTER TABLE ofgroupuser RENAME TO ofGroupUser;
ALTER TABLE ofid RENAME TO ofID;
ALTER TABLE ofmessagearchive RENAME TO ofMessageArchive;
ALTER TABLE ofmucaffiliation RENAME TO ofMucAffiliation;
ALTER TABLE ofmucconversionlog RENAME TO ofMucConversionLog;
ALTER TABLE ofmucmember RENAME TO ofMucMember;
ALTER TABLE ofmucroom RENAME TO ofMucRoom;
ALTER TABLE ofmucroomprop RENAME TO ofMucRoomProp;
ALTER TABLE ofmucservice RENAME TO ofMucService;
ALTER TABLE ofmucserviceprop RENAME TO ofMucServiceProp;
ALTER TABLE ofoffline RENAME TO ofOffline;
ALTER TABLE ofpfrules RENAME TO ofpfrules;
ALTER TABLE ofpresence RENAME TO ofPresence;
ALTER TABLE ofprivacylist RENAME TO ofPrivacyList;
ALTER TABLE ofprivate RENAME TO ofPrivate;
ALTER TABLE ofproperty RENAME TO ofProperty;
ALTER TABLE ofpubsubaffiliation RENAME TO ofPubsubAffiiation;
ALTER TABLE ofpubsubdefaultconf RENAME TO ofPubsubDefaultConf;
ALTER TABLE ofpubsubitem RENAME TO ofPubsubItem;
ALTER TABLE ofpubsubnode RENAME TO ofPubsubNode;
ALTER TABLE ofpubsubnodegroups RENAME TO ofPubsubNodeGroups;
ALTER TABLE ofpubsubnodejids RENAME TO ofPubsubNodeJIDs;
ALTER TABLE ofpubsubsubscription RENAME TO ofPubsubSubscription;
ALTER TABLE ofremoteserverconf RENAME TO ofRemoteServerConf;
ALTER TABLE ofroster RENAME TO ofRoster;
ALTER TABLE ofrostergroups RENAME TO ofRosterGroups;
ALTER TABLE ofrrds RENAME TO ofrrds;
ALTER TABLE ofsaslauthorized RENAME TO ofSASLAuthorized;
ALTER TABLE ofsecurityauditlog RENAME TO ofSecurityAuditLog;
ALTER TABLE ofuser RENAME TO ofUser;
ALTER TABLE ofuserfag RENAME TO ofUserFlag;
ALTER TABLE ofuserprop RENAME TO ofUserProp;
ALTER TABLE ofvcard RENAME TO ofVCard;
ALTER TABLE ofversion RENAME TO ofVersion;