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 ?

score 46 · Answer 1 · edited Nov 09 '21 at 01:56

46

mysqldump -u user -p some_database > some_database_dump.sql

edited Nov 09 '21 at 01:56

Sagun Shrestha

answered Mar 29 '10 at 11:33

Eimantas

4

I can't see that this answers the question. – MandyShaw Apr 16 '19 at 07:41
2

should be `mysqldump -u user -p some_database > some_database_dump.sql` – Sagun Shrestha Dec 30 '19 at 18:17

score 22 · Accepted Answer · edited Nov 18 '19 at 08:20

22

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

edited Nov 18 '19 at 08:20

Jitesh Manglani

answered Mar 29 '10 at 11:33

soulmerge

score 1 · Answer 3 · edited Jan 19 '19 at 12:40

1

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

edited Jan 19 '19 at 12:40

issac john

answered Oct 11 '16 at 22:05

Kishore Guruswamy

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! – d_kennetz Apr 15 '19 at 18:52
1

Anyway as far as I can see this does not answer the question. – MandyShaw Apr 16 '19 at 07:40

score 1 · Answer 4 · answered Jan 27 '21 at 13:17

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 '21 at 13:17

Ali Raza

4 Answers4