Page 1 of 1

MySQL automatic generated some weird numbers

Posted: Fri May 02, 2008 1:40 pm
by cyberlei
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

Re: MySQL automatic generated some weird numbers

Posted: Tue May 06, 2008 2:52 pm
by califdon
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

Posted: Wed May 07, 2008 12:23 pm
by cyberlei
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

Posted: Wed May 07, 2008 2:29 pm
by califdon
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
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.

Re: MySQL automatic generated some weird numbers

Posted: Wed May 07, 2008 3:22 pm
by cyberlei
califdon wrote:
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
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.

Thanks a lot for your advised. :D