после восстановления БД из архива выдает ошибку

[voventij]

Добрый день, ОС=windows XP бд=mysql
После восстановления БД из архивной резервной копии, перестали открываться приходные накладные. Выписывает ошибку:
"При выполнении запроса произошла ошибка
select * from dpbase.listdocspn where (fdoc = concat('PN') and fnop in (2) and fdoc_dat >= '2010-03-09 00:00:00' and fdoc_dat <= '2011-03-09 00:00:00' ) order by fdoc_dat, fdoc_num


Table 'dpbase.listdocspn' doesn't exist".

Когда создавал резервную копию, архив создался без ошибок. При восстановлении пишет что импорт БД выполнен с ошибками:
Импорт E:\DebetPlusV12\arhiv\2011-03-09/dpbase_2011-03-09_19-25.arh
Сервер localhost
База dpbase

ERROR 1227 (42000) at line 39955: Access denied; you need the SUPER privilege for this operation
ERROR 1227 (42000) at line 39965: Access denied; you need the SUPER privilege for this operation
ERROR 1227 (42000) at line 39975: Access denied; you need the SUPER privilege for this operation
ERROR 1227 (42000) at line 39985: Access denied; you need the SUPER privilege for this operation
ERROR 1227 (42000) at line 39995: Access denied; you need the SUPER privilege for this operation
ERROR 1227 (42000) at line 40005: Access denied; you need the SUPER privilege for this operation
ERROR 1227 (42000) at line 40015: Access denied; you need the SUPER privilege for this operation
ERROR 1227 (42000) at line 40025: Access denied; you need the SUPER privilege for this operation
ERROR 1227 (42000) at line 40035: Access denied; you need the SUPER privilege for this operation
ERROR 1227 (42000) at line 40045: Access denied; you need the SUPER privilege for this operation
ERROR 1227 (42000) at line 40055: Access denied; you need the SUPER privilege for this operation
ERROR 1227 (42000) at line 40065: Access denied; you need the SUPER privilege for this operation
ERROR 1227 (42000) at line 40075: Access denied; you need the SUPER privilege for this operation
ERROR 1227 (42000) at line 40085: Access denied; you need the SUPER privilege for this operation
ERROR 1227 (42000) at line 40095: Access denied; you need the SUPER privilege for this operation
ERROR 1227 (42000) at line 40105: Access denied; you need the SUPER privilege for this operation
ERROR 1227 (42000) at line 40115: Access denied; you need the SUPER privilege for this operation
ERROR 1227 (42000) at line 40135: Access denied; you need the SUPER privilege for this operation
ERROR 1227 (42000) at line 40145: Access denied; you need the SUPER privilege for this operation
ERROR 1227 (42000) at line 40155: Access denied; you need the SUPER privilege for this operation
ERROR 1227 (42000) at line 40165: Access denied; you need the SUPER privilege for this operation
ERROR 1227 (42000) at line 40175: Access denied; you need the SUPER privilege for this operation
ERROR 1227 (42000) at line 40185: Access denied; you need the SUPER privilege for this operation
ERROR 1227 (42000) at line 40195: Access denied; you need the SUPER privilege for this operation
ERROR 1227 (42000) at line 40205: Access denied; you need the SUPER privilege for this operation
ERROR 1227 (42000) at line 40215: Access denied; you need the SUPER privilege for this operation
ERROR 1227 (42000) at line 40225: Access denied; you need the SUPER privilege for this operation
ERROR 1227 (42000) at line 40235: Access denied; you need the SUPER privilege for this operation
ERROR 1227 (42000) at line 40245: Access denied; you need the SUPER privilege for this operation
ERROR 1227 (42000) at line 40255: Access denied; you need the SUPER privilege for this operation
ERROR 1227 (42000) at line 40265: Access denied; you need the SUPER privilege for this operation
ERROR 1227 (42000) at line 40275: Access denied; you need the SUPER privilege for this operation
ERROR 1227 (42000) at line 40285: Access denied; you need the SUPER privilege for this operation
ERROR 1227 (42000) at line 40295: Access denied; you need the SUPER privilege for this operation
ERROR 1227 (42000) at line 40305: Access denied; you need the SUPER privilege for this operation
ERROR 1227 (42000) at line 40315: Access denied; you need the SUPER privilege for this operation
ERROR 1227 (42000) at line 40325: Access denied; you need the SUPER privilege for this operation
ERROR 1227 (42000) at line 40335: Access denied; you need the SUPER privilege for this operation
ERROR 1227 (42000) at line 40345: Access denied; you need the SUPER privilege for this operation
ERROR 1227 (42000) at line 40355: Access denied; you need the SUPER privilege for this operation
ERROR 1227 (42000) at line 40365: Access denied; you need the SUPER privilege for this operation
ERROR 1227 (42000) at line 40375: Access denied; you need the SUPER privilege for this operation
ERROR 1227 (42000) at line 40385: Access denied; you need the SUPER privilege for this operation
ERROR 1227 (42000) at line 40395: Access denied; you need the SUPER privilege for this operation
ERROR 1227 (42000) at line 40405: Access denied; you need the SUPER privilege for this operation
ERROR 1298 (HY000) at line 40408: Unknown or incorrect time zone: 'NULL'
ERROR 1231 (42000) at line 40410: Variable 'sql_mode' can't be set to the value of 'NULL'
ERROR 1231 (42000) at line 40411: Variable 'foreign_key_checks' can't be set to the value of 'NULL'
ERROR 1231 (42000) at line 40412: Variable 'unique_checks' can't be set to the value of 'NULL'
ERROR 1231 (42000) at line 40413: Variable 'character_set_client' can't be set to the value of 'NULL'
ERROR 1231 (42000) at line 40415: Variable 'collation_connection' can't be set to the value of 'NULL'
ERROR 1231 (42000) at line 40416: Variable 'sql_notes' can't be set to the value of 'NULL'

Импорт выполнен с ошибками
Время выполнения: 00:02:52

Подскажите, как исправить и что я сделал неправильно. Спасибо.

[Татьяна]

А Вы модификацию проводили после импорта базы? (подсистема Администрирование / меню Сервис / Обновление структрур базы данных)

[voventij]

Большое спасибо, помогло! Модификацию базы после импорта нужно проводить каждый раз?

[Татьяна]

Модификация проводится в двух случаях:
-если версия программы и версия базы разные
-если вкачиваете базу с формата *.mdb или *.xml (нужно проводить модификацию с переиндексацией)