Try ERPNext Buy Support Partners Foundation

Error in Restoring Database - Table tabSingles doesn't exist

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

which command are you using to restore database?

bench or mysql?

bench

try with these parameters

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

Thank you For your comment and support

I try it but same error I get :sleepy:

do the following steps.

  1. create new site at new server with same name
  2. install erpnext app
  3. 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.

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")

:confused:

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.

after this you can run bench migrate

I do it , Now I have this error

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

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.

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