hey all! This question could very easily belong in newbies, but I figured I'd change up my usual posting practice🙂.
I'm running ubuntu and I'd like to move my Mysql database over to a windows machine. I would very much appreciate any advice and / or suggestions.
I would use the EXPORT and IMPORT functions in phpMyAdmin. You can export one file copy of one or several databases. Then on your other machine you can import such file. You should have MySQL and phpMyAdmin on both machines.
Here is one tutorial: Export-Import MySQL data via phpMyAdmin http://joomla.ausweb.com.au/content/view/22/64/
If it's a large database, it's actually recommended to use a utility such as mysqldump for transporting databases from one place to another.
That way you avoid the overhead and possible timeouts involved with using a webserver, PHP script, etc.
I use navicat for this kind of thing (although it's not free to buy). Can log into both servers and transfer the tables directly from one to the other in real time, no dumping needed
