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
