How To Restore Database

[cheesewizz]

Hello there

I've tried to install the lates version of DOTPROJECT version 2.xxx
I just want to restore data I dont want manually typing because i have many data input on the previous version of dotproject

I used PHPMYADMIN to import of the database
when i restore it it gives me some error
that its hard for me to understand

Please check below:

Error

SQL query:

-- phpMyAdmin SQL Dump
-- version 2.8.2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jul 10, 2006 at 05:22 PM
-- Server version: 4.1.12
-- PHP Version: 5.0.4
--
-- Database: `dotproject`
--
-- --------------------------------------------------------
--
-- Table structure for table `billingcode`
--
CREATE TABLE `billingcode` (
`billingcode_id` bigint( 20 ) NOT NULL AUTO_INCREMENT ,
`billingcode_name` varchar( 25 ) NOT NULL default '',
`billingcode_value` float NOT NULL default '0',
`billingcode_desc` varchar( 255 ) NOT NULL default '',
`billingcode_status` int( 1 ) NOT NULL default '0',
`company_id` bigint( 20 ) NOT NULL default '0',
PRIMARY KEY ( `billingcode_id` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =1;


please any one i need help...


thank you

best regards

cheesewizz

[ajdonnison]

You don't mention what the error is, but you shouldn't need to reload the data after an upgrade. Just load the files, making sure your includes/config.php is retained, then run the web-based installer (dotproject/install). Make sure you check the docs.dotproject.net site for details on installing and upgrading.

[nukemizer]

I have found that when users input characters like ' ( don't, thing's, that's and so on...)
anywhere in a task or description area, I will not be able to restore from XML.
of a previous backup to XML.

Is there perhaps something that I have wrong in the configuration
that would prevent restore if special characters are input by users
when adding to DP ?

Thank you to anyone who can offer a suggestion.
Nuke

[caseydk]

Do *not* use the backup module.

Use mysqldump and crontab to back it up... and mysql (or phpMyAdmin) to restore it.

Besides, database backup/restore is not a project management task, it is a system administration task.