Backup, Empty and Import databases with Drush in Drupal.


Create a backup.

drush sql-dump > /path/to/folder/backup.sql

Empty the database tables.

drush sql-drop

Import the tables.

drush sql-cli < /path/to/folder/backup.sql

Useful and Most used mysql commands


See the description of the fields 

DESC atd_order_extras;

Add a new field to an existing table (at the beginning)

ALTER TABLE table ADD field VARCHAR(10) FIRST;

Add a new field to an existing table (after a concrete field)

ALTER TABLE table ADD field VARCHAR(10) AFTER another_field;

Delete a field from an existing table

ALTER TABLE table DROP field;