Database development work is usually done on a local machine and when complete, the database is transferred to a production server. When using MySQL, the best way to do this is to use the mysqldump program, one of the numerous programs that are part of the MySQL package. As a developer, you may find that this program is second only to the mysql command in usefulness.