mysqldump: Got error: 1054

Asked

Viewed 72 times

0

I am trying to do a Dump to do a Database Merge. Follow command:

mysqldump -u root -p senha -hlocalhost --opt -t --where codemp=1 database > emp01.sql

The same is returning the error

mysqldump: Got error: 1054: Unknown column 'codemp' in 'Where clause' when retrieving data from server

This column exists. Has anyone seen or caught any such case?

Screenshot

Captura de Tela

mysql database

  • Show a print of this table please

  • select this table and display the print

  • try the table name + field, where minhatabela.codemp=1

1 answer

0


I think the problem is that you did not specify the table in the command.

mysqldump -u root -p senha -hlocalhost --opt -t [NOME_DA_TABELA] --where codemp=1 database > emp01.sql

  • There are more than 700 tables, I will have to do for all then?

  • It worked. Thank you very much.

Browser other questions tagged mysql database

You are not signed in. Login or sign up in order to post.