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!
Scam Warning
Post Reply
Registered User
Posts: 16
Joined: Mon Jul 27, 2015 7:11 pm
Name: pak node

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
Recognised Extension Developer
Posts: 1890
Joined: Wed Jan 02, 2008 7:35 pm

Re: Question about dumping mysql database

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

I use Auto Database Backup for this: ... _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-

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
Support Team Member
Support Team Member
Posts: 21724
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”