Re: [phpOpenTracker-general] session_register() & Incorrect key file for table: 'pot_visitors' problem

Andreas Israel <[email protected]> Sat, 16 Jul 2005 12:53:29 +0200
Newsgroups gmane.comp.web.phpopentracker.general
Message-ID <[email protected]>
Hello Jeroen,


>Although I am not quite sure
>how to build a new blank table. 
>
In such cases I use phpMyAdmin (http://www.phpmyadmin.net/). It's a tool 
for webbased mysql-administration. If you don't know it, take a look on 
it. It's the time worth. (To build the blank 'visitor'-table: copy and 
paste the relevant SQL - statements out of 
"phpOpenTracker-1.5.1/phpOpenTracker/docs/sql/mysql/myisam.sql" into the 
formular for the database in phpMyAdmin - it's easy to "learn" the tool).

>What I want to do it to build a completly
>new database.
>This is how I build the current one. Can you confirm that it
>is the right way?
>
>: mysqladmin -h localhost -u root -p create phpopentracker
>: mysql phpopentracker <
>phpOpenTracker-1.5.1/phpOpenTracker/docs/sql/mysql/myisam.sql
>
>
>mysql> INSERT INTO user (Host, User, Password, Select_priv) VALUES
>('localhost', 'phptracker', password('mypassword'), 'Y');
>mysql> GRANT ALL ON phpopentracker.* TO phptracker;
>mysql> FLUSH PRIVILEGES
>  
>
Everything seems to be alright.

Nice Saturday.

Andreas