Mailing List Archive: IC and MYSQL Assistance required?

IC and MYSQL Assistance required?

Jan 16, 2001, 4:48 AM

Post #1 of 3 (679 views)

Hello List,

I have just about got IC 4.6.1 installed, and have made an attempt at
running makecat.

Since IC uses MYSQL, and my hosting company has MYSQL installed, but I
cannot create a database becaue of permission problems.

Therefore approached the hosting company who say they can create a database
but it will be held somewhere else on there servers and not local to my
virtual space. Thus restricting me configuring IC and administering the
database correctly, and if I was to move to another hosting company the
database gets left behind.

My questions is:

- Is there any other way I can still use IC and MYSQL or any other
opensource database ( that will work with IC - I am prepared to have it
installed local to my virtual space ) , so the I still have administration
access to it.

- Can IC be configured but with no database backend at all.

I would appreciate any guidance list members can offer on this matter.

Thanks to all in advance.

Hans

IC and MYSQL Assistance required? [ In reply to ]

chris at sitemajic

Jan 16, 2001, 8:53 AM

Post #2 of 3 (679 views)

Permalink

>
> Therefore approached the hosting company who say they can create a
> database
> but it will be held somewhere else on there servers and not local to my
> virtual space. Thus restricting me configuring IC and administering the
> database correctly, and if I was to move to another hosting company the
> database gets left behind.
>
But your data should never be left behind. see mysqldump

> My questions is:
>
> - Is there any other way I can still use IC and MYSQL or any other
> opensource database ( that will work with IC - I am prepared to have
> it
> installed local to my virtual space ) , so the I still have
> administration
> access to it.
>

I perfer not to have makecat setup my sql access. I add sql access after the
catalog is running, then restart the IC server. Not sure if this is the best
way- but it is effective is mysql is locked down...

> - Can IC be configured but with no database backend at all.
>
Yep- choose 0 on the SQL part in makecat- as long you have the proper perl
modules installed.

-Chris
> I would appreciate any guidance list members can offer on this matter.
>
> Thanks to all in advance.
>
> Hans
>
>
> _______________________________________________
> Interchange-users mailing list
> Interchange-users@lists.akopia.com
> http://lists.akopia.com/mailman/listinfo/interchange-users
>

Chris Jesseman, President
http://www.sitemajic.net

IC and MYSQL Assistance required? [ In reply to ]

dan at dpcsys

Jan 16, 2001, 12:55 PM

Post #3 of 3 (682 views)

Permalink

On Jan 16, Hansraj Pankhania wrote:
>Since IC uses MYSQL, and my hosting company has MYSQL installed, but I
>cannot create a database becaue of permission problems.
>
>Therefore approached the hosting company who say they can create a database
>but it will be held somewhere else on there servers and not local to my
>virtual space. Thus restricting me configuring IC and administering the
>database correctly, and if I was to move to another hosting company the
>database gets left behind.

As long as they give you full access permissions on the database
you won't have any problems.

mysqldump will give you all the data if you have shell access.

Dan
--
Dan Busarow 949 443 4172
Dana Point Communications, Inc. dan@dpcsys.com
Dana Point, California 83 09 EF 59 E0 11 89 B4 8D 09 DB FD E1 DD 0C 82