Re: [Leopardcrm-development] Web Hosting Provider Installation Help Needed
Brought to you by:
dan_harper
|
From: Dan H. <te...@da...> - 2005-04-12 02:18:25
|
Hi Anthony, I was afraid that that may have been the case. Unfortunately there is=20= no capabilities at the moment for that. Is there a way you can test out Leopard to see if it's what you're=20 looking for? I say that because if you try it and find it useful, I=20 don't mind making a minor release to include the capability to=20 configure a table prefix. Let me know. Cheers, Dan On 12/04/2005, at 12:09 PM, Anthony wrote: > Dan, > > Thank you for your comments. I will try it and let you know. > > By the way, can Leopard be configured to prefix all its tables? > For example: "lpcrm_." MySQL database has over 150 tables > already. Any clues appreciated. TIA. > > Dan Harper wrote: > >> Hi Anthony, >> >> The best way to do it would be to modify the database script that=20 >> comes with Leopard CRM: >> - Remove the line that says "create database leopard" >> - Replace it with "use database xxxx" - xxxx =3D the database name = at=20 >> your hosting provider >> - Then the rest of the script will insert tables into your standard=20= >> database. >> >> NOTE: The only problem I can think of is if you have multiple tables=20= >> of the same name used by another program. Just check through the=20 >> script and make sure, Leopard uses fairly generic table names,=20 >> "customer", etc. so that may be a problem if you want to use Leopard=20= >> alongside another system that has the same table name. >> >> Hope that helps, let me know if I can help further. >> >> Regards, >> Dan >> >> >> On 12/04/2005, at 3:07 AM, Anthony wrote: >> >>> How can Leopard be configured to use existing MySQL database? Web=20 >>> hosting >>> service only provides single MySQL database. Any clues appreciated.=20= >>> TIA. >>> >>> --=20 >>> Anthony >>> www.Pucho.com >>> >>> >>> >>> >>> >>> ------------------------------------------------------- >>> SF email is sponsored by - The IT Product Guide >>> Read honest & candid reviews on hundreds of IT Products from real=20 >>> users. >>> Discover which products truly live up to the hype. Start reading = now. >>> http://ads.osdn.com/?ad_ide95&alloc_id=14396&op=3Dclick >>> _______________________________________________ >>> Leopardcrm-development mailing list >>> Leo...@li... >>> https://lists.sourceforge.net/lists/listinfo/leopardcrm-development >>> >>> >>> >> Dan Harper >> http://danharper.org/ > > > --=20 > > Anthony@pu > > > > Dan Harper Network/Database Administrator PLAN Australia e-mail: da...@pl... phone: +61 3 8622 2222 |