Advertisement:

Author Topic: backup and restore after an update problems importing data to the database  (Read 1563 times)

osCanyon

  • Hero Member
  • *****
  • Posts: 701
  • osCanyon, the class of Osclass
I have a couple of sites that were upgraded from an older version, one was 3.12 and the other was 3.4,
after the upgrade which seemed to go as expected, I tried to backup the data base via the osclass admin under tools
and then restore the Same backup as I just downloaded but get this error
"There was a problem importing data to the database"

some research showed that the Engine InnoDB didnt like Primary Key and would fail
 on one of the sites I tried installing a plugin but sane database error, it had the storage engine of InnoDB so I changed the struct.sql to MyISAM and the plugin installed and is working
 has anybody tried to do a backup and restore after an update of osClass?

osCanyon

  • Hero Member
  • *****
  • Posts: 701
  • osCanyon, the class of Osclass
Brand New Install of 3.61, no other themes or plugins installed, immediately went to tools and did 'Backup Data' then right to 'Import Data'
and received same error
There was a problem importing data to the database

teseo

  • Hero Member
  • *****
  • Posts: 6169
Hi,

I've seen before problems with the Osclass tool, due (I think) to its way to escape quotes. ??? You can do this test: use PhpMyAdmin, create a new database and then try to import from there Osclass backup .sql

If no errors, it's definitely some Osclass bug on the Import module. ???

Regards

osCanyon

  • Hero Member
  • *****
  • Posts: 701
  • osCanyon, the class of Osclass
yes, I did the import from phpmyadmin and is ok, so must be the internal backup/restore has bugs
also it will crash if trying to backup a fair sized database :(   (from osclass admin)