Problems when restoring a base in mysql

Navigation
0

By mistake delete a table from my base, I have a backup before, but when wanting to restore it, it tells me that the table does not exist, I need to create it first? I already try to do it but there are many fields and I do not remember exactly the fields, I have another table in another computer but how do I export the pure structure of the base so I can create it and then restore it?

    
asked by sanlegas 18.05.2018 в 20:48
source

1 answer

1

With SHOW CREATE TABLE nombredelatabla gives you the code to create the table on the other base

link

    
answered by 18.05.2018 в 20:54
What is the best way to establish a value of a dropdown from the database [closed] Create an array of JSON objects with PHP