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
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