Hi Thomas, I'll give you a screenshot this time, so you know I'm not actually lying about what I'm typing and what result I'm getting....
On Mon, 21 Jan 2019 at 12:58, Thomas Keffer <[email protected]> wrote: > Try either > > .table > > or > > SELECT tbl_name FROM sqlite_master WHERE type='table'; > > -tk > > > On Mon, Jan 21, 2019 at 4:54 AM Cycle London <[email protected]> > wrote: > >> Hi Andrew, >> >> Please forgive me, I'm not being deliberately thick, and I'm not trying >> to annoy anyone. Tried the above - even tried to remove the space between >> the command the semicolon, just in case sqllite handled white space >> differently than MySQL ... >> >> [cyclellondon@weather ~]$ sqlite3 archive.sdb >> SQLite version 3.7.17 2013-05-20 00:56:22 >> Enter ".help" for instructions >> Enter SQL statements terminated with a ";" >> sqlite> show tables ; >> Error: near "show": syntax error >> sqlite> show tables; >> Error: near "show": syntax error >> >> On Mon, 21 Jan 2019 at 12:50, Andrew Milner <[email protected]> >> wrote: >> >>> you are being very obscure >>> >>> SQLite only has one database in use at one time - the one you open >>> >>> usage - eg - sqlite3 archive.sdb >>> >>> then you can >>> show tables; >>> >>> >>> >>> On Monday, 21 January 2019 14:41:10 UTC+2, Cycle London wrote: >>>> >>>> CHeers. Those links aren't really clear. Maybe i'm too old. Or too >>>> dim. >>>> >>>> Anyway, time to gird my loins, snapshot the VM .. and just do it. >>>> >>>> On Mon, 21 Jan 2019 at 10:42, gjr80 <[email protected]> wrote: >>>> >>>>> Regards transferring from SQLite to MySQL have you ready through the >>>>> Transfer from SQLite to MySQL page of the wiki ( >>>>> https://github.com/weewx/weewx/wiki/Transfer%20from%20sqlite%20to%20MySQL) >>>>> and the Configuring MySQL section of the User's Guide ( >>>>> http://weewx.com/docs/usersguide.htm#configuring_mysql) ? >>>>> >>>>> Those two areas have about everything you need for the transfer. >>>>> >>>>> Gary >>>>> >>>>> -- >>>>> You received this message because you are subscribed to a topic in the >>>>> Google Groups "weewx-user" group. >>>>> To unsubscribe from this topic, visit >>>>> https://groups.google.com/d/topic/weewx-user/nlfPiicnLsw/unsubscribe. >>>>> To unsubscribe from this group and all its topics, send an email to >>>>> [email protected]. >>>>> For more options, visit https://groups.google.com/d/optout. >>>>> >>>> -- >>> You received this message because you are subscribed to a topic in the >>> Google Groups "weewx-user" group. >>> To unsubscribe from this topic, visit >>> https://groups.google.com/d/topic/weewx-user/nlfPiicnLsw/unsubscribe. >>> To unsubscribe from this group and all its topics, send an email to >>> [email protected]. >>> For more options, visit https://groups.google.com/d/optout. >>> >> -- >> 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]. >> For more options, visit https://groups.google.com/d/optout. >> > -- > You received this message because you are subscribed to a topic in the > Google Groups "weewx-user" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/weewx-user/nlfPiicnLsw/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- 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]. For more options, visit https://groups.google.com/d/optout.
