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