Thread: MySQL

  1. #1
    Registered User
    Join Date
    Nov 2001

    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)

  2. #2
    &TH of undefined behavior Fordy's Avatar
    Join Date
    Aug 2001
    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.


Popular pages Recent additions subscribe to a feed

Similar Threads

  1. Change detection in MySQL.
    By amitbora27 in forum A Brief History of
    Replies: 2
    Last Post: 05-13-2009, 10:34 AM
  2. MySQL libraries
    By csonx_p in forum C++ Programming
    Replies: 6
    Last Post: 10-02-2008, 02: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, 12: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, 01:25 PM