Hi!
On Aug 01, Maciej Bobrowski wrote:
>
> Hi,
>
> I want to backup some data from a database. In previous releases when I
> backuped a database to a file I got inserts each in one line, separated
> with semicolon. It was very comfortable, because I could very easy edit
> the file, change something and give it to the database. Now after the
> backup the file is very weakly readable. It works of course but it is not
> as convenient as before (in previous releases). Now INSERTS to tables
> looks like:
>
> INSERT INTO table VALUES (values1), (values2), ... (valuesN);
>
> I want something like that:
>
> INSERT INTO table VALUES (values1);
> INSERT INTO table VALUES (values2);
> ...
> INSERT INTO table VALUES (valuesN);
>
> Of course I can write a script which will do it, but meybe there is an
> option to the mysqldump? I tried --complete-insert and omitted the
> --extended-insert option, but it doesn't work.
>
> How can I do this?
% mysqldump --help
...
--opt Same as --add-drop-table --add-locks --all --quick
--extended-insert --lock-tables --disable-keys. Enabled
by default, disable with --skip-opt.
Regards,
Sergei
--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
