Can Shared accounts populate SQL DBs? (without shell access)

[jcarlson]

I always love those SQL/PHP web applications/systems which just automatically create their own DBs and run off and create their own tables, etc. etc.

But for an application I just downloaded, I'm reading the Installation txt file and it has the following:

* Set up the database

On a Unix-like system, the command line tools can generally be used:

- Create a database:
$ mysqladmin -p create dms

- Create and populate the tables:
$ mysql -p dms < sql/mysql/install/structure.sql
$ mysql -p dms < sql/mysql/install/data.sql

- Create the database users
$ mysql -p dms < sql/mysql/install/user.sql

Anyway to get this thing running in phpMyAdmin? I know that we don't have "unix shell" access in the HostGator Shared plans, but is there a work-around of some sort?

Thanks in advance!
- Jamie

[quietFinn]

You create the database and the database user in your cPanel, then you connect to phpMyAdmin and execute those:

sql/mysql/install/structure.sql
sql/mysql/install/data.sql
sql/mysql/install/user.sql

I suppose those are in the installation package.