mysqldump: Got error: 1054

0

I'm trying to do a Dump to do a Database Join. The following 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 picked up such a case?

Screen Capture

    
asked by anonymous 17.10.2017 / 19:28

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
    
17.10.2017 / 21:49