[wp-hackers] Database Size

[Ryan Duff]

Podz wrote:
> Databases are getting larger over time, but the ability of phpmyAdmin 
> and the server settings is limiting the size of a file import that can 
> be done. There are also limits on the amount of text that can be pasted 
> as a query. I'm getting a few emails now where the only answer seems to 
> be a long and tedious cut/paste. As the problem will only get worse, 
> anyone got any creative ideas ?


Upload the file via ftp then put in a support ticket with your host and 
have them do the sql import via command line. You can also do this 
yourself if you have shell access on your server. That way you won't be 
limited to the ~60-120 second time out that most hosts limit you to.

-- 
Ryan Duff
http://ryanduff.net
AIM: ryancduff
irc.freenode.net #wordpress