title: BackUp MySql Database from CommandLine
body: <p>I am able to backup mysql database via command line by executing the below :</p>
  
  <blockquote>
    <p>C:\MySQL\MySQL Server
    5.0\bin\mysqldump\" -uroot -ppassword sample > \"D:/admindb/AAR12.sql\"</p>
  </blockquote>
  
  <p>But there is no DROP and CREATE database queries in my .mysql file</p>
  
  <p>What should i add in the syntax to get the create info to my generated .sql file ?</p>
  
  <pre><code>    -- MySQL dump 10.11
  --
  -- Host: localhost    Database: sample
  -- ------------------------------------------------------
  -- Server version   5.0.67-community-nt
  
  /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  /*!40101 SET NAMES utf8 */;
  /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
  /*!40103 SET TIME_ZONE='+00:00' */;
  /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
  /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
  
  --
  -- Table structure for table `awss_red_force`
  --
  --
  
  DROP TABLE IF EXISTS `awss_red_force`;
  SET @saved_cs_client     = @@character_set_client;
  SET character_set_client = utf8;
  CREATE TABLE `awss_red_force` (
    `int_scenario_id` int(11) NOT NULL,
    `str_entity_name` varchar(100) default NULL,
    `str_hla_type` varchar(30) default NULL,
    `str_parent_name` varchar(100) default NULL,
    `dbl_x` double default NULL,
    `dbl_y` double default NULL,
    `dbl_z` double default NULL,
    PRIMARY KEY  (`int_scenario_id`),
    KEY `awss_red_force_ibfk_1` (`int_scenario_id`),
    CONSTRAINT `awss_red_force_ibfk_1` FOREIGN KEY (`int_scenario_id`) REFERENCES `scenario` (`int_scenario_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  SET character_set_client = @saved_cs_client;
  
  --
  -- Dumping data for table `awss_red_force`
  --
  
  LOCK TABLES `awss_red_force` WRITE;
  /*!40000 ALTER TABLE `awss_red_force` DISABLE KEYS */;
  /*!40000 ALTER TABLE `awss_red_force` ENABLE KEYS */;
  UNLOCK TABLES;
  </code></pre>