matt tisdel wrote:
> My problem is whenever I try and
> overwrite the old tables it says it cant because
> there is a table named eqdkpBAK_whatever already.
> Is there a command to simply overwrite the entire
> table or do I need to delete the table and
> recreate it?
The usual way to handle this is to issue a command like "drop table if exists ..." to drop the table in case it exists already. Then it is recreated from the script. Be careful with relationships, though.
Btw: why keeping the tables in a separate schema, just for backup? If you have exported them to a script you can store that in a safe place and have your backup without having to setup another schema only for that purpose.
Mike
Mike Lischke, MySQL Developer Tools
Oracle Corporation
MySQL Workbench on Github:
https://github.com/mysql/mysql-workbench
On Twitter:
https://twitter.com/MySQLWorkbench
On Slack: mysqlcommunity.slack.com (#workbench)
Report bugs to
http://bugs.mysql.com
MySQL documentation can be found here:
http://dev.mysql.com/doc/refman/8.0/en/