The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

PHPmyAdmin - Another anoying issue with export/import

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

  1. Nick57

    Nick57 Well-Known Member

    Joined:
    Jul 19, 2005
    Messages:
    100
    Likes Received:
    0
    Trophy Points:
    16
    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:
    100
    Likes Received:
    0
    Trophy Points:
    16
    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:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    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.
     
Loading...

Share This Page