mysql creation script

wxdqz

New Member
I am installing an open source website package called phpwebsite that uses a mysql database. Among the files, there is a file named phpwebsite.mysql. According to the documention for mysql, this is a 'script' for batch loading a database into mysql.

The problem is that I have tried to enter the proper commands in my telnet client to get it to work and it won't. I have tried the following:

mysql> use mydatabase
mysql> < phpwebsite.mysql

The only response I get is:

->

Then I tried what the doc for mysql suggested:

mysql -u username -ppassword database < phpwebsite.mysql

It responded with:

Cannot Open phpwebsite.mysql

I also tried renaming the file with just .sql.

So, how can I get this to work? Where should the file phpwebsite.mysql be on my account. I have a virtual account with Communitech.net if that helps. I have the file in the directory for the package and in the main html directory.

Oh, and I also tried copying the contents of phpwebsite.mysql and pasting it into my telnet client and 2 tables were created along with many many errors.

I am stuck. Please help me. Thank you.

Jonathan
 
Back
Top