Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Transporting MySQL-database
Message
De
07/04/2001 09:52:42
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Import/Export
Divers
Thread ID:
00492699
Message ID:
00493189
Vues:
15
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 ?
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform