MySQL data backup?

Question

I have an database with tons of data in it. I also wrote a new program that will change the data in the database. Is there any way to make a copy of the database before i run my program? Or is there any other solution?

What I'm thiking is making a copy of the database, Run the program, which modified the main database. If things goes wrong, how do I use my copied database data to revert the main database?

Please provide steps and commands on linux. I'm new with the database mysql and its commands.

Offtopic. not a programming question. This is more DBA-related — Marc B
– Marc B, Commented Jul 25, 2016 at 19:07

0xtvarun · Accepted Answer · 2016-07-25 16:51:07Z

1

You can use the mysqldump command to make a backup of your database and overwrite the backup file everytime

mysqldump -u <user> -p <db> > dump.sql

answered Jul 25, 2016 at 16:51

0xtvarun

6986 silver badges19 bronze badges

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

Comments

Amit Garg · Accepted Answer · 2016-07-25 19:00:30Z

0

Read the following link this will tell you how to dump your database via different ways and restore it.

http://www.thegeekstuff.com/2008/09/backup-and-restore-mysql-database-using-mysqldump/

Basic command to dump a single database is:
mysqldump -u root -p[root_password] [database_name] > dumpfilename.sql

answered Jul 25, 2016 at 19:00

Amit Garg

1,2682 gold badges13 silver badges22 bronze badges

Comments

Victor Hugo Montes · Accepted Answer · 2016-07-25 16:49:52Z

0

Is there any way to make a copy of the database before i run my program?

Yes, there's. You have to use the client utility mysqldump before run you app.

It is something like

shell> mysqldump [options] > dump.sql

answered Jul 25, 2016 at 16:49

Victor Hugo Montes

1,3331 gold badge18 silver badges31 bronze badges

Collectives™ on Stack Overflow

MySQL data backup?

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related