Title: exclude  the "users" table
Last modified: August 20, 2016

---

# exclude the "users" table

 *  Resolved [IeIouch](https://wordpress.org/support/users/ieiouch/)
 * (@ieiouch)
 * [13 years, 3 months ago](https://wordpress.org/support/topic/exclude-the-users-table/)
 * Hi,
 * Is it possible to add the possibility to exclude the “users” table from the export
   of the database in a next update ?
 * This would allows not to send in preprod (or prod) the users ID/passwords used
   in local.
 * A checkbox added in the back office and a little condition on the export would
   do the trick.
 * Thanks,
 * Example: without configuration in Back Office
 *     ```
       foreach ($tables as $table) {
   
               if($table[0] != $table_prefix."users"){ // new : accepts all tables except users
   
                    if ( 'VIEW' == $table[1] ) continue;
                    $table = $table[0];
        			// Increase script execution time-limit to 15 min for every table.
        			$this->stow("# " . sprintf(__('Table: %s','wp-migrate-db'),$this->backquote($table)) . "\n");
        			$this->stow("# --------------------------------------------------------\n");
        			$this->backup_table($table);
   
               } // new end if
       }
       ```
   
 * [http://wordpress.org/extend/plugins/wp-migrate-db/](http://wordpress.org/extend/plugins/wp-migrate-db/)

Viewing 1 replies (of 1 total)

 *  Plugin Contributor [Brad Touesnard](https://wordpress.org/support/users/bradt/)
 * (@bradt)
 * [13 years, 3 months ago](https://wordpress.org/support/topic/exclude-the-users-table/#post-3493606)
 * The ability to select which tables to export (along with lots of other features)
   will be available in the Pro version to be released in the next few weeks. Here’s
   a sneak peek of the feature: [https://dl.dropbox.com/u/4113520/wpmdb-select-tables.png](https://dl.dropbox.com/u/4113520/wpmdb-select-tables.png)
 * If you’re interested in being notified when it’s released, you can subscribe 
   to the mailing list: [http://bradt.ca/wpmdb-subscribe-form.php](http://bradt.ca/wpmdb-subscribe-form.php)

Viewing 1 replies (of 1 total)

The topic ‘exclude the "users" table’ is closed to new replies.

 * ![](https://ps.w.org/wp-migrate-db/assets/icon.svg?rev=2851356)
 * [WP Migrate Lite - Migration Made Easy](https://wordpress.org/plugins/wp-migrate-db/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wp-migrate-db/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wp-migrate-db/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-migrate-db/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-migrate-db/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-migrate-db/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [Brad Touesnard](https://wordpress.org/support/users/bradt/)
 * Last activity: [13 years, 3 months ago](https://wordpress.org/support/topic/exclude-the-users-table/#post-3493606)
 * Status: resolved