
Originally Posted by
DrByte
Clearly something's not working correctly with the import. It could be something wrong with how you originally exported. Or a number of things.
But another option that might work (since you're using the same server for both the live and test sites) is to use phpMyAdmin to do the copy of the live database to another database already in your server. Whether this will work depends on the cofniguration of phpMyAdmin and server security restrictions.
What I've done before is:
- click on the "live" database, on the left column.
- Then in the right column click on the Operations tab.
- On that screen I have a "Copy Database To..." option, where I can enter the name of the database I want to copy everything over to ... plus some checkboxes:
-- Check the "Copy structure and data" box.
-- Uncheck the "Create database" (because you already have the database, and security rules on shared servers usually prevent you from creating db's with phpMyAdmin)
-- Check the Drop Tables/Views (so that it removes any same-named tables in the new db)
-- Keep the Auto-Increment checked
-- constraints are probably irrelevant
The "switch to copied db" option simply tells phpMyAdmin to switch its screens to the new db after the copy is done. So, might be handy to "check" this box.