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!

dump mysql

Discussion in 'Database Discussion' started by alexandz, Dec 16, 2011.

  1. alexandz

    alexandz Well-Known Member

    Joined:
    Oct 28, 2011
    Messages:
    111
    Likes Received:
    0
    Trophy Points:
    66
    Location:
    Chile
    cPanel Access Level:
    Root Administrator
    Hello! I wonder if you can get a cpanel mysql dump without a master?
     
  2. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    16,570
    Likes Received:
    438
    Trophy Points:
    583
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    Without a Master what? Do you mean you wish to dump a single database from one account?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. alexandz

    alexandz Well-Known Member

    Joined:
    Oct 28, 2011
    Messages:
    111
    Likes Received:
    0
    Trophy Points:
    66
    Location:
    Chile
    cPanel Access Level:
    Root Administrator
    I refer to want to export the dump of a database from a client, but no owner
     
  4. alexandz

    alexandz Well-Known Member

    Joined:
    Oct 28, 2011
    Messages:
    111
    Likes Received:
    0
    Trophy Points:
    66
    Location:
    Chile
    cPanel Access Level:
    Root Administrator
    It happens that I present the following error:

    Dec 15 02:05:36 Warning: mysqldump: Got error: 1449: The user specified as a definer ('root'@'%') does not exist when using LOCK TABLES
    Dec 15 02:05:36 Warning: Failed to dump mysql databases xxxxxxx
     
  5. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    16,570
    Likes Received:
    438
    Trophy Points:
    583
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    Please post the line you're using to initiate the dump. (editing anything private of course)
     
    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