?
Solved

Joomla Database Restoration

Posted on 2009-05-04
6
Medium Priority
?
1,326 Views
Last Modified: 2012-06-27
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?

0
Comment
Question by:Amanda Watson
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 4

Expert Comment

by:davidsperling
ID: 24293158
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 :-)
0
 
LVL 2

Expert Comment

by:Byteridge
ID: 24293513

Hi

Did you exported database using phpMyAdmin

Thanks
0
 
LVL 2

Accepted Solution

by:
tcs224694 earned 2000 total points
ID: 24294302
Hi i have good experience in joomla..Send me the details i will look into it.
Using phpmyadmin u can get this done in a  jiffy...Export all the tables in .sql format.
You have recieved this error because your database is not using jos_ as  prefix
 To Change prefix Go to your database and check correct prefix (common starting charcters of tablename). Put that prefix in your configuration file of joomla.

Search for the configuration.php file and do the following.
$mosConfig_dbprefix = ' ';
inside the ' ' change to match the prefix of your database then save it
0
Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

 
LVL 2

Assisted Solution

by:tcs224694
tcs224694 earned 2000 total points
ID: 24294320
Also see this ....I found this in a joomla forum once...

Installation fails with error
SQL Error DB function failed with error number 1146

You have received this error because your database is not using 'jos' as its prefix. Your database prefix is specified in Global Configuration / System / Database

To fix this error, open the 'install.component.sql' file in the package in notepad or your chosen file editor

Replace all occurrences of 'jos_', with your database prefix

Save the file, then zip up the installation folder and reinstall the component

Note: in older versions of our components the SQL statements are in the file 'install.component.php' or in the component XML file. In this case the same replacement should be made in the SQL statements in these files

If you let us know what your database prefix is we can change the code to suit your needs.


0
 
LVL 11

Author Comment

by:Amanda Watson
ID: 24299496
That fixed it!! Changing the prefix of all tables to jos

Thanks
0
 
LVL 2

Expert Comment

by:tcs224694
ID: 24302624
Thanks for the Points.

Glad i help u:)
0

Featured Post

Get proactive database performance tuning online

At Percona’s web store you can order full Percona Database Performance Audit in minutes. Find out the health of your database, and how to improve it. Pay online with a credit card. Improve your database performance now!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There are times when I have encountered the need to decompress a response from a PHP request. This is how it's done, but you must have control of the request and you can set the Accept-Encoding header.
In this blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test.
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
Suggested Courses

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question