• 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
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

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]
 
reply
    Bookmark Topic Watch Topic
  • New Topic