Apache Friends Support Forum

Hi,

I had a xampp on my local drive of pc, before some days, for some reasons I have to format my whole pc. I backup my xampp folder to my external drive. Then I install portable xampp on my external drive.

Then I copy all folders from htdocs to take my projects on new xampp. Then I copy whole data folder of mysql folder to new mysql data folder. After I start my xampp and go to phpmyadmin, what I am seeing is I got all databases but some of databases missing all tables and some of databases have 1 or 2 tables, I didn't got all tables into none of database.

I also tried to copy one by one folder from old data table to new data folder but not worked. I also tried to first make the database on new xampp then copy only files of particular database folder to new database folder but that not worked too.

Please help me to recover my all tables of all databases. Its urgent, I am running out of time for deadline of my project.

Thanks for the help.

Regards,
Palak

What version was old XAMPP and which version are you using now? You can't just copy folder with upgrade.

Hi JJ,

Thanks for your reply.

My old xampp version was XAMPP Version: 1.8.1 Control Panel Version: 3.1.0 and new portable xampp version is XAMPP Version: 1.8.1 Control Panel Version: 3.1.0 Beta 4

Please note that, previously I was using xampp with normal installation on windows 7 and the new xampp is portable version of xampp which I installed on my external HDD.

Thanks,
Palak

Hi Palak,

You have an backup of your entire XAMPP folder, so just get this started again and export your needed databases with mysqldump.
A copy over of the mysql data folders can work but don't have to. That is not the clean way to move a database from one DBMS to another one.

Best wishes,
Altrea

Hello Altrea,

Yes I have whole xampp folder, I tried that before to start xampp control panel from there, when I start xampp control it gives me below warning.

Code: Select all

WARNING: Your install directory contains spaces.  This may break programs/scripts

Then also I tried to start Apache and MySQL, it starts but when I go to my http://localhost/phpmyadmin it only show me some of databases about 30% of database rest of databases are missing over there. I don't know how to recover all databases.!

I am totally aware about the method of sql dump to backup database, but when I took backup I was in hurry and don't have much time to export one by one db from my my 55dbs.

Please help me to recover my all dbs.

Thanks for your help.
Palak

1) Shut down all instances of Apache and MySQL (if there are running any processes)

2) Proceed to the NEW installed Xampp folder, proceed to the mysql folder and rename the data folder to data-original (or similar)

3) Proceed to the BACKUP Xampp folder, proceed to thy mysql folder and copy the whole data folder from this BACKUP to the NEW Xampp folder (what results in replacing the original data folder by the backuped folder). DO NOT CUT&PASTE THE DATA FOLDER, COPY&PASTE IT!! Because this is your only valid backup.

4) Start the NEW Xampp installation and open http://localhost/phpmyadmin - it *should* show the old content of your backuped Xampp installation. If phpmyadmin fails to open, it might by necessary to copy&paste the configuration file config.inc.php from the backuped Xampp/Phpmyadmin folder to the new one (and reload http://localhost/phpmyadmin).

P.S.:

pbcomput wrote:I backup my xampp folder to my external drive. Then I install portable xampp on my external drive.

If you installed the portable Xampp Version into the same folder as your backup, you probably destroyed your backup. Hopefully you choose different targets!

Hello Nobbie,

You are a life saver..! My problem has been solved..!

I got all my dbs back on phpmyadmin. I took sql dump of that. So I can import it to my new phpmyadmin.

But I don't know why it not worked before when I did the same thing. you can check my first post of this thread.

Anyway thanks again.

Regards,
Palak