back up mysql databases.

I have just changed servers and had to create each database and user for each
one manually.

I backed up the data in the databases, but would like to know how i can back
everything.

the username, passwords, data. to a file so if the server went down i can
just run a sql or something to restore the data, or is there a function to do
that in phpmyadmin?

thanks in advance for your help.

The best approach is to use PHPMyAdmin.

When you log in, on the left column, select "Export". Select the databases you
want to export, and the method (XML, SQL, CSV etc).

If you select SQL, you should also set your export type to either "REPLACE" if
you are making incremental backups, and may want to replace any bad records
with a backup, or "INSERT" for full backups for empty databases.

Hope that helps.

hi thank you for your reply.

This is near enough what i am doing at the moment...
but what i would like to do it also backup the database users and their
paswords too so i do not have to create each user and what base they have
access to. i have only just transfered to a new server and thought i have
backed everything up but not the user names and the passwords and login details
for each base, and had to look at each file that needs data to find out the
user names and password to re enter them again. took well over an hour to do
(and no coffee break either!)

can this be done too?