CodeCharge Studio
search Register Login  

Visual Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> Archive -> CodeCharge.Discussion

 duplicating some SQL databases

Print topic Send  topic

Author Message
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?
> >
> >
>


   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

MS Access to Web

Convert MS Access to Web.
Join thousands of Web developers who build Web applications with minimal coding.

CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.