PDA

View Full Version : Database restore and backup.


dbertrand
06-20-2007, 09:44 PM
How do you backup (and restore) QueWeb database(s) ?

Here's what I tried so far:
- Install QueWeb
- Add "dbertrand" employee
- Open MySQL Administrator (separate install)
- Backed up qwoss and mysql databases
- Uninstall QueWeb
- Install QueWeb again
- Restore databases
- Employee "dbertrand" is not there !? (bad)

What did I miss ?

Note: I'm running under Windows XP.

dantonov
06-28-2007, 01:41 PM
Hello, it seems you didn't restore actual database... I used database backups repeatedly and there was no problem. I would guess that a root of the problem is that MySQL Admin left current database and didn't replace it with old. Please try following troubleshooting:
- stop QueWeb
- drop qwoss database using MySQL Admin or mysql.exe tool
- restore database from backup
- run QueWeb
If you find any problems - please let us now! We will help you as far as possible.