On Apr 5, 2012, at 9:21 AM, Michael Parson wrote: > On Wed, 4 Apr 2012, Michael Parchet wrote: > >> I have install the mysql5 port. I do a secure installation whith only the >> root user and a password. >> So noe I wold like to run a sql script to create a database. >> I have tried the following command but this last has no effect >> sudo mysql5 -u root -p password script.sql >> Can you help me please ? > > Close, but try this: > sudo mysql5 -u root -p password < script.sql
If "script.sql" does not "create/use" a database you may need to add the database to the command. $ mysql5 -uroot -p -e "create database if not exists dbname;" $ mysql5 -uroot -p dbname < script.sql Regards, Bradley Giesbrecht (pixilla)
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________ macports-users mailing list macports-users@lists.macosforge.org http://lists.macosforge.org/mailman/listinfo.cgi/macports-users