mysqldump -u username -p database_name > backupfile.sql

CREATE TABLE new_table LIKE old_table;

CREATE TABLE new_table (
    id INT(11) NOT NULL AUTO_INCREMENT,
    col2 VARCHAR(50) NOT NULL,
    col3 INT(11) NOT NULL,
    PRIMARY KEY (id)
);

INSERT INTO new_table SELECT * FROM old_table;

DROP TABLE old_table;
ALTER TABLE new_table RENAME TO old_table;

ALTER TABLE old_table MODIFY id INT(11) NOT NULL AUTO_INCREMENT;