mysqldump: Got error: 1044

A Former User

The easiest way to do it is to pop the code into Notepad++ and under Edit select the Indent option and it will do it automatically for you. Then you can just paste it here.

That's a lot of work.. Maybe we can get a GUI option for that.

steve

There we go. Edited it for you.

steve

@thecreativeone91 said:

That's a lot of work.. Maybe we can get a GUI option for that.

Feature requests can be posted directly to the developers over at community.nodebb.org. Posting there directly gets a lot of attention.

technobabble

Thank you @steve for the rewrite. Thanks to @scottalanmiller for the how to!

technobabble

@technobabble said:

Hopefully someone can tell me where I can exclude the "information_schema" database.

technobabble

Does anyone know how I can edit this script to exclude a backup of the "information_schema" database?

technobabble

According to the mysql website "do not dump the table code" is:

--ignore-table=db_name.tbl_name

Does anyone know if I just add that line after the /usr/bin/mysqldump line below?:

for i in $DBNAMES; do
/usr/bin/mysqldump

Interesting...I made a red area in the code area.

JaredBusch

@technobabble said:

Interesting...I made a red area in the code area.

automagic syntax highlighting. it knows that -- is a comment generally when starting a line of text.

JaredBusch

Also, your credentials are in the post.

technobabble

@JaredBusch Thanks man..fixed that.

Do you know where to add the code snippet?