Backup MySQL via php, in a Symfony application

Question

I'm trying to do a php script to backup my database. Here's what I've tried so far :

$command = "mysqldump -u [username] -p [password] [databasename] | gzip > db.sql.gz";
$this->output = system($command);

How do I get the password and username from databases.yml ?
How can I do a script that sends me the backup file, instead of saving it on the server (à la phpmyadmin) ?

xzyfer · Accepted Answer · 2011-02-23 11:36:37Z

2

You can create a symfony task. If you pass in an environment (i.e. dev, prod) or connection you get access to the Doctrine connection manager and create a connection. You can use that connection to make a database dump or get the connection details from the connection manager.

You can use the doctrine insert sql task as template for your task. I've done similar in the past.

answered Feb 23, 2011 at 11:36

xzyfer

14.2k5 gold badges37 silver badges46 bronze badges

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

7 Comments

Manu Over a year ago

Nice suggestion, but I'd like to be able to do it from everywhere, without having to log in to the server via ssh

xzyfer Over a year ago

Your solution above will still require you to ssh into the server. The only way to do it without ssh'ing into the server is to trigger it from the browser. You can trigger symfony task from in side your action by instantiating the task class. This is exactly what the cli app does.

Manu Over a year ago

I'll look into doing that in the action

xzyfer Over a year ago

Yeah, any symfony cli task can be executed from an action. This has the added bonus of making your code reusable and testable.

Manu Over a year ago

What about the second part of my question, the sending of the file ?

|

Collectives™ on Stack Overflow

Backup MySQL via php, in a Symfony application

1 Answer 1

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related