Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

Mysqldump more than one table?

Tags:

mysql

mysqldump

How can I use mysqldump to dump certain tables that start with common prefix?

like image 837
mabuzer Avatar asked Jun 01 '10 11:06

mabuzer

People also ask

How do I dump multiple tables in MySQL?

To dump multiple tables with multiple where conditions. Then, for second table, use ">>". It will append the previous dump file.

Can Mysqldump lock tables?

By default, the mysqldump utility, which allows to back a MySQL database, will perform a lock on all tables until the backup is complete.

Which flag allows you to dump all the database table entries?

To dump large tables, you could combine the following two flags, --single-transaction and --quick .

1 Answers

Hehe, this is kind of a hack, but it works (using bash):

mysqldump -u USER -p DATABASE $(mysql -u USER -p -D DATABASE -Bse "show tables like 'PREFIX%'") > /tmp/DATABASE.out

Change the ALLCAPS words as needed.

like image 73
unutbu Avatar answered Oct 21 '22 21:10

unutbu
Sign in to Comment

Related questions

Unique record mysql on inserts
MySQL Connector/J Replacement [closed]
MySql Select, Count(*) and SubQueries in Users<>Comments relations
MYSQL - Order timestamp values ascending in order, from newest to oldest?
MYSQL subquery SELECT in JOIN clause
MySQL, how to insert null dates
MySQL Convert Bytes to Kilobytes, Megabytes, Gigabytes
Bookshelf.js/Knex.js is too "helpful" with UTC DATETIME columns
mysql order by -id vs order by id desc
'mysqldump' is not recognized as an internal or external command
Cannot select where ip=inet_pton($ip)
Warning in ./libraries/plugin_interface.lib.php#551 count(): Parameter must be an array or an object that implements Countable
how to convert json to string
How to allow fulltext searching with hyphens in the search query
What is the datatype of facebook userid
Pass List<string> Into SQL Parameter
How to read sql query to pandas dataframe / python / django
Create dynamic JSON from foreach
Using the $wpdb in wordpress to run SQL commands
Why does connection to my MySQL server in Azure fail if my app does not have SSL enabled?

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!