how can i import huge data?

[hehachris]

the maximum size is 2M only...how can i import a .sql which is very large? (i have 1 with 90M)

 

[sky]

I suppose you can upload it via FTP, and create a php script that read the file.
Execute it via a cron perhaps?

Im ot shure, but it will work i think...

Else, long but sure, split the file into litle part

Sky

 

[hehachris]

omg
if split:
90M .sql file
45 partitions!

 

[jmstacey]

It either that, splitting it up or you can increase the max size in the php.ini file. But I wouldn't rcommend that on a live server.

One other option is to upload it via ftp and import the database through the command line.

 

[Icheb]

Contact the provider, and ask them to import it, if you don't have SSH access.

Otherwise you could indeed upload it via FTP, and than import it from the commandline, with the MySQL client program.

My largest import so far was about 400 MB (large forum). Uploading took more time than importing

 

[nobaloney]

Another way would be to write a program to restore the data and upload it as well as the data; then run it from your browser.

Be sure to delete it after you've run it.

Jeff