Support

Akeeba Backup for Joomla!

#8987 AEDumpNative :: Table #__ This would cause restoration errors

Posted in ‘Akeeba Backup 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
Akeeba Backup version
n/a

Latest post by nicholas on Tuesday, 09 August 2011 08:13 CDT

user43828
Mandatory information about my setup:

Have I read the related troubleshooter articles above before posting (which pages?)? No
Have I searched the forum before posting? No
Have I read the documentation before posting (which pages?)? No
Joomla! version: (1.5.23)
PHP version: (5.2.17)
MySQL version: (5.0.51a)
Host: (Dreamhost VPS)
Akeeba Backup version: (3.3.2)

EXTREMELY IMPORTANT: Please attach your Akeeba Backup log file in order for us to help you with any backup or restoration issue.

Description of my issue:
Upon doing a backup I'm receiving a lot of AEDumpNative error warnings, I really need these database tables and was wondering if there were a way to back them up.

Example [110806 12:25:10] AEDumpNative :: Table akb_ak_profiles has a prefix of #__. This would cause restoration errors; table skipped.
[110806 12:25:10] AEDumpNative :: Table akb_ak_stats has a prefix of #__. This would cause restoration errors; table skipped.
[110806 12:25:10] AEDumpNative :: Table akb_banner has a prefix of #__. This would cause restoration errors; table skipped.
[110806 12:25:10] AEDumpNative :: Table akb_bannerclient has a prefix of #__. This would cause restoration errors; table skipped.
[110806 12:25:10] AEDumpNative :: Table akb_bannertrack has a prefix of #__. This would cause restoration errors; table skipped.
[110806 12:25:10] AEDumpNative :: Table akb_categories has a prefix of #__. This would cause restoration errors; table skipped.
[110806 12:25:10] AEDumpNative :: Table akb_components has a prefix of #__. This would cause restoration errors; table skipped.
[110806 12:25:10] AEDumpNative :: Table akb_contact_details has a prefix of #__. This would cause restoration errors; table skipped.
[110806 12:25:10] AEDumpNative :: Table akb_content has a prefix of #__. This would cause restoration errors; table skipped.

Any help would be great and thanks for providing a great product.

nicholas
Akeeba Staff
Manager
Hi!

Please take a look at your database. You have a bunch of tables whose name begins with hash-underscore-underscore (#__). This should never happen with a Joomla! site, as this three character combination is magical to Joomla! and automatically gets replaces with the current database table naming prefix.

In order to tell you what you need to do next, I need to see the entire backup log file. It will give me information about your database layout which will help me give you an accurate list of actions to follow. Can you please ZIP the log file and attach it to your next post? Thank you in advance!

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!

user43828
Thanks for taking a look at this, the only thing that I can say maybe the culprit of this abnormal naming of the tables would be a app we use for uploading products into VirtueMart. The component is called CSVI VirtueMart and during the last update it made some DB changes. Before this was done Akeeba was running fine as we just moved the site to a new server with the existing Akeeba free version and it worked fine.

I was prompted to go pro when I noticed the DB tables were not getting backed up..

Thanks for looking into this and let me know what you think would be the best process/adjustment going forward to ensure all db tables are getting backed up.

Wade

nicholas
Akeeba Staff
Manager
Most likely you used a very old, buggy version of Akeeba Backup to restore your site, or you restored it manually without following our instructions for editing the SQL files. In any case, you will have to do some manual work.

First, take your site off-line. The following procedure will take 10-30 minutes and your site will be unusable until you are done.

1. Using phpMyAdmin, rename all your tables, one by one. Replace the #__ prefix with jos. For example, #__users must be renamed to jos_users.

2. Edit your configuration.php file, found in your site's root. Find a line which looks like this:
var $dbprefix = '#__';
and change it to read:
var $dbprefix = 'jos_';


You should now be able to go back to your site's back-end, set it back to on-line status and take a full backup.

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!