Well I have the following problem:
I'm moving from server to agency, and I came across the following problem: it had only 1 database and within that database there were several tables with the names of the clients.
The problem is that within these tables had other tables with Wordpress for example. I would like to know if you have how to back up this table with the Wordpress tables inside, and restore as a new database inside the new server.
This organization you described is not the WordPress standard. Usually when there are multiple WordPress installations within the same database, a prefix is used for each installation. Here you can identify the tables by the prefix and export them separately.
If you still have access to WordPress from each client it is best to use the WordPress exporter to move the sites. It will take care of the database and all attachments and you will not need to worry about how the database was organized.
Depending on the size of the site and server performance, the import may give timeout or memory error. In this case you have two options. Either separate the export xml into smaller pieces or use a backup plugin to transfer the database.
If you are going to use a backup plugin, I suggest the BackupWordPress . You need PHP greater than 5.3 to run. It only backs up the database so it will create a sql file only with the tables relative to that site.
