Amanda Watson
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`,`usern ame`,`gid` ,`guest`,` client_id` ) VALUES ( '381c0d213bcc0ba0b3a9ec0ec 80b4e2b',' 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?
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`,`usern
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?
Hi
Did you exported database using phpMyAdmin
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
That fixed it!! Changing the prefix of all tables to jos
Thanks
Thanks
Thanks for the Points.
Glad i help u:)
Glad i help u:)
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 :-)