up vote 1 down vote favorite
share [g+] share [fb]

I just imported a sql text file from a live site.
The SQL database is the actual site and would like to have it locally.

So far it was successful but then if I log in to my localhost/manager
I still see the default template. How can I see the template of the live site?

I'm using MODx as CMS.

========

this is where I did the import and so far it looks good http://s197.photobucket.com/albums/aa253/tintingerri/Test/?action=view&current=sqlfoto.png

=========

This is what I did I change the db name in the config.inc.PHP which can be found: htdocs\learningModx\manager\includes

from modx to "mydbname" but then after that I was able to see the site the problem is, I don't know which user is being logged in. I can see at the right that it's admin, but if I logged out and used admin and the password now it didn't work.

Where can I modify this username and password?

link|improve this question
76% accept rate
More info - what are you trying to do? What do you mean by sql text file? What version of SQL? Is it MySQL, PostGRE, SQL Server, Oracle? – JNK Aug 11 '10 at 13:26
I'm using XAMPP mysql. the sql text file that's the exported file from the IT guy. I should do some test first locally, before I can start editing and adding contents in the live website. – tintincutes Aug 11 '10 at 13:38
@JNK:please check my update response – tintincutes Aug 11 '10 at 13:45
Off topic for Super User - see the FAQ, but it is on topic for webmasters.stackexchange.com – ChrisF Aug 21 '10 at 19:53
feedback

closed as off topic by ChrisF, Diago Aug 22 '10 at 0:44

Questions on Super User are expected to generally relate to computer software or computer hardware, within the scope defined in the faq.

1 Answer

up vote 1 down vote

Templates are usually stored as files in folders and not in the database.

My guess is that it switches to the default template because it can't find the folder the database points to.
You can resolve that by copying the folder and then changing the template in case it was reverted.

I've also found those two links:

It's hard to give instructions on software we don't know,
I guess you should ask your question again on the MODx Support Forum.

Good luck!

link|improve this answer
thanks TomWij,yes I understand, it's difficult to give instructions if you don't know the software. I was trying if somebody out there have tried installing Modx. Thanks for the links, I already have them. But it didn't say here, what to do after you import the sql frm a live website to your local server. Just wondering. I will try to ask in the forum as well.Thanks – tintincutes Aug 11 '10 at 13:40
i just remember that after importing the text file to the SQL, you have to change the config.inc.php but not sure how to do it anymore. And then once you updated that, all the tables will be imported to the CMS and you can see the contents. That's my problem... – tintincutes Aug 11 '10 at 13:44
Ah, yeah. Pointing the site to the DB sure helps... I thought you would have done that so far as you didn't mention any other missing things besides the template. – Tom Wijsman Aug 11 '10 at 14:03
how can you do this? – tintincutes Aug 11 '10 at 14:16
show 2 more comments
feedback

Not the answer you're looking for? Browse other questions tagged or ask your own question.