following is the that I create dump from mysql database. <pre class="prettyprint"><code>mysqldump -u root tempbkk > ttt.dump </code></pre> but I want to create a dump that exclude one or more file while creating dump from database we select.What is the command for that ?

<code>mysqldump -u user -p some_database > some_database_dump.sql</code>

create dump file from database in mysql

Tags:

mysql

dump

following is the that I create dump from mysql database.

mysqldump -u root tempbkk > ttt.dump

but I want to create a dump that exclude one or more file while creating dump from database we select.What is the command for that ?

797

asked Mar 29 '10 11:03

chetan

1 Answers

mysqldump -u user -p some_database > some_database_dump.sql

118

answered Sep 24 '22 13:09

Eimantas

Related questions
                            
                                right join even if row on second table does not exist
                            
                                Update multiple rows in a single MySQL query
                            
                                How to configure fluent nHibernate with MySQL
                            
                                What does /*!xxxxxx statement */ generated by mysqldump mean?
                            
                                Hibernate Exception on MySQL Cross Join Query
                            
                                Django ORM, group by day
                            
                                Eclipse/MySQL integration plugins? [closed]
                            
                                MySQL: ALTER IGNORE TABLE ADD UNIQUE, what will be truncated?
                            
                                MySQL Views and index use
                            
                                MYSQL SELECT records older than 1 year ago
                            
                                Dropping table makes MySQL hang
                            
                                MySQL - Trigger for updating same table after insert
                            
                                JDBC VS Hibernate [closed]
                            
                                MySQL: Setting sql_mode permanently
                            
                                Creating ENUM variable type in MySQL
                            
                                MySQL INNER JOIN Alias
                            
                                Mysql command line password with special characters is not working
                            
                                Where should I store a foreign key?
                            
                                Using Count to find the number of occurrences
                            
                                sequelize.js TIMESTAMP not DATETIME