you should try this: on the shell prompt not in mysql prompt--- mydqldump -u username -p db_name>filename.txt
On 4/29/05, 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 > > > > > > 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]<[EMAIL PROTECTED]> > - Your use of Yahoo! Groups is subject to the Yahoo! Terms of > Service <http://docs.yahoo.com/info/terms/>. > > -- Akhil Bansal [Non-text portions of this message have been removed] 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/
