Knowledge Forum


This community is for professionals and enthusiasts of our products and services.
Share and discuss the best content and new marketing ideas, build your professional profile and become a better marketer together.


Query should execute while working with customer database

Harsh Bhatt

While we are working with customer database we must need to ensure not any activity will work with live data

1 Answer
Harsh Bhatt
Best Answer

We should need to trigger below queries after restore customer database into local system or staging server 

to inactive automatic action
Update ir_cron set active='false';

To set dummy email address into partner
Update res_partner set mailto:email='';

To remove UUID key
Update ir_config_parameter set value='backup_db' where key='database.uuid';

To remove outgoing email server
Delete from ir_mail_server;

To remove incoming email server
Delete from fetchmail_server;

to update login_id and password for admin user
update res_users set login='admin' where id=2;
update res_users set password='admin' where id=2;


Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!