RE: [PHP-DB] Problem importing large db to mysql in windows
> 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 Since you're using relatively recent version of MySQL might I suggest you setting up the MySQL replication system (chap 11 in the manual if I remember correctly). You don't have to be constantly receiving updates however if setup correctly you can use the LOAD table FROM master command to grab the most recent copy of the table you want in a single command. Sincerely, Craig Vincent -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, August 01, 2001 10:41 AM > To: Doug Schasteen; [EMAIL PROTECTED] > 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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > -- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] Problem importing large db to mysql in windows
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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 01, 2001 10:41 AM To: Doug Schasteen; [EMAIL PROTECTED] 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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]