|
|
Posted by jdbartlett on 08/13/07 20:29
On Aug 13, 3:23 pm, rebecca...@gmail.com wrote:
> Usually, I log into phpMyAdmin to export the entire SQL DB. Is there
> any separate PHP code way to do this without logging in there?
You could call mysqldump from the command line. If you have a large
database to export, you may want to compress it, too. Assuming you
use Linux, the command will look something like this:
mysqldump --compact --compress -uYOURUSERNAME -pYOURPASSWORD
DATABASENAME | gzip --best > FILENAME
Navigation:
[Reply to this message]
|