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