Apache Friends Support Forum

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 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?

Same here. Curious that this reasonable and important question has not been answered.

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

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

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.

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)

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 ?

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'.