database backup

i have a database that i want to transfer to a new server. How do i do this please help

Use mysqldump. You will need to read about the options in the documentation, but basically, you can run mysqldump and pipe the output to a text file, which you can use as the complete set of SQL queries and inserts to create the database at the other end.

# mysqldump -u username -h hostname -p databasename > mydatabase.txt