Fwd: Re: Copying MySql database to others

2003-01-10 Thread Frank Peavy 
Query.
I guess I don't understand how this mailing list works..
I send messages and some of them get posted, some don't .

Some instances, I send a message and it gets posted, I try to respond and 
the message
never appears

Can someone explain?


Date: Wed, 08 Jan 2003 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?
snip
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 and field names with backquotes if your table
or column names might contain special characters (like ä, ö, ü).
6. Check Save as file.
7. Click Go.


Since I have limited command line access (ISP hosted database), I will 
probably have to use phpMyAdmin.

Part of my logic was to copy my MySql database to another MySql database, 
so that I can use the second database for QA purposes.

When I perform the Export as above, does that make a copy in another 
database or is that to an  external file? If it is an external file, would 
I have to Import it to another database that I create?



-
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Copying MySql database to others

2003-01-10 Thread Frank Peavy 
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 -uusername -ppassword my_database 
c:\mysql\my_database_export.sql

Doesn't this assume that I have command line access? Since I am in a hosted 
(ISP) environment, I am trying to do this through phpMyAdmin. Can I not do 
this through phpMyAdmin?


-
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Copying MySql database to others

2003-01-10 Thread Stefan Hinz, iConnect \(Berlin\) 
Frank,

   c:\mysql\bin mysql -uusername -ppassword my_database 
 c:\mysql\my_database_export.sql

 Doesn't this assume that I have command line access? Since I am in a
hosted
 (ISP) environment, I am trying to do this through phpMyAdmin. Can I
not do
 this through phpMyAdmin?

Right. It means you need command line access on the QA host, which I
assumed was a local machine. Of course, it's also possible to use
phpMyAdmin for this:

1. Choose the database you want the imported tables to go.
2. Click the SQL tab.
3. Click Browse to choose my_database_export.sql.
4. Click Okay.

Regards,
--
  Stefan Hinz [EMAIL PROTECTED]
  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 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 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 -uusername -ppassword my_database 
 c:\mysql\my_database_export.sql
 Doesn't this assume that I have command line access? Since I am in a
hosted
 (ISP) environment, I am trying to do this through phpMyAdmin. Can I
not do
 this through phpMyAdmin?



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Copying MySql database to others

2003-01-09 Thread Frank Peavy 
Thanks everyone for your input.

Stefan,

 From, within phpMyAdmin?
snip
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 and field names with backquotes if your table
or column names might contain special characters (like ä, ö, ü).
6. Check Save as file.
7. Click Go.


Since I have limited command line access (ISP hosted database), I will 
probably have to use phpMyAdmin.

Part of my logic was to copy my MySql database to another MySql database, 
so that I can use the second database for QA purposes.

When I perform the Export as above, does that make a copy in another 
database or is that to an  external file? If it is an external file, would 
I have to Import it to another database that I create?


-
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Copying MySql database to others

2003-01-09 Thread Stefan Hinz, iConnect \(Berlin\) 
Frank,

 Since I have limited command line access (ISP hosted database), I will
 probably have to use phpMyAdmin.
 Part of my logic was to copy my MySql database to another MySql
database,
 so that I can use the second database for QA purposes.
 When I perform the Export as above, does that make a copy in another
 database or is that to an  external file? If it is an external file,
would
 I have to Import it to another database that I create?

 6. Check Save as file.

This means phpMyAdmin will write the export file to a file which it will
send to the browser. You can save this file on the machine where the
other (QA) MySQL server is running. On this machine, you can load the
export like this:

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 -uusername -ppassword my_database 
c:\mysql\my_database_export.sql

Regards,
--
  Stefan Hinz [EMAIL PROTECTED]
  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 PROTECTED];
[EMAIL PROTECTED]
Sent: Thursday, January 09, 2003 3:37 AM
Subject: Re: Copying MySql database to others


Thanks everyone for your input.

Stefan,
  From, within phpMyAdmin?
snip
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 and field names with backquotes if your table
or column names might contain special characters (like ä, ö, ü).
6. Check Save as file.
7. Click Go.

Since I have limited command line access (ISP hosted database), I will
probably have to use phpMyAdmin.

Part of my logic was to copy my MySql database to another MySql
database,
so that I can use the second database for QA purposes.

When I perform the Export as above, does that make a copy in another
database or is that to an  external file? If it is an external file,
would
I have to Import it to another database that I create?



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Copying MySql database to others

2003-01-08 Thread Frank Peavy 


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, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Copying MySql database to others

2003-01-08 Thread Stefan Hinz, iConnect \(Berlin\) 
Frank,

 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?

There are alot of possibilities to accomplish this fast.

   From the command line?

shell mysqldump -uusername -ppassword your_database  export_file.sql

Or, if you want to copy / backup all your databases:

shell mysqldump -uusername -ppassword  export_file.sql --all-databases

 From, within phpMyAdmin?

First make sure you have a recent copy of phpMyAdmin. 2.3.3pl1 is the
most recent (http://phpmyadmin.net). You can only backup one database at
a time with this tool, not all of them like with --all-databases.

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 and field names with backquotes if your table
or column names might contain special characters (like ä, ö, ü).
6. Check Save as file.
7. Click Go.

Regards,
--
  Stefan Hinz [EMAIL PROTECTED]
  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, 2003 6:18 PM
Subject: Re: Copying MySql database to others



 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, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail
[EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Copying MySql database to others

2003-01-08 Thread Frank Peavy 
Thanks everyone for your input.

Stefan,

 From, within phpMyAdmin?
snip
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 and field names with backquotes if your table
or column names might contain special characters (like ä, ö, ü).
6. Check Save as file.
7. Click Go.


Since I have limited command line access (ISP hosted database), I will 
probably have to use phpMyAdmin.

Part of my logic was to copy my MySql database to another MySql database, 
so that I can use the second database for QA purposes.

When I perform the Export as above, does that make a copy in another 
database or is that to an  external file? If it is an external file, would 
I have to Import it to another database that I create?


-
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php