Original Post
Hi there I got tired of having to create tables within my database by hand, so Ive tried to give file redirection a go. Basically ive got a Database called books (which ive already created) and an sql file called booktable.sql. My aim is to use the contents of booktable.sql to create and update the tables rather than have to do it all by entering everything by hand using the command line mysql. The file booktable.sql is currently in the 'bin' directory along with the mysql exe, and I have tried the following commands..... \. booktable.sql (returned the message : ERROR : Failed to open the file 'booktable.sql', error 2 AND mysql -u USERNAME -d books -p < booktable.sql (returned the error message the system cannot find the file specified) Do you guys have any suggestions?