Help !! How do i backup my database ?

[darkshadow]

I want to move my board to somewhere else,but how do i backup my database ? And how do i put up the database back to my new board ?
Thanks,any help will be appreciated.

[steven]

Do you have telnet access?
If so, use the following command to backup the database

mysqldump -uusername -ppassword databasename > file.sql


Then to restore it, use the following command
mysql -uusername -ppassword databasename < file.sql

So if your username is steven
password is test
database is forums
it would look like the following
to Backup
mysqldump -usteven -ptest forums > file.sql

to restore
mysql -usteven -ptest forums < file.sql

[darkshadow]

ok,thanks.I'll try it