Database

[jkcerda]

how can I replace ONE database with another?

can I just mess with the config file to use the new DB?
do I need to do anything to a downloaded DB in order for this to work?

trying to get my test forum working with my back up DB.

if you used WAMP before, WHERE is the DB that gets created located?

thanks.

--------------- Added [DATE]1284854848[/DATE] at [TIME]1284854848[/TIME] ---------------

any help here?
getting this error

MySQL says:
Variable 'character_set_client' can't be set to the value of 'NULL'

Error in Query:

/*!40101 SET character_set_client = @saved_cs_client */; -> Variable 'character_set_client' can't be set to the value of 'NULL'

using bigdump

[ctweb]

Most probably "@saved_cs_client" variable isn't defined.

Remove that SET character_set_client line from the SQL/query and try..

As for your earlier question, it's best to create a new db, and change the config details. If you overwrite your existing database, then you wont have a backup in case something goes wrong..

If you have the option to create a new DB, go for it.. On WAMP, do you have phpmyadmin installed? It's one of the best ways to administer your databases.. There are other windows based tools too.. phpmyadmin is web based though..

[jkcerda]

Originally Posted by ctweb

Most probably "@saved_cs_client" variable isn't defined.

Remove that SET character_set_client line from the SQL/query and try..

As for your earlier question, it's best to create a new db, and change the config details. If you overwrite your existing database, then you wont have a backup in case something goes wrong..

If you have the option to create a new DB, go for it.. On WAMP, do you have phpmyadmin installed? It's one of the best ways to administer your databases.. There are other windows based tools too.. phpmyadmin is web based though..

it was easier than that. I tried a few utilities, I used the same dumper to make a back up on my live DB as I did to restore my test DBon my laptop, THAT, worked, guessing the dumper was not recognizing or had trouble with the compression of the DB backups I had.

anyways, its working now, thanks for your help.

[ctweb]

No worries.. Glad you got it working..

[jkcerda]

Originally Posted by ctweb

No worries.. Glad you got it working..

pretty happy, all the noobs like myself should have a test board IMHO,

[ARSamo]

I am also facing the same problem......., plz suggest me what can i do.....

[Agathadaimon]

Originally Posted by ARSamo

I am also facing the same problem......., plz suggest me what can i do.....

Receive an error when loading backup?