Yesterday, I was having fun writing mysql scripts and importing them.
I would do a drop database and re-import, editing the data in the
script.
Today, I couldn't for the life of me do an import on a mysql export
file, even using commands stored from yesterday, in bash_history.
I am getting errors like:
ERROR 1046 at line 10: No Database Selected.
Line 10 just says "CREATE TABLE Test (" with only comment preceeding,
until I realized that mysqldump was not putting:
CREATE DATABASE Test;
USE Test;
at the beginning, so mysqlimport was useless where the database did
not yet exist. Do I have to manually add those lines to transfer a
dump file to a new machine?
John Jensen
520 Goshawk Court
Bakersfield, CA 93309
661-833-2858
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php