*

questions

  • *****
  • 319 posts
Tools / backup data OSCLASS MYSQL Autobackup
« on: February 22, 2023, 04:20:34 PM »
Trying to import the database by tools / backupdata

making tests to see how it works and I get this error

/* OSCLASS MYSQL Autobackup (22/02/2023 17:15) *//* Table structure for table `oc_t_locale` */CREATE TABLE IF NOT EXISTS `oc_t_locale` (  `pk_c_code` char(5) NOT NULL,  `s_name` varchar(100) NOT NULL,  `s_short_name` varchar(40) NOT NULL,  `s_description` varchar(100) NOT NULL,  `s_version` varchar(20) NOT NULL,  `s_author_name` varchar(100) NOT NULL,  `s_author_url` varchar(100) NOT NULL,  `s_currency_format` varchar(50) NOT NULL,  `s_dec_point` varchar(2) DEFAULT '.',  `s_thousands_sep` varchar(2) DEFAULT '',  `i_num_dec` tinyint(4) DEFAULT 2,  `s_date_format` varchar(20) NOT NULL,  `s_stop_words` text DEFAULT NULL,  `b_enabled` tinyint(1) NOT NULL DEFAULT 1,  `b_enabled_bo` tinyint(1) NOT NULL DEFAULT 1,  `b_locations_native` tinyint(1) DEFAULT 0,  `b_rtl` tinyint(1) DEFAULT 0,  PRIMARY KEY (`pk_c_code`),  UNIQUE KEY `s_short_name` (`s_short_name`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

What should I do?

*

MB Themes

Re: Tools / backup data OSCLASS MYSQL Autobackup
« Reply #1 on: February 22, 2023, 07:09:56 PM »
What is error?
  To get fast support, we need following details: Detail description, URL to reproduce problem, Screenshots

*

questions

  • *****
  • 319 posts
Re: Tools / backup data OSCLASS MYSQL Autobackup
« Reply #2 on: February 22, 2023, 09:03:53 PM »
This is the error I get in phpmyadmin when I try to import the generated sql file in tools/backup data by osclass.

The osclass sql generated in picture. The error comes when I try to import it.


*

questions

  • *****
  • 319 posts
Re: Tools / backup data OSCLASS MYSQL Autobackup
« Reply #3 on: February 23, 2023, 09:24:40 PM »
Need help, that’s the error I get while export-import using Tools / Backup for Sql.

*

MB Themes

Re: Tools / backup data OSCLASS MYSQL Autobackup
« Reply #4 on: February 24, 2023, 09:03:39 PM »
@questions
Use real backup tool instead.
These backups from Mysql will only work OK on empty database with foreign keys check disabled.
  To get fast support, we need following details: Detail description, URL to reproduce problem, Screenshots