Can I get my Database back?

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

Can I get my Database back?

Postby eddie-edwards » 11. July 2020 10:03

Hi there,

I hope someone can please help me.

I've had Xampp running on my desktop computer happily for a couple of years. However, last week my desktop tower went and killed by hardrive before it then dies on me totally. I have back-ups of everything just in case this sort of this happens.

I have a laptop running Windows 10 and so I wanted to move my Xampp onto that. I have dragged the entire Xampp folder that contains everything from the version running on my recently deceased desktop machine. However, I cannot seem to find the data for the databases.

As I have every file that was on my desktop pc now sitting on my laptop, I assumed that all data for the databases would also have been copied over.

So my questions are:

1. As I just dragged a back-up folder of Xampp onto my laptop, it is not installed, just sitting there. How can I install this properly?
2. Do I still have my database content somewhere within these files and folders, or does Xampp store this information somewhere else on the machine other than the Xampp folder? I hope not as I had 2 years worth of data on there
3. If my data is somewhere within the Xampp folder, can someone please tell me how to access it?

I'm very grateful for any answers anyone can give me.
eddie-edwards
 
Posts: 5
Joined: 11. July 2020 09:55
XAMPP version: 3.2.4
Operating System: Windows 10

Re: Can I get my Database back?

Postby Altrea » 11. July 2020 15:16

Hi,

eddie-edwards wrote:1. As I just dragged a back-up folder of Xampp onto my laptop, it is not installed, just sitting there. How can I install this properly?

If you don't need an Uninstaller, it is fairly easy.
Just execute the setup_xampp.bat script to adjust all paths and you are good to go.

eddie-edwards wrote:2. Do I still have my database content somewhere within these files and folders, or does Xampp store this information somewhere else on the machine other than the Xampp folder? I hope not as I had 2 years worth of data on there

By default all databases are stored in the folder /xampp/mysql/data/ but with InnoDB as default storage engine it is not that easy to separate databases from each others because the ibdata1 file takes a centralizes role for all databases.

eddie-edwards wrote:3. If my data is somewhere within the Xampp folder, can someone please tell me how to access it?

The easiest way would be to start Apache and Mariadb in the xampp control panel and use phpmyadmin to access the database.

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: Can I get my Database back?

Postby eddie-edwards » 11. July 2020 18:19

Thanks very much for your comments :)
I tried to run the setup_xampp.bat file, as administrator, but I got the following error below.

I went back and installed the Microsoft program, restarted and tried again, but I'm still getting the same error?

################################# START XAMPP TEST SECTION #################################
[XAMPP]: Test php.exe with php\php.exe -n -d output_buffering=0 --version ...
The system cannot find the path specified.

[ERROR]: Test php.exe failed !!!
[ERROR]: Perhaps the Microsoft C++ 2008 runtime package is not installed.
[ERROR]: Please try to install the MS VC++ 2008 Redistributable Package from the Mircrosoft page first
[ERROR]: http://www.microsoft.com/en-us/download/details.aspx?id=5582

################################# END XAMPP TEST SECTION ###################################

Press any key to continue . . .
----------------------
eddie-edwards
 
Posts: 5
Joined: 11. July 2020 09:55
XAMPP version: 3.2.4
Operating System: Windows 10

Re: Can I get my Database back?

Postby Altrea » 11. July 2020 20:59

You need to run the setup_xampp.bat file as user not as administrator.
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: Can I get my Database back?

Postby eddie-edwards » 12. July 2020 20:38

Thanks so much for all your help.

I have everything back up and running now :D

However, if I click on the 'Admin' button for the MySQL whilst inside the Xampp Control panel (run both as administrator and without), I get the following error show up in the browser:

-----------------------------------
Access forbidden!

You don't have permission to access the requested directory. There is either no index document or the directory is read-protected.

If you think this is a server error, please contact the webmaster.
Error 403
------------------------------------

I've gone into the MySQL main folder and made sure that it wasn't read-only. I also made sure all the sub folders were also not read-only.

I'm so close to sorting this out, I'd be very grateful if you coudl please help me once more.
eddie-edwards
 
Posts: 5
Joined: 11. July 2020 09:55
XAMPP version: 3.2.4
Operating System: Windows 10

Re: Can I get my Database back?

Postby Altrea » 13. July 2020 01:30

Which url is written in your browsers address bar at the time the error occurs?
What is the contents of your Apache access.log file?
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: Can I get my Database back?

Postby eddie-edwards » 14. July 2020 20:28

Hi Again,

The URL in the address bar is:

http://localhost/phpmyadmin/

The Apache log file for today, when I just tried it again shows:

192.168.1.2 - - [14/Jul/2020:07:40:41 +0100] "GET / HTTP/1.1" 302 - "-" "avast! Antivirus"
192.168.1.2 - - [14/Jul/2020:07:40:41 +0100] "GET /dashboard/ HTTP/1.1" 200 7577 "-" "avast! Antivirus"
192.168.1.2 - - [14/Jul/2020:07:40:42 +0100] "GET / HTTP/1.1" 302 -
192.168.1.2 - - [14/Jul/2020:07:40:42 +0100] "GET /dashboard/ HTTP/1.1" 200 7577
192.168.1.2 - - [14/Jul/2020:07:40:48 +0100] "GET /HNAP1/ HTTP/1.1" 404 1056 "-" "avast! Antivirus"
::1 - - [14/Jul/2020:20:26:08 +0100] "GET /phpmyadmin/ HTTP/1.1" 403 1056 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:78.0) Gecko/20100101 Firefox/78.0"
::1 - - [14/Jul/2020:20:26:10 +0100] "GET /favicon.ico HTTP/1.1" 200 30894 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:78.0) Gecko/20100101 Firefox/78.0"


What is odd is that it talks about Avast Antivirus, but I don't have that on my machine? - I have AVG free.
eddie-edwards
 
Posts: 5
Joined: 11. July 2020 09:55
XAMPP version: 3.2.4
Operating System: Windows 10

Re: Can I get my Database back?

Postby Nobbie » 14. July 2020 21:10

Enter "GET /HNAP1/" into Google and get worried.... you have a big problem with you router. Xampp Forum cannot help you on that issue.
Nobbie
 
Posts: 13170
Joined: 09. March 2008 13:04

Re: Can I get my Database back?

Postby eddie-edwards » 15. July 2020 12:38

It's not bad in this case.

Avast has gone in and tested the ports, Avast tests everything.

I think this is cropping up due to the fact that I copied all the files from my desktop machine into my laptop. The desktop had Avast running on it, but this laptop doesn't.

I found out the problem. When I copied the files over, the phpMyAdmin folder did not copy across.

I have added that now and I can get in.
eddie-edwards
 
Posts: 5
Joined: 11. July 2020 09:55
XAMPP version: 3.2.4
Operating System: Windows 10


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 110 guests