So far I used MySql 5.1 for Windows and if I wanted to migrate the whole database to another computer I did this:
- installed a MySql 5.1 on the new computer (yes I know I can install from command line too)
- Stopped the server
- copied the old ibdata1 file and all the database folders from the old computer the the new one (data folder)
- Restarted the server and everything was fine
Today I installed 5.5 and I wanted to migrate the old 5.1 data and I wanted to repeat the whole process and to my greatest surprise there wasn't ibdata1 nor the log files in the data folder.
What can I do then? I have about 150 databases (it's a developer machine) so I don't want to export the Sql-s one by one.