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!

how to copy all mysql users manually?

Discussion in 'Data Protection' started by rastoma, Apr 15, 2010.

  1. rastoma

    rastoma Well-Known Member

    Joined:
    Aug 27, 2001
    Messages:
    158
    Likes Received:
    0
    Trophy Points:
    316
    If a drive is too full and I can't run backups, I want to copy the entire /var/lib/mysql directory but that doesn't copy db users and permissions.

    Where is the db user data located?
     
    #1 rastoma, Apr 15, 2010
  2. yapluka

    yapluka Well-Known Member

    Joined:
    Dec 24, 2003
    Messages:
    301
    Likes Received:
    1
    Trophy Points:
    168
    Location:
    France
    cPanel Access Level:
    Root Administrator
    db users and privileges are in the database "mysql".
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #2 yapluka, Apr 15, 2010
  3. cPanelJared

    cPanelJared Technical Analyst

    Joined:
    Feb 25, 2010
    Messages:
    1,835
    Likes Received:
    20
    Trophy Points:
    143
    Location:
    Houston, TX
    cPanel Access Level:
    Root Administrator
    Make a dump of the MySQL database

    As yapluka mentioned, these data are in the mysql database. The best way to preserve these data is to make a dump of the mysql database, which will create a file that contains all of the commands needed to create the database again. A very basic use of the mysqldump command would be the following:

    Code:
    # mysqldump mysql > /root/mysql.sql
    This will create a dump file in /root, mysql.sql, that contains all of the SQL statements needed to create the mysql database again. To import the database in the future, simply redirect the dump file into MySQL:

    Code:
    # mysql mysql < /root/mysql.sql
    If you need to move the MySQL data directory due to lack of disk space, there are several threads in our forums that describe how to do this. A couple of good suggestions are the following:

    http://forums.cpanel.net/f5/move-mysql-databases-6655.html
    cPanel Forums - View Single Post - Move MySQL Databases
    http://forums.cpanel.net/f5/how-move-mysql-data-folder-110481.html
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #3 cPanelJared, Apr 16, 2010
(You must log in or sign up to post here.)
Loading...
Similar Threads - copy mysql users
  1. Rakaris Bakaris

    SOLVED Hide copyright message from php cli output

    Rakaris Bakaris, Jun 5, 2018, in forum: cPanel Developers
    Replies:
    3
    Views:
    68
    cPanelMichael
    Jun 6, 2018
  2. rpvw

    SOLVED Copy Paste in FileManager Editor Issue

    rpvw, May 16, 2018, in forum: User Experience
    Replies:
    9
    Views:
    130
    cPanelMichael
    May 21, 2018
  3. alias harun

    SOLVED [CPANEL-20499] Transfers fail when "Copy Home Directory" is deselected

    alias harun, May 16, 2018, in forum: Data Protection
    Replies:
    5
    Views:
    252
    cPanelMichael
    May 23, 2018
  4. Srinath S M

    Copying the Account level filter over to Global filter

    Srinath S M, May 2, 2018, in forum: E-mail Discussion
    Replies:
    3
    Views:
    98
    cPanelLauren
    May 3, 2018
  5. Oluwatosin

    Copy home directory and database to another server?

    Oluwatosin, Apr 19, 2018, in forum: Data Protection
    Replies:
    1
    Views:
    98
    cPanelMichael
    Apr 19, 2018

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.
    Accept Learn More...
    Dismiss Notice