Error in Restoring Database - Table tabSingles doesn't exist

AhmedSmart · February 24, 2018, 5:43am

Hi,

I have a problem when I try Restore database in localhost machine.

It give me this error :

pymysql.err.ProgrammingError: (1146, u"Table ‘d56cb677eaab3383.tabSingles’ doesn’t exist")

Note :

Database is backup form my cloud
Both localhost and the cloud same version
Installed Apps
ERPNext: v10.1.2 (master)
Frappe Framework: v10.1.0 (master)
NO CUSTOMIZATION MADE

Any help or suggestion ?

Thanks

adnan · February 24, 2018, 5:52am

which command are you using to restore database?

bench or mysql?

AhmedSmart · February 24, 2018, 6:05am

bench

adnan · February 24, 2018, 6:12am

try with these parameters

bench --force --site erpnext restore /home/frappe/frappe/

AhmedSmart · February 24, 2018, 7:28am

Thank you For your comment and support

I try it but same error I get

adnan · February 24, 2018, 8:32am

do the following steps.

create new site at new server with same name
install erpnext app
restore with the following command.
bench --force --site erpnext restore /home/frappe/frappe/

it’ll work.

the error, in your backup,is it’s trying to insert records in table which dosen’t exist.

AhmedSmart · February 24, 2018, 9:53am

I try it I create new site at new server with same name I install Erpnext
I use this commend bench --force --site erpnext restore /home/frappe/frappe/

Again same error

pymysql.err.ProgrammingError: (1146, u"Table ‘1bd3e0294da19198.tabSingles’ doesn’t exist")

adnan · February 24, 2018, 9:59am

try to restore your DB directly from MYsql

mysql -u root -p 1bd3e0294da19198 < /home/path to sql file.

it’ll ask for your DB root password

please make sure your file should be extracted from *.sql.gz extention.

adnan · February 24, 2018, 10:00am

after this you can run bench migrate

AhmedSmart · February 24, 2018, 10:14am

I do it , Now I have this error

pymysql.err.ProgrammingError: (1146, u"Table ‘1bd3e0294da19198.tabPatch Log’ doesn’t exist")

adnan · February 24, 2018, 10:16am

i have a doubt about your backup file.

if you still have access to oldserver you can take the backup again directly from Mysql

mysqldump -u root -p 1bd3e0294da19198 > /home/path to sql file.

and then restore that new file.

maddiikiran · May 19, 2020, 7:14pm

i too have the same problem.
Followed all the above specified steps.
but not resolved

Dragavs · March 31, 2021, 3:47am

I also tried the steps above using bench and mysql, bench is getting same error but when i try using mysql it was successful yet my data is not restored.

kunhi_mohamed · December 26, 2023, 12:18pm

i have the same issue. the problem is in backup file for me.

but there is no error rise at ‘bench backup’. but when i backup with ‘mysqldump’ got an timeout then tuning the parameters at *.cnf file fixed the issue.

shubham_mishra · January 22, 2024, 11:11am

I am also getting the same issue Table “tabSingles” doesn’t exist.
I tried --force method also but still getting the same error.
But i tried to restore the database form backend with this command “bench --site your_site_name mariadb” and then “source /mysqldb_file_location” it worked.
I want to know the exact reason why the backup is not being uploaded with the bench command.