On Sun, 9 Feb 2003 16:24:03 -0700, Pamela Hart wrote: >My question is this: I need to input data from a .sql file into an >existing and empty database I have created. > >I type this into terminal at the main command line: mysql -uUser >database_name < filename.sql. > >I keep getting an error message that says no such file or directory >exists. > >I have tried every version of this command I can think of, including >from within the mysql console. >
Where is filename.sql located? To use the .sql file as input as this command is written requires that the file be in the same directory as the mysql program. You can specify a relative or absolute path to filename.sql such as ../sql/filename.sql or /local/mysql/sql/filename.sql >Please help. > Hope this does. Doug --------------------------------------------------------------------- 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
