Database Schema

[msilverton]

I am trying to setup and online bookmark function, the install directions say:

3) use database_schema.sql to setup your database.

bash$ mysql -u username -p database_name < database_schema.sql

As I do not have shell access, are there docs somewhere that will guide me through the process of using this pre-defined database setup?

Any direction appreciated.

Thanks, Mike

[dgm3574]

Something to try....

That .sql file contains a set of sql statements to be executed.

You could write a PHP file that would open the .sql file and execute each statement in it, after making a connection to your MySQL instance.

OR, you could install phpMyAdmin in your web root, point it at your MySQL database. Then, take each SQL statement in that .sql file, and manually copy & paste it into phpMyAdmin and execute them.

HTH

[msilverton]

Do you think I could setup a CRON job that would accomplish it from the command line?

Mike

[dgm3574]

If your account has access to the mysql commandline tool, you *may* be able to try that. Interesting idea at any rate. I'd ask the tech support folk what the path is to the mysql commandline tool and give it a whirl.

Dave