Hi,I don't know very much about Mysql.
Installation file says:
"Import the files in the sql/ directory into MySQL using 'mysql -uusername -p < file.sql' in the following order:
Optional: user.sql (Note: change the password!) (This is only necessary if you wish to create a separate MySQL user for PHPWebHosting (recommended))
tables.sql
values.sql (Note: change the password!)
Then run this from the command line (while still in sql/):
php values.php
This will create the database, tables, and default values you need."
I didn't get it!
I read a thread about the importing problem but I didn't understand much again.
Well I have an account with a Free Host.
I think that means: I just can upload files and launch php files,I have their "standard" mysql database installation,everything I can do I have to do it by a browser.
I read about a root access to the database.
I think I don't have it (I think it means you launch some admin panel directly or remotly from the server to admin mysql installation package).
Well my database info are:
$sqlhost = 'mysql.host.com'; #MySQL host to connect to
$sqluser = 'username'; #MySQL username
$sqldb = 'username'; #MySQL database. 'phpwebhosting' by default
Can I complete installation by a script or a manual procedure without bothering the admin?
Can I use the script with such kind of mysql installation with a free host or should admin change something with my sql account?
Thanks for your precious help.
Bye,
lastninja@tiscalinet.it
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
You need shell-level access to import the SQL files. This means you can log in to the machine by telnet or ssh. If you don't have that, you'll have to ask the administrator to do it for you. Note that you can access the sql/values.php via a web browser, and it will work, but the .sql files will not.
It is possible to do it by browser only, but it would take a great deal of work and is not at all worth the effort.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Thanks,I managed to do that by phpadmin script.
I copied the commands inside the tables and values files and I pasted them into phpadmin form for manipulating the database.
Now I have a problem with upload,but I'll opena new thread
Bye
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi,I don't know very much about Mysql.
Installation file says:
"Import the files in the sql/ directory into MySQL using 'mysql -uusername -p < file.sql' in the following order:
Optional: user.sql (Note: change the password!) (This is only necessary if you wish to create a separate MySQL user for PHPWebHosting (recommended))
tables.sql
values.sql (Note: change the password!)
Then run this from the command line (while still in sql/):
php values.php
This will create the database, tables, and default values you need."
I didn't get it!
I read a thread about the importing problem but I didn't understand much again.
Well I have an account with a Free Host.
I think that means: I just can upload files and launch php files,I have their "standard" mysql database installation,everything I can do I have to do it by a browser.
I read about a root access to the database.
I think I don't have it (I think it means you launch some admin panel directly or remotly from the server to admin mysql installation package).
Well my database info are:
$sqlhost = 'mysql.host.com'; #MySQL host to connect to
$sqluser = 'username'; #MySQL username
$sqldb = 'username'; #MySQL database. 'phpwebhosting' by default
Can I complete installation by a script or a manual procedure without bothering the admin?
Can I use the script with such kind of mysql installation with a free host or should admin change something with my sql account?
Thanks for your precious help.
Bye,
lastninja@tiscalinet.it
You need shell-level access to import the SQL files. This means you can log in to the machine by telnet or ssh. If you don't have that, you'll have to ask the administrator to do it for you. Note that you can access the sql/values.php via a web browser, and it will work, but the .sql files will not.
It is possible to do it by browser only, but it would take a great deal of work and is not at all worth the effort.
Thanks,I managed to do that by phpadmin script.
I copied the commands inside the tables and values files and I pasted them into phpadmin form for manipulating the database.
Now I have a problem with upload,but I'll opena new thread
Bye