Best way to transfer 150MB database?

[Nam]

What is the best way to transfer a 150MB vbulletin database to new domain (same host). I guess PHPMyAdmin won't take the file that big and the only way is probably through Unix command. Would anybody care to give any tips?

Besides the databse, I have around 4GB of files, any help to moving those files would be greatly appreciated too.

[Lynne]

When I transfer the database from one of my servers to the other, I use "scp". A guy that I have hired to do some server work for me before has used "rsync" when transferring the whole site from one server to another. (1 GB database, 6 GB attachments)

[snakes1100]

You can just ftp from one server to the other from a shell, the servers will need ncftp installed on them though, to find out if ncftp is installed just type the following, if it prompts for a u & p, your good to go.

ftp ipaddyhere

If it prompts for a u & p do the following afterwards.

bin (enter)
put (enter)
will ask for filename (be in the same dir as the file)