Copy Wordpress database without using Phpmyadmin

Question

I need to migrate a Wordpress site from one server to another. One of the necessary steps is to export the database used on the current site, edit some data if necessary (such as the site address and the file Urls) and import the database to the new server.

Is it possible to do this process of exporting/importing without using Phpmyadmin, only with database access data (database name, server, login and password)? Is there any tool that allows you to access the database without being installed on the server itself?

Answer 1

Visual export from administrative panel (no code)

An excellent alternative that use for this type of task is the free plugin All-in-One WP Migration, which allows exporting and importing the SQL database (or all the files from the site if you prefer), from the Wordpress dashboard itself, without having to deal with FTP and file permissions, fully visual.

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

After installation the operation is simple:

1. On site A: Go to the menu Site Migration > Export export the database (or the full site) with the plugin. In a few moments it will generate a file with the extension .zip;
2. On site B: Go to the menu Site Migration > Import and drag the file .zip generated in step 1 into the import area.

And just like that!

The plugin works very well and can even be used by customers, for a quick backup of the full site or only the database, just trigger some very simple options.

Another important function of the plugin is to fully visual search and replace the website address and other information (such as the server path), which need be changed in the final database to allow the site to function properly after export.

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

Answer 2

WP-DB-Backup

There is a Wordpress plugin that performs the backup, WP-DB-Backup, where we can read on the page of the same:

WP-DB-Backup Allows you easily to backup your core Wordpress database Tables. You may also backup other Tables in the same database.

That translated:

WP-DB-Backup allows you to easily perform a backup of the configuration tables present in the Wordpress database. You can also backup other tables present in the same database.

Installation

Installation is achieved in four simple steps that can be seen here:

1. Extract the folder wp-db-backup/ for /wp-content/plugins/;

2. Enable the plugin in the administrative area under Admin -> Plugins;

3. The plugin will try to create a directory with the name /wp-content/backup-*/ within the Wordpress directory;

4. You may need to give write permissions to the directory /wp-content (at least temporarily) so that the plugin can create the directory mentioned in point 3.

   For example:

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

Answer 3

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 star of the German Wordpress school, I have only praise for his work: Allow, Backwpup, Multilingual Press and a wide et cetera of other plugins, projects on Github and participation in Stack Exchange Wordpress Developers.

Main screen

Control screen (section Dump, using Start Adminer Inside)

---

Editing of exported data

For this I use the following procedure:

• Import the dump Mysql in a local database or an empty one on the server.
• Use the application Database Search and Replace Script in PHP to replace everything needed (Urls and Paths, mainly).
• Export this modified database and import to the final server.

Answer 4

There is a Mysql tool called Mysql Workbench which I personally find more practical than using phpMyAdmin. Many things can be done with it, including importing and exporting the database. However, it requires installation on your computer, which I don’t know if it will be a problem for you.

Answer 5

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

And here a video tutorial how to use it.

Answer 6

After searching a lot! The best free backup plugin from the bank is Updraftplus: https://wordpress.org/plugins/updraftplus/ It has over 800,000 active installations, fast support and 4.9/5 star rating.