Tables not showing on Database

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Tables not showing on Database

Postby pbcomput » 13. October 2013 04:21

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. :roll:

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
pbcomput
 
Posts: 4
Joined: 13. October 2013 03:58
Operating System: windows 7 & 8

Re: Tables not showing on Database

Postby JJ_Tagy » 13. October 2013 06:41

What version was old XAMPP and which version are you using now? You can't just copy folder with upgrade.
JJ_Tagy
 
Posts: 788
Joined: 30. January 2012 13:44
XAMPP version: 5.5.15
Operating System: Windows 10 Pro x64

Re: Tables not showing on Database

Postby pbcomput » 13. October 2013 07:19

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
pbcomput
 
Posts: 4
Joined: 13. October 2013 03:58
Operating System: windows 7 & 8

Re: Tables not showing on Database

Postby Altrea » 14. October 2013 04:43

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
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: Tables not showing on Database

Postby pbcomput » 14. October 2013 06:46

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.! :roll:

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
pbcomput
 
Posts: 4
Joined: 13. October 2013 03:58
Operating System: windows 7 & 8

Re: Tables not showing on Database

Postby Nobbie » 14. October 2013 11:34

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!
Nobbie
 
Posts: 13171
Joined: 09. March 2008 13:04

Re: Tables not showing on Database

Postby pbcomput » 15. October 2013 11:06

Hello Nobbie,

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

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. :roll: you can check my first post of this thread.

Anyway thanks again. :)

Regards,
Palak
pbcomput
 
Posts: 4
Joined: 13. October 2013 03:58
Operating System: windows 7 & 8


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 83 guests