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
