Support

Admin Tools

#13641 PHP File Change Scanner table not loading on DB restore

Posted in ‘Admin Tools for Joomla! 4 & 5’
This is a public ticket

Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.

Environment Information

Joomla! version
n/a
PHP version
n/a
Admin Tools version
n/a

Latest post by nicholas on Tuesday, 25 September 2012 14:14 CDT

user39895
Mandatory information about my setup:

Have I read the related troubleshooter articles above before posting (which pages?)? Yes
Have I searched the tickets before posting? Yes
Have I read the documentation before posting (which pages?)? Yes
Joomla! version: 2.5.7
PHP version: 5.2
MySQL version: 5.5
Host: godaddy
Admin Tools version: 2.3.2

Description of my issue:
I recently had to move my site from one server to another. Upon trying to restore a backup of the database, the standard control panel was telling me the restore failed. I then copied all test from the .sql file and when into the phpMyAdmin program. I pasted it in as an sql statement and ran it. The failure was happening in the admintools_filescache table.

Any idea as to why this could happen?
What can I do to avoid it in the future?

Thank you,
Ryan

nicholas
Akeeba Staff
Manager
Hello Ryan,

What is the exact SQL error you are receiving?

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

user39895
Unfortunately, not a lot of information here:

-------------------------
SQL query:

/*!40000 ALTER TABLE `xxxxx_admintools_filescache` DISABLE KEYS */;

MySQL said: Documentation
#2006 - MySQL server has gone away

-----------------------

nicholas
Akeeba Staff
Manager
Please ask your host to increase MySQL's wait_timeout in my.cnf and restart the MySQL server. They are shutting down the MySQL connections WAY too fast for the server to be usable when backing up or restoring your database. Please note that the table where the error occurred is completely irrelevant. It simply happens after "a while". This "while" is the wait_timeout in MySQL server's my.cnf configuration file and that's why I suggest that it should be increased.

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

user39895
Good thinking! I remember having to do the same thing on a WAMP setup at home. Sorry to bother you with this, and I appreciate your suggestion.

nicholas
Akeeba Staff
Manager
You're welcome, Ryan!

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Support Information

Working hours: We are open Monday to Friday, 9am to 7pm Cyprus timezone (EET / EEST). Support is provided by the same developers writing the software, all of which live in Europe. You can still file tickets outside of our working hours, but we cannot respond to them until we're back at the office.

Support policy: We would like to kindly inform you that when using our support you have already agreed to the Support Policy which is part of our Terms of Service. Thank you for your understanding and for helping us help you!