SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Enthusiast
    Join Date
    Jul 2000
    Posts
    34
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    embarrasing Q from a fella who should know better...

    Given that I've a client who has an SQL db hosted on a server, and given that I've been asked to tranfer that db to another server, I'm wondering... can I transfer a physical file or do I have to rebuild the db and populate it with the cvrrent data?

    Thanx for all input.
    M
    marty_p

    MENZ.com site administrator.

  2. #2
    SitePoint Wizard gold trophysilver trophy
    Join Date
    Nov 2000
    Location
    Switzerland
    Posts
    2,479
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Ahahaahahahaha! How embarrassing!

    Kidding.

    Think the answer is "it depends". With MySQL you can transfer the physical files that define the database (if you have access to the "mysql/data" directory it will be obvious which). But the alternative is to use the mysqldump (see this tutorial) to build one giant query which creates the tables then fills them with data. Most databases should at least allow you to do the last part.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •