• 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
  • Tim Cooke
  • Devaka Cooray
Sheriffs:
  • Liutauras Vilda
  • paul wheaton
  • Rob Spoor
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • Piet Souris
  • Mikalai Zaikin
Bartenders:
  • Carey Brown
  • Roland Mueller

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]
 
rubbery bacon. crispy tiny ad:
We need your help - Coderanch server fundraiser
https://coderanch.com/wiki/782867/Coderanch-server-fundraiser
reply
    Bookmark Topic Watch Topic
  • New Topic