I've had that problem before. It's usually a problem with the max upload size set in the php.ini or something.
My suggestion would be, if you can get into the mysql console on the server. Like so: [mike@sherman mike]$ mysql -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 9 to server version: 3.23.43 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> use test; Database changed mysql> source /tmp/hugequery.sql Doing that won't fail you. However, if it's a problem saying "Table already exists" then you will either need to drop all the tables in that database, or re-generate the query, enabling "drop table" statements. Mike Johan Nagels wrote: >Hi, > >I'm trying to import a huge SQL-dump (generated by another program). The >statements are correct because if I excute them one-by-one no error is >generated. However if I upload them all at once (thru phpMyAdmi or Free >Mascon) I always get an error somewhere at te second line. >Btw. in the dump there are 4040 insert-statements, all about 450 chars wide >=> the file is more than 1.8 Mb big. > >Can anybody help me with this asap, coz my boss is waiting... > >tnx, > Johan > > >--------------------------------------------------------------------- >Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail <[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
