![]() |
|
|||
|
I installed httpd-2-0-47 ,mysql-standard-l4.0.15 and PHP-Nuke-6.8 for my portal on linux machin.Mysql and apache work fine but iits error when i try create database nuke under /usr/local/sql
[root@localhost sql]# ls nuke.sql [root@localhost sql]# mysqladmin create nuke bash: mysqladmin: command not found [root@localhost sql]# mysql nuke > nuke.sql bash: mysql: command not found It doesnt work in.. /sql but i can create database nuke in the mysql prompt instead [root@localhost mysql]# bin/mysql mysql>create database nuke: Query OK, 1 row affected (0.01 sec) The problem is here ????????? 1) But when i fill the databases with the tables in nuke.sql file: mysql>mysql nuke < nuke.sql; ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysql nuke < nuke.sql' at line 1 please hlep me |
|
|||
|
Usually for me its like this:
mysql -u username_databaseusername -p username_databasename < sqlfileimgoingtoimport password: (enter the password in to the database) IE: mysql -u pcplay_nuke -p pcplay_nuke < nuke.sql The error sort of seems like the error is inside the SQL file you are trying to put into the database. Try a different SQL file. |
![]() |
| Thread Tools | |
| Display Modes | |
|
|