Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Transporting MySQL-database
Message
From
07/04/2001 09:52:42
 
General information
Forum:
Microsoft SQL Server
Category:
Import/Export
Miscellaneous
Thread ID:
00492699
Message ID:
00493189
Views:
16
Are you moving it or do you just want a copy there?

If moving it, you can run sp_detach_db, then copy the files, then run sp_attach_db on the target machine.

But if you just want a copy, you can run the BACKUP command and back up to type DISK. Then you can copy the file to the CD and then run RESTORE on the target machine. Read the BOL topic on BACKUP carefully. It makes reference to setting BLOCKSIZE to 2048 for copying to CDs. I've never tried this.

>I'd like to save my MySQL-database on e.g. a CD and place it on a different
>computer. How can I save my database-structure AND data on e.g. a CD without
>losing anything ? Is it possible anyway or do I have to create a database on
>the other computer by myself ?
Previous
Reply
Map
View

Click here to load this message in the networking platform