Todd Smith
|
Posted: 04/25/2001, 9:02 AM |
|
Is there a way, or a program to use, that will copy mySQL databases from an
online Unix server, and duplicate them in my Windows mySQL server on my home
PC, so I can develop with CodeCharge at home?
|
|
|
guest
|
Posted: 04/25/2001, 9:21 AM |
|
I usually use MySQLdump as described here:
http://www.mysql.com/documentation/mysql/bychapter/manu....html#mysqldump
to get a backup and then restore using: mysql dbname < dumpeddata.sql
they also list a method right below that using a perl scrip that just
copies the database files. I've done this manually when the server
was down. Just FTP the files into the mysql data directory in my
windows machine. But for me this method has alway worked best when I
shutdown the server, copied the files to another directory, brought
the server back up, then ftp'd the copied files.
On Wed, 25 Apr 2001 11:00:04 -0500, "Todd Smith"
<todd@designsouth.net> wrote:
>Is there a way, or a program to use, that will copy mySQL databases from an
>online Unix server, and duplicate them in my Windows mySQL server on my home
>PC, so I can develop with CodeCharge at home?
>
>
|
|
|
Steven Dowd
|
Posted: 04/25/2001, 4:29 PM |
|
try the program 'mascon' from www.scibit.com it handles server to server
mysql db transfers with ease
steven
<baze22@yahoo.com> wrote in message
news:3ae6f7b4.188262427@news.codecharge.com...
> I usually use MySQLdump as described here:
>
> http://www.mysql.com/documentation/mysql/bychapter/manu...ls.html#mysqldu
mp
>
> to get a backup and then restore using: mysql dbname < dumpeddata.sql
>
> they also list a method right below that using a perl scrip that just
> copies the database files. I've done this manually when the server
> was down. Just FTP the files into the mysql data directory in my
> windows machine. But for me this method has alway worked best when I
> shutdown the server, copied the files to another directory, brought
> the server back up, then ftp'd the copied files.
>
>
> On Wed, 25 Apr 2001 11:00:04 -0500, "Todd Smith"
> <todd@designsouth.net> wrote:
>
> >Is there a way, or a program to use, that will copy mySQL databases from
an
> >online Unix server, and duplicate them in my Windows mySQL server on my
home
> >PC, so I can develop with CodeCharge at home?
> >
> >
>
|
|
|
|