Win a copy of Pro Spring MVC with WebFlux: Web Development in Spring Framework 5 and Spring Boot 2 this week in the Spring 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
  • Jeanne Boyarsky
  • Liutauras Vilda
Sheriffs:
  • Rob Spoor
  • Bear Bibeault
  • Tim Cooke
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Piet Souris
Bartenders:
  • Frits Walraven
  • Himai Minh

Backup database

 
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,
Help please to learn how to back up database.
How manage to save the data?
My forum is openning all day long after wrong way of shutting (after the light was turned off unexpectedly by accident).
I have JForum 2.1.4
[originally posted on jforum.net by Anonymous]
 
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
Don't use HSQLDB!

Use MySQL.
Version 5.0 is here: http://www.mysql.com

Don't forget check 'UTF-8' when run 'MySQL Server Instance Config Wizard' in Windows!
If use Linux/Unix, add the following 2 lines to /etc/my.cnf :
[mysql]
default-character-set=utf8
........
[mysqld]
default-character-set=utf8

:!:
or indicate this when will create jforum database (as root!):
CREATE DATABASE jforum DEFAULT CHARACTER SET utf8;

don't forget create jforum's user:
GRANT ALL PRIVILEGES ON jforum.* TO 'jforum_owner'@'localhost'
-> IDENTIFIED BY 'password_here' WITH GRANT OPTION;


Good luck! 8)
[originally posted on jforum.net by Novikov]
reply
    Bookmark Topic Watch Topic
  • New Topic