mysql dump problem - not dumping

prosad

hi!

my problems:

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

Quote:

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

gives me:

Expand|Select|Wrap|Line Numbers

 
/*!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

Quote:

Originally Posted by 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?

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

Expand|Select|Wrap|Line Numbers

 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

mysql dump problem - not dumping

re: mysql dump problem - not dumping

re: mysql dump problem - not dumping

re: mysql dump problem - not dumping

re: mysql dump problem - not dumping

Similar MySQL Database bytes

/bytes/development

/bytes/it

/bytes/about