mysql --verbose --host=localhost --user=root -p < 0.2-to-0.3.sql
Note that you should change the host name and user name if they aren't localhost and root. You will be prompted for a password, press ENTER if you don't have a password.
If you plan to initializate your database follow the following steps:
http://[your_host]/[phpMyCatalog_location]/index.phpand then click on the Initialize DB link and follow the instructions. If you can see that link in the phpMyCatalog main index you should check previous steps.
For example, if you install the software in
/var/www/html/phpMyCatalog-0.x.x, your Apache "document root" is
/var/www/html/ (very common) and you host is
localhost, The program can be started by pointing your browser to (see figure 1):
(then bookmark that location, it's much more confortable)
Welcome to the MySQL monitor. Commands end with ; or
Your MySQL connection id is 29 to server version: 3.23.52
Type 'help;' or '
\h' for help. Type '
\c' to clear the buffer.
mysql> show databases; +--------------+ | Database | +--------------+ | mysql | | phpMyCatalog | +--------------+ 2 rows in set (0.00 sec) mysql> quit
You should see your phpMyCatalog database there (in my case it's phpMyCatalog). If you cannot see it, there has been an error in your database initialization, posibly related to mysql user access rights. As you should have seen, the "automatic" database initialization process shows you the command that it's trying to run. If you get errors creating the database, you should attempt to run the command manually from the shell (from phpMyCatalog directory). You my have to change host and user data if they are not localhost/root.
mysql -verbose -host=localhost -user=root -p < initialize.sql
If you can't get the thing running, please post a support request on sourceforge project page by clicking here.