mysqldump INSERT rows in each line

Posted on 2005-04-16
Last Modified: 2009-12-16


I've noticed that since I have installed "MySQL Distrib 4.1.10" mysqldump is now creating more/all inserts in one "INSERT ROW" like:
INSERT INTO `table` VALUES (1,'something'),(2,'anything'),(3,'everything');

The earlier version did it in this way:
INSERT INTO `table` VALUES (1,'something');
INSERT INTO `table` VALUES (2,'anything');
INSERT INTO `table` VALUES (3,'everything');

I prefer the second one, because it's more helpfull if I want to edit anything and for many reasons, too.
Is there a way to tell "mysqldump" to create for each insert a new row?


Question by:BlueJ
    LVL 17

    Accepted Solution

    In 4.0 all variables was FALSE by default and you could for example use the short -e to start using extended inserts.
    In 4.1 this and several other mysql specific variables are set to TRUE by default.

    If you want to set them to FALSE again you have two choices:
    Either create a default file where you turn of the variables that you choose.

    Or you can use the long variable name combined with a value like this:
    mysqldump --extended-insert=FALSE

    This works for all variables that controls the behaviour of mysqldump which can be found at the end of a "mysqldump --help" listing.

    for more info check out:

    Author Comment


    Thanks akshah123,

    perfect help!


    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Suggested Solutions

    I use MySQL for many of my development projects in a Windows environment. To manage my databases (and perform queries) for years I used a tool called MySQL administrator.  This tool has since been replaced by MySQL Workbench. So I decided to m…
    Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now