Hi guys, I have a 160mb GZ / 600MB unzipped DB that I need to import. I have tried both bigdump and ssh command and cannot get it to import. The Bigdump comes up with an error in the sql, and the ssh just doesnt do anything. The command Im using in ssh is mysqldump -u user -p dbname > /home/uname/public_html/file.sql Any ideas what I could be doing wrong? Or any suggestions in either, -opening a 600mb text file? (yuck) -Somehow getting the import to work around the error? -Or get ssh to import it. Also, If anyones keen, name the price for you to do it and I will consider it. Cheers all
mysqldump will export the database - what you're looking for is : mysql -u username -p -h localhost data-base-name < data.sql
if i had to import a db that large, and nothing seemed to work, i would split that db into several sections and use bigdump to import one section at a time. file splitter if you so go the split file route, these programs will split the files however you want, but you have to make sure the start and end of each file is formatted properly, it'll leave half a line on the previous and next page so you have to watch out for that.