Database Map tool via command line

bmett

• August 06, 2018 22:16

Hi there, I need to map a large amount of databases and database users to the correct cPanel accounts (several hundred accounts). I'm aware that I can map those one by one via the WHM Database Map Tool, but that would take me forever. Is there a command line script I can use for this purpose, so I can create a bash script doing the mapping for me? The databases and database users all follow the same naming convention, therefore a batch mapping script should be easy to create, but I don't know if there is a command line script that maps databases/database users to cPanel accounts. Cheers.

• 

  24x7server

  • August 07, 2018 06:16

  Hi, You can check the below documentation link which has pretty much all details in it. The dbmaptool Script - Version 68 Documentation - cPanel Documentation For a bulk operation, you may have to use bash script in combination to the commands mentioned in the above link..

  0
• 

  cPanelLauren

  • August 07, 2018 17:36

  Hi @bmett The dbmaptool script would be the right item for the job as already suggested. Thanks!

  0
• 

  bmett

  • August 08, 2018 00:26

  How did I not see that script? I must be blind ... thanks for the replies, this did the trick.

  0
• 

  cPanelLauren

  • August 08, 2018 14:06

  Hi @bmett No worries, I'm glad it worked for you! Thanks!

  0

Please sign in to leave a comment.