please help - copying a database CLEAN - at wit's end here

[sfullman]

I ahve tried copying through phpMyAdmin, etc. etc. and nothing gets a clean copy that doesn't in some way reference the old db, OR have tables that say they are marked as crashed.

I have written php scripts and I don't seem to get the same number of records copied over when I do this:

insert into newdb.table1 select * FROM olddb.table1

part of the issue is that I have views, and also views that depend on views. using phpmyadmin, it does them in alphabetical order and if it tries to create a view that depends on other views which have not been created yet, it fails.

PLEASE HELP!!!! I'm thinking this should not be that hard to get a copy of a database that totally dereferences the old database

[johanafm]

MySQL has some setting to turn off foreign key constraint checks, which might do the trick for you while doing this in phpMyAdmin. Just don't forget to turn FK constraint checks back on again afterwards.

But you might want to consider using mysqldump, written only for the purpose of dumping entire databases so that they can be recreated somewhere else, or use MySQL Workbench which is a GUI that allows you to do a whole lot of things, including database dumps and db imports.