1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

MySQL Problem: mysqldump doesn't work

Discussion in 'Computers, Games, Electronics etc' started by Citizen_Insane, Aug 16, 2005.

  1. Citizen_Insane

    Citizen_Insane Senior Member

    Messages:
    3,698
    Likes Received:
    3
    Joined:
    Jul 24, 2003
    Location:
    Minneapolis
    error:

    mysqldump: unrecognized option `--max_allowed_packet=16M'

    I've reset it like 10 billion times and it still doesn't work. Anyone have any clue WTF is going on?
     
  2. pissedoffsol

    pissedoffsol RETIRED

    Messages:
    49,693
    Likes Received:
    54
    Joined:
    Sep 28, 2002
    Location:
    Retirement Home
    what are you dumping? a table? a db? a query/part of a table?

    what are you using to dump with? command line? phpmyadmin?
     
  3. Citizen_Insane

    Citizen_Insane Senior Member

    Messages:
    3,698
    Likes Received:
    3
    Joined:
    Jul 24, 2003
    Location:
    Minneapolis
    I'm running mysql 4.0.18

    I'm dumping a whole database, that I'm SURE is less than 16mb.

    Its running via commandline on a remote linux box.
     
  4. pissedoffsol

    pissedoffsol RETIRED

    Messages:
    49,693
    Likes Received:
    54
    Joined:
    Sep 28, 2002
    Location:
    Retirement Home
  5. Citizen_Insane

    Citizen_Insane Senior Member

    Messages:
    3,698
    Likes Received:
    3
    Joined:
    Jul 24, 2003
    Location:
    Minneapolis
    I tried, but it gives the error no matter what options I define when I run the program.

    Even if I tell it to redefine max_allowed_packet to 500mb, it still gives the error:



    The fact that it says "unrecognized option" to me means that there is something wrong with the program's understanding of the option...which doesn't make sense.
     
  6. Citizen_Insane

    Citizen_Insane Senior Member

    Messages:
    3,698
    Likes Received:
    3
    Joined:
    Jul 24, 2003
    Location:
    Minneapolis
    well, I found a way arround it. I just found the directory where my databases were stored and renamed the one I wanted to change.

    I still have no clue wtf is going on with mysqldump.
     
Verification:
Draft saved Draft deleted

Share This Page