MySQL

This is a discussion on MySQL within the A Brief History of Cprogramming.com forums, part of the Community Boards category; My applogise to the admin, didn;t quite know where to put this. I'm trying to copy data from one database, ...

  1. #1
    Registered User
    Join Date
    Nov 2001
    Posts
    29

    Question MySQL

    My applogise to the admin, didn;t quite know where to put this.

    I'm trying to copy data from one database, to another. Both Db's have the same tables in them, and are laid out the same.

    Just wondered if there was an easy way to do it. If not, then its a long night drinking coffee, and hitting my keyboard!
    --Jock (Bristol Bound)
    http://www.termisoc.com
    http://case.termisoc.com

  2. #2
    &TH of undefined behavior Fordy's Avatar
    Join Date
    Aug 2001
    Posts
    5,789
    I use MySQL, but have never had to do this.

    I think that as the tables are stored in seperate files, you may be able to simply move them as long as you have flushed and closed down the database. I'm not sure about how or if you would need extra configuration to get the new DB up and running. Your best bet would be to see the MySQL site itself. They have great support docs that would undoubtably give a better answer than anyone here.


    MySQL

Popular pages Recent additions subscribe to a feed

Similar Threads

  1. Change detection in MySQL.
    By amitbora27 in forum A Brief History of Cprogramming.com
    Replies: 2
    Last Post: 05-13-2009, 11:34 AM
  2. MySQL libraries
    By csonx_p in forum C++ Programming
    Replies: 6
    Last Post: 10-02-2008, 03:23 AM
  3. About C++ and MySQL or oether free database
    By xxxrugby in forum C++ Programming
    Replies: 18
    Last Post: 12-30-2005, 06:28 AM
  4. Get data from mysql and use in a system.
    By smaakage in forum Tech Board
    Replies: 3
    Last Post: 10-04-2005, 01:03 PM
  5. Get data from mysql and use in a system.
    By smaakage in forum C++ Programming
    Replies: 5
    Last Post: 10-02-2005, 02:25 PM

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21