Professional Web Applications Themes

appending data to tables? - MySQL

I have two identical databases on two different servers and I need to add the data in tables from one server to the tables in the other server. Is there a way to do that in mysql? I thought about mysqldump but that would overwrite the data in one of the databases. I really need to APPEND data in tables from one database into identical tables of a database on a different server. Or maybe there is some way to synchronize 2 databses? I don't need to do it in real time, just occasionally. thanks, Ralph...

  1. #1

    Default appending data to tables?

    I have two identical databases on two different servers and I need to add the data in tables from
    one server to the tables in the other server. Is there a way to do that in mysql? I thought about
    mysqldump but that would overwrite the data in one of the databases. I really need to APPEND data in
    tables from one database into identical tables of a database on a different server. Or maybe there
    is some way to synchronize 2 databses? I don't need to do it in real time, just occasionally.

    thanks,
    Ralph
    Ralph Guest

  2. #2

    Default Re: appending data to tables?

    On 27 Feb, 16:08, Ralph Smith <com> wrote: 

    Maybe I'm missing something, but if the tables are identical then the
    data is already on both servers?

    Captain Guest

  3. #3

    Default Re: appending data to tables?

    Ralph Smith <com> wrote in
    news:com:
     

    Not if you use the --no-create-info option.

    --
    felix
    Felix Guest

Similar Threads

  1. Replies: 2
    Last Post: December 23rd, 08:23 AM
  2. Appending data to a db field
    By gbert in forum Macromedia ColdFusion
    Replies: 5
    Last Post: May 9th, 01:52 AM
  3. Please help with data in 2 tables
    By Vivista Eastbourne in forum ASP Database
    Replies: 10
    Last Post: October 13th, 02:07 PM
  4. Replies: 1
    Last Post: July 10th, 08:29 PM

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
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139