Unsupported Screen Size: The viewport size is too small for the theme to render properly.

How To Copy Database To Another Host

forums › forums › SQLyog › Using SQLyog › How To Copy Database To Another Host

  • This topic is empty.
Viewing 0 reply threads
  • Author
    Posts
    • August 6, 2012 at 5:41 am #12762
      AlanT
      Member

      I am using Community v 10.

      Wanted to copy the whole database from my localhost to a server, but got an error of code 1005, foreign key constraint.

      Right click the database and choose “Copy database to Different Host/Database…”

      The table of the error occurred is Employee, there is a foreign key (Employee.SupervisorID) references Supervisior.EmployeeID.

      I guess because Supervisor table was not yet copied.

      Anyway to get around it?

  • Author
    Posts
Viewing 0 reply threads
  • You must be logged in to reply to this topic.