Mysql dump restore doing some funny stuff

by newbie14   Last Updated September 11, 2019 23:06 PM

I am using linux platform. I also dump the data into a file and I restore into a server and I ran this command

[[email protected] /]# mysqldump -u root -p fms  < /device.sql

The funny part it keep running and this dump only consist of table data and I see other table data being run when I run this command where is the other table data comes from?



Answers 1


I think you meant this:

mysql -u root -p fms < /device.sql 

This will import SQL from /device.sql into the fms database

mysqldump only outputs and is not designed to input anything

Doing this

mysqldump -u root -p fms

will echo the mysqldump all all tables currenly in the fms database

RolandoMySQLDBA
RolandoMySQLDBA
April 25, 2012 18:09 PM

Related Questions




How do you mysqldump specific table(s)?

Updated June 19, 2015 23:02 PM

Backup and restore "mysql" database

Updated September 14, 2017 22:06 PM