Having trouble dumping 143 MB file into phpmyadmin. It says it can only do 10 MB files so I would have to split it up into 15 files. But it takes forever to copy and paste with 2.5 million lines of data. Does anyone know any easy way to get this data into my database?
Can you get a shell prompt? In your Cpanel see if you have the option of SSH or Shell access. If so, you can do imports/exports the easy way... mysqldump and mysql < edit: or it may just be faster to call your hosting company, tell them where the data file is, and let them run the import command.. otherwise you are stuck with breaking it up. I've seen someone around here claim to have a PHP script that will import larger files, but it will still timeout I think unless you have the ability to modify the ini timeout values.
Shell (usually only given to the root account) access would allow you to use commands to transfer the file from one server account to another (really fast).
If your on a shared hosting account you won't be able to use SSH, 99.999% of the hosts don't allow it unless you're on a VPS or dedicated box. Maybe you could ask your host to do the transfer for you, it could be done in just a few seconds - whereas it'd take you hours.
If you upload the sql file to the server and give me ftp/mysql details I can do it with a parser I have
You'd be surprised how tightly plaintext can compress. I think Winzip can save as *.gz, but I'm not sure. I use WinRAR which definately can save as gzip. You can download a trial here: http://www.download.com/3000-2250-10007677.html Just looking at my phpmyadmin it says the limit is 51,200kb. Different version I guess.
Usually you should do that big of files through Shell if you ask me! But at least you got the job done!
Agree the guy who created this script is a genious! The script imports records in rows of whatever you choose in the config. This script is a stress saver
Not to get to far off topic, but I've wondered about this as well. Say I'm running cpanel and I want to use shell to get a DB in place. I upload the zipped up DB to the root of the users account, what commands would I use to actually extract it to mySQL? Any kind of example would be great
I know this is already taken care of, but just for the record, Dreamhost allows SSH access for shared servers. You should be able to upload the file via FTP and then log into the server with Putty and import with Mysql's command line tools.