<div>
FYI - To specify more than one table to ignore, use the directive multiple times, once for each table. Each table must be specified with both database and table names, e.g. --ignore-table=database.ta<wbr />ble
</div>


FYI - To specify more than one table to ignore, use the directive multiple times, once for each table. Each table must be specified with both database and table names, e.g. --ignore-table=database.table

<div>
<div class="content wysiwyg-content">
<br />
I am using mysqldump --opt -u username -p databasename table1 table2 table3 ... to create a dumo of my database for specific tables.<br />
<br />
However, now, I want to take backup of whole database (55+ tables), except 1<br />
<br />
what is the optimal way to issue the mysqldump without listing 54 table names (excluding one table in the database)
</div>
</div>



I am using mysqldump --opt -u username -p databasename table1 table2 table3 ... to create a dumo of my database for specific tables.

However, now, I want to take backup of whole database (55+ tables), except 1

what is the optimal way to issue the mysqldump without listing 54 table names (excluding one table in the database)

Mysqldump for all except one table

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.