Re: What is the best way to backup a MySQL Database

On Mon, 2004-03-22 at 14:35, Elliot J. Balanza wrote: > Hi > > I've been trying to use MySQL dump with a php query (since we dont have like > a mysql_dump function) but it's not working. > > Can anyone please point me to a page so i can read a method to backup MySQL > databases to an .sql file using php? > Will exec() with mysqldump work? Do you need to get tabel structure as well or are you just after the data? You can do SELECT * INTO OUTFILE 'file_name' FROM tbl_name if your just after data. -- Brian GnuPG -> KeyID: 0x04A4F0DC | Key Server: pgp.mit.edu ====================================================================== gpg --keyserver pgp.mit.edu --recv-keys 04A4F0DC Key Info: http://gfx-design.com/keys Linux Registered User #339825 at http://counter.li.org