Software

Ask something
Discussion Locked

Setting Up a Database Using FTP?

0 helpful
1 reply

by c_cmorrow

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I am trying to install PHP-Nuke, and I have a web host that has MySQL (a requirement for PHP-Nuke).

In the installation instructions, it says:

=======
Change to the /sql/ directory and there is a file called "nuke.sql" this file contains the commands to build the database structure, tables and the default data.

1) Create a database called, for example, nuke:
mysqladmin create nuke

2) Now fill the databases with the tables in nuke.sql file:
mysql nuke < nuke.sql

=======

Now my question is, my host, Powweb.com, allows FTP, but no telnet. How should I run this program to set up MySQL?

Any suggestions would be appreciated.

Regards,

CSM

1 reply

by alan rueckgauer

Assuming you have the requisite MySQL environment at your end, follow the instructions, then ftp the file up to the host. I'm a SQL Server guy, so I don't know the specifics of how to get the remote to recognize the db, but it probably involves having the host's admin add it to the server's catalog.

If this needs to be added to an existing db, ftp the db from the host, create the new db (with a different name), import the existing data, then rename the new db to the destination name and ftpthat back. (Again, check with the admin to find out if you can just replace the existing files or if they need to do something for it to work.)

This discussion is closed to new replies.