Help.. phpmyadmin cant import my sql dump

I followed upgrade instructions for 2.2.3 and backed up my DB using PHPMYADMIN. I completed upgrade and now it is time to reimport the dump and I can't. Looks like my dump is too big for phpmyadmin import. I tried mysql Administrator and that said it couldn't restore mysqldumps. Please help. I am running on windows xp (used otrs win32 installer) on my internal network. I know next to nothing about Mysql so please provide detailed instruction on how to get this dump into the new database. Mysql has default login (root) and no password if that helps. Barry

Make your ³max_allowed_packet² bigger.
Not sure how that goes down in windows land but in my world its located @
/etc/my.cnf
I¹m sure in windows the file is still called my.ini and is probably
somewhere near where it was installed.
Follow this and you may get more info on how to do it:
http://lists.mysql.com/mysql/204790
HTH,
Andy
On 9/18/07 3:36 PM, "* ProfitGrabber Support*"
I followed upgrade instructions for 2.2.3 and backed up my DB using PHPMYADMIN. I completed upgrade and now it is time to reimport the dump and I can¹t. Looks like my dump is too big for phpmyadmin import. I tried mysql Administrator and that said it couldn¹t restore mysqldumps. Please help. I am running on windows xp (used otrs win32 installer) on my internal network. I know next to nothing about Mysql so please provide detailed instruction on how to get this dump into the new database. Mysql has default login (root) and no password if that helps.
Barry
_______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support or consulting for your OTRS system? => http://www.otrs.com/
participants (2)
-
* ProfitGrabber Support*
-
Andy Lubel