phpMyAdmin database backup help

[amnesiak]

Hi,

I˙m trying to make a database backup in my phpMyAdmin, I would like to use that backup for my store in my localhost server, where I test modules, css ect.

The problem is when I make a database backup from my server where the real store is located and import this database to the store at localhost, the store at localhost actually connects to internet where my real store is. I dont want that as this is my localhost store.

The database alss overwrites the username and password in my localhost store.

So the question is, what tables from my database should I exclude from preventing this to happen?

[franV]

I think it has to do with your sql database setup on your local server.

If i remember correctly there is a option where you can set up your database to connect with an external database.

This might be your problem here. It should not connect because this is a test enviroment.

I would probably create a new localhost database with a setup that does not connect to an outside server.

 

I'm a bit of a phpadmin noob myself and can do the basics but i plan to study these books that could help with phpadmin stuff. All availably in ebook formats as well.

 

http://www.packtpub....management/book

http://www.packtpub....management/book