transfer DB files from win to mac (external disk)

Problems with the Mac OS X version of XAMPP, questions, comments, and anything related.

transfer DB files from win to mac (external disk)

Postby manfromshadow » 26. September 2011 16:55

im new on Mac and i would like to transfer my previous databases on mac.

I set up XAMP to read PHP file from external disk, but now i need configure XAMP to read databases from extrnal source too.

default storage for XAMP mySQL db is:

Where i must change this path and what all to do?

Because if I just copy DB files from my old comp to XAMPP/xamppfiles/var/mysql/ I saw my DB in PHPmyAdmin, but i cannot work with that.

I would like to transfer DB and Permissions too.

Thanks for any help.
Posts: 1
Joined: 26. September 2011 16:50

Re: transfer DB files from win to mac (external disk)

Postby JonB » 27. September 2011 10:36

Use phpMyAdmin, the CLI mysqldump, or MySQL workbench to export the databases you wish to transfer. (that is the way you do this).

See my post for Mr. Alexander.

MySQL Workbench -

Then just import them into your new XAMMP install. In your case, you 'may' want to include the 'MySQL' database - it contains the metadata for Users and privileges. Be careful if you do so. I usually don't transfer the user data, preferring to set it up. If you DO decide to do this - Backup the new database FIRST - in case you trash things.

Then do yourself a favor and learn about MySQL backup methods.

Good Luck
User avatar
AF Moderator
Posts: 3210
Joined: 12. April 2010 16:41
Location: Land of the Blazing Sun
Operating System: Windows XP/7 - Fedora 15 1.7.7

Return to XAMPP for Mac OS X

Who is online

Users browsing this forum: No registered users and 8 guests