At 12:06 +0200 3/7/02, Egor Egorov wrote: >Josiah, >Thursday, March 07, 2002, 8:18:58 AM, you wrote: > >JW> I know how to inport a .sql file into mysql by using mysql -u username -p >JW> password < filename.mysql(sql) but how do you import one that is >made to go >JW> into a database you already have created? Would the command by mysql -u >JW> username -p password < dbname filename.sql(mysql) > >Justa redirect the standard input from a file: > >mysql database_name -u username -p password < filename.sql
1. The database name goes after the options, not before. 2. There can't be any space between -p and the password. mysql -u username -ppassword database_name < filename.sql > >JW> Josiah Wallingford --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
