django-dbbackup icon indicating copy to clipboard operation
django-dbbackup copied to clipboard

dbrestore warnings

Open m-aminiz opened this issue 4 years ago • 1 comments

Hi everyone I execure dbbackup command so I got a .sql file from my sqllite database but when I try to restore this file I got below warnings. when I checked database created by dbrestore command I found out some of my records were not inserted.

E:\learning\thyrocx\thyrocx\venv\lib\site-packages\dbbackup\db\sqlite.py:75: UserWarning: Error in db restore: no such table: main.accounts_person
  warnings.warn("Error in db restore: {}".format(err))
E:\learning\thyrocx\thyrocx\venv\lib\site-packages\dbbackup\db\sqlite.py:75: UserWarning: Error in db restore: no such table: main.django_content_type
  warnings.warn("Error in db restore: {}".format(err))
E:\learning\thyrocx\thyrocx\venv\lib\site-packages\dbbackup\db\sqlite.py:75: UserWarning: Error in db restore: no such table: main.auth_group_permissions
  warnings.warn("Error in db restore: {}".format(err))
E:\learning\thyrocx\thyrocx\venv\lib\site-packages\dbbackup\db\sqlite.py:75: UserWarning: Error in db restore: no such table: main.auth_user_groups
  warnings.warn("Error in db restore: {}".format(err))
E:\learning\thyrocx\thyrocx\venv\lib\site-packages\dbbackup\db\sqlite.py:75: UserWarning: Error in db restore: no such table: main.auth_user_user_permissions
  warnings.warn("Error in db restore: {}".format(err))
E:\learning\thyrocx\thyrocx\venv\lib\site-packages\dbbackup\db\sqlite.py:75: UserWarning: Error in db restore: no such table: main.auth_permission
  warnings.warn("Error in db restore: {}".format(err))
E:\learning\thyrocx\thyrocx\venv\lib\site-packages\dbbackup\db\sqlite.py:75: UserWarning: Error in db restore: no such table: main.accounts_doctor_treatment_group
  warnings.warn("Error in db restore: {}".format(err))
E:\learning\thyrocx\thyrocx\venv\lib\site-packages\dbbackup\db\sqlite.py:75: UserWarning: Error in db restore: no such table: main.accounts_patient
  warnings.warn("Error in db restore: {}".format(err))
E:\learning\thyrocx\thyrocx\venv\lib\site-packages\dbbackup\db\sqlite.py:75: UserWarning: Error in db restore: no such table: main.algorithms_step
  warnings.warn("Error in db restore: {}".format(err))
E:\learning\thyrocx\thyrocx\venv\lib\site-packages\dbbackup\db\sqlite.py:75: UserWarning: Error in db restore: no such table: main.algorithms_algorithm
  warnings.warn("Error in db restore: {}".format(err))
E:\learning\thyrocx\thyrocx\venv\lib\site-packages\dbbackup\db\sqlite.py:75: UserWarning: Error in db restore: no such table: main.consultations_message
  warnings.warn("Error in db restore: {}".format(err))
E:\learning\thyrocx\thyrocx\venv\lib\site-packages\dbbackup\db\sqlite.py:75: UserWarning: Error in db restore: no such table: main.consultations_consultation
  warnings.warn("Error in db restore: {}".format(err))
E:\learning\thyrocx\thyrocx\venv\lib\site-packages\dbbackup\db\sqlite.py:75: UserWarning: Error in db restore: no such table: main.datas_followupsonography
  warnings.warn("Error in db restore: {}".format(err))
E:\learning\thyrocx\thyrocx\venv\lib\site-packages\dbbackup\db\sqlite.py:75: UserWarning: Error in db restore: no such table: main.datas_preopsonography
  warnings.warn("Error in db restore: {}".format(err))
E:\learning\thyrocx\thyrocx\venv\lib\site-packages\dbbackup\db\sqlite.py:75: UserWarning: Error in db restore: no such table: main.datas_thyroidtest
  warnings.warn("Error in db restore: {}".format(err))
E:\learning\thyrocx\thyrocx\venv\lib\site-packages\dbbackup\db\sqlite.py:75: UserWarning: Error in db restore: no such table: main.datas_secondprimarymalignancy
  warnings.warn("Error in db restore: {}".format(err))
E:\learning\thyrocx\thyrocx\venv\lib\site-packages\dbbackup\db\sqlite.py:75: UserWarning: Error in db restore: no such table: main.datas_renaltest
  warnings.warn("Error in db restore: {}".format(err))
E:\learning\thyrocx\thyrocx\venv\lib\site-packages\dbbackup\db\sqlite.py:75: UserWarning: Error in db restore: no such table: main.datas_relatedsurgery
  warnings.warn("Error in db restore: {}".format(err))
E:\learning\thyrocx\thyrocx\venv\lib\site-packages\dbbackup\db\sqlite.py:75: UserWarning: Error in db restore: no such table: main.datas_raitherapy
  warnings.warn("Error in db restore: {}".format(err))
E:\learning\thyrocx\thyrocx\venv\lib\site-packages\dbbackup\db\sqlite.py:75: UserWarning: Error in db restore: no such table: main.datas_preopsonographyelements
  warnings.warn("Error in db restore: {}".format(err))
E:\learning\thyrocx\thyrocx\venv\lib\site-packages\dbbackup\db\sqlite.py:75: UserWarning: Error in db restore: no such table: main.datas_posttherapyraiscan
  warnings.warn("Error in db restore: {}".format(err))
E:\learning\thyrocx\thyrocx\venv\lib\site-packages\dbbackup\db\sqlite.py:75: UserWarning: Error in db restore: no such table: main.datas_patientstatus
  warnings.warn("Error in db restore: {}".format(err))
E:\learning\thyrocx\thyrocx\venv\lib\site-packages\dbbackup\db\sqlite.py:75: UserWarning: Error in db restore: no such table: main.datas_pathologyreport
  warnings.warn("Error in db restore: {}".format(err))
E:\learning\thyrocx\thyrocx\venv\lib\site-packages\dbbackup\db\sqlite.py:75: UserWarning: Error in db restore: no such table: main.datas_othertherapies
  warnings.warn("Error in db restore: {}".format(err))
E:\learning\thyrocx\thyrocx\venv\lib\site-packages\dbbackup\db\sqlite.py:75: UserWarning: Error in db restore: no such table: main.datas_otherimaging
  warnings.warn("Error in db restore: {}".format(err))
E:\learning\thyrocx\thyrocx\venv\lib\site-packages\dbbackup\db\sqlite.py:75: UserWarning: Error in db restore: no such table: main.datas_followupsonographyelements
  warnings.warn("Error in db restore: {}".format(err))
E:\learning\thyrocx\thyrocx\venv\lib\site-packages\dbbackup\db\sqlite.py:75: UserWarning: Error in db restore: no such table: main.datas_firstdegreefamilyhistory
  warnings.warn("Error in db restore: {}".format(err))
E:\learning\thyrocx\thyrocx\venv\lib\site-packages\dbbackup\db\sqlite.py:75: UserWarning: Error in db restore: no such table: main.datas_diagnosticraiscan
  warnings.warn("Error in db restore: {}".format(err))
E:\learning\thyrocx\thyrocx\venv\lib\site-packages\dbbackup\db\sqlite.py:75: UserWarning: Error in db restore: no such table: main.datas_comorbidities
  warnings.warn("Error in db restore: {}".format(err))
E:\learning\thyrocx\thyrocx\venv\lib\site-packages\dbbackup\db\sqlite.py:75: UserWarning: Error in db restore: no such table: main.datas_cbc
  warnings.warn("Error in db restore: {}".format(err))
E:\learning\thyrocx\thyrocx\venv\lib\site-packages\dbbackup\db\sqlite.py:75: UserWarning: Error in db restore: no such table: main.datas_bonesurvey
  warnings.warn("Error in db restore: {}".format(err))
