Thanks everyone for your input. Stefan,
Since I have limited command line access (ISP hosted database), I will probably have to use phpMyAdmin.> >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".
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
