Hi John,

Do you have access to a command prompt? There's quite a neat trick to copy
an entire database from one server to another using mysqldump :

mysqldump -u <user> -p<pass> --opt <dbname> | mysql -u <user> -p<pass>
-h<host> -C <dbname>

This is for a Unix system and pipes the output from the mysqldump utility
straight into the mysql client rather than an intermediary file. You run it
on the source system and use the host switch in the mysql client to access
another server.

Is that the sort of thing you're after?

Mark.
|-----------------------------+-------------------------------------------|
| "John A DAVIS " | |
| <mysqldba-ezmlmshield-x641| |
| 67154.[Email address protected] To|
| com> | "LazyDBA Discussion" |
| | <[Email address protected] |
| 04/05/2006 01:38 | cc|
| | |
| | Subject|
| | real question about |
| | migrating |
| | |
| | |
| | |
| | |
| | |
| | |
|-----------------------------+-------------------------------------------|






I developed a complete website/database on CrystalTech (my ISP) using
their developers account for $2.95 a month.
It is now working and I have opened a business account and I need to
migrate all the table over to this new account. Is that hard to do? I
don't even know where to start.

I have been using SQL Server DTS to upload tables and data but it
chokes on blobs or text fields. There has got to be an easy way to
migrate a whole schema to another account.

Cheers,
John


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To unsubscribe, e-mail: mysqldba-[Email address protected]
Website : http://www.LazyDBA.com




######################################################################
The information contained in this e-mail and any subsequent
correspondence is private and confidential and intended solely
for the named recipient(s). If you are not a named recipient,
you must not copy, distribute, or disseminate the information,
open any attachment, or take any action in reliance on it. If you
have received the e-mail in error, please notify the sender and delete
the e-mail.

Any views or opinions expressed in this e-mail are those of the
individual sender, unless otherwise stated. Although this e-mail has
been scanned for viruses you should rely on your own virus check, as
the sender accepts no liability for any damage arising out of any bug
or virus infection.
######################################################################

MySQL LazyDBA home page