-----Original Message-----
From: John A DAVIS
[mailto:mysqldba-ezmlmshield-x37736005.[Email address protected]
Sent: Thursday, May 04, 2006 10:41 AM
To: LazyDBA Discussion
Subject: Re: real question about migrating
No Unix in this situation. I did find a quite elegant solution. I backed
up the database and then restored it to the new account. no worries.
thanks
John
>>> "Mark Grout "
<mysqldba-ezmlmshield-x42968268.[Email address protected] 5/4/2006 1:42
AM >>>
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.
######################################################################
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To unsubscribe, e-mail: mysqldba-[Email address protected]
Website : http://www.LazyDBA.com
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To unsubscribe, e-mail: mysqldba-[Email address protected]
Website : http://www.LazyDBA.com
MySQL LazyDBA home page