Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

PHPmyAdmin - Another anoying issue with export/import

Discussion in 'Database Discussion' started by Nick57, Aug 20, 2013.

  1. Nick57

    Nick57 Well-Known Member

    Joined:
    Jul 19, 2005
    Messages:
    102
    Likes Received:
    0
    Trophy Points:
    166
    cPanel Access Level:
    Root Administrator
    [Solved] PHPmyAdmin - Another anoying issue with export/import

    Hi,

    In the past I was able to export the DB and import it in a different cPanel account to do some work on the website/database.

    Now, when exporting it dumps the DB with the name user_db.sql
    When importing in the other cPanel account it comes with error:

    Error

    SQL query:

    --
    -- Database: `user_db`
    --
    CREATE DATABASE IF NOT EXISTS `user_db` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

    MySQL said: Documentation
    #1044 - Access denied for user 'owner'@'localhost' to database 'user_db'


    owner is the current and user is the new account.
    In the past this was no problem at all.

    Any one a trick how to get this working again?
     
    #1 Nick57, Aug 20, 2013
    Last edited: Aug 20, 2013
  2. Nick57

    Nick57 Well-Known Member

    Joined:
    Jul 19, 2005
    Messages:
    102
    Likes Received:
    0
    Trophy Points:
    166
    cPanel Access Level:
    Root Administrator
    Sorted, Import has been successfully finished, 183 queries executed.
     
  3. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    43,961
    Likes Received:
    1,821
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello :)

    I am happy to hear the issue is now resolved. Could you let us know if you took any specific steps to resolve the issue in-case other users experience a similar problem?

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice