Professional Web Applications Themes

what's the most efficient way to update the whole database? - MySQL

What's the best way to update database?( mysql ) I have set up two databases one for website and the other for accepting new records. These two databases are remotely located. I want to update this database every three days. What's the fastest way to update the websites database. MD...

  1. #1

    Default what's the most efficient way to update the whole database?

    What's the best way to update database?( mysql )

    I have set up two databases one for website and the other
    for accepting new records. These two databases are remotely located.
    I want to update this database every three days.

    What's the fastest way to update the websites database.

    MD



    M Guest

  2. #2

    Default Re: what's the most efficient way to update the whole database?

    On Thu, 28 Sep 2006 08:21:14 GMT, M D wrote: 

    If the local copy has all the records that the remote one does,
    something similar to

    mysqldump -u useryou -p --opt database | \
    mysql -h newhost.com -u userid -p database

    If the new record database ONLY has new records, just insert the records
    instead.

    I'm a little confused as to what your emphasis on speed is intending to
    solve, if you're on a three-day schedule.

    --
    79. If my doomsday device happens to come with a reverse switch, as soon as it
    has been employed it will be melted down and made into limited-edition
    commemorative coins.
    --Peter Anspach's list of things to do as an Evil Overlord
    Peter Guest

Similar Threads

  1. Access Database will not update
    By KJ Klosson in forum Coldfusion Database Access
    Replies: 4
    Last Post: November 6th, 11:49 AM
  2. Use a CFC to update a database with a date
    By EdmondsM in forum Coldfusion - Advanced Techniques
    Replies: 6
    Last Post: July 25th, 05:57 PM
  3. update database
    By JPrice in forum Coldfusion Database Access
    Replies: 6
    Last Post: July 9th, 08:44 PM
  4. Replies: 2
    Last Post: December 18th, 09:24 PM
  5. update from between database
    By Thomas in forum ASP.NET General
    Replies: 2
    Last Post: July 28th, 11:52 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