Member Avatar for divyakrishnan

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

  • 3 Contributors
  • 3 Replies
  • 272 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by divyakrishnan
Member Avatar for pritaeas

What are the error messages ?

Member Avatar for rch1231

remove the space between the -p and the password.

Member Avatar for divyakrishnan

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.