Reload Mysql Server with PHP

[DeepBlerg]

hi all,

i am just wondering, if there is any way of reloading MySQL server with php script. i am logging on as root and have all permissions.

thanx for your time.

 

[fireburner69]

What do you mean Reloading mysql server?

Restart?
Reload with data?
what?

 

[skiflyer]

If they're on the same server just use shell() or exec().

If they're on separate servers you can do the same using rsh calls if they're available to you. Not aware of any direct way to do it through the PHP->MySQL connection.

 

[cLFlaVA]

Take a look at the mysqldump function in mysql.

*cLFlaVA
----------------------------
A polar bear walks into a bar and says, "Can I have a ... beer?"
The bartender asks, "What's with the big pause?

 

[DRJ478]

If you mean reloading the GRANT tables:

http://dev.mysql.com/doc/mysql/en/mysql_reload.html

There is also all different kind of admin commands that can just be sent as a SQL string. Therefore, you might not want to connect to the server as root unless it is from the local system. A certain risk is taken when the superuser can connect from anywhere.
Alternatively create a reload user who has only reload privileges, but no shutdown, delete privs. That would curtail any excessive rights and possible abuse.