'undumping' a mysql file that has 2 databases in it

[bonosa]

I know how to 'undump' a sql file which has tables specific to a database. Butif my sql file contains several databases (or even just one database) hwo do I stick it into mysql?

I tried mysql < file.sql since for the tables counterpart it is

mysql mydb < fileOfTables.sql

But I couldnt get my databases out into mysql.
How do I do this?

Thanks,
sb

 

[nego78]

You must write into file which tables belongs to which database

use nameoffirrstdatabase;
create table bla ....

use nameofanother database
create table bla2 ....

use nameofotherdb
create table bla3 ....


or if tables belongs to 1 database
you should run mysql like this

mysql -u username -p -D nameofdatabase < file.sql


gry online