Before editing my db I did an export and have that file on my local machine.
I messed up and deleted a table somehow and am trying to import the back up back in but it keeps telling me the data already exists and will not overwrite. I have full permissions.
Do I have to delete my db's to restore or is there a command I can use to
just import and overwrite what is there?
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DATABASE `slip_ccrt1` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ ci' at line 1
What do I put in before DATABASE? to get this back up and running?
Thanks in advance,
Rich
I messed up and deleted a table somehow and am trying to import the back up back in but it keeps telling me the data already exists and will not overwrite. I have full permissions.
Do I have to delete my db's to restore or is there a command I can use to
just import and overwrite what is there?
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DATABASE `slip_ccrt1` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ ci' at line 1
What do I put in before DATABASE? to get this back up and running?
Thanks in advance,
Rich