SEO

#1 (**permalink**) 05-02-2008, 05:05 AM

Hello,

I have a snapshot of a database which I migrated about a week ago to
do a proof of concept. Now that it has been proven out, I need to
migrate the database which has the most current data AND the snapshot
which I took.

I have dumped out the database using the typical "mysqldump -h
localhost dbname > dbname.sql", but when I restore the dbname.sql
file, do I use the "mysql -h localhost dbname < dbname.sql" command,
or are there additional flags/options which need to be included?

Thanks in advance,
Sheel Shah

#2 (**permalink**) 05-02-2008, 05:05 AM

<sheel331@yahoo.com> wrote in message
news:3d645531-3e1e-4c8a-9575-4fa57e732a9f@34g2000hsf.googlegroups.com...
> Hello,
>
> I have a snapshot of a database which I migrated about a week ago to
> do a proof of concept. Now that it has been proven out, I need to
> migrate the database which has the most current data AND the snapshot
> which I took.
>
> I have dumped out the database using the typical "mysqldump -h
> localhost dbname > dbname.sql", but when I restore the dbname.sql
> file, do I use the "mysql -h localhost dbname < dbname.sql" command,
> or are there additional flags/options which need to be included?
>
> Thanks in advance,
> Sheel Shah

Now that your proof of concept has been accepted, apply the same changes to
your production database as you did to the snapshot (after you back it up,
of course).

Trying to stuff data from a mismatched database is asking for trouble.

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

SEO

restoring database + overwrite