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

2002-07-05 Thread Peter Lovatt
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 t

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

2002-07-05 Thread NIPP, SCOTT V (SBCSI)
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,