Reply to Re: How to import large MySQL data dump using PHP?

Your name:

Reply:


Posted by Petr Vileta on 12/31/06 14:50

"Brian Huether" <bhuetherNO@comcastSPAM.net> píše v diskusním příspěvku
news:Y_ednT4o1NiQLwrYnZ2dnUVZ_rKvnZ2d@comcast.com...
> My webhost does not give me shell access. Normally, I use this sort of
> command on my local machine:
>
> c:\data> c:\mysql\bin\mysql -uroot -pxxxxx db < file.sql
>
> My webhost gives me PhpMyAdmin access, but I can never use that
> successfully with large files. The sql file I need to import is 15MB.
>
Here is problem with php script timeout. Usually webhosting provider set
this option to few seconds only and not allow to change it inside php
script.
Workaround of your problem is to split sql file to few parts and run these
in a right order.
Best way is to change webhosting provider :-)

--

Petr Vileta, Czech republic
(My server rejects all messages from Yahoo and Hotmail. Send me your mail
from another non-spammer site please.)

[Back to original message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация