SQL from webpage:

[Daniel]

Hi,

Let's say that I can't log on to the MySQL daemon on the server; Is it
then possible to use the dump-file from mysqldump in a PHP-query so it
can be executed/processed on the localhost? I've tried just pasting the
SQL into a simple query, but it doesn't seem to work. And I can't find
much info about it anywhere. It all requires me to log on or create a
connection from outside localhost ... and I can't.

Thanks,

--
Daniel Henriksen
ds*@vip.cybercity.dk

Soccer Games Homepage:
http://sgh.soccergaming.com

[Aggro]

Daniel wrote:

Hi,

Let's say that I can't log on to the MySQL daemon on the server; Is it
then possible to use the dump-file from mysqldump in a PHP-query so it
can be executed/processed on the localhost? I've tried just pasting the
SQL into a simple query, but it doesn't seem to work. And I can't find
much info about it anywhere. It all requires me to log on or create a
connection from outside localhost ... and I can't.

You can log into mysql from outside the localhost, if you want to. Would
this be a better solution or is there some reason for not doing this?

[Aggro]

Daniel wrote:

Hi,

Let's say that I can't log on to the MySQL daemon on the server; Is it
then possible to use the dump-file from mysqldump in a PHP-query so it
can be executed/processed on the localhost? I've tried just pasting the
SQL into a simple query, but it doesn't seem to work. And I can't find
much info about it anywhere. It all requires me to log on or create a
connection from outside localhost ... and I can't.

You can log into mysql from outside the localhost, if you want to. Would
this be a better solution or is there some reason for not doing this?

[Aggro]

Daniel wrote:

Hi,

Let's say that I can't log on to the MySQL daemon on the server; Is it
then possible to use the dump-file from mysqldump in a PHP-query so it
can be executed/processed on the localhost? I've tried just pasting the
SQL into a simple query, but it doesn't seem to work. And I can't find
much info about it anywhere. It all requires me to log on or create a
connection from outside localhost ... and I can't.

You can log into mysql from outside the localhost, if you want to. Would
this be a better solution or is there some reason for not doing this?

[Daniel]

Aggro wrote:

You can log into mysql from outside the localhost, if you want to. Would
this be a better solution or is there some reason for not doing this?

I know I can and wish I could, but there is obviously a problem allowing
my hostname, so I cannot log on mySQL and access the database. Alas this
may seem to take a while to fix and (having spent some time programming
a new site in PHP) I would very much like to have my site up and running
=) That's why I ask. Hmm, but it doubt I can ... =(

Thanks for your time,

--
Daniel Henriksen
ds*@vip.cybercity.dk

Soccer Games Homepage:
http://sgh.soccergaming.com

[Daniel]

Aggro wrote:

You can log into mysql from outside the localhost, if you want to. Would
this be a better solution or is there some reason for not doing this?

I know I can and wish I could, but there is obviously a problem allowing
my hostname, so I cannot log on mySQL and access the database. Alas this
may seem to take a while to fix and (having spent some time programming
a new site in PHP) I would very much like to have my site up and running
=) That's why I ask. Hmm, but it doubt I can ... =(

Thanks for your time,

--
Daniel Henriksen
ds*@vip.cybercity.dk

Soccer Games Homepage:
http://sgh.soccergaming.com

[Daniel]

Aggro wrote:

You can log into mysql from outside the localhost, if you want to. Would
this be a better solution or is there some reason for not doing this?

I know I can and wish I could, but there is obviously a problem allowing
my hostname, so I cannot log on mySQL and access the database. Alas this
may seem to take a while to fix and (having spent some time programming
a new site in PHP) I would very much like to have my site up and running
=) That's why I ask. Hmm, but it doubt I can ... =(

Thanks for your time,

--
Daniel Henriksen
ds*@vip.cybercity.dk

Soccer Games Homepage:
http://sgh.soccergaming.com

[Aggro]

Daniel wrote:

I know I can and wish I could, but there is obviously a problem allowing
my hostname, so I cannot log on mySQL and access the database. Alas this
may seem to take a while to fix and (having spent some time programming
a new site in PHP) I would very much like to have my site up and running
=) That's why I ask. Hmm, but it doubt I can ... =(

I'm not sure what you are talking about..

Are you able to log in to mysql as root? (From localhost that is)
Do you know about the "grant" syntax? For example...

-----------
This will allow "user" to connect to "database" only from localhost:

GRANT ALL ON database.* TO user@localhost IDENTIFIED BY "password"

-----------
This will do the same, except this allows connection only from example.com:

GRANT ALL ON database.* TO us**@example.com IDENTIFIED BY "password"

-----------
And this allows connection from any address starting with 192.168.0.

GRANT ALL ON database.* TO user@'192.168.0.%' IDENTIFIED BY "password"

-----------
I hope this helps, but I'm still unsure about what the problem is, sorry.

[Aggro]

Daniel wrote:

I know I can and wish I could, but there is obviously a problem allowing
my hostname, so I cannot log on mySQL and access the database. Alas this
may seem to take a while to fix and (having spent some time programming
a new site in PHP) I would very much like to have my site up and running
=) That's why I ask. Hmm, but it doubt I can ... =(

I'm not sure what you are talking about..

Are you able to log in to mysql as root? (From localhost that is)
Do you know about the "grant" syntax? For example...

-----------
This will allow "user" to connect to "database" only from localhost:

GRANT ALL ON database.* TO user@localhost IDENTIFIED BY "password"

-----------
This will do the same, except this allows connection only from example.com:

GRANT ALL ON database.* TO us**@example.com IDENTIFIED BY "password"

-----------
And this allows connection from any address starting with 192.168.0.

GRANT ALL ON database.* TO user@'192.168.0.%' IDENTIFIED BY "password"

-----------
I hope this helps, but I'm still unsure about what the problem is, sorry.

[Aggro]

Daniel wrote:

I know I can and wish I could, but there is obviously a problem allowing
my hostname, so I cannot log on mySQL and access the database. Alas this
may seem to take a while to fix and (having spent some time programming
a new site in PHP) I would very much like to have my site up and running
=) That's why I ask. Hmm, but it doubt I can ... =(

I'm not sure what you are talking about..

Are you able to log in to mysql as root? (From localhost that is)
Do you know about the "grant" syntax? For example...

-----------
This will allow "user" to connect to "database" only from localhost:

GRANT ALL ON database.* TO user@localhost IDENTIFIED BY "password"

-----------
This will do the same, except this allows connection only from example.com:

GRANT ALL ON database.* TO us**@example.com IDENTIFIED BY "password"

-----------
And this allows connection from any address starting with 192.168.0.

GRANT ALL ON database.* TO user@'192.168.0.%' IDENTIFIED BY "password"

-----------
I hope this helps, but I'm still unsure about what the problem is, sorry.

[Aggro]

Daniel wrote:

I'm not able to log in at all. Please bear in mind that I'm not the
server-admin and the only thing I can run on localhost is the PHP-pages
and that's why I was asking if I can use the sql from mysqldump in a
query on one of these PHP-pages ... I'm not able to log in on mySQL (if
I could I could as well use mysqldump to recreate the tables) and I
cannot use any mySQL commands.

Ok now I understand. But I'm not yet sure how or what you are doing with
php. I'm pretty sure you can create tables etc. if you have rights to do
so. I don't know if php have it's own system to do this, so you need to
check

http://www.php.net/

website, or ask from some php related newsgroups. I bulieve the website
has a very good documentation about these things.

[Aggro]

Daniel wrote:

I'm not able to log in at all. Please bear in mind that I'm not the
server-admin and the only thing I can run on localhost is the PHP-pages
and that's why I was asking if I can use the sql from mysqldump in a
query on one of these PHP-pages ... I'm not able to log in on mySQL (if
I could I could as well use mysqldump to recreate the tables) and I
cannot use any mySQL commands.

Ok now I understand. But I'm not yet sure how or what you are doing with
php. I'm pretty sure you can create tables etc. if you have rights to do
so. I don't know if php have it's own system to do this, so you need to
check

http://www.php.net/

website, or ask from some php related newsgroups. I bulieve the website
has a very good documentation about these things.

[Aggro]

Daniel wrote:

I'm not able to log in at all. Please bear in mind that I'm not the
server-admin and the only thing I can run on localhost is the PHP-pages
and that's why I was asking if I can use the sql from mysqldump in a
query on one of these PHP-pages ... I'm not able to log in on mySQL (if
I could I could as well use mysqldump to recreate the tables) and I
cannot use any mySQL commands.

Ok now I understand. But I'm not yet sure how or what you are doing with
php. I'm pretty sure you can create tables etc. if you have rights to do
so. I don't know if php have it's own system to do this, so you need to
check

http://www.php.net/

website, or ask from some php related newsgroups. I bulieve the website
has a very good documentation about these things.