Transfering a whole DB

[Lightwar6]

Is it possible to copy a complete database from one machine to another fairly easily and quickly. Either by dumping it as a large file or having it transfer remotly right from the mysql prompt?

Thanks

[Sxooter]

It's usually pretty easy. Most databases can do something like this from the command line of the server:

createdatabase dbname
dump_command -h remote.host -d dbname | sql dbname

On postgresql it's:

createdb dbname
pg_dump -h remote.host dbname | psql dbname

[Lightwar6]

Thank you.