193 reputation
5
bio website
location
age
visits member for 3 years, 4 months
seen Jul 19 at 18:47

Feb
17
awarded  Scholar
Feb
17
awarded  Supporter
Feb
17
accepted Using “Generate Scripts” with EMERGENCY/SINGLE USER mode
Feb
17
comment Using “Generate Scripts” with EMERGENCY/SINGLE USER mode
In the end, I created a new database on the same instance, used the "Script as.." to get the "CREATE TABLE" script (excl data), and then copied the data over as suggested by you. From the healthy database I could easily get the full insert query using "Generate scripts". +Accepted for the workaround
Feb
16
awarded  Student
Feb
16
comment Using “Generate Scripts” with EMERGENCY/SINGLE USER mode
I've tried that option, but it seems it does not include data. What I am using is "tasks"->"generate scripts" on the database itself. It has an option to include data. BTW, I am able to do SELECTs on the data and can of course manually create insert statements from the (tabular) data I get.
Feb
16
comment Using “Generate Scripts” with EMERGENCY/SINGLE USER mode
I tried KILLing the connection right before the generation step in the script wizard, but I got the same error. Looks like it creates another connection.
Feb
16
asked Using “Generate Scripts” with EMERGENCY/SINGLE USER mode
May
6
comment Entity Relationship Model for linked tables
Hi, credits for pointing out my assumptions, which might not be valid. Adding the translator as author-per-country would complicate things. One solution could be to add the author link table between Book-Country and Author tables - to get a list of authors for every book-country combination. Another to use the link table as suggested by @Aufwind with Author-Book-Country, but with the Country ID taken to mean something like "if NULL valid for all countries", if set only for this country (i.e. translator(s))
May
5
answered Entity Relationship Model for linked tables
May
5
answered How do you restore a particular table in MySQL?
May
4
awarded  Editor
May
4
revised How do I make MySQL auto increment in random order?
added 5 characters in body
May
2
awarded  Teacher
May
2
answered How do I make MySQL auto increment in random order?