[Archon-L] problem restoring a mysql database in Archon

[Chris Prom]

Jason,

I'm not sure if I understand correctly--are you trying to restore 
to a database that was created in Archon 1.0?  If so, I would 
think you should install a version of 1.0, do the restore from 
sql file either in archon or phpmyadmin, then upgrade Archon 
using the using the 1.11 install packet.  There are some 
differences in the data model between 1.0 and 1.1, so you cannot 
restore a 1.0 database directly into a 1.1 version of archon. 
But the installer/updater will take a 1.0 DB and transform 
everything to the 1.1 data structure.

Thanks,

Chris

--

Christopher J. Prom
Assistant University Archivist
University of Illinois Archives
19 Library
1408 W. Gregory Dr.
Urbana, IL 61801

phone:	217.333.0798
fax:	217.333.2868
e-mail:	prom at uiuc.edu
web:	http://web.library.uiuc.edu/ahx

On Fri, 15 Jun 2007, Jason Kneip wrote:

> Good morning-
>
> I've having a problem restoring a MySQL database I used last year while testing out Archon and was hoping someone might have some suggestions on fixing this issue. I installed Archon v1.0 last year on a "live" server I have for personal use. I did spend a significant amount of time populating the database, but felt there might be security issues running and editing a liver version of Archon. So I decided to install XAMPP and work off a local machine while I was getting comfortable with the software. I did backup the Archon MySQL database I populated as an SQL file as well as the installed files.
>
> So a few days ago I downloaded and installed Archon v1.1, but have realized my earlier backup procedures lacked some foresight. I cannot figure out how to "swap" for lack of a better term, the newly-created Archon database with my earlier version. And I know I shouldn't have assumed it would be so easy because the Archon database not only contains collection information, but other data that might cause problems with a new installation.
>
> I even contemplated cutting and pasting portions of the SQL file (like INSERT into TABLE...) to re-populate my new installation of Archon as a last resort, but it was too much trouble. I sure wish I'd printed out some of the records so I could just re-type the data into Archon.
>
> Anyway-does anyone have any suggestions on how to re-install Archon using data from an earlier installation's MySQL database? Any ideas would be helpful.
>
> One final point-how are others using Archon backing up their MySQL databases. I know many database admins. use a function/program called "cron" or "pseudo-cron" for this purpose.
>
> Thanks much for any help.
>
> Jason Kneip
> Archives/Special Collections Librarian
> Auburn University at Montgomery Library
> (334) 244-3213
>
>
> _______________________________________________
> Archon mailing list
> Archon at archon.org
> http://archon.org/mailman/listinfo/archon_archon.org
>