Why not copying the data without dump?
# drop new table if exists drop table if exists users_new; # create new table as clone create table users_new like users; # copy data insert into users_new select * from users;