Menu Content

Support

> Forums, FAQs & Paid Support
Welcome, Guest
Username Password: Remember me

problem with mysql backup export-import and Bookit
(1 viewing) (1) Guest
Universal booking and reservations component for Joomla!.

NOTE: This category has been locked. If you have purchased paid version, please, use our Support Ticket system instead. If you are using free edition, please see the Community Support section.
  • Page:
  • 1

TOPIC: problem with mysql backup export-import and Bookit

problem with mysql backup export-import and Bookit 12 years, 5 months ago #31762

Hello. I find a problem when make a backup of the BD of Joomla 2.5.
After erasing the tables of the database I return to import the file of the backup, but appears the next error:

-----------------------------------------------------
screen-error-restaurar-backup-mysql.jpg


MySQL say: Documentation
#1227 - Access denied; you need (at least one of) the SUPER privilege(s) for this operation
-----------------------------------------------------


In the final part of the Backup file, I see this lines:

--------------------------------------------
-- Estructura para la vista `sgj_booking_template_value_view`
--
DROP TABLE IF EXISTS `sgj_booking_template_value_view`;

CREATE ALGORITHM=UNDEFINED DEFINER=`servici3_prbpt25`@`localhost` SQL SECURITY DEFINER VIEW `sgj_booking_template_value_view` AS select `value`.`id` AS `id`,`translation`.`language_id` AS `language`,`translation`.`value` AS `value` from (`sgj_booking_template_value` `value` left join `sgj_falang_content` `translation` on((`translation`.`reference_id` = `value`.`id`))) where ((`translation`.`reference_table` = _utf8'booking_template_value') and (`translation`.`reference_field` = _utf8'value'));
-------------------------------------------------

This is correct or a DROPTABLE must not exist there?

And way phpMyAdmin required from me that I have Super privileges?

Many thanks for the support about this.
Last Edit: 12 years, 5 months ago by dmpitu.
The topic has been locked.
  • Page:
  • 1
User Login Empty