Why is mysqldump not dumping all data?

Posted on 2009-04-24
Last Modified: 2012-05-06
Im using 5.0.45 community version of mySQL server

It seems like it fogets to put in the INSERT INTO statements for some of the tables.

Maybe its a bug in v. 5.0.45 ?
Question by:loopstudio

    Author Comment

    And if thats the case , of an error, then what version could someone recommend to upgrade to?

    Hopefully to a version so I dont have to change my SQL statements in my whole code again for the 50th time!
    LVL 1

    Expert Comment

    I would suggest you post the command that you're using to do the dump and a snippet of the query you think that is causing the error. Just to be sure, you should be doing something like this... mysqldump -uusername -ppassword databasename tablename > file.txt
    LVL 2

    Expert Comment

    Try this..

    Go to phpmyadmin and create a database.Then click the import button and select the .sql file u having and run it.
    It is working fine for me...How long ur .sql file?

    Author Comment

    majikman: Im doing EXACTLY as You write in your example! :)

    tcs224694: I dont use phpmyadmin, im using ASP and HeidiSQL, But I will try somwthing semilar! yes! I wil ltry create a DB in HeidiSQL and then run the SQL and see what happens :)
    LVL 2

    Expert Comment

    when u click the import there is a browse button which will tell u the max file size...

    Before import check whether ur file siz is less than that...

    U have any doubts just post me back...

    Author Comment

    I am trying it now as we are writing.

    Im not using an import function, but I simply opened the SQL.
    Then it said it was larger than 5 MB and I was asked if i wanted to run it without opening it. I answered yes.
    lets see what happens. Its 14.3 MB.

    The "problem" original was that when I was looking inside of the SQL there were missing a lot of INSERT INTO statements.. as far as I could see.. But ok, now I try actually running the script.

    Author Comment

    Hmm.. The running of the SQL file in HeidiSQL never stopped, so I finally killed it!

    Now I have tried to import with the following:

    mysql -u root -p password database < c:\backup\dumpfile.sql

    BUT.. here nothing came into the db, because when I looked in HeidiSQL the newly created db for the purpose was still empty.

    Oh it can simply not be true.. nor the dump or the restore works.. ;o(

    Any ideas?


    Accepted Solution

    I found the solution myself.
    I upgraded the MySQL server.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Suggested Solutions

    Title # Comments Views Activity
    Query Syntax 5 46
    Python mysql Insert data error 3 48
    move records one table to another 14 36
    MySQL Error 3 0
    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…
    Both Easy and Powerful How easy is PHP? (  Very easy.  It has been described as "a programming language even my grandmother can use." How powerful is PHP?  http://en.wikiped…
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    760 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

    14 Experts available now in Live!

    Get 1:1 Help Now