how does duplicate database work?

[Richardt]

Does this do an "export" and then an "import"?

If so, then for remote databases, all data is passing over the network.

Is there a way in Sequel Pro to duplicate a database where all the work is performed on the remote machine?

I have a user that wants to be able to regularly take a snapshot of the production database and replace a test database.  They want to do it through Sequel Pro. 

For a large database, it seems that one would want to use mysqldump and then import locally with mysql.

Thanks.

Richard

[Rowan Beentje]

Hi Richard,

Duplicating a database performs a INSERT INTO ... SELECT * FROM ... query for each table, so all the data is copied locally within MySQL - this is faster than even doing a mysqldump and reimporting.

(Note that a few things, like duplicating routines, are currently unhandled though...)

Rowan

> --
> You received this message because you are subscribed to the Google Groups "Sequel Pro" group.
> To unsubscribe from this group and stop receiving emails from it, send an email to sequel-pro+...@googlegroups.com.
> To post to this group, send email to seque...@googlegroups.com.
> Visit this group at http://groups.google.com/group/sequel-pro?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>