Re: [phpesp-general] Copying surveys between databases

[Jim B. <jp...@si...>]

* boardtc <bo...@gm...> [2005-07-08 12:21]:
> I have to say having just setup a test survey and then my first survey
> proper, phpEsp is simply a dream. Fantastic stuff, thank you.
> 
> This will not be a habit I hope but I have another question which I
> could not find in the faq. I have just setup a survey on a local
> database installation and am in the process of setting up one at my
> isp (errors running the create sql script on their server, talking to
> them about it)/.
> 
> My question is : is there a way I can copy my survey from one
> installation database to another? If it is more trouble than it's
> worth I can retype the whole things out.
> 
> Thanks a lot,
> 
> Cheers,
> 
> Tom.
> 


To copy a database from one system to another:


mysqldump --opt -u root -p  phpesp > mydb.out

(xfer mydb.out to other system here)

mysql -u root -p phpesp < mydb.out


Note- this will completely erase any phpesp database
on the new system.


If you just want to copy a phpesp survey in the same database,
see my notes at:

http://sixshooter.v6.thrupoint.net/phpESP_proto/README.txt


Best Regards,
Jim B.