Web Hosting Talk : Web Hosting Main Forums : Hosting Security and Technology : mysqldump Question

[SI-Chris]

Can anyone tell me what the "-a" option is for in mysqldump? I've seen it in use but can't seem to find it in the documentation.

[PersonalJ]

I believe it is the same as --all-databases

http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html

[RoseHosting]

Below is an explanation of using '-a' option with the 'mysqldump' command:

"-a, --all Deprecated. Use --create-options instead."

More information about available options for the 'mysqldump' command you can find by executing the 'mysqldump --help | less'.

[SI-Chris]

Originally Posted by PersonalJihad

I believe it is the same as --all-databases

http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html

That's the uppercase: -A

I'm talking about the lowercase: -a

[david510]

See below.

-a, --all --> Deprecated. Use --create-options instead.

--create-options --> Include all MySQL specific create options.