Akeeba Backup for Joomla!

Tuesday, 07 June 2016 17:36 CDT

relsig

EXTREMELY IMPORTANT: Please attach a ZIP file containing your Akeeba Backup log file in order for us to help you with any backup or restoration issue. If the file is over 2Mb, please upload it on your server and post a link to it.

Description of my issue:

I'm accessing a database table from Event Booking with Fabrikar. Unfortunately this breaks the table and therefore the component quits working. This brought up the idea to create a daily temporary table automatically and accessing the copy instead the original table.
Is there a possibility to do this with Akeeba backup? The table can be overwritten daily, I just need it for read access.

Thanks

Roger

Wednesday, 08 June 2016 02:36 CDT

nicholas

You are trying to solve the wrong problem. What you need to do is run repair and optimize against this table frequently – for example, every half an hour. You can use the command line mysql client command and your host's CRON job system to automate that.

FWIW what you had in mind had a few holes in its planning. Let's say that you are making a copy of the table. Any new data inserted in the table would be lost as soon as you restore it. Moreover, you cannot make a copy of the table under a different name. Furthermore you cannot copy the table if it's already broken. So unless you were constantly taking a backup of the table (which is really bad for your server!) you couldn't guarantee a semi-consistent backup copy of that table. Then again, you'd need to write some software to detect when the table is broken, delete it and restore it from the backup. Suddenly this sounds like a Rube Goldberg contraption instead of a solution to the simple problem of MyISAM tables becoming corrupt on frequent access. Think simple.

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!

Thursday, 09 June 2016 11:03 CDT

relsig

Thanks for your answer.
I actually wanted to restore the table under a new name and then access it with Fabrikar instead of the original table. If there is a new entry between two restores, this doesn't matter. Updating it once a day would be enough.

But I guess the main problem is that I can't restore it under a new name, so I guess I have to find another solution.

Thanks.

Support