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

[Antonio]

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:



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

[Sam Granger]

http://phpminiadmin.sourceforge.net/

Try that - 1 php file, works really good.

Sort of phpmyadmin but lightweight.

[2012]

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

[woj]

install your own phpmyadmin, problem solved...

[SmokeyTheBear]

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

[2012]

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

[Antonio]

http://phpminiadmin.sourceforge.net/

Try that - 1 php file, works really good.

Sort of phpmyadmin but lightweight.

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