MySQL Bugs: #6662: Importing mysqldumps can give excessive amounts of warnings

Bug #6662	Importing mysqldumps can give excessive amounts of warnings
Submitted:	16 Nov 2004 10:37	Modified:	3 Mar 2005 16:37
Reporter:	Tobias Asplund	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: mysqldump Command-line Client	Severity:	S3 (Non-critical)
Version:	4.1	OS:	Any (All)
Assigned to:	Lars Thalmann	CPU Architecture:	Any

Description:
Currently notes gets displayed as warnings when importing a mysqldumped file, if you are restoring a backup, for example, you will not trust the import/restore to be correct if you do get warnings, so something should be done for this.

How to repeat:
an example is DROP TABLE IF EXISTS... it'll generate a warning if the table does not exist.

This has now been pushed into 4.1 tree and will most likely be included in 
the next 4.1.11 release.

A new session option SQL_NOTES was introduced.  If this is set, then 
warnings of level NOTES are shows as usual, but if this is cleared, they 
are ignored.  SHOW VARIABLES shows this variable and it is boolean.
When using 'mysqldump' new SET commands are introduced in the dump
making all notes be ignored when applying the dump.

ChangeSet@1.2165.17.2, 2005-02-22 12:40:31+01:00, lars@mysql.com
  BUG#6662: Changes after Guilhems and Sergs review

ChangeSet@1.2165.17.1, 2005-02-21 18:40:28+01:00, lars@mysql.com
  BUG#6662: Importing mysqldumps should not show any warnings of level "notes".

Noted in 4.1.11/5.0.3 changelogs.

Mentioned in SET OPTION, SHOW WARNINGS, and
dynamic system variables manual sections.

http://demo.elefanteinstaller.com/phpbb2/profile.php?mode=viewprofile&u=552
http://www.boredloft.com/Forum/memberlist.php?mode=viewprofile&u=1464
http://www.webdesignforidiots.net/forums/memberlist.php?mode=viewprofile&u=24133
http://forum.mobilecrazed.com/index.php?action=profile;u=64781
http://forum.areabebas.ce.ms/memberlist.php?mode=viewprofile&u=191

https://www.makeoverarena.com/welcome-to-the-month-of-september/

https://www.makeoverarena.com/20-best-gift-ideas-for-wife-in-september/

https://www.makeoverarena.com/best-september-gift-idea-for-husband/

https://www.makeoverarena.com/new-month-of-september-messages/

https://www.makeoverarena.com/new-month-messages-to-your-customers/

https://www.makeoverarena.com/happy-new-month-prayers-for-your-grandfather/

https://www.makeoverarena.com/happy-new-month-messages-for-your-teacher/

https://www.makeoverarena.com/50-happy-new-month-messages-for-your-lover/

https://www.makeoverarena.com/best-collections-of-happy-new-month-messages/

https://www.makeoverarena.com/happy-new-month-wishes-to-your-mother-in-law/

https://www.makeoverarena.com/happy-new-month-wishes-for-new-motivation/

https://www.makeoverarena.com/happy-new-month-messages-for-your-brother-in-law/

https://www.makeoverarena.com/100-happy-new-month-messages-for-your-mom/

https://www.makeoverarena.com/happy-new-month-messages-for-your-pastor-in-april-2023/

https://www.makeoverarena.com/happy-new-month-gift-for-boyfriend-this-year/

https://www.makeoverarena.com/best-high-quality-computer-desks-to-buy-right-now/

https://www.makeoverarena.com/author/successful/

https://www.techfiver.com/how-to-find-the-right-mortgage

https://www.techfiver.com/flood-insurance-how-to-get-flood-insurance

https://www.techfiver.com/flood-insurance-how-to-get-flood-insurance

https://www.techfiver.com/employee-login-for-walgreen

https://www.techfiver.com/employee-login-for-toast

https://www.techfiver.com/employee-login-for-successfactors

https://www.techfiver.com/the-best-cheap-car-insurance-for-2023

https://www.techfiver.com/best-personal-loans-how-to-qualify-and-apply-for-a-personal-loan

https://www.techfiver.com/best-loans-for-bad-credit-for-2023

https://www.techfiver.com/the-best-life-insurance-companies-for-you-this-2023

https://www.techfiver.com/best-health-insurance-companies-2023

https://www.techfiver.com/shoneys-restaurant-how-to-make-shoneys-online-ordering

https://www.techfiver.com/beginners-guide-to-credit-cards-how-credit-cards-operate

https://www.techfiver.com/the-ultimate-guide-to-seo-marketing-in-2023

https://www.techfiver.com/the-5-key-components-of-internet-marketing

https://www.techfiver.com/taco-bells-hours-for-breakfast

Thanks for support, <a href="https://www.neuronimbus.com/solutions/neurotal-talent-management">talent hr solutions</a>

https://www.neuronimbus.com.au/blog/innovation-down-under-how-sydneys-mobile-app-developer...
https://www.neuronimbus.com.au/e-commerce-development-services

https://www.neuronimbus.com/devops-automation-services
https://www.neuronimbus.com/blog/step-by-step-guide-converting-your-website-into-a-seamles...