Connect to the PhpMyAdmin web interface with mysql-user rights - root. By default, the access address in PhpMyAdmin is as follows:
http://ip-адрес-сервера/phpmyadmin
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 "
go to the "Export " tab
Choose "normal " or "fast " export method, format "SQL " and click "Forward "