importing sql files

[s4dadmin]

I did a database dump into a sql file sold I could load the local database to another computer. How do you load/import .sql files?

 

[KarveR]

from the mysql prompt:
windows:
mysql> \. C:/path/to/file.sql

*nix:
mysql> \. /path/to/file.sql

;-)

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

 

[s4dadmin]

Thanks KarveR! Perfect

 

[Dustman]

you can also pipe it in from the shell.. when you run mysql:

c:\mysql\bin\mysql -u username -p databasename < filename.sql

same thing on *nix
$>mysql -u username -p databasename < filename.sql

You can also check out some of the nice gui interfaces.. try mysqlfront at

http://www.mysqlfront.de/

-Dustin
Rom 8:28