[URGENT!] Moving my website.

[sanma]

Hello,

I'm moving one of my bigger sites to smokyhosts, but i have some problems...

1) I was using php5, and apparently i can't upload a .htaccess file to the server, so i can't change the handler to read them as php5 files.

2) I can't upload the database, it has 70mb aprox. and i can't do it through phpmyadmin. So someone suggested to do this:

Code: Select all

Upload the .sql file somewhere on your VPS and run the following command through SSH to restore the database.

mysql -u dbusername -p databasename < backup.sql

(replace “dbusername” and “databasename” with your database username and database name respectively; change backup.sql to the file name)

When i do it it asks me for the password of the database... BUT I CAN'T PUT IT!
I can't write when it asks for the password, and then i press enter and it says it needs the password...

3) Even though i can't upload the database yet, when i try to access the forum (I'm using SMF by the way), i get an Internal Server Error: 500... which i don't know if it's normal, but just in case i mention it.

I can't have it offline for a long time, so PLEASE help me :S



Thanks!