"Frank Peavy" <[EMAIL PROTECTED]>
To: "Stefan Hinz, iConnect (Berlin)" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Friday, January 10, 2003 8:09 PM
Subject: Re: Copying MySql database to others
> Stefan,
>
> >Let's say, you exported database &
Stefan,
Let's say, you exported database "my_database", and you saved the export
file as "c:\mysql\my_database_export.sql" on your QA machine. You can
import it with this command (assuming that database "my_database" exists
on your QA machine, but has no tables in it):
c:\mysql\bin> mysql -uuse
3 18:37:33 -0800
To: "Stefan Hinz, iConnect \(Berlin\)" <[EMAIL PROTECTED]>,
<[EMAIL PROTECTED]>
From: Frank Peavy <[EMAIL PROTECTED]>
Subject: Re: Copying MySql database to others
Thanks everyone for your input.
Stefan,
> >From, within phpMyAdmin?
1. In the left f
>
Geschäftsführer / CEO iConnect GmbH <http://iConnect.de>
Heesestr. 6, 12169 Berlin (Germany)
Tel: +49 30 7970948-0 Fax: +49 30 7970948-3
- Original Message -
From: "Frank Peavy" <[EMAIL PROTECTED]>
To: "Stefan Hinz, iConnect (Berlin)" <[EMAIL
Thanks everyone for your input.
Stefan,
> >From, within phpMyAdmin?
1. In the left frame, choose the database you want to backup / copy.
2. Click the EXPORT tab in the right frame.
3. Choose the tables in the database you want to backup.
4. Choose "Structure and data".
5. Check "Enclose table an
Thanks everyone for your input.
Stefan,
> >From, within phpMyAdmin?
1. In the left frame, choose the database you want to backup / copy.
2. Click the EXPORT tab in the right frame.
3. Choose the tables in the database you want to backup.
4. Choose "Structure and data".
5. Check "Enclose table an
CTED]>
Geschäftsführer / CEO iConnect GmbH <http://iConnect.de>
Heesestr. 6, 12169 Berlin (Germany)
Tel: +49 30 7970948-0 Fax: +49 30 7970948-3
- Original Message -
From: "Frank Peavy" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, January 08
I need to copy a MySql Production database to QA. What is the best method of
doing this? Do I need to write SQL queries or is there another quicker method?
From the command line?
From, within phpMyAdmin?
-
Before posting, pl