kb: how-to
ABT: Group B
Question
How to create a database dump using PHPMyAdmin?
Answer
- Go to Domains > example.com > Databases > database_name.
- Click PHPMyAdmin.
- Click on Export from the top set of tabs.
- Select the tables from the list that you would like to dump. To dump the entire database, click Select All.
- "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. - Check the "Save as file" box. Also, select a compression option (such as "gzipped") to compress the backup before downloading it from the server.
- Click the Go button, and, at the prompt, save the file to the local computer.
Comments
2 comments
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
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.
Please sign in to leave a comment.