The easiest way to export a MySql database from a website and software to work with this database locally?

Question

MySQL

Hello!
Advise: It is
necessary to unload the MySql database from the site and study it locally on the computer. There is access through phpMyAdmin.
After that, you need to study the data inside, make reports and possibly edit individual tables. Zero knowledge, in the direction of which programs to look?
According to the software, there should be an accessible knowledge base (and it’s better to be intuitive), the ability to save queries (so as not to drive in every time), and the ability, in case of successful editing, to upload individual tables from the database back to the site.
Thank you!

Answer 1

Why separate software? You can deploy the same phpmyadmin locally.
Well, or try some www.heidisql.com if you really want a desktop

Answer 2

I prefer SQLYog .
Make several requests for a person, then show him how to open them through "File - Open ...
These requests will pull out the necessary data for him, which he can change, then save in one click.

Answer 3

Export the database structure + data through the Lord PapapMaesquel. As I understand it, I will have to install a local database - from offsite . It seems to me that dbForge for Mysql has not been invented as a GUI for Windows .

Answer 4

If it’s quite simple, we put WampServer on the local machine, there is phpMyAdmin there. Further, on the site - export, on the machine - import, and pick your health :) Back fill in the same way - from the local export of the desired table, on the site - import