View Single Post
  #1 (permalink)  
Old 09-16-2003, 02:25 PM
saman140 saman140 is offline
Junior Member
 
Join Date: Sep 2003
Posts: 1
Default error with mysql nuke < nuke.sql;

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
Reply With Quote