[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 112: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 112: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 112: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 112: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4762: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3897)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4764: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3897)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4765: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3897)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4766: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3897)
nodo-domotica.nl • Toon onderwerp - Export van Webapp-database vanaf Synology - Afdrukweergave
nodo-domotica.nl
http://www.nodo-domotica.nl/forum/

Export van Webapp-database vanaf Synology
http://www.nodo-domotica.nl/forum/viewtopic.php?f=36&t=2437		 Pagina 1 van 1
Auteur:  PieterS [ 15 maart 2015, 22:52 ]
Titel:  Export van Webapp-database vanaf Synology
Beste Nodo-gebruikers,

Draait er misschien iemand van deze gebruikersgroep de webapp op een Synology-NAS met de versie DSM 5.1...
Helaas heb ik onlangs de database van de (inmiddels oude) webapp vernaggeld. En de export die ik in januari gemaakt had bleek niet meer ingelezen te kunnen worden.

Synology draait met DSM 5.1-5022
SQL-database is MariaDB versie 5.5.4-0029

Middels phpMyAdmin de oude SQL-database importeren lukt niet meer:



Hopelijk is er iemand bereid om een export te doen van zijn Nodo-database en de tabelstructuur met indexen beschikbaar te stellen?
De orginele structuur blijkt niet zondermeer in te lezen. MariaDB is wat kritischer geworden met veldnamen o.i.d. zo lijkt het. :oops:



Ik zou er erg mee geholpen zijn... Alvast bedankt.
Pieter
Auteur:  tazitiz [ 16 maart 2015, 13:04 ]
Titel:  Re: Export van Webapp-database vanaf Synology
Hoi Pieter,

kan je de Hele alinea uit je export hier plaatsen (liefst als text ipv plaatje deze keer) met de regel erin waar staat:
create table if not exists `nodo_tbl_devices`

dan kan ik er misschien een tip over geven.


Walter
Auteur:  PieterS [ 16 maart 2015, 14:17 ]
Titel:  Re: Export van Webapp-database vanaf Synology
Auteur:  PieterS [ 16 maart 2015, 17:23 ]
Titel:  Re: Export van Webapp-database vanaf Synology
Auteur:  henkdejonge [ 17 maart 2015, 09:22 ]
Titel:  Re: Export van Webapp-database vanaf Synology
Auteur:  PieterS [ 17 maart 2015, 20:44 ]
Titel:  Re: Export van Webapp-database vanaf Synology
Dag Henk,

Bedankt voor je reactie en moeite.
Één vraagje: ik ga er van uit dat jij de structuur van je Webapp-database niet hebt aangepast?
Just in case...
Auteur:  henkdejonge [ 18 maart 2015, 13:00 ]
Titel:  Re: Export van Webapp-database vanaf Synology
Auteur:  PieterS [ 19 maart 2015, 21:49 ]
Titel:  Re: Export van Webapp-database vanaf Synology
Dag Henk,

Ik heb zeker wat aan de aangeleverd info gehad. Na de opmaak/layout wat prettiger leesbaar gemaakt te hebben een vergelijkingsslag gemaakt. Daarbij bleek dat in de tabel Nodo_tbl_activities de primary key was weggehaald. In hoeverre dat een probleem veroorzaakt in het gebruik weet ik niet. Ik werk niet met Activiteiten... :shock:
Maar nu is die twijfel in elk geval weg!

Bedankt! En ik heb nu in elk geval weer een goede backup en documentatie. ;)

Gr.
Pieter
Pagina 1 van 1 Alle tijden zijn GMT + 1 uur
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/