I'm trying to upload a large databse just under 10mb but phpmyadmin is getting timeout error. I've been told by support that SSH is enabled on my server. So can someone give a step by step guide how to use SSH? Which client do I need and what command I have to use to upload my sql file into the database. Thanks.
Your best bet is to upload via sftp or scp and then import from the command line: $ mysql -u root -p mydatabase < mydatabasefile.db Code (markup): If you're running Windows (bleh) there are ssh/scp/sftp clients here.
Thanks. I also found another solution that worked. I used this program SQL Dumpfile Splitter to split the databse into parts of 1mb(it allows you to choose the file sizes) and then uploaded it via phpmyadmin one part at a time. It sure is slower but it works