Im new to databasing and using Heidisql version 9.1.0.4867 (32 bit) on XP. Im impressed with heidisql and am getting on ok , the only thing im curious about is that i work between two computers so routinely have to export the database and then import it so that it replaces the pre-existing version, and always when i load the sql file i get the following error message ; " your query produced 6 warnings. Warnings from last query: Note: Storage engine InnoDB of the table 'postcards'.'theatres' dosnt have this option" Where 'postcards is the name of the database and 'theatres' is the name of the bottom of 3 tables present in the database. Im using InnoDB , the default engine. What does this error message mean ? Incidentally everything seemingly loads fine and works fine - but i always get this error message.
6 errors when loading (importing) an sql file
Thanks for your attention ansgar. Here is the text for the theatre table copied from the sql file , with the data clipped , i can post the data if you need it but i presumed it wasnt necessary.
-- Dumping structure for table postcards.theatres
CREATE TABLE IF NOT EXISTS theatres
(
location
varchar(200) COLLATE utf8_unicode_ci NOT NULL,
sub
varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
name
varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
album
int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci MAX_ROWS=200 AVG_ROW_LENGTH=100;
-- Dumping data for table postcards.theatres: ~78 rows (approximately)
/!40000 ALTER TABLE theatres
DISABLE KEYS /;
INSERT INTO theatres
(location
, sub
, name
, album
) VALUES
('london', NULL, 'albert hall', 36),
<>
('london', '', 'lyric', 14);
/!40000 ALTER TABLE theatres
ENABLE KEYS /;
/!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') /;
/!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) /;
/!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT /;
Dear Sir,
i am getting this error after access thru HS database my site is down now Kindly someone can help me out
There has been an error processing your request SQLSTATE[28000] [1045] Access denied for user 'rweb45dd_mitha'@'localhost' (using password: YES)
Trace:
0 /home/rweb45dd/public_html/mithaiboxes.com/lib/Zend/Db/Adapter/Pdo/Mysql.php(111): Zend_Db_Adapter_Pdo_Abstract->_connect()
1 /home/rweb45dd/public_html/mithaiboxes.com/lib/Varien/Db/Adapter/Pdo/Mysql.php(396): Zend_Db_Adapter_Pdo_Mysql->_connect()
2 /home/rweb45dd/public_html/mithaiboxes.com/lib/Zend/Db/Adapter/Abstract.php(460): Varien_Db_Adapter_Pdo_Mysql->_connect()
3 /home/rweb45dd/public_html/mithaiboxes.com/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SET NAMES utf8', Array)
4 /home/rweb45dd/public_html/mithaiboxes.com/lib/Varien/Db/Adapter/Pdo/Mysql.php(504): Zend_Db_Adapter_Pdo_Abstract->query('SET NAMES utf8', Array)
5 /home/rweb45dd/public_html/mithaiboxes.com/app/code/core/Mage/Core/Model/Resource.php(179): Varien_Db_Adapter_Pdo_Mysql->query('SET NAMES utf8')
6 /home/rweb45dd/public_html/mithaiboxes.com/app/code/core/Mage/Core/Model/Resource.php(110): Mage_Core_Model_Resource->_newConnection('pdo_mysql', Object(Mage_Core_Model_Config_Element))
7 /home/rweb45dd/public_html/mithaiboxes.com/app/code/core/Mage/Core/Model/Resource/Setup.php(141): Mage_Core_Model_Resource->getConnection('core_setup')
8 /home/rweb45dd/public_html/mithaiboxes.com/app/code/core/Mage/Core/Model/Resource/Setup.php(234): Mage_Core_Model_Resource_Setup->__construct('core_setup')
9 /home/rweb45dd/public_html/mithaiboxes.com/app/code/core/Mage/Core/Model/App.php(428): Mage_Core_Model_Resource_Setup::applyAllUpdates()
10 /home/rweb45dd/public_html/mithaiboxes.com/app/code/core/Mage/Core/Model/App.php(354): Mage_Core_Model_App->_initModules()
11 /home/rweb45dd/public_html/mithaiboxes.com/app/Mage.php(684): Mage_Core_Model_App->run(Array)
12 /home/rweb45dd/public_html/mithaiboxes.com/index.php(83): Mage::run('', 'store')
13 {main}
Error log record number: 345585869435
Please login to leave a reply, or register at first.