Uploading mysql database via SSH
I have always uploaded my Magento database via PHPMyAdmin (I know I know, it’s for novices)…but an incident yesterday with SimpleHelix (my current Magento hosting provider) forced me to learn how to import database and use SSH. The whole incident started two days ago when I tried troubleshooting a new Magento installation, as the installation went through fine, but I kept getting error messages when I tried to view the front-end and when I tried logging into the backend; neither worked. Tried googling on the web site for the error message (can’t remember what it was), but found no relevant errors…somewhat surprised, so I figure maybe it’s not a Magento issue.
I logged into the mysql database and I was surprised that my new Magento database only had 100 tables, the default installation should have 200+, so after carefully reviewing the import process, a small text on the phpmyadmin caught my eye: (Max: 102 kKiB)…I was like WTF!!! Contacted SimpleHelix to see if there’s anything they can do, couple hours pass by, they wrote back telling me they can move me to a different server for better performance…but my problem was not performance related, it was a STUPID limitation they put on the server. DO THEY REALLY EXPECT PEOPLE TO ALWAYS BE IMPORTING EMPTY DATABASE?! Simple Helix is simply not sensitive to real business needs.
Simple Helix was having performance issues several weeks ago, but I believe that is under control now…machines they can upgrade, but tech support they haven’t. As much as I want to recommend Simple Helix as my preferred web hosting company for Magento, I just can’t, and won’t until something is changed.
Going off-topic..but just wanted to rant a little bit.
Anyways, what I ended up doing was downloading Putty.exe, and before connecting, FTP my Magento database (.sql file only) to the server. Then connect using putty to my web hosting server and type in the following command:
mysql -u username -p database_name < dumpfile.sql
It worked like a charm. I am back in business. I thank myself for resolving this.