E:\learning\thyrocx\thyrocx\venv\lib\site-packages\dbbackup\db\sqlite.py:75: UserWarning: Error in db restore: no such table: main.django_apscheduler_djangojob
  warnings.warn("Error in db restore: {}".format(err))
E:\learning\thyrocx\thyrocx\venv\lib\site-packages\dbbackup\db\sqlite.py:75: UserWarning: Error in db restore: no such table: main.django_apscheduler_djangojobexecution
  warnings.warn("Error in db restore: {}".format(err))
E:\learning\thyrocx\thyrocx\venv\lib\site-packages\dbbackup\db\sqlite.py:75: UserWarning: Error in db restore: no such table: main.documents_document
  warnings.warn("Error in db restore: {}".format(err))
E:\learning\thyrocx\thyrocx\venv\lib\site-packages\dbbackup\db\sqlite.py:75: UserWarning: Error in db restore: no such table: main.documents_file
  warnings.warn("Error in db restore: {}".format(err))
E:\learning\thyrocx\thyrocx\venv\lib\site-packages\dbbackup\db\sqlite.py:75: UserWarning: Error in db restore: no such table: main.queues_queueelement
  warnings.warn("Error in db restore: {}".format(err))
E:\learning\thyrocx\thyrocx\venv\lib\site-packages\dbbackup\db\sqlite.py:75: UserWarning: Error in db restore: no such table: main.django_session
  warnings.warn("Error in db restore: {}".format(err))
E:\learning\thyrocx\thyrocx\venv\lib\site-packages\dbbackup\db\sqlite.py:75: UserWarning: Error in db restore: index accounts_doctor_treatment_group_from_doctor_id_to_doctor_id_46f1961d_uniq already exists
  warnings.warn("Error in db restore: {}".format(err))
E:\learning\thyrocx\thyrocx\venv\lib\site-packages\dbbackup\db\sqlite.py:75: UserWarning: Error in db restore: no such table: main.auth_user
  warnings.warn("Error in db restore: {}".format(err))
E:\learning\thyrocx\thyrocx\venv\lib\site-packages\dbbackup\db\sqlite.py:75: UserWarning: Error in db restore: index auth_group_permissions_group_id_permission_id_0cd325b0_uniq already exists
  warnings.warn("Error in db restore: {}".format(err))
E:\learning\thyrocx\thyrocx\venv\lib\site-packages\dbbackup\db\sqlite.py:75: UserWarning: Error in db restore: index auth_permission_content_type_id_codename_01ab375a_uniq already exists
  warnings.warn("Error in db restore: {}".format(err))
E:\learning\thyrocx\thyrocx\venv\lib\site-packages\dbbackup\db\sqlite.py:75: UserWarning: Error in db restore: index auth_user_groups_user_id_group_id_94350c0c_uniq already exists
  warnings.warn("Error in db restore: {}".format(err))
E:\learning\thyrocx\thyrocx\venv\lib\site-packages\dbbackup\db\sqlite.py:75: UserWarning: Error in db restore: index auth_user_user_permissions_user_id_permission_id_14a6b632_uniq already exists
  warnings.warn("Error in db restore: {}".format(err))
E:\learning\thyrocx\thyrocx\venv\lib\site-packages\dbbackup\db\sqlite.py:75: UserWarning: Error in db restore: index django_content_type_app_label_model_76bd3d3b_uniq already exists
  warnings.warn("Error in db restore: {}".format(err))
E:\learning\thyrocx\thyrocx\venv\lib\site-packages\dbbackup\db\sqlite.py:77: UserWarning: Error in db restore: FOREIGN KEY constraint failed
  warnings.warn("Error in db restore: {}".format(err))

m-aminiz avatar May 24 '21 20:05 m-aminiz

@m-aminiz did you get any solution for this?

Devtue avatar Jan 28 '22 16:01 Devtue