Re: Maximum number of user variables

2005-05-12 Thread Neculai Macarie
> Here is a summary of how I have merged hierarchical data structures in the > past. I start by adding a column or two to my destination data tables for > each table in the tree I need to reconstruct. The first new column (I > usually call it something like "old_ID") holds the original PK of the

Re: Maximum number of user variables

2005-05-12 Thread SGreen
"Neculai Macarie" <[EMAIL PROTECTED]> wrote on 05/12/2005 03:26:33 AM: > > >> Not that I'm aware of. What type of conversions are you doing that you > > >> need 30,000 use vars? An easy solution would be to try it and find out > :) > > > > > > I need to move multiple linked entries (in around 12

Re: Maximum number of user variables

2005-05-12 Thread Eric Bergen
It sounds like you should be doing the link preservation and number update part in php or perl. Neculai Macarie wrote: Not that I'm aware of. What type of conversions are you doing that you need 30,000 use vars? An easy solution would be to try it and find out :) I need to move multi

Re: Maximum number of user variables

2005-05-12 Thread Neculai Macarie
> >> Not that I'm aware of. What type of conversions are you doing that you > >> need 30,000 use vars? An easy solution would be to try it and find out :) > > > > I need to move multiple linked entries (in around 12 tables) from one > > running server to another. I'm using auto_increment's all over

Re: Maximum number of user variables

2005-05-11 Thread Dominicus Donny
- Original Message - From: "Neculai Macarie" <[EMAIL PROTECTED]> To: "Mysql" Sent: Thursday, May 12, 2005 1:20 PM Subject: Re: Maximum number of user variables Not that I'm aware of. What type of conversions are you doing that you need 30,000 use vars? A

Re: Maximum number of user variables

2005-05-11 Thread Neculai Macarie
> Not that I'm aware of. What type of conversions are you doing that you > need 30,000 use vars? An easy solution would be to try it and find out :) I need to move multiple linked entries (in around 12 tables) from one running server to another. I'm using auto_increment's all over the place and I

Re: Maximum number of user variables

2005-05-11 Thread Eric Bergen
Not that I'm aware of. What type of conversions are you doing that you need 30,000 use vars? An easy solution would be to try it and find out :) -Eric Neculai Macarie wrote: Hi! What is the maximum number of user variables that I can have in MySQL ? (I need to transfer a application fro

Maximum number of user variables

2005-05-11 Thread Neculai Macarie
Hi! What is the maximum number of user variables that I can have in MySQL ? (I need to transfer a application from one server to another and I need to rebuild the links between tables with new id's on the new server (I'm using auto_increment extensively), and I have a solution that inv