Hi All,
Our MySQL database automatic generating some weird numbers in the past couple months,I am not quite sure its the Navicat or MySQL problem. please check the screen shoot and advised. Thanks a lot
Navicat 7
MySQL 5
MySQL automatic generated some weird numbers
Moderator: General Moderators
MySQL automatic generated some weird numbers
- Attachments
-
- ss5-02.JPG (59.14 KiB) Viewed 223 times
Re: MySQL automatic generated some weird numbers
So what tables are in those numbered databases? I'm sure they are being created by Navicat, since I've never heard of MySQL gratuitously generating new databases. The other possibility would be that you are running some script that is creating them, but that's highly unlikely. Try opening one of those and see what kind of tables are in them (presuming there are some).
Re: MySQL automatic generated some weird numbers
Thanks for your replied califdon.
it`s a db.opt file and opened by notepad, it`s only show"default-character-set=latin1default-collation=latin1_swedish_ci" inside that db.opt file. please check the screen shoot seem like it created by random.
Best Regards
cyberlei
it`s a db.opt file and opened by notepad, it`s only show"default-character-set=latin1default-collation=latin1_swedish_ci" inside that db.opt file. please check the screen shoot seem like it created by random.
Best Regards
cyberlei
- Attachments
-
- screen shoot2.JPG (31.35 KiB) Viewed 178 times
-
- wired numbers.JPG (42.84 KiB) Viewed 179 times
Re: MySQL automatic generated some weird numbers
That appears to be a system table, but I'm surprised it's not in the MySQL folder. Probably something Navicat uses. In any case, they are certainly not random and I advise you to just leave them alone.cyberlei wrote:Thanks for your replied califdon.
it`s a db.opt file and opened by notepad, it`s only show"default-character-set=latin1default-collation=latin1_swedish_ci" inside that db.opt file. please check the screen shoot seem like it created by random.
Best Regards
cyberlei
Re: MySQL automatic generated some weird numbers
califdon wrote:That appears to be a system table, but I'm surprised it's not in the MySQL folder. Probably something Navicat uses. In any case, they are certainly not random and I advise you to just leave them alone.cyberlei wrote:Thanks for your replied califdon.
it`s a db.opt file and opened by notepad, it`s only show"default-character-set=latin1default-collation=latin1_swedish_ci" inside that db.opt file. please check the screen shoot seem like it created by random.
Best Regards
cyberlei
Thanks a lot for your advised.