mysql dump problem - not dumping

[prosad]

hi!

my problems:

1. i can not restore my database
from my command line i type

c:\wamp\mysql\bin>mysqldump -u root csu --opt<c:\wndows\temp\csu_backup

gives me:

/*!40101 SET @OLD_CHARACTER...
/*!40104 ....
dump complete 2007-08-27...

when i check 'csu' database no tables created.
original backup created using mysqldump
working from command line and WAMP server
thks in advance.

[pbmods]

Heya, Prosad.

Is the problem that mysqldump isn't working? Or is the problem that you can't restore the database from a dumpfile.

Did you select a database before evaluating the dumpfile?

[prosad]

Heya, Prosad.

Is the problem that mysqldump isn't working? Or is the problem that you can't restore the database from a dumpfile.

Did you select a database before evaluating the dumpfile?

pbmos,

mysqldump is working, selected database csu and creates tables in 'csu' database but no data dumped into restored tables. tables have no records thoughdump file have records in them.
used phpmyadmin and worked fine though this is not my desired approach

[code green]

mysqldump creates a dump - to a file if required - of a database.
To create a DB from the dump you need mysql.exe

create dump file
c:\wamp\mysql\bin\mysqldump -u root csu --opt >c:\wndows\temp\csu_backup
Restore from file
c:\wamp\mysql\bin\mysq -u root csu <c:\wndows\temp\csu_backup

[prosad]

code green,
thanks. works well.
nothing is simple where knowledege is lacking