MySQL commands (not SQL statements) from PHP

Question

Is it possible to, from within a PHP script, execute the same commands you could with the MySQL client?

I know I could theoretically call 'system' to invoke the mysql client installed on the system, but I am not sure how to avoid interactivity (I don't want a REPL/shell, I just want to fire a command). Is there a way to execute commands via the mysql client without going into the shell? In either case this approach seems a bit sketchy.

To clarify, when I say command I am referring to the follow: http://dev.mysql.com/doc/refman/5.0/en/mysql-commands.html

What command specifically do you want to execute?

ircmaxell
– ircmaxell

2010-09-30 19:42:09 +00:00
Commented Sep 30, 2010 at 19:42 — ircmaxell
– ircmaxell, Commented Sep 30, 2010 at 19:42

zod · Accepted Answer · 2010-09-30 20:11:56Z

1

while ($obj = mysql_fetch_object($res)) {
        $file = $path.$obj->base.".sql";
        $cmd = "rm -f ".$file;
        exec($cmd);
        $cmd = "nice -19 mysqldump -h".$host." -u".$login." -p".$pass." ".$obj->base." > ".$file;
        exec($cmd);
        $sql = "update save_mysql set last_daily=NOW() where base = '".$obj->base."'";
        mysql_query($sql);
}

Are you looking for something like this.

using exec function you can call mysql command`

edited Sep 30, 2010 at 20:11

answered Sep 30, 2010 at 20:02

zod

12.5k25 gold badges74 silver badges107 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Tarka Over a year ago

Could you indent your code 4 spaces? Select the chunk, and click the 1010 button. This will make it nicely formatted and easy to read.

Robin · Accepted Answer · 2010-09-30 19:53:17Z

0

Sounds hacky. There's Expect to handle "programming interactivity", i.e. a way to wait for the prompt to say particular things. I don't think exec will work, unless you can pass specific switches and run mysql in a non-interactive mode. Depending on what you're trying to do I'd say it best to try and figure out a SQL command you can send through the regular client libs.

answered Sep 30, 2010 at 19:53

Robin

4,2801 gold badge22 silver badges20 bronze badges

Collectives™ on Stack Overflow

MySQL commands (not SQL statements) from PHP

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related