RE: [PHP-DB] MySQL test database creation...

Thanks, but I finally stumbled across the answer. Thankfully it was simple enough even for me. In case anyone else had this question also, all you have to do is browse for your dump file in the 'SQL' window of phpMyAdmin and click 'Go'. That's it. -----Original Message----- From: NIPP, SCOTT V (SBCSI) [mailto:php-db-return-20341-sn4265=sbc.com@lists.php.net] Sent: Friday, July 05, 2002 12:26 PM To: 'php-db@lists.php.net' Subject: [PHP-DB] MySQL test database creation... Hey guys... I know that this is not specifically on topic for this group, but I promise this is an easy one. I am developing a web app, and need to create a development copy of the production database. I have created the new database, now I just need to export and import the schema and data from the production database. I am running MySQL 3.23.49, and I am using phpMyAdmin for the bulk of my database administration. I can get the data and schema dumped to a file easily enough with phpMyAdmin, but it does not seem to offer an import. I know that mysqlimport should be the tool to handle this, but I want to make this as easy as possible for myself and I am pretty sure there is a way to have it create the tables and everything from the schema data. I have check the mysql documentation, but I am not finding what I need. I am sure it is in there, but I have had a pretty long night with little sleep. Thanks in advance for the help. Scott Nipp Phone: (214) 858-1289 E-mail: sn4265@sbc.com Web: http:\\ldsa.sbcld.sbc.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php