Exporting a MySQL database via PhpMyAdmin

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 "