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

hi If the database is not too much data you can export using phpMyAdmin and select 'complete inserts' which generates complete queries. you could also do INSERT INTO db_2.tablename SELECT * FROM db_1.tablename if both databases are on the same server. There may be better answers, but these two are simple :) Peter ----------------------------------------------- Excellence in internet and open source software ----------------------------------------------- Sunmaia www.sunmaia.net info@sunmaia.net tel. 0121-242-1473 ----------------------------------------------- > -----Original Message----- > From: NIPP, SCOTT V (SBCSI) [mailto:sn4265@sbc.com] > Sent: 05 July 2002 18:26 > 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 >