MYSQL backup question

[John Griffiths <john@capmon.com>]

Hello all,

How do i go about backing up and then recovering a mysql database

i tried

#mysqldump -p --all --add-drop-table foo >/home/john/foo.sql

then to recover

#mysqladmin create -p fooa < foo.sql 

it creates ok but then the php application i run yeilds bad results....