Skip to main content

No dDB after transfer

Answered

Comments

4 comments

  • William Del Piero cPanel Staff

    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
  • Mijail Kireev

    https://drive.google.com/drive/folders/1ZqucmRbDcgCep3gL__l-ARtYEnWE8ArU?usp=sharing 

    This are the logs.

    thank you in advance.

    0
  • Mijail Kireev

    I got the logs on a google drive. I just post it on another message but still pending approval.

    0
  • William Del Piero cPanel Staff

    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.