Joomla.it Forum

Joomla! 3 => Installazione, migrazione e aggiornamento => : gbfonzie 07 Feb 2017, 00:09:17

: Problema importazione db - da locale a remoto
: gbfonzie 07 Feb 2017, 00:09:17

Salve ho sviluppato un sito in locale e sto avendo problemi per portare il tutto in remoto. Quando importo il DB mi da il seguente errore, qualcuno è in grado di aiutarmi pls?! :-\


ErroreQuery SQL:
(http://mysql.aruba.it/phpMyAdmin-5/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.0%2Fen%2Fcreate-table.html&token=21b8ad2dc4ad8f318e23d7503d8990ee&phpMyAdmin=kdrni7sbuisgbfkalc1892dprc6213g9)CREATETABLE[/url]`zna_assets`(`id` (http://mysql.aruba.it/phpMyAdmin-5/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.0%2Fen%2Fnumeric-types.html&token=21b8ad2dc4ad8f318e23d7503d8990ee&phpMyAdmin=kdrni7sbuisgbfkalc1892dprc6213g9)INT[/url](10)UNSIGNEDNOTNULLAUTO_INCREMENTCOMMENT'Primary Key',`parent_id` (http://mysql.aruba.it/phpMyAdmin-5/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.0%2Fen%2Fnumeric-types.html&token=21b8ad2dc4ad8f318e23d7503d8990ee&phpMyAdmin=kdrni7sbuisgbfkalc1892dprc6213g9)INT[/url](11)NOTNULLDEFAULT'0'COMMENT'Nested set parent.',`lft` (http://mysql.aruba.it/phpMyAdmin-5/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.0%2Fen%2Fnumeric-types.html&token=21b8ad2dc4ad8f318e23d7503d8990ee&phpMyAdmin=kdrni7sbuisgbfkalc1892dprc6213g9)INT[/url](11)NOTNULLDEFAULT'0'COMMENT'Nested set lft.',`rgt` (http://mysql.aruba.it/phpMyAdmin-5/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.0%2Fen%2Fnumeric-types.html&token=21b8ad2dc4ad8f318e23d7503d8990ee&phpMyAdmin=kdrni7sbuisgbfkalc1892dprc6213g9)INT[/url](11)NOTNULLDEFAULT'0'COMMENT'Nested set rgt.',`level` (http://mysql.aruba.it/phpMyAdmin-5/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.0%2Fen%2Fnumeric-types.html&token=21b8ad2dc4ad8f318e23d7503d8990ee&phpMyAdmin=kdrni7sbuisgbfkalc1892dprc6213g9)INT[/url](10)UNSIGNEDNOTNULLCOMMENT'The cached level in the nested tree.',`name` (http://mysql.aruba.it/phpMyAdmin-5/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.0%2Fen%2Fstring-types.html&token=21b8ad2dc4ad8f318e23d7503d8990ee&phpMyAdmin=kdrni7sbuisgbfkalc1892dprc6213g9)VARCHAR[/url](50)COLLATEutf8mb4_unicode_ciNOTNULLCOMMENT'The unique name for the asset.\n',`title` (http://mysql.aruba.it/phpMyAdmin-5/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.0%2Fen%2Fstring-types.html&token=21b8ad2dc4ad8f318e23d7503d8990ee&phpMyAdmin=kdrni7sbuisgbfkalc1892dprc6213g9)VARCHAR[/url](100)COLLATEutf8mb4_unicode_ciNOTNULLCOMMENT'The descriptive title for the asset.',`rules` (http://mysql.aruba.it/phpMyAdmin-5/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.0%2Fen%2Fstring-types.html&token=21b8ad2dc4ad8f318e23d7503d8990ee&phpMyAdmin=kdrni7sbuisgbfkalc1892dprc6213g9)VARCHAR[/url](5120)COLLATEutf8mb4_unicode_ciNOTNULLCOMMENT'JSON encoded access control.',PRIMARYKEY(`id`),UNIQUEKEY`idx_asset_name`(`name`),KEY`idx_lft_rgt`(`lft`,`rgt`),KEY`idx_parent_id`(`parent_id`))ENGINE=INNODBDEFAULTCHARSET= utf8mb4 COLLATE= utf8mb4_unicode_ci AUTO_INCREMENT=85;
Messaggio di MySQL: #1273 - Unknown collation: 'utf8mb4_unicode_ci'


[/font][/size]

: Re:Problema importazione db - da locale a remoto
: marine 07 Feb 2017, 02:42:24

prova ad usare akeeba backup

https://extensions.joomla.org/extensions/extension/access-a-security/site-security/akeeba-backup/

: Re:Problema importazione db - da locale a remoto
: tomtomeight 07 Feb 2017, 07:45:04

Hai versioni db diverse fra locale e remoto. Apri il file peima di importare ed elimina ogni riferimento alla collation utf8mb4. In alternativa chiedi all'hoster di aggiornare mysql.