Importing local database error

[himanshu-kmr]

Hello,

I have exported my localhost/phpmyadmin db and imported into the different system. To get existing data and configuration.
But after importing if I am creating any new Category I am getting error

"SQLSTATE[HY000]: General error: 1449 The user specified as a definer ('bagistodb'@'localhost') does not exist (SQL: update categories set _lft = case when _lft >= 15 then _lft+2 else _lft end, _rgt = case when _rgt >= 15 then _rgt+2 else _rgt end where (_lft >= 15 or _rgt >= 15)) "

On .env

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=bagisto
DB_USERNAME=root
DB_PASSWORD=

Webiste is working fine but on admin panel on some section it is giving this error.

If i am running seeder then it is working fine.

Please help me.. '

Thankyou in advance.

[devansh-webkul]

Hi @himanshu-kmr,

Just check this thread,
https://github.com/bagisto/bagisto/issues/2015

[himanshu-kmr]

@devansh-webkul Thank You

I just created bagistodb user and bagisto and problem solved.

Thanking You

[devansh-webkul]

Hi @himanshu-kmr,

Thanks for the update.

Also, if you like our support, you may give us the review here:- https://www.trustpilot.com/review/bagisto.com

That would be grateful for us.

Thanks & Regards,

Bagisto Team