Connect to the PhpMyAdmin web interface with mysql-user rights - root. By default, the access address in PhpMyAdmin is as follows:

http://ip-адрес-сервера/phpmyadmin  

file

Next, select the desired database from the left, mark the tables that you want to save (to mark multiple tables, click on them while holding down the "Ctrl" key) or click on the link "Mark All "

file

go to the "Export " tab

file

Choose "normal " or "fast " export method, format "SQL " and click "Forward "