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.
