I was wondering if there is a way to backup my mysql database.
Kind of have to agree with diafol. Google is your best bet.
However, as you have posed this question within the PHP section;
You can use a Mysql query to store your database in a file.
@diafol Really you don't think I tried that. I pretty much looked every where.
The only thing that seemed to work to the way I wanted is to use OUTFILE but I want the file to goto my website directory but I think it's going to the mysql data and I don't have access to it so I can't get the file.
Well, if you were more forthcoming with your question, perhaps we could direct you better.e.g. what have you tried / what failed?
Do you wish to do this via PHP, Linux command line, Windows CL, myPHPAdmin? Need more info.
This runs an exec() command. Dangerous unless you know what you're doing and the page is bulletproof.