sounds strange, but if you do it this way, you should have no problems:
mysqldump test_database > test_database.dump
mysql test_database < test_database.dump
will import everything in test_database.dump into your database..
somehow, you had selected your database, but that got dropped ?
Atle
On Tue, 20 Feb 2001, John Jensen wrote:
>
> 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
>
---------------------------------------------------------------------
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