1
vote
1answer
578 views

How to restrict MySQL user to not import and export database

I have created a read only MySQL user but this user have an option to export the database through phpmyadmin. How can I disable the options Export and Import?
2
votes
1answer
2k views

How to export mysql database based on a where condition

I need to export the data and structure of a table but the data must have a specific condition (WHERE status=0 and id>20). How to export mysql database based on a where condition from phpMyAdmin or ...