restoring multiple databases

[formasfunction]

So I used phpMyAdmin to export about 6 databases into on .sql file. All of the tutorials I've read about restoring databases talk about restoring into a current db. If I have 6 dbs in the file, what is the correct restoration command? I'm working the restore on the command line, not phpMyAdmin. I know this command:
mysql -u [username] -p [password] [database_to_restore] < [backupfile]
but obviosly I there isn't just one "database to restore" in my .sql file, there are 6. Any help would be greatlly appreciated.

Thanks,
Greg

 

[KarveR]

mysql -u root -p

enter the password when prompted

mysql> \. /path/to/file.sql

and watch it go.

______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.

 

[formasfunction]

Thanks a bunch! One more quick question, what is the path that mysql takes? When I'm in "mysql>" is the path from the location of mysql or from the root? I running RedHat Linux so the path to mysql is /usr/bin/mysql. If I put the file in /usr/bin/file.sql does that mean I write the code as follows:

mysql> \. file.sql

OR

mysql> \. /usr/bin/file.sql

Thanks in advance.

--Greg

 

[KarveR]

fully qualified path of the file :
/usr/bin/file.sql

______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.

 

[KarveR]

oh, sidenote 3 .. engage brain .. you may well need to enclose file and path in single quotes:

'/usr/bin/file.sql'

______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.