SEO

#1 (**permalink**) 02-28-2008, 08:15 AM

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

#2 (**permalink**) 02-28-2008, 08:16 AM

On Thu, 28 Sep 2006 08:21:14 GMT, M D wrote:
> 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.

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

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