Wednesday, November 13, 2013

How to import DB Files from old XAMPP folder to new

I was updating my XAMPP htdocs folder on my 3rd computer at my office (I had to change because of defects and upgrades), when I realized that my old works was not in my current htdocs folder. I decided to copy the old files into my new folder and when I checked it on a browser I forgot that the DB files are not yet imported. I searched for automatic and manual methods, but then I found nothing(Or at least I thought, I usually eye the first 3-5 results on Google). And so, what I did was, I browsed every folder on XAMPP that would give me hints what to do.

Until I reached the 'mysql' (In terms of common sense you would go first with 'phpmyadmin' and 'mysql') then I found folders inside /xampp/mysql/data that are named as what my old DB's were.

I copied these specific folders pasted them into the same folder on the current xampp folder, then VoilĂ ! You can now check your phpMyAdmin and see your old DBs listed on the left sidebar.