Cakephp-- Run Sql File in controller

[Dharmender]

I need to upload SQL file and run it in controller in cakephp. I am unable to execute using exec and shell_exec both returns errors i.e. exec given empty string and shell_exec gives null value.

 

How to run mysql command using exec or shell_exec

[boompa]

What a horrible idea this is! Letting someone execute arbitrary SQL code against your database? Good gravy!

[Jessica]

You can't execute an sql file, you can use the mysql commands to use loadfile.

 

But yes, this is a horrible, horrible idea.

[Dharmender]

My client wants to have backup and restore facility online.

 

I have made online backup sql file.

 

Now I want to allow user to upload sql file.

 

 

You can't execute an sql file, you can use the mysql commands to use loadfile.

 

But yes, this is a horrible, horrible idea.

 

[DaveyK]

My client wants to have backup and restore facility online.

 

So write code that allows him to without the security hazard ?