PDA

View Full Version : How to pipe an sql source file in MySQL?


iluvafrica
05-22-2003, 01:43 AM
Question: How can the command "source:data.sql" work. It says file cannot be found?

This is after I saved the files in E:\Mysql\data

Background
--------------
I have just set up MySQL,PHP and Apache.

Since I can now manipulate data, both from command and using HTML.

ur help with will be appreciated.

Spookster
05-27-2003, 05:14 PM
What is it that you are trying to do? Are you trying to run sql scripts via command line?

mordred
05-27-2003, 07:43 PM
You should be able to run the SQL statements contained in the file like this (enter this in the mysql prompt):

source E:\mysql\data\data.sql

Watch out that the file is really named like this, because Windows has the annoying tendency to add .txt to files created with notepad.