Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

We're integrating another office into ours. That includes some of their data.

I have a new installed MariaDB 5.5 server. The data dir = /home/data/MariaDB. I've done a new/fresh install into that directory:

ls -1 /home/data/MariaDB
    ibdata1
    ib_logfile0
    ib_logfile1
    multi-master.info
    mysql/
    mysql_upgrade_info
    performance_schema/
    test/

The server is up & running.

I inherited some data from a now-defunct MySQL server. It's in:

ls -1 /home/data/MySQL-OLD
    auto.cnf
    ibdata1
    ib_logfile0
    ib_logfile1
    mysql/
    mysql_upgrade_info
    performance_schema/
    proj_DB_2136/
    proj_DB_4216/
    proj_DB_6217/
    test/

I want to move data for three DBs -- "proj_DB_2136/", "proj_DB_4216/", and "proj_DB_6217/" -- into my working MariaDB server. Same names, same data, everything.

I just need to do this one time, so I can start working on the old data on my new server.

I'd like to do it the right way, without losing anything!

mysqldump makes sense for me, but only for working databases already IN the running server.

What's the correct way to get this data safely brought over?

share|improve this question
    
Are the tables MyISAM or InnoDB or a mix of both? –  Michael - sqlbot Jul 13 '13 at 4:48
    
The inherited data has a mix of both. Once I get the data onto my new server, I'll convert to InnoDB. –  DavidG Jul 13 '13 at 19:29

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.