I just moved to DH from possibly the worst webhost on earth. I just painstakingly uploaded our ~300mb site @ 7kbs… not a fun experience. Now I wanna upload the SQL backups. Our site consists of a forum and a PostNuke CMS - we need the SQL content we’ve developed over the last two years.
What I have backed up from the old site are two gzipped files that are between 2 and 4mb each. Inside them are text files that are each 100mb+ (nice compression!). I tried uploading both the .gz and the .txt files in phpMyAdmin to get a timeout 500 error. I figure there’s a limit on uploads, so I looked in the support area… telling me I need to use SSH shell access to do this… is this the only solution? Does anyone else have experience with this kind of thing?
Also, this page:
references this command:
cat filename | mysql -uusername -ppassword -h yourMySQLHostname dbname
does ‘filename’ have to refer to a file on the server, or one on my home machine? Do I reference it to a directory (eg d:/backups/forum.txt) or what?