create dump file from database in mysql

Question

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 ?

Sagun Shrestha · Accepted Answer · 2021-11-09 01:56:53Z

58

mysqldump -u user -p some_database > some_database_dump.sql

edited Nov 9, 2021 at 1:56

Sagun Shrestha

1,19812 silver badges24 bronze badges

answered Mar 29, 2010 at 11:33

Eimantas

49.5k17 gold badges134 silver badges173 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

MandyShaw Over a year ago

I can't see that this answers the question.

Sagun Shrestha Over a year ago

should be mysqldump -u user -p some_database > some_database_dump.sql

Jitesh Manglani · Accepted Answer · 2019-11-18 08:20:54Z

22

mysqldump can skip tables, you need the --ignore-table parameter. Check out the manual of mysqldump.

edited Nov 18, 2019 at 8:20

Jitesh Manglani

4856 silver badges12 bronze badges

answered Mar 29, 2010 at 11:33

soulmerge

76.2k20 gold badges121 silver badges160 bronze badges

Comments

issac john · Accepted Answer · 2019-01-19 12:40:08Z

2

mysqldump -u <user> -p<password> --databases <dbname> -r <NameofBackup.sql>

edited Jan 19, 2019 at 12:40

issac john

881 gold badge1 silver badge6 bronze badges

answered Oct 11, 2016 at 22:05

Kishore Guruswamy

2,1311 gold badge14 silver badges5 bronze badges

2 Comments

d_kennetz Over a year ago

Hi! Code only answers are considered low quality on SO; please consider adding an explanation to your code snippet as to improve it for OP and future visitors of the site. Thanks!

MandyShaw Over a year ago

Anyway as far as I can see this does not answer the question.

Ali Raza · Accepted Answer · 2021-01-27 13:17:28Z

1

Simply type this command mysqldump -u user -p database_name_in_database > name_of_file.sql

it will ask password for user. and there you go, your dumb file is ready. on same the location from where you run the command

answered Jan 27, 2021 at 13:17

Ali Raza

4899 silver badges20 bronze badges

Collectives™ on Stack Overflow

create dump file from database in mysql

4 Answers 4

2 Comments

Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related