FUNCTION tablename.PREG_RLIKE does not exist I figured, OK, I must have to reinstall them. I try the config command for lib_mysqludf_preg and get this: ERROR 1125 (HY000) at line 17: Function 'lib_mysqludf_preg_info' already exists ...
mysql -u dbuser -p db < /home/path/data.sql All goes well, the restore rebuilds over 350 tables but then stops with the error ERROR 1146 (42S02) at line 8663: Table 'mydb.zipData' doesn't exist Can anyone tell me what might be causing this. It has already restored 350 tables ...
mysql -u user -p DataBase < MyFile.sql Show a message like: ERROR 1146 (42S02) Table 'DataBase.MyTable' doesn't exist. Note.- SO Linux Centos realease 6.9 & MySQL 5.1.73-log in the both servers. Can somebody help me? THANKS ...
Hmm. I'll check this. This is a problem of MySQL treating these as case sensitive. Symbols in SQL should be case insensitive unless they are quoted.Navigate: Previous Message• Next Message Options: Reply• Quote Subject Written By Posted #42S02Table 'mysql.PROC' doesn't exist Dennis...
Somehow I've messed my database while creating a new user it gives mysql.columns_priv doesn't exist. I checked myusql db and can't find this table. I already have few database and I'm using mySQL for live Websites. Q.1 Is it possible to create columns_priv table in mysql db?