crm database migration

Hi,

I just want to migrate the current database to another OroCRM application, I dumped the database and loaded in the new application, but I got several error saying some entity doesn’t exist or that I’m calling a getId function on a non existent object.

How can I perform this migration ? Do you best practices ?

Thanks.

Olivier.

Topic

[Yevhen ShyshkinParticipant]

Hi, freelancer.

Please:
1) ensure that instances have the same code (i.e. same application version and versions of dependencies)
2) manually remove cache from /app/cache directory and run app/console cache:clear –env prod

[freelancerParticipant]

Yevhen, thank you.

[SpurgeonParticipant]

Hi Yeven,

I too attempted the same, replicated the files from one server to another and recreated the permissions then imported the tables in to the db too.

I had initial errors which went away with sudo rm -rf app/cache/prod folder

Now, after login, the page is empty except for top nav bar.

Could you kindly help on how to port an instance from server to another?

Thanks in advance!
Spurgeon

[Yevhen ShyshkinParticipant]

Hello, spurgeonbj.

Basically, as usual migration, it requires to copy environment, code and DB.

In your specific case, please:
0) remove cache again and then run php app/console cache:clear --env=prod;
1) check permissions for directories app/cache, app/logs, web/css, web/js;
2) check app/logs/prod.log for errors;
3) check php and web server error logs.

If you’ll find some errors – put them here, I’ll help you to fix it.

[SpurgeonParticipant]

Hi Yevhen,

Thanks for the quick and kind response.

Will revert after a fresh try, if need be.

Thanks once again!

Warm regards and gratitude,
Spurgeon

[Author]

Replies