MySql Backup Script

[joshl_1995]

Hello Community,
I was wondering if there is a way to backup my mysql database.

[diafol]

http://bit.ly/XjAcfd

[Martyn_86]

Kind of have to agree with diafol. Google is your best bet.

However, as you have posed this question within the PHP section;

http://dev.mysql.com/doc/refman/5.1/en/select-into.html

You can use a Mysql query to store your database in a file.

[joshl_1995]

@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.

[diafol]

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.

Maybe: http://stackoverflow.com/questions/2170182/how-to-backup-mysql-database-in-php

This runs an exec() command. Dangerous unless you know what you're doing and the page is bulletproof.