Hi guys

i've worked out how to create a database, show a database, and drop a database.

I've been trying to inport a sql file into a sql database.but it dont seem to work.
I got told to source the file with in the dir the sql file sit's.
mysql> source /home/tommytomato/downloads/nuke.sql

here is what i've done.

[root@www bin]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 32 to server version: 3.23.58

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show databases;
+----------+
| Database |
+----------+
| mysql |
| test |
+----------+
2 rows in set (0.00 sec)

mysql> create database nuke;
Query OK, 1 row affected (0.03 sec)

mysql> show databases;
+----------+
| Database |
+----------+
| mysql |
| nuke |
| test |
+----------+
3 rows in set (0.00 sec)

mysql> \q
Bye
[root@www bin]# mysqladmin -u root -p drop nuke
Enter password:
Dropping the database is potentially a very bad thing to do.
Any data stored in the database will be destroyed.

Do you really want to drop the 'nuke' database [y/N] y
Database "nuke" dropped
[root@www bin]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 34 to server version: 3.23.58

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show databases;
+----------+
| Database |
+----------+
| mysql |
| test |
+----------+
2 rows in set (0.00 sec)

mysql>

that was the test add show and drop, so that works.
now the bit i got told i dont quiet understand.



is the source the path to were the sql sits.

[root@www root]# cd /home/tommytomato/downloads
[root@www downloads]# ls
nuke.sql


any one tune me up abit please.

tommytomato

I'm not entirely sure what you are trying to do, but if you are trying to run a series of sql commands in an external file, I tend to do it a bit differently using redirection:

#>mysql -u hangdog -p </path/to/mysqlscript.sql


Once I type in my password, the script runs.

Now if you are trying to load data from a file into a database, you need to investigate the LOAD DATA INFILE sql command.

yer i'm trying to import the sql file into the nuke database.

then i would like to be able to view its contents..


I am alitte lost,

my sql sits in a folder called downloads

so you saying it would be like this

#>mysql -u root -p </home/user/downloads/nuke.sql

then i want to view it see if it worked



tommytomato

O i just tried what you said
and i get this
[root@www downloads]# mysql -u root -p </home/tommytomato/downloads/nuke.sql
Enter password:
ERROR 1046 at line 11: No Database Selected

OK, I think you are confusing a couple of things. If nuke.sql contains data to be loaded into the nuke database, the redirection I showed you isn't going to work. To load data that exists in a file, you need to use the LOAD DATA INFILE command (see the mySQL documentation for the fine details).

Now if nuke.sql contains sql commands that you need mysql to execute, then the redirection should work. You just need to add a little sql code to the top of the file. Since I'm assuming that the nuke database doesn't exist, and you want nuke.sql to create it, you need to create it as the first step. So the first couple of lines of nuke.sql should be:
create database nuke;
use nuke;
Other sql commands you want executed on nuke;

If the nuke database already exists, you only need to use the use nuke; to start nuke.sql.