HELP! PHP guys - how do I back up a database????
 

Ok, I want to back up my whole database for one site.
I have FTP access but no phpMyAdmin access, no control panel either.
I want these fields "checked" when expoerting the database:

http://www.6dicksunder.com/hl/db.jpg

I have the dabase name, username, password
I'm guessing this can be done with PHP?

Pseudo PHP code:
connect to the database
export the whole database to a sql file
done


???

Thanks in advance

http://phpminiadmin.sourceforge.net/

Try that - 1 php file, works really good. :thumbsup

Sort of phpmyadmin but lightweight.

Easy, I don't have the code in front of me but easy to google ... just connect and dump to a file ?

Probably better ways but that works ...

install your own phpmyadmin, problem solved...

$query = "SELECT * INTO OUTFILE '$backupFile' FROM $tableName";

you might have a problem with write access ... maybe just email it

downloaded! thanks!!!!!!!!!