Win a copy of Fixing your Scrum this week in the Agile forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Ron McLeod
  • Paul Clapham
  • Rob Spoor
  • Liutauras Vilda
Sheriffs:
  • Jeanne Boyarsky
  • Junilu Lacar
  • Tim Cooke
Saloon Keepers:
  • Tim Holloway
  • Piet Souris
  • Stephan van Hulst
  • Tim Moores
  • Carey Brown
Bartenders:
  • Frits Walraven
  • Himai Minh

How can I backup jforum database (MySQL)

 
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
This will backup all of your MySQL DBs in one pass:

mysqldump -u"user" --password="your_password" -hlocalhost --all-databases --opt --allow-keywords --flush-logs --hex-blob --master-data --max_allowed_packet=16M --quote-names --result-file=BACKUP_MYSQL_ALL.SQL

You can substitute the DB name instead of "--all-databases" to do just one DB.
[originally posted on jforum.net by GatorBait3]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi,
I am a newbie to the MySQL dbms. To backup my jforum data, can I simply copy the database subdirectory under the data directory of my MySQL installation directory after I shutdown the MySQL database server?

Please advise and thanks!
Michael Wu
[originally posted on jforum.net by michaelwu]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
mysqldump is your freind in that matter


[originally posted on jforum.net by lazee]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Thank you all for the information.

The command is right but is still too difficult to me. So, I surfed MySQL website and found that they actually provide a GUI Administrator tool. I downloaded it and gave it a try. It's quite easy to use. Newbie like me should try it first.

As such, adding a backup and restore jforum database command to the Administrator's arsenal seems very important for those like me who have no much knowledge about the underlying database of the system.

Michael Wu
[originally posted on jforum.net by michaelwu]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

michaelwu wrote:As such, adding a backup and restore jforum database command to the Administrator's arsenal seems very important for those like me who have no much knowledge about the underlying database of the system.
Michael Wu



This is something that can be done, but it's a lot more work than it sounds. This is due to the fact that we do support a number of databases.

Beside that, the tools provided for backup/restore by the database vendors will always be more reliable than anything that we can come up with.

But this might be something we can look into one day.


[originally posted on jforum.net by lazee]
 
Good heavens! What have you done! Here, try to fix it with this tiny ad:
the value of filler advertising in 2021
https://coderanch.com/t/730886/filler-advertising
reply
    Bookmark Topic Watch Topic
  • New Topic