I am trying to backup a large table and after reading various other answers on this site have tried
mysqldump --user=user --password=password dbname1 tablename | mysql --user=user --password=password dbname2
I get the error
DROP command was denied to user 'user'@'localhost' for table tablename
which scares me. This is the first time I've worked with such a large DB and thus needed to use mysqldump, so I don't know what's going on. Why would it need the DROP command? I want to basically copy the table into another database, not modify (or delete) the existing one in any way.