WP-DB-Backup

There is a plugin for Wordpress that does the backup, WP-DB-Backup, where we can read it on the page:

  

WP-DB-Backup allows you to easily backup your core WordPress database tables. You can also backup other tables in the same database.

What translated:

  

WP-DB-Backup allows you to easily back up the configuration tables present in the WordPress database. You can also back up other tables in the same database.

Installation

Installation is accomplished in four easy steps that you can viewed here :

$ cd /wordpress/
$ chgrp www-data wp-content (onde "www-data" é o grupo que o teu cliente de FTP utiliza)
$ chmod g+w wp-content

Visual export from administrative panel (without code)

An excellent alternative that I use for this type of task is the free plugin All-in -One WP Migration , which allows you to export and import the SQL database (or all site files, if you prefer), from the WordPress panel itself, without having to deal with with FTP and file permissions, totally visually .

The installation of the plugin is done by the WordPress panel itself in " Plugins > Adicionar Novo ". Search for "All-in-One WP Migration".

Aftertheinstallationtheoperationissimple:

Andthat'sit!

Thepluginworksverywellandcanevenbeusedbyclients,foraquickbackupofthewholesiteorjustthedatabase,justbytriggeringsomeverysimpleoptions.

I use the plugin frequently in my projects and recommend it to everyone.

Adminer

The plugin is a PHPMyAdmin within WordPress. It is a complete MySQL database administration tool written in PHP.

The author of the plugin, Frank Bültge , is a playwright of the German school of WordPress, I only praise the your work: Administer , BackWPup a>, Multilingual Press and a wide et cetera of other plugins, projects on GitHub, and participation in the Stack Exchange WordPress Developers.

Home screen

ControlPanel(Dumpsection,usingStartAdminerinside)

Editing exported data

For this I use the following procedure:

• Import the dump MySQL into a local database or an empty one on the server.
• Use the Database Search and Replace Script application in PHP to replace everything that is needed (mainly URLs and Paths).
• Export this modified base and import it to the final server.

There is a MySQL tool called MySQL Workbench that I personally find more practical than using phpMyAdmin. It is possible to do many things with it, including importing and exporting the database. However, it requires installation on your computer, which I do not know will be a problem for you.

You can use Navicat , so you will not need plugins or third parties. It will create a direct connection between the servers.

And here a cool video tutorial of how to use it.

After searching a lot! The best free backup bank plugin is UpDraftPlus: link It has more than 800 thousand active installations, fast support and note 4.9 / 5 stars.