Perfect Presence Server Switch Mysql

[chapt0r]

I recently signed up for perfect presence server to host my board, Unfortunatly I am still on my old Win2k box. I am able to back that up, but how can I restore it to the new one. (LINUX) I have tried to use the "mysql -uusername -p database < /path" command in the phpadmin section and I always recieve a syntax error. They also recently gave me SSH access but I am used to, cd mysql/bin and running the mysql manager. then inputting the above command. I am new to a Linux server obviously, but trying to figure it out. Any thoughts or places to for me to check out?


Chap

[eva2000]

you have to run the import command via SSH enabled telnet client such as Putty http://www.chiark.greenend.org.uk/~sgtatham/putty/ or SecureCRT http://www.vandyke.com/products/securecrt/ and not phpmyadmin

or if using cpanel from the SSH telnet within cpanel control panel

to restore

mysql -u mysqlusername -p vbdatabasename < /path/to/backup.sql

further reading:
- http://mysql.he.net/doc/m/y/mysqldump.html
- http://i4net.tv/marticle/get.php?action=getarticle&articleid=10
- http://www.webmasterbase.com/article/678