I am trying to move all the stuff including silverstripe and mysql data from Linux to Windows. What are the right steps to do this? These are what I did:
1. Copy all the files within mysite directory to the counterpart in Windows box.
2. Reinstall Silverstripe there
3. Export and import Mysql data
However, all the pages under Silverstripe CMS in Windows box lost the customized PageType, going back to the default one "Page".
I think step 2 is not neccessary. If you did so, make sure you export all the data from the database on linux and tell mysql you want to overwrite all data in the new database when you import the data into the new database on windows.
It would be easier if in step you create a new database only and then in step 3 you just export and import all the data into the new database.
No..... not working..... it complains I am browsing pages that are not found.
I think somehow Silvertripes gets to talk with Mysql in a normal way, direct copy of it from Linux to Windows won't make the correct linkage..
Linux vs Win MySQL is the issue probably. Linux is case sensitive for tables and windows is not (or the other way round?!?). I dont know if theres a easy way to get round this when exporting / importing the database as Ive never had to do it but a couple people have done it by hand :P
I can vouch for what willr says, . On *nix, MySQL tables can contain uppercase/lowercase, while on windows only lowercase. The only way that i know to migrate between these is to open up your SQL dump and manually edit all the tablenames to lowercase. Then you can import this into your windows MySQL DB, and it should all work fine.