Question about dumping mysql database

Do not post support requests, bug reports or feature requests. Discuss phpBB here. Non-phpBB related discussion goes in General Discussion!
Get Involved
Post Reply
paknode1101
Registered User
Posts: 16
Joined: Mon Jul 27, 2015 7:11 pm
Name: pak node
Contact:

Question about dumping mysql database

Post by paknode1101 » Wed Jul 29, 2015 1:47 pm

Hello, can any one tell me how can I dump mysql database in phpbb or by using any third party software like mysql dumper which is available on internet. As we must backup database on every day basis so that is why I need such feature or a third party software for doing it.

User avatar
Ger
Recognised Extension Developer
Posts: 1887
Joined: Wed Jan 02, 2008 7:35 pm
Location: 192.168.1.100
Contact:

Re: Question about dumping mysql database

Post by Ger » Wed Jul 29, 2015 2:57 pm

I use Auto Database Backup for this:
https://www.phpbb.com/customise/db/exte ... _backup_2/
My extensions:
Simple CMS, Feed post bot, Avatar Resize, Modbreak, Magic OGP, Live topic update, Modern Quote, Quoted Where (GDPR) and Autoresponder.
Newest: FAQ manager for 3.2

Like my work? Buy me a coffee to keep it coming. :ugeek:
-Available for custom work-

shurijo
Registered User
Posts: 33
Joined: Sun Mar 15, 2015 8:37 pm

Re: Question about dumping mysql database

Post by shurijo » Wed Aug 05, 2015 1:35 pm

I also use the above plugin.

If you want to use a cron job, then you can use the "mysqldump" command. I'm using the above plugin, then also doing hourly dumps via cron job.

mysqldump -c -h $mysqlhost --user $username --password=$password $databasename > outputfile.sql

User avatar
Mick
Support Team Member
Support Team Member
Posts: 21662
Joined: Fri Aug 29, 2008 9:49 am
Location: Cardiff

Re: Question about dumping mysql database

Post by Mick » Wed Aug 05, 2015 2:02 pm

Knowledge Base - Transferring Your Board to a New Host or Domain pretty much explains how to dump and restore successfully.
"The more connected we get the more alone we become" - Kyle Broflovski

Post Reply

Return to “phpBB Discussion”