[EventCalendar] Moving the database help ...

[Damon]

Hello - still trying to trouble shoot my "ERROR 2013 (HY000): Lost
connection to MySQL server during query" when restoring a backed up
database to a different server and enabling the eventCalendar plugin
(site works with plugin disabled).  I did some more trouble shooting
...

I have two sites with the eventcalendar plugin; one is local powermac
and one is public server.  I
attempted to backup both (using terminal and using the "backup
plugin")  and use both on the new
location (a linux server) -- both failed.  However, I was able to
backup from the public server and run it on my older PowerMac (the
"local" mentioned above).  This worked!  I didn't actually restore a
site, but am using the following SQL query to test it:

SELECT DISTINCT * FROM wp_posts WHERE 1=1 AND (post_date_gmt <=
'2006-09-09 12:23:59' AND id NOT IN
(-1,3,4,6,7,8,9,22,28,29,30,38,39,40,41,42,43,47,48,50,51,52,53,54,55,56,57,58,59,60,61,62,63)
) AND (post_status = "publish") AND post_status != "attachment" GROUP
BY wp_posts.ID ORDER BY post_date DESC LIMIT 0, 10;

On the powermac these queries work from the backup files; on the linux
machine they do not.    The only difference in steps I am taking is
that 1. my username and passwords for the mysql databases are
different on my mac and on my linux box; 2. on my mac I use "root" as
the user but on the new linux server I use "damon"; 3. that the public
and local servers (older) are using mysql version 4.x wherease the new
linux server is using 5.x

Do you think that the query would trip because of the mysql version ?
I even tried enabling the root user on my linux box and going that
route but still no luck!

any thoughts ?

Thanks,
Damon


On 9/7/06, Darrell Schulte <d at schulte.mn> wrote:
>
> On Sep 7, 2006, at 4:49 PM, Damon wrote:
>
> > Hi - where can I download the latest beta of eventcalendar ?  I tried
> > moving my database a second time to a new system (ensuring the plugins
> > were disabled) but when I move to the new system and begin enabling
> > plugins I am getting the "lost connection" error in mysql when I come
> > to eventcalendar still... I am wondering if maybe a newer version of
> > this program would fix the problem (the problem is included below).
>
> Damon,
>
> Here ya go: http://sourceforge.net/project/showfiles.php?group_id=176316
> Or, for the daring, subversion: http://sourceforge.net/svn/?
> group_id=176316
>
> Darrell Schulte
> http://schulte.mn
>
>
>
> _______________________________________________
> EventCalendar mailing list
> EventCalendar at firetree.net
> http://penguin.firetree.net/cgi-bin/mailman/listinfo/eventcalendar
>


-- 
"In Search of #6", a travelogue & memoire  by Damon Timm
available for free online as an audiobook / podcast or to read at:
http://www.damonjustisntfunny.com