PC Playground  

Go Back   PC Playground > The Core > Scripting/Programming
Register FAQ Members List Calendar Search Today's Posts Mark Forums Read

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 09-16-2003, 01:25 PM
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
  #2 (permalink)  
Old 09-16-2003, 01:53 PM
Administrator
 
Join Date: Jan 2003
Posts: 1,348
Default

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


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT. The time now is 07:27 AM.


Powered by vBulletin Version 3.6.2
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.