--- Gordon Stewart <[EMAIL PROTECTED]> wrote: > > Hi there, - if I want to extract all of a MYSQL database - & put it into a > text-file - Is (I'm remembering an 'export' command / query code ?) - is > there a special / quick command to do this ? > > Or do i need to use a SELECT command - & then loop through the results & save > it to a file after ? > > (basically, a comma-deliminated file - No quotes around text... ) > > G
I prefer to use the command-line tool mysqldump to generate an SQL file with the CREATE TABLE and INSERT statements necessary to recreate the table. However, yes there is a SELECT INTO OUTFILE which I think is what you are looking for. You could do it in PHP as well, of course. James _____ James D. Keeline http://www.Keeline.com http://www.Keeline.com/articles http://Stratemeyer.org http://www.Keeline.com/TSCollection http://www.ITeachPHP.com -- Free Computer Classes: Linux, PHP, etc. Spring Semester Begins Jan 31 -- New Classes Start Every Few Weeks. Community email addresses: Post message: [email protected] Subscribe: [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] List owner: [EMAIL PROTECTED] Shortcut URL to this page: http://groups.yahoo.com/group/php-list Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php-list/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
