how can i import huge data?

hehachris

Verified User
Joined
Nov 24, 2004
Messages
598
Location
Hong Kong
the maximum size is 2M only...how can i import a .sql which is very large? (i have 1 with 90M)
 
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
 
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.
 
Last edited:
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 :D
 
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
 
Back
Top