On Fri, 2002-04-12 at 10:56, Steve Buehler wrote: > I am using PHP to run the following command: > passthru("mysqldump -q -u$userName -p$password -h$hostName $databaseName"); > > The problem is that it puts EVERYTHING on one line and, of course, and > wraps it. I want to be able to dump the dump(schema) of a database onto a > web page so that they can view and/or cut and paste the dump results. > > An other question. How can I make the command automatically try to send it > as a file to the clients computer as an database.sql file so that they can > save it? Like phpmyadmin does. >
Run the data through a regular expression like, $line =~ s/\n/<br>/g; Sorry for the perl description. -Jason --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php