Help.. phpmyadmin cant import my sql dump

The info from link was over my head. I did try ini change you suggested. I made the change in my.ini file. I set it to a size larger than the dump file (file is 29m I set it to 31m). I still can not import using phpmyadmin. I have been told phpmyadmin has trouble with large file. Is there another gui program I can use, or can someone please provide the mysql command I can use in windows command prompt. -barry
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

* ProfitGrabber Support* wrote:
The info from link was over my head. I did try ini change you suggested. I made the change in my.ini file. I set it to a size larger than the dump file (file is 29m I set it to 31m). I still can not import using phpmyadmin. I have been told phpmyadmin has trouble with large file. Is there another gui program I can use, or can someone please provide the mysql command I can use in windows command prompt.
You need to raise the max_allowed_packet for both the server and the
client. And then don't go through phpMyAdmin or you'll also have to
deal with a PHP's memory/upload/etc. limits. On Linux I'd set a big
enough value for max_packet_size (say, 50M) in /etc/my.cnf (don't
know where you'd do this on Windows), restart the MySQL server and
then issue a command like this:
# mysql --max_allowed_packet=50M db_name < db_dump.sql
If the dump file contains a CREATE statement you leave out the
db_name of the command (as it doesn't exist yet, but the dump file
will create it). See the 'Packet too large' docs:
participants (2)
-
* ProfitGrabber Support*
-
Nils Breunese (Lemonbit)