Help with the World.sql sample database
Could any one lead me to a true link where I can download the world.sql sample database? Thanks.
I NEED HELP ON 'SOURCE(\.) MYSQL
Hi, I'm very new to this and I need help. What I want to do is to execute a source command statement from cmd to create tables and populate them on a data base that I created in Mysql. Here is what I did at CMD: *I changed the directory from c:\ to mysql *At mysql prompt i used -u root -p that prompted me to give my password. *I put in my password and I was allowed to access the mysql server. *I used the 'the use --database' command and I can see the database I created is active and waiting to be worked on. *then to run the script which is on a note pad with the name create and file type: sql I typed the following at the mysql prompt: *source create.sql; I get the error message '2' and '22' whichever way I tried the source command. I appreciate your help Kebede Teferi
MY PROBLEM WITH THE SOURCE(\.) IS SOLVED
I thank you all who responded to solve my problem in using the source command to execute a mysql script saved on a notepad. Thank you, for your tips, I've solved the problem. When I was using the \.create.sql at the prompt I wasn't giving the full path where 'create.sql' is residing. Once I did, that thanks to you all, I saw my command line streaming with data and finally the result was in my database. Thanks. Kebede
help on loading the world.sql(script and data) onto world database
hi, it's my first time trying my hand in inputting data in batches to mysql database and it drives me crazy, please help. *I've created the WORLD database. *I've downloaded WORLD.SQL and unzipped the file. *When I open it in notepad I see the instructions to create the three tables and the instructions for data insertions. As per the load instruction on MySQL page I did the following within mysql: *mysql use world; *mysql source world.sql; I get an error message 'Can't open the file' error: 2. I tried the following at windows command prompt: *C:\Document and Settingsmysql world world.sql I get the message 'I can't get file specified. I don't have any problem connecting to mysql from windows prompt, and world.sql is a sub folder under Documents and Settings. I know I'm green related to mysql, and I need your help. Thanks - It's here! Your new message! Get new email alerts with the free Yahoo! Toolbar.