SEO

#1 (**permalink**) 02-28-2008, 06:21 AM

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 Settings>mysql 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.

#2 (**permalink**) 02-28-2008, 06:21 AM

Kebede,

Send some example of WORLD contains.

Regards
Juan

On 5/9/07, kebede teferi <kebedeteferi@yahoo.com> wrote:
>
> 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 Settings>mysql 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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

help on loading the world.sql(script and data) onto world database