1. Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2012
    Southern New Jersey, USA
    Rep Power

    Mysqldump question

    Ok I have two MySQL databases each on a separate server, they have slightly different schemas/databases in each...but the smaller one has all the schemas/databases that the larger one has

    So what is the syntax to using mysq1dump to just export the RAW data from the one database and import it into the other database.

    I know the following...but it is not correct yet:

    Mysqldum –u root –p --no-create-db --no-create-info [database name 1] [database name 2] [database name 3] > [dump file]

    To Import

    Mysql –u (root) –p(password) mydb < mydb.sql

    Dump to a delimited file

    Mysqldump – u [root] –p –t –T/path/to directory {database] –fields-enclosed-by=\” –fields-terminated-by=,

    How can I do this...

    Also note in the 2nd database that I am importing into, the objects for the different schemas/databases will already be created in the database, they just will not have any data
    Last edited by ByGoneYrs; August 2nd, 2013 at 12:30 PM.

IMN logo majestic logo threadwatch logo seochat tools logo