I am not able to restore sql file from linux command prompt.
 I have used the below  command. 
 Here is the message.No table is restored. 
 I am running this in my local machine

 adminuser@virtualboximagescom-VirtualBox-34s7dkv4:/$ 
 mysqldump -u root -p  replication_test </home/adminuser/Downloads/rp.sql
 Enter password: 
 -- MySQL dump 10.13  Distrib 5.5.28, for debian-linux-gnu (i686)
 -- Host: localhost    Database: replication_test
 -- Server version    5.5.28-0ubuntu0.12.10.1



/*!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 */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 -- Dump completed on 2012-11-22  5:57:46
 adminuser@virtualboximagescom-VirtualBox-34s7dkv4:/$


 This coming as output and no table is inserted in the database

Recommended Answers

mysqldump creates an sql file. If you wish to import it again you'll need to use mysql

Jump to Post

All 2 Replies

mysqldump creates an sql file. If you wish to import it again you'll need to use mysql

thanks a lot. So simple mistake I could not catch it ..

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.20 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.