How to transfer my MySQL database to another computer?

php mysql xampp dbmigrate
dannail picture dannail · Mar 25, 2012 · Viewed 57.7k times · Source

I am using XAMPP package in my own desktop with Window 7 as OS.
That means I'm using MySQL DB and Apache server.

Now I would like to copy/migrate my whole MySQL DB to my friend's desktop, which is also with Window as OS, and also using XAMPP package.

Is there any way for me to do that?

Answer

A.Aleem11 picture A.Aleem11 · Dec 29, 2016

Copy database files from MySQL folder (under old xampp folder) except share,bin, and script folder see attached image to see which files need copy (only files with in green box) and replace all these database files in new installed xampp directory in MySQL folder.

Restart xampp start MySQL and open database and table to make sure its working.

Files to replace in green lines

Related questions

Fatal error: Uncaught Error: Call to undefined function mysql_connect()

I am trying to do a simple connection with XAMPP and MySQL server, but whenever I try to enter data or connect to the database, I get this error. Fatal error: Uncaught Error: Call to undefined function mysql_connect() in …

Read More
Maximum execution time in phpMyadmin

When I try to execute (some) queries in phpMyadmin I get this error Fatal error: Maximum execution time of 60 seconds exceeded in C:\xampp\phpmyadmin\libraries\dbi\mysql.dbi.lib.php on line 140 because I have a very large table (…

Read More
MySQL Database won't start in XAMPP Manager-osx

I downloaded XAMPP about a month ago and it was working just fine. Today I installed a voice recognition software and then restarted my computer. Ever since, MySQL won't start in my manager-osx application. It doesn't throw me an in …

Read More