mysql majour problem

parsajax

Verified User
Joined
Jun 11, 2008
Messages
20
Hi
I Have a dedicated server with debian 5 and directadmin
i moved my sites from old server to the new one by admin backup
and any Auto Increment did set to 1 in all databases
and i change it to x and reset the server and it backed to 1
i was download backup of db and manually set those to x and reseted the server. but it still changed to 1.
anyone can help me?
 

parsajax

Verified User
Joined
Jun 11, 2008
Messages
20
i found that its because of InnoDb Database types convertion and i changed my databases types to MyIsam and the problem solved.

any body can Learn Me How I Can change all db types to MyIsam in the fastes way?
 
Top