DB dump

[simplyJ]

I have dumped my database into a .sql file. When I try to load the database from the file I get errors from the insert statments.

My dev DB is on my local PC, but I have a production DB on a server. How can I work on the dev DB and then copy that database over the production DB when it is tested?

 

[abombss]

If you are on *nix try using the mysqlhotcopy.pl script. It is by far the easiest. If you are on windows let me know and I can send you a modified working windows and cygwin version.

peace,

abombss

 

[simplyJ]

I am working with mySQL on WinXP. Can you send me the cygwin version?

Thanks!