MySQL automatic generated some weird numbers

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
cyberlei
Forum Commoner
Posts: 27
Joined: Tue Oct 16, 2007 6:19 pm
Location: Milpitas, CA

MySQL automatic generated some weird numbers

Post 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
Attachments
ss5-02.JPG
ss5-02.JPG (59.14 KiB) Viewed 223 times
User avatar
califdon
Jack of Zircons
Posts: 4484
Joined: Thu Nov 09, 2006 8:30 pm
Location: California, USA

Re: MySQL automatic generated some weird numbers

Post 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).
cyberlei
Forum Commoner
Posts: 27
Joined: Tue Oct 16, 2007 6:19 pm
Location: Milpitas, CA

Re: MySQL automatic generated some weird numbers

Post 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
Attachments
screen shoot2.JPG
screen shoot2.JPG (31.35 KiB) Viewed 178 times
wired numbers.JPG
wired numbers.JPG (42.84 KiB) Viewed 179 times
User avatar
califdon
Jack of Zircons
Posts: 4484
Joined: Thu Nov 09, 2006 8:30 pm
Location: California, USA

Re: MySQL automatic generated some weird numbers

Post 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.
cyberlei
Forum Commoner
Posts: 27
Joined: Tue Oct 16, 2007 6:19 pm
Location: Milpitas, CA

Re: MySQL automatic generated some weird numbers

Post 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
Post Reply