Moving Mysql Databases Between Computers

[Paul]

Hi all,

I'm just in the process of buying a new computer and am frightening myself with just how much stuff I have on my old one that I need to move over!

 

As far as transferring the MySql databases that I've created, both for Larry's tutorials and for work that I'm doing, is it as straightforward as just copying the contents of C:\xampp\mysql\data from one computer to another.

 

Thanks

Paul

[Larry]

In theory, you could do that, but I'd recommend opening phpMyAdmin on the existing computer and exporting the entire set of databases, except for the mysql database. Then install XAMPP on the new computer and use phpMyAdmin there to import them.

 

If you have too much data (like over a couple of megabytes), you can't important that in phpMyAdmin, in which case using the command line mysql_dump and mysql_import would be the way to go.