PDA

View Full Version : mysqldump never dump


cgibie
05-01-2007, 06:32 PM
Hey guys, I am trying to dump an existing database data to a new database. I did the mysqldump:

mysqldump -u root -p db2 < db1_backup.sql

I did that, and when I go to mysql prompt to show tables, then select * from table1, I got no result. I am clueless what I did wrong.

Could someone help please?

guelphdad
05-01-2007, 07:11 PM
mysqldump -u root -p db2 > db1_backup.sql

> says to write to a file. you had
< which says bring in from a file