That's what you get if you try it on an empty file. Try it on weewx.sdb, the file that WeeWX uses.
-tk On Mon, Jan 21, 2019 at 5:02 AM Cycle London <[email protected]> wrote: > 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. > -- 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.
