continuum-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Wayne Fay" <wayne...@gmail.com>
Subject Re: Database rebuilding process
Date Tue, 26 Sep 2006 22:20:09 GMT
Hi Ryan,

Did you mean to send this to Continuum-Users? I think not...

Wayne

On 9/26/06, Ryan Slobojan <rsloboja@babycenter.com> wrote:
> Hi,
>
> I've come up with a sequence that we can use for exporting data and
> structure separately from a MySQL database, and importing the same data
> and structure into a local MySQL database. For the same of these
> examples, we'll assume that the remote database is named 'test' and
> resides on SFDev-4, and that the user is 'dvbrowse' with password
> 'l00katme'
>
> Export database structure from remote database
>
> mysqldump -u dvbrowse --password=l00katme -h sfdev-4 -C -d -r test.sql
> test
>
> Export database data from remote database
>
> mysqldump -u dvbrowse --password=l00katme -h sfdev-4 -c -C -K -e -n -t
> -q -r test-data.sql test
>
> Import structure/Rebuild local database
>
> mysql -u root --password=n3wb4by test < test.sql
>
> Import data into local database
>
> mysql -u root --password=n3wb4by test < test-data.sql
>
> Thanks,
>
> Ryan Slobojan
>
>
>
>

Mime
View raw message