On October 19, 2021, we have enabled single-sign-on for our Plesk Support Center to provide a seamless login/account experience. This implies that you’ll be able to use a single account across any of our web-facing properties.
If you had already registered your account at Plesk 360 (formerly known as My Plesk) please use one for login. Otherwise please re-register it using the same email address as your existing Zendesk login (support account). It’s essential that you use the same email address on our support center to ensure that your tickets stay attached to the same account.

Articles in this section

See more

How to create a database dump using PHPMyAdmin in Plesk?

Avatar
Pavel Rozental
Updated
Follow
kb: how-to ABT: Group B

Question

How to create a database dump using PHPMyAdmin?

Answer

  1. Go to Domains > example.com > Databases > database_name.
  2. Click PHPMyAdmin.
  3. Click on Export from the top set of tabs.
  4. Select the tables from the list that you would like to dump. To dump the entire database, click Select All.
  5. "Structure" and "Data" boxes must be selected on the right.
    In the Structure section, check the "Add DROP TABLE / DROP VIEW" box to make exported file to be able to replace existing tables of the same name. To merge this backup with another database, do not select this.
  6. Check the "Save as file" box. Also, select a compression option (such as "gzipped") to compress the backup before downloading it from the server.
  7. Click the Go button, and, at the prompt, save the file to the local computer.

Comments

2 comments

Sort by Date Votes
  • Avatar
    JuJue Holistic Wellness

    That's the issue!

    going to

    Domains > example.com > Databases > database_name.

    then click on

    PHPMyAdmin.

    I get presented a login page. No good

    I should be able to login ohoMyAdmin on server wide option from when logged in, I then can easily switch between several databases of the domain.

    The grater issue however is, Not only am I presented with a login page as administrator but also as a "Client". Imagine, a client wanting to work in phpMyadmin and can't get global access.

    Why isn't there a similar option like in WHM (makes DB work so much easier and time-saving!

     

    Thanks

    0
    Comment actions Permalink
  • Avatar
    Francisco Roman Garcia Rodriguez

    Hi JuJue Holistic Wellness,

    Then you have an issue in that Plesk server since if you're logged in to Plesk as Admin (or Client), when clicking on the phpMyAdmin button you automatically log in to it.

    If you're still having such problem, please open a ticket so it can be investigated properly.

    0
    Comment actions Permalink

Please sign in to leave a comment.

Have more questions? Submit a request

Related articles