i have a database that i want to transfer to a new server. How do i do this please help
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