RE: [PHP-DB] Problem importing large db to mysql in windows

I have several files I import daily using phpMyAdmin, the biggest of which is over 4Mb and it only takes 5-10 seconds, but both machines (my pc-750Mhz Win98 and the server) are on the same network. If you are using dialup to access it, that could be why it is taking longer. Otherwise, I would look somewhere else for the problem. Maureen Biorn Doug Schasteen <dschast@escindex.com> said: > It works great! However, even though my .sql file was only 2.4 mb, it > took nearly 15 minutes to import it all. I expect to be working with > 20mb files in the not too distant future. Will it really take over two > hours? Is this mysql's fault or the fault of my POS 500mhz WinME > machine? Anyone know? > > -----Original Message----- > From: biorn@ebmstpa.com [mailto:biorn@ebmstpa.com] > Sent: Wednesday, August 01, 2001 10:41 AM > To: Doug Schasteen; php-db@lists.php.net > Subject: Re: [PHP-DB] Problem importing large db to mysql in windows > > It sounds like the problem you are having is the same one I had. There > is a > variable in the php.ini called upload_max_filesize that the default max > size > in here is 2Mb, so when importing or exporting a dump file that is over > 2Mb, > it will not work. Try changing this in your php.ini file and see if > that > fixes it. You may need to restart the server that PHPMyAdmin is running > on to > get it to register. Let us know if it still does not work. Thanks. > > Maureen Biorn > > > Doug Schasteen <dschast@escindex.com> said: > > > I'm running a local web server for development on my Win ME machine > > using apache, mysql 3.23.38, and php4. I've been copying my mysql > > database that is online to my local one every once in a while. When > the > > database starting getting greater than 1mb I remember the mysql > > > filename.sql wouldn't work anymore and I had to use mysqldump > > > filename.sql to dump the db to a file. I always used phpMyAdmin to run > > the sql file and import everything to my local db. My problem is that > > now my database is greater than 2mb and phpMyAdmin no longer wants to > > run my .sql file. It just skips straight to "SQL command executed > > successfully" but says "No Tables", so obviously it isn't even trying > to > > run the file. This is almost exactly what was happening on the "dump" > > end before I started using mysqldump. > > > > So, what's the IMPORT equivalent of mysqldump and how do I run it on > > windows? > > > > - Doug Schasteen > > > > > > -- > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > --