Mysqldump getting error only when trying to output to file

Question

I am using CMD to do a mysqldump. When I run the following command it works fine:

mysqldump -hmyhost -uroot -pmypass mydb

The dump works just fine, however, when it is done, it seems that no .sql file is created for the mysql dump and it just outputs the db data to the screen.

So, I was trying to output the contents to a file using the following command:

mysqldump -hmyhost -uroot -pmypass mydb > C:/mypath/tofile/testdb_dump.sql

But get the following error:

mysqldump: Error: 'Table ' information_schema.files' doesn't exist when trying to dump tablespaces

I greatly appreciate any feedback as to how to resolve this error and backup the db to an .sql file.

Many thanks in advance!

msouth · Accepted Answer · 2016-04-18 18:21:32Z

3

Try mysql -u root -pmypass --opt mydb --no-tablespaces > C:\mypath\tofile\testdb_dump.sql

edited Apr 18, 2016 at 18:21

msouth

88111 silver badges23 bronze badges

answered Dec 20, 2013 at 18:09

Sergi

5753 silver badges16 bronze badges

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

7 Comments

Sergi Over a year ago

Sorry. i wrote it wrong: mysqldump -u root -pmypass --opt mydb > C:\mypath\tofile\testdb_dump.sql

AnchovyLegend Over a year ago

Thanks for the reply. Still getting the same error information_secham.files doesn't exist.

Sergi Over a year ago

What MySQL version are you using?

Sergi Over a year ago

In this link it says

Verified as described: error happens when 5.1 or 5.5 mysqldump tries to backup from 4.1 server. Version 5.0 is not affected.  Workaround: remove this error message from final dump.

. Maybe it is the same problem.

Sergi Over a year ago

Try adding --no-tablespaces.

|

Collectives™ on Stack Overflow

Mysqldump getting error only when trying to output to file

1 Answer 1

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related