No dDB after transfer
AnsweredI did a transfer using transfer tool and the DB from the origin was not copied to the new destination. Any info about it?
-
Hi,
Were there any errors in the transfer logs related to the database during the account migration? You can review the Transfer logs in WHM > Review Transfers and Restores. This is usually the best place to determine why a database may not have been copied.
If you can share any specific errors you find, I’ll be happy to help review them.0 -
https://drive.google.com/drive/folders/1ZqucmRbDcgCep3gL__l-ARtYEnWE8ArU?usp=sharing
This are the logs.thank you in advance.
0 -
I got the logs on a google drive. I just post it on another message but still pending approval.
0 -
Hi,
After reviewing the transfer logs, it appears that mysqldump encountered an error during the database export. I’ve redacted any sensitive information (usernames, table names), but the relevant portion of the log shows:mysqldump: Couldn't execute 'show fields from `dbuser`': View 'database.table' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
mysqldump is reporting that the MySQL view is malformed or corrupt. This can happen due to changes in the database structure, removal of databases, or an incorrect definer being set.
To resolve this, the affected view will need to be corrected or recreated directly within the database. We have documentation that walks through how to identify and repair the issue:mysqldump view references invalid tables or columns or functions or definer/invoker
0
Please sign in to leave a comment.
Comments
4 comments