Codezwiz >> Forums >> General PHP Nuke Help >> I can't backup my database anymore

You can also do it by uploading the SQL anywhere on your directories then restoring the database through SSH

command to do so:

mysql DATABASE_NAME < /PATH/TO/FILE.SQL

Make sure your host provided you SSH access, as some hosts don't provide that.

thanks i do believe my host does provide ssh access. Is that done through a web browser or a special program? Sorry I'm a nooB to this

Ok I figured out how to gain shell access to my server. I'm using a program called Putty. Works great!! However I'm still unsuccessful at restoring my database. I've uploaded my sql dump to my new server root and tried to restore it with the following command in ssh.

mysql -h(hostname) -u(username) -p(password) (databasename) <mysqldumpfilename.sql

ok I just discovered that phpmyadmin sucks for backing up and restoring any sufficient size mysql database. I used the SSH on my server to do the sql dump and the SSH on my new server to restore the database. This worked perfectly. I just thought I'd share that! Thanks for the help all!