I am trying to move my forum from one directory to another on the same domain. The main reason I am doing this is because the new version of the software works best with php5 and the older database is running a lower version.
The database dump is on the server on the same domain (but in a different folder from the target folder)
The SSH command I am giving to restore the database is as follows: (username and directory names are not real)
mysql -u USERNAME -p NEWDATABASE < /home/.cash/etcetc/ect/forumbackup.sql
However this results in the following error:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Can someone please shed some light on this problem for me and offer a possible solution as well?
PS: One thing I forgot to mention is that the database size is 132MB so it is not possible for me to restore it using phpmyadmin since it only allows 10mb files at a time and copying and pasting the whole db as a query would take me ages!