MySQL Forums
Forum List  »  Newbie

Creating a dump file
Posted by: Stuckagain
Date: May 22, 2005 08:34AM

Hi there

I'm very new to MYSQL so please forgive my ignorance!

I've created a database with a single table in MYSQL which is fine.

I'd like to create a dump file so that I can upload it to a web host's database but I can't seem to get the syntax right.

I've tried this:

mysqldump -h localhost -u root -ppassword databasename > dump.sql

and I've tried this:

mysqldump databasename > pathtodumpfile

I end up with the -> appearing. If I add ; then the syntax fails.

Could someone let me know where I'm going wrong.

Thanks in advance.

Options: ReplyQuote


Subject
Written By
Posted
Creating a dump file
May 22, 2005 08:34AM
May 22, 2005 11:10AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.