Use mysqldump to extract the data out of the database. then edit the resultant file to get rid of the "CREATE TABLE" preamble. Then use the mysql command to read it back into the old database (use the SOURCE command).
On Fri, Sep 6, 2024 at 1:18 AM J. H. <[email protected]> wrote: > Hello, I would like to insert the data for 2018 into my existing Mariadb. > The data is on the memory card of an HP1000. Importing via CSV import has > not been successful so far because of the date formats. If I start weewx > with an empty DB, the data is immediately recognized and transferred. What > possibilities are there ... still? Thank you > > -- > You received this message because you are subscribed to the Google Groups > "weewx-user" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/weewx-user/8e6cb98c-deb5-4eb2-ac7b-1a87227af97fn%40googlegroups.com > <https://groups.google.com/d/msgid/weewx-user/8e6cb98c-deb5-4eb2-ac7b-1a87227af97fn%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- You received this message because you are subscribed to the Google Groups "weewx-user" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/CAPq0zEAZbzr29z9-8M6BHTP3RUCszL_-6pb8rsU8caDEfqFFZw%40mail.gmail.com.
