django-dbbackup
django-dbbackup copied to clipboard
dbrestore warnings
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 did you get any solution for this?