danhakhavro 42 Posted January 28, 2015 Share Posted January 28, 2015 (edited) Hello metindev, I have 1 problem in my mysql, i want too create a table but when i crate it, she work fine, but when i turn pc off and back another day the table doesnt exist. If i doo backup of mysql the problem to be continued. There print of my problem. Somebody know how i can solve it? There a table of mysql: CREATE TABLE IF NOT EXISTS `XXXX` ( `id` int(11) NOT NULL AUTO_INCREMENT, `nume` varchar(30) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; Edited August 18, 2022 by Metin2 Dev Core X - External 2 Internal Link to comment Share on other sites More sharing options...
danhakhavro 42 Posted January 28, 2015 Author Share Posted January 28, 2015 (edited) Hello metindev, I have 1 problem in my mysql, i want too create a table but when i crate it, she work fine, but when i turn pc off and back another day the table doesnt exist. If i doo backup of mysql the problem to be continued. There print of my problem. Somebody know how i can solve it? There a table of mysql: CREATE TABLE IF NOT EXISTS `XXXX` ( `id` int(11) NOT NULL AUTO_INCREMENT, `nume` varchar(30) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; Somebody know why this happen? Its really boring... Edited August 18, 2022 by Metin2 Dev Core X - External 2 Internal Link to comment Share on other sites More sharing options...
Reboot 772 Posted January 28, 2015 Share Posted January 28, 2015 Table not exista ))) logicaly =))) Link to comment Share on other sites More sharing options...
danhakhavro 42 Posted January 28, 2015 Author Share Posted January 28, 2015 Table not exista ))) logicaly =))) This table delete automaticaly and i dont know why. Now its work fine, but now i go sleep back tomorrow and the table doesn´t exist again. Link to comment Share on other sites More sharing options...
danhakhavro 42 Posted January 29, 2015 Author Share Posted January 29, 2015 (edited) Hello metindev, I have 1 problem in my mysql, i want too create a table but when i crate it, she work fine, but when i turn pc off and back another day the table doesnt exist. If i doo backup of mysql the problem to be continued. There print of my problem. Somebody know how i can solve it? There a table of mysql: CREATE TABLE IF NOT EXISTS `XXXX` ( `id` int(11) NOT NULL AUTO_INCREMENT, `nume` varchar(30) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; Somebody know why this happen? Its really boring... Edited August 18, 2022 by Metin2 Dev Core X - External 2 Internal Link to comment Share on other sites More sharing options...
flexio 83 Posted January 29, 2015 Share Posted January 29, 2015 try ENGINE=MyISAM DEFAULT CHARSET=latin1; Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now