running scripts in mysql

[Anon]

New to MySQL. I have typed up some commands in my text editor to create some tables... I saved the file as whatever.txt.

How do I call on this file/script from MySQL to be applied to a database? I am running mysqld from a MS-DOS prompt in Windows. Do I call it from the bin/mysqladmin, or do I go into mysql? What are the commands? I want to run the whatever.txt script to the databases called "mynewdb."

Thank you

[[deleted]]

just pipe the file through the mysql commandline tool.

I suggest you read the mysql manual first.

[Anon]

vincent, i was asking what the command was, providing specific file/script name and database name, so that I would get a quick, SPECIFIC response with the command that I need.

your reply was not much help. i did try to find something about it in the MySQL manual... no luck yet.

I am still waiting for help.

Thank you.

[imamf]

alternate #1
1.you can do parsing from mysql_result and write onto some file like "result_script.php" with php function.
2.then you running that script.
3.delete that file.

alternate #2 {I not sure perfect}
1.you can parisng result and stripslashes all
slash quote.
2.running that result as php userdefined function.

I think alternate #1 is the best for U.

radu wrote:

New to MySQL. I have typed up some commands in my text editor to create some tables... I saved the file as whatever.txt.

How do I call on this file/script from MySQL to be applied to a database? I am running mysqld from a MS-DOS prompt in Windows. Do I call it from the bin/mysqladmin, or do I go into mysql? What are the commands? I want to run the whatever.txt script to the databases called "mynewdb."

Thank you

[crislewis]

If you do have PHP, then why not use phpmyadmin which has a neat run query from file function. I use it all the time.

Cheers,

Cris

[Anon]

chris,

I got phpmyadmin, and got it to work. thank you very much.