6 errors when loading (importing) an sql file

[expired user #10198]'s profile image [expired user #10198] posted 7 years ago in Import/Export Permalink

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.

ansgar's profile image ansgar posted 7 years ago Permalink

We will have to find out which "option" in the CREATE TABLE code is meant. So, it would be good if you post the SQL code for one of the tables here.

[expired user #10198]'s profile image [expired user #10198] posted 7 years ago Permalink

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 /;

Rajesh Modi's profile image Rajesh Modi posted 7 years ago Permalink

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.