Migrating Joomla from local to production server shows error - Joomla! Forum - community, help and support

i have joomla 2.5 site created locally on machine, i've migrated vps running nginx, php , mysql. here did in order:

1. uploaded joomla files in public_html
2. changed files permission 644 , folders 755
3. imported database.sql mysql using these commands:

--> mysql> create database databasename;
--> mysql> grant privileges on databasename.* username@localhost identified 'password';
--> mysql> flush privileges;
--> mysql> exit
--> user@vps:~$ mysql -p -u username database_name < file.sql

i can see tables inside database already, , changed needed information on joomla configuration.php when open site, error:

code: select all

table 'databasename.s1t3j0s_session' doesn't exist sql=insert `s1t3j0s_session` (`session_id`, `client_id`, `time`) values ('rh249ehb2tbsqkdff34v177d76', 0, '1357339991')

i double checked table , there, tried repairing too.

where did got wrong?

you need "empty" sessions table