When copying live database to dev database do you always have to "drop" the tables first, seems the only way I can do it.
Is it not possible to just overwrite with new one?
John
When copying live database to dev database do you always have to "drop" the tables first, seems the only way I can do it.
Is it not possible to just overwrite with new one?
John
What command do you use for this? Do you use mysqldump or do you just use the query window from phpMyAdmin? Etc.
Just the window in "operations"
In this case you have to drop the database, otherwise it would just overwrite the similar data and not the excess data that has changed during your last copy and now. (e.g. products you have deleted will still be present, etc.).
Thanks for reply