Link to home
Start Free TrialLog in
Avatar of Amanda Watson
Amanda WatsonFlag for Australia

asked on

Joomla Database Restoration

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?
jtablesession::Store Failed
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?

Avatar of davidsperling
davidsperling

Don't know joomla but...

Error: 1146 SQLSTATE: 42S02 (ER_NO_SUCH_TABLE)
Message: Table '%s.%s' doesn't exist


http://dev.mysql.com/doc/refman/5.0/en/error-messages-server.html

How did you do the backup/restore? Mysqldump or MysqlAdministrator? Maybe you should try the other one :-)

Hi

Did you exported database using phpMyAdmin

Thanks
ASKER CERTIFIED SOLUTION
Avatar of tcs224694
tcs224694
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Amanda Watson

ASKER

That fixed it!! Changing the prefix of all tables to jos

Thanks
Thanks for the Points.

Glad i help u:)