Bug #10289 http://dev.mysql.com/doc/world-setup.html - USE before SOURCE
Submitted: 1 May 2005 10:00 Modified: 18 May 2005 19:30
Reporter: Kai Voigt Email Updates:
Status: Closed Impact on me:
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version: OS:
Assigned to: CPU Architecture:Any

[1 May 2005 10:00] Kai Voigt
In step 4 at http://dev.mysql.com/doc/world-setup.html, the following command is issued.

mysql> SOURCE world.sql;

Then, the database is changed.

mysql> USE world;

In case the current database is different to "world", the source command will load the data into the wrong table.

How to repeat:
see above

Suggested fix:
Either place an "use world" into the "world.sql" file, or change the database by entering "use world" before the source statement.
[18 May 2005 19:19] Stefan Hinz
Sent a request to fix this to the web team.