On Apr 4, 2012, at 12:14 PM, Michael Parchet wrote: > Hello, > > 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 ?
You should probably take this to a mysql support forum. I do this: $ mysql5 -uroot -p mysql> create database mydb; mysql> use mydb; mysql> system ls; mysql> source script.sql; mysql> show tables; mysql> exit; Your script.sql file may well create a database or has a "use dbname" statement at the top. http://dev.mysql.com/doc/refman/5.0/en/batch-commands.html Regards, Bradley Giesbrecht (pixilla)
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________ macports-users mailing list [email protected] http://lists.macosforge.org/mailman/listinfo.cgi/macports-users
