Support

Admin Tools

#23839 SQL import does not work

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 on Sunday, 03 January 2016 17:20 CST

ClientFW2015login
 Hi!

i have installed Admin Tools, enabled the firewall and created the htaccess-files with the built-in htaccess-maker.
Then i made a ftp and a database backup.

I tryed to import the .sql-Backupfile in a local XAMPP-testdatabase and get the error in the attachment:
("atools-sqlimport")
#1050 - Table 'bplrd_admintools_acl' already exists

when i try to import an old sql-dump, which was created before the installation of admin-tools-pro, there are no problems with the import.

when i take a look at the cuurent-my-sql-settings at my website, i can see only 1 table which is called 'bplrd_admintools_acl' (see attachment: "atools-sql-table")

can you help me with this issue?

thank you and best regards from austria,
andreas

tampe125
Akeeba Staff
Hello Andreas,

the problem is not related to Admin Tools, but to the backup process.
In the database dump, you are not checking if the table already exists, hence the error.
I'd strongly suggest you to use Akeeba Backup Core (the free version) for your backups, that will speed up your tasks.

Davide Tampellini

Developer and Support Staff

๐Ÿ‡ฎ๐Ÿ‡นItalian: native ๐Ÿ‡ฌ๐Ÿ‡งEnglish: good โ€ข ๐Ÿ• My time zone is Europe / Rome (UTC +1)
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

ClientFW2015login
Hi!

I have tryed the akeeba backup too, and this works fine.

but i also want to take sql and ftp backups separately.
i have checked the database, the error occured on the 1st table, and the database is totaly empty

i activated the optimize-database-option in the backend after installing admin tools, is it possible that this function has made some changes in the database?
i have tryed an older version of the database, this works fine, i dont change the settings during the export of the database

Thank you!

tampe125
Akeeba Staff
I'm sorry but we can't offer support for issues not related with our software.
You are manually taking the backup of your site, assisting you in such task is out of the scope of our Terms of Service.

Davide Tampellini

Developer and Support Staff

๐Ÿ‡ฎ๐Ÿ‡นItalian: native ๐Ÿ‡ฌ๐Ÿ‡งEnglish: good โ€ข ๐Ÿ• My time zone is Europe / Rome (UTC +1)
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

ClientFW2015login
Hi

i have deleted all files on the ftp-share and in the database and imported an old backup, i reinstalled all components and took a new backup
now it works ;-)

i have no idea what the issue was, but now its solved

tampe125
Akeeba Staff
Good news, then ;)

Davide Tampellini

Developer and Support Staff

๐Ÿ‡ฎ๐Ÿ‡นItalian: native ๐Ÿ‡ฌ๐Ÿ‡งEnglish: good โ€ข ๐Ÿ• My time zone is Europe / Rome (UTC +1)
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

System Task
system
This ticket has been automatically closed. All tickets which have been inactive for a long time are automatically closed. If you believe that this ticket was closed in error, please contact us.

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!