MySQL Installation

Submitted by washyk on Fri, 03/19/2010 - 11:04
in

My intern and I are attempting to load in AT. Previous to this, one of our IT guys had tried and never got past MySQL. From what we can tell, MySQL was downloaded but not the admin download. So, we went to download the admin, using the link on the page http://archiviststoolkit.org/support/CreatingBlankDatabase. This took us to a website that was for MySQL Workbench 5.1. So, we download that and this is where we are stuck. We tried to create users but can't seem to figure out how to do the privileges.

Can anyone help us?

Kathleen Washy
UPMC Mercy Archives
Pittsburgh, PA

‹ Linux installation Recommended Server for MySQL Database ›

Hi, Kathleen, I believe your

Submitted by annie_ucsd on Fri, 04/02/2010 - 10:56.

Hi, Kathleen,

I believe your questions was answered on atug, but just in case, i'll post here too.

The AT application is designed to run with the community versions of MySQL (MySQL version 5.x and above). Here’s the link to download:
http://www.mysql.com/downloads/

And the link for step-by-step information on installing the backend db server is at:

http://archiviststoolkit.org/support/InstallingDatabaseServer

Best wishes,
Annie

Problem while creating database

Submitted by jk on Thu, 04/01/2010 - 11:30.

Hello,
Il have a problem while creating the database with the maintenance program 2.0 : "specified key was too long max key length is 1000 bytes"
I am working with windows XP and WAMP release
As it is said on your website, I have uncommented the part concerning innodb.
Mys sql.ini file is as follows :
-----------------------
default-storage-engine=INNODB
skip-innodb
innodb_additional_mem_pool_size=2M
innodb_flush_log_at_trx_commit=1
innodb_log_buffer_size=1M
innodb_buffer_pool_size=15M
innodb_log_file_size=10M
innodb_thread_concurrency=8
------------------------------------------
Do you have an idea ?
Thank you

Jacques Kergomard