Mysql recovery Times error: v_actList view does not exist; successfully restored view name is changed to lowercase.

question 1:

created a view-based view using mysql, and when you use navicate to restore sql database files, the prompt child view (the view called by the parent view) does not exist. (this is the case with more than one view)

question 2

when you restore the database, the view restore is not successful, and then the view is copied manually, and the view name is changed to lowercase.

  • View of the original database

clipboard.png

clipboard.png

< hr >

attempted solution:

if you copy the child view first, and then copy the parent view, you can write normally. Is it because of the order in which mysql views are restored?

< hr >

error message is as follows:

[Err] 1146-Table "test.v_actlist" doesn"t exist
[Err] 1146-Table" test.v_useract" doesn"t exist

< hr >
Mysql
May.22,2021

Navicate will be lowercase when dealing with table or view names. If you want to keep it uppercase, you need to add quotation marks. You can use reverse quotation marks `, or double quotation marks "

.

and check my.ini or my.cnf, to see if there is no lower_case_table_names=0-like configuration.

Previous: How does sql replace content with regular expressions or wildcards?

Next: The display of gitlab, on yum-y install causes the download to fail.

css mysql arrays josn react html typescript webpack npm sass R objective-c .net sql-server jquery python-3.x angularjs django angular excel regex iphone ajax linux xml pandas vba spring database wordpress string wpf xcode windows bash postgresql oracle multithreading eclipse list firebase algorithm macos forms image scala visual-studio azure bootstrap spring-boot react-native python-2.7 docker performance function winforms matlab powershell apache dataframe api sqlite numpy rest shell selenium flutter dart maven loops qt swing android-studio csv express file class tensorflow sorting codeigniter perl
MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1e4f6ba-43d59.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1e4f6ba-43d59.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?