Hi..
I had used the following command to restore a mysql database on command line.


mysql -u root -p admin test < D:\backup\test.sql


here username-root,password-admin,database-test,backupfile located at-D:\backup\test.sql.

It doesnot working..showing error messages..If anybody knows plz help me.
Thanks

remove the space between the -p and the password.

Thanks for ur help .Now it is solved....I removed the space character

Be a part of the DaniWeb community

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