How can I backup jforum database (MySQL)

[Migrated From Jforum.net]

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]

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]

mysqldump is your freind in that matter


[originally posted on jforum.net by lazee]

[Migrated From Jforum.net]

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]

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]