How to dump only specific table from MySQL?

Claim your Biolink Click Here
1 like 0 dislike
2.6k views

If my database has 5 tables and I want to dump only 1 table. Is it possible withmysqldumpcommand?

in Education & Reference by (830 points) | 2.6k views

1 Answer

0 like 0 dislike
Best answer

mysqldump -u username -p db_name table1_name > dump.sql

by (4.7k points)
selected by

Related questions

0 like 0 dislike
1 answer
How to dump table structure only from mysql
asked Jul 12, 2018 in Education & Reference by Marc (4.7k points) | 260 views
2 like 0 dislike
1 answer
How to get specific values from a STRING in MYSQL
asked May 12, 2021 in Education & Reference by Sam (1.6k points) | 291 views
0 like 0 dislike
1 answer
how to check mysql table status
asked May 26, 2015 in Education & Reference by Simmi (830 points) | 448 views
1 like 0 dislike
1 answer
SELECT only rows that contain any alphabetic characters in MySQL Table?
asked Mar 31, 2014 in Education & Reference by Yogi (460 points) | 258 views
2 like 0 dislike
1 answer
How to replace the part of the string from one column in mysql databse?
asked May 12, 2020 in Education & Reference by Yogi (460 points) | 217 views
0 like 0 dislike
1 answer
MySQL - Search a string in all fields from every table from a database
asked Sep 6, 2013 in Education & Reference by Asker | 2.0k views
1 like 0 dislike
1 answer
how to take daily mysql backup as a .sql file in linux automatically
asked Sep 30, 2022 in Education & Reference by Krish (1.1k points) | 122 views
0 like 0 dislike
3 answers
How to repair vicidial mysql database
asked Jan 20, 2014 in Education & Reference by Sam (1.6k points) | 1.9k views
0 like 0 dislike
1 answer
How to check Size of Databases [in MB] Mysql
asked Aug 6, 2013 in Education & Reference by Arvind | 740 views

Where your donation goes
Technology: We will utilize your donation for development, server maintenance and bandwidth management, etc for our site.

Employee and Projects: We have only 15 employees. They are involved in a wide sort of project works. Your valuable donation will definitely boost their work efficiency.

How can I earn points?
Awarded a Best Answer 10 points
Answer questions 10 points
Asking Question -20 points

Most popular tags

Related questions

1,312 questions
1,473 answers
569 comments
4,809 users