Joomla Database Restoration
Posted on 2009-05-04
I am trying to put an old joomla site onto a new server. I have got all the files transferred and have changed the configuration.php file. I have exported the database and restored it into the new database.
When I go to the website to test it I get this error?
DB function failed with error number 1146
Table 'murraygrey.jos_session' doesn't exist SQL=INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` ) VALUES ( '381c0d213bcc0ba0b3a9ec0ec80b4e2b','1241420564','','0','1','0' )
So I think I have exported the database in a format that isnt compatible with the new database? Is anyone familiar with this procedure? Can I email the details to access the database on the other server to see if someone can export it correctly? Do you think this is the problem?
Could it be the permissions are not set for the user on the new database?