StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POBackUp MySql Database from CommandLine
text
Body
copied!<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>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload