Backup mySQL databases from localhost running on Wamp server

Question

For a while now I've been trying to automate the backup of some databases I've got running in my localhost. I have a couple of personal apps running on my PC and I would like to back their db's continuously so as not to lose any of that info (because it's not online, so there's always the issue with my PC breaking down or a virus wiping everything out, etc.)

So I've been looking for a way to do this for some time now. I've continuously hit walls due to the fact that this is a local virtual server. But finally I seem to have found a way to do it.

It works perfectly at the output end. I mean, I wanted something that would output the dbs to my Dropbox, for instance, and this works... It outputs a file, alright, but the file is empty, which can only mean it's not able to retrieve the actual data. I've tried several things, including setting the exact path of the SQL data within my Wamp folder, but to no avail.

I'm rather stuck here. Maybe somebody could give me a hand. Thanks!

The PHP I'm using is simple enough, just an ´exec()´ command as you can see below:

exec('mysqldump --user='.$_SESSION['user'].' --password='.$_SESSION['password'].' --host=localhost myDatabase > C:\Users\Xavier\Dropbox\db_backups\file.sql');

does whatever user php is running under have the rights to write into your home directory? — Marc B
– Marc B, Commented Nov 14, 2013 at 22:01
@MarcB Yes, I always run as Admin. Am the only one using the PC. — QuestionerNo7
– QuestionerNo7, Commented Nov 14, 2013 at 22:09
@mb14 I'm not sure what you mean by "setting up a replication." I'm a self-taught coder, so basically still rather an amateur on many things. I'm afraid this is one of them. I don't know what you're referring to. Though I'm looking it up online as I write this! — QuestionerNo7
– QuestionerNo7, Commented Nov 14, 2013 at 22:10
google mysql replication => dev.mysql.com/doc/refman/5.0/en/replication.html. It's a way to synchronize in realtime 2 database, a master and slave, which is pretty much what you are trying to achieve — mb14
– mb14, Commented Nov 14, 2013 at 22:12

QuestionerNo7 · Accepted Answer · 2013-11-14 22:20:49Z

5

OK! So it seems I was able to get it to work.

A little more research and I found this website: See the website

Basically, it told me what path to follow in order to run the mysqldump on the Dbs in my Wamp server and everything was output as expected.

My case is rather specific and perhaps many people don't share this need, but this is the result:

exec('C:\wamp\bin\mysql\mysql5.6.12\bin\mysqldump --user='.$_SESSION['user'].' --password='.$_SESSION['password'].' --host=localhost myDatabase > C:\Users\Xavier\Dropbox\db_backups\file.sql');

By the way, thanks a lot to @MarcB and @mb14 for trying to help me out and posting their comments below!

answered Nov 14, 2013 at 22:20

QuestionerNo7

6306 gold badges14 silver badges31 bronze badges

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

1 Comment

Ram Sharma Over a year ago

Perfect answer it saves my day

Collectives™ on Stack Overflow

Backup mySQL databases from localhost running on Wamp server

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related