Backup error

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

Backup error

Postby oheurtel » 18. February 2011 12:03

With version 1.7.4, I have an error when I try to backup XAMPP :
Code: Select all
# /opt/lampp/lampp backup
Backing up databases...
performance_schema: FAILED

As a workaround, you can edit the file /opt/lampp/share/lampp/backup and modify the test line 39 :
Before :
Code: Select all
if test "$i" = "Database" -o "$i" = "information_schema"

After :
Code: Select all
if test "$i" = "Database" -o "$i" = "information_schema" -o "$i" = "performance_schema"
oheurtel
 
Posts: 2
Joined: 16. February 2011 16:10

Re: Backup error

Postby Brallion » 26. May 2011 12:09

I had the same problem. I applied this fix and it seems to have worked. My question- Could there potentially still be a problem with my backup; Is this just masking the error? Or does this solve the problem entirely?
Brallion
 
Posts: 2
Joined: 26. May 2011 12:06

Re: Backup error

Postby jdwilsonjr » 04. August 2011 18:34

Same here. Curious that this reasonable and important question has not been answered.
jdwilsonjr
 
Posts: 1
Joined: 04. August 2011 18:29

Re: Backup error

Postby JonB » 08. August 2011 18:24

Could there potentially still be a problem with my backup; Is this just masking the error? Or does this solve the problem entirely?



the ServerGeek is looking into it, no guarantees

:shock:
User avatar
JonB
AF Moderator
 
Posts: 3210
Joined: 12. April 2010 16:41
Location: Land of the Blazing Sun
XAMPP Version: 1.8.3-2
Operating System: Windows XP/7 - Fedora 15 1.7.7

Re: Backup error

Postby JonB » 08. August 2011 19:06

Preliminary report:

A. The 'workaround' appears to be a valid solution, all we/they are trying to do is NOT backup the MySQL 'state' data, which is not relevant when restoring user databases and their tables. Explanation: the MySQL database construct will not be in the same state at some future date when you may want to restore the data (in fact you could whack the specific MySQL install permanently). The reason for the 'needed fix' is that the script was written before performance_schema became a default table.

B. Once I have made an adequate alternative backup of my 'real development data' on this LAMPP box, I'll contrive an experiment to test if the restore works. Unfortunately, the backup data is stored in a binary object whose structure is intended to be executed (as opposed to being read). SO it appears 'only the brave survive'.

C. Learning Webmin, rsync and/or the MySQL CLI (command line interface) resolves EVERY ONE of these concerns

Good Luck to all
8)
User avatar
JonB
AF Moderator
 
Posts: 3210
Joined: 12. April 2010 16:41
Location: Land of the Blazing Sun
XAMPP Version: 1.8.3-2
Operating System: Windows XP/7 - Fedora 15 1.7.7

Re: Backup error

Postby simo-lampp » 02. April 2012 08:53

oheurtel wrote:With version 1.7.4, I have an error when I try to backup XAMPP :
Code: Select all
# /opt/lampp/lampp backup
Backing up databases...
performance_schema: FAILED

As a workaround, you can edit the file /opt/lampp/share/lampp/backup and modify the test line 39 :
Before :
Code: Select all
if test "$i" = "Database" -o "$i" = "information_schema"

After :
Code: Select all
if test "$i" = "Database" -o "$i" = "information_schema" -o "$i" = "performance_schema"


I tried this with even 1.7.3 and it worked fine.
This version actually had only
Code: Select all
if test "$i" = "Database" -o

Seems to be the best fit.
simo-lampp
 
Posts: 2
Joined: 29. March 2012 13:22
XAMPP Version: 5.6.3
Operating System: XP, 7, Ubuntu, Fedora

Re: Backup error

Postby JonB » 17. June 2012 22:00

After just building a new 'VirtualBox' home for one of my development projects, I ran right back into this moving things (as I wanted to use minimal non-XAMPP steps. LOL - I had completely forgotten about the issue.

I used the line 39 fix (above) , and got a good backup of the original install.

I was moving a 1.7.4 XAMMP on Fedora 14/Gnome 'real server' to a VirtualBox on Win7 guest instance of Fedora 16/LXDE.

(and trying to write a guide about it)

:mrgreen:
User avatar
JonB
AF Moderator
 
Posts: 3210
Joined: 12. April 2010 16:41
Location: Land of the Blazing Sun
XAMPP Version: 1.8.3-2
Operating System: Windows XP/7 - Fedora 15 1.7.7

Re: Backup error

Postby kimmy » 30. September 2012 01:01

Noob question but whats included in the back up ?

Do all the files in xampp get copied and placed into another folder or does just some of xampp get backed up into another folder ?
kimmy
 
Posts: 15
Joined: 21. September 2012 17:50
XAMPP Version: 5.6.3
Operating System: unity 64bit

Re: Backup error

Postby JonB » 01. October 2012 16:35

the 'right' answer is to look at this file:

/opt/lampp/share/lampp/backup

the 'basic' answer is it backs up htdocs, your settings and your logfiles (as I recall)

then places the output contained in a bash shell file (.sh) in /opt/lampp/backup

The answer to every question, always is 'go find out'. :wink:

8)
User avatar
JonB
AF Moderator
 
Posts: 3210
Joined: 12. April 2010 16:41
Location: Land of the Blazing Sun
XAMPP Version: 1.8.3-2
Operating System: Windows XP/7 - Fedora 15 1.7.7


Return to XAMPP for Linux

Who is online

Users browsing this forum: No registered users and 7 guests