Loading data into mysql

[ebola100]

I am trying to install PHP Nuke on my computer. At one point they say to

2) Now fill the databases with the tables in nuke.sql file:

mysql nuke < nuke.sql

This isn't working at all for me.

"LOAD DATA LOCAL INFILE "myfile.txt" INTO TABLE my_table;" isn't working either...

Anyone know a way to load data into a mysql database?

Thanks guys.

[dreamcatcher]

Do you have PHPMyAdmin installed? If so, click on SQL and browse for the file and thats it.

[Romeo]

Hmm, you don't give much details ... does it really "not work" without any error messages?

Have you checked, if you should have created the "nuke" databse first before filling?
mysql> create database nuke;

Could it be a permission problem?
mysql --user=root --password=xyz nuke < nuke.sql

To get some more hints about working with MySql you may search Google for the "MySql database survival guide".

Regards,
R.

[ebola100]

well it isn't a login or database creation problem. but thanks for the good resource...i've got some reading to do.

:)