Re: OT: SQL database - some questions

this server I got a backup of a sql database. The system that ran > that time, was wordpress, and the database is called something like > "bla_bla_wp2016018_911.sql.gz" > > On this website I wrote some blogs, which I want to have back. > > So my question: Are these blogs con

Re: OT: SQL database - some questions

. From this server I got a backup of a sql database. The system that ran that time, was wordpress, and the database is called something like "bla_bla_wp2016018_911.sql.gz" On this website I wrote some blogs, which I want to have back. So my question: Are these blogs content in this data

Re: OT: SQL database - some questions

this server I got a backup of a sql database. The system that ran > that time, was wordpress, and the database is called something like > "bla_bla_wp2016018_911.sql.gz" > > On this website I wrote some blogs, which I want to have back. > > So my question: Are

Re: OT: SQL database - some questions

On Wed, 28 Jun 2017 15:12:26 +0200 Hans wrote: > Hi Greg, > huu, that looks quite difficult for me. > > Start by actually reading the compressed backup, using zless. See > > whether it looks like an SQL dump. If it does, then you can > > proceed to the next steps. >

Re: OT: SQL database - some questions

Hi Greg, huu, that looks quite difficult for me. > Start by actually reading the compressed backup, using zless. See whether > it looks like an SQL dump. If it does, then you can proceed to the next > steps. > Ho dso I do this? I unzipped my *.sql.gz and have now *.sql file. How can I

Re: OT: SQL database - some questions

On Wed, Jun 28, 2017 at 02:25:55PM +0200, Hans wrote: > sqlbrowser looked best promising, but my sql databases can't be opened with > it. I want to export the *.sql file into a new database, but I get stuck with > an error. Telling ???e "unknown statement: 1#, unrecogized token: 1"#"", so > it

Re: OT: SQL database - some questions

sqlbrowser looked best promising, but my sql databases can't be opened with it. I want to export the *.sql file into a new database, but I get stuck with an error. Telling ḿe "unknown statement: 1#, unrecogized token: 1"#"", so it looks like a format error. Well, I do not know, what is

Re: OT: SQL database - some questions

On Wed, 28 Jun 2017 10:53:02 +0200 Hans <hans.ullr...@loop.de> wrote: Hello Hans, >Maybe I should precise my question: How can I restore my data from this >sql database on my desktop? Is there a tool to extract my blogs? 'sqlitebrowser' _may_ be of some assistance. Disclaimer; I'

Re: OT: SQL database - some questions

was looking for. After restore, you can browse the tables to find your blogs using Tora, phpMyAdmin, or any other tools. All the data will be of course with html tags. Maybe I should precise my question: How can I restore my data from this sql database on my desktop? Is there a tool to extract my

Re: OT: SQL database - some questions

Hi Hans, > Maybe I should precise my question: How can I restore my data from this sql > database on my desktop? Is there a tool to extract my blogs? > > I do not want to build a webserver with php and wordpress and so on, just > extract my blogs. Phpmyadmin needs a w

Re: OT: SQL database - some questions

store, you can browse the tables to find your blogs using > Tora, phpMyAdmin, or any other tools. > All the data will be of course with html tags. > Maybe I should precise my question: How can I restore my data from this sql database on my desktop? Is there a tool to extract my blogs? I do

Re: OT: SQL database - some questions

Hi Hans, > I had had a webserver hosted by a provider, which is switched off since a > year. From this server I got a backup of a sql database. The system that ran > that time, was wordpress, and the database is called something like > "bla_bla_wp2016018_911.sql.gz" i supp

OT: SQL database - some questions

Dear list, this is a little offtopic, but maybe you can make things a little bit clearer for me. I had had a webserver hosted by a provider, which is switched off since a year. From this server I got a backup of a sql database. The system that ran that time, was wordpress, and the database

Re: [OT] sql database webmail?

On Wed, 2001-08-22 at 21:21, Eric Boo wrote: Hi all, I would like to ask, which GPL/BSD licensed web mail program out there stores info in an SQL database? Most do. IMP is fairly nice: http://www.horde.org/imp Most importantly, it must store the user and password in the database

Re: [OT] sql database webmail?

Sorry, but I do not quite understand. If I use imapd with SQL database support (what's a good one that does this?), don't I still need to create user accounts on the system so the smtp server can deliver to the user directory (or some other location). I'm actually looking for a web mail that does

Re: [OT] sql database webmail?

A long time ago, in a galaxy far, far way, someone said... Sorry, but I do not quite understand. If I use imapd with SQL database support (what's a good one that does this?), don't I still need to create user accounts on the system so the smtp server can deliver to the user directory (or some

[OT] sql database webmail?

Hi all, I would like to ask, which GPL/BSD licensed web mail program out there stores info in an SQL database? Most importantly, it must store the user and password in the database and not touch the /etc/passwd Thanks, and regards. Eric

Re: which SQL database?

John Hasler [EMAIL PROTECTED] writes: Randy Edwards writes: Both have excellent manuals and tutorials. Being in the process of teaching myself SQL by way of PostgreSQL, I have to say that the PostgreSQL docs fall far short of my definition of excellent. I'm afraid that I'd agree, but the

which SQL database?

Hi! I wanted to setup a Apache+PHP3 Intranet Database Server, Orcale, MySQL or PostgreSQL, which one is more easy to learn and config also better supported by Apache+PHP3 ?

Re: which SQL database?

On Fri, Jun 09, 2000 at 21:21:37 +0800, Alex Kwan wrote: I wanted to setup a Apache+PHP3 Intranet Database Server, Orcale, MySQL or PostgreSQL, which one is more easy to learn and config also better supported by Apache+PHP3 ? I haven't worked with Oracle, but I suspect it is quite complex

Re: which SQL database?

I wanted to setup a Apache+PHP3 Intranet Database Server, Orcale, MySQL or PostgreSQL, which one is more easy to learn and config also better supported by Apache+PHP3 ? As far as ease of learning I'd say they're a tossup, six in one hand, half-dozen in the other (not saying I'm an expert in

Re: which SQL database?

Randy Edwards writes: Both have excellent manuals and tutorials. Being in the process of teaching myself SQL by way of PostgreSQL, I have to say that the PostgreSQL docs fall far short of my definition of excellent. -- John Hasler [EMAIL PROTECTED] (John Hasler) Dancing Horse Hill Elmwood, WI

Re: which SQL database?

On Fri, Jun 09, 2000 at 04:26:26PM -0400, Randy Edwards wrote: MySQL is faster, but at the sake of some redundancy/features. MySQL also has a quirky, non-free license. PostgreSQL is slower but is a fuller SQL implementation. It's also DFSG free. Someone did some benchmarking awhile

Re: SQL database editor?

Alexander Kushnirenko [EMAIL PROTECTED] wrote: I have MySQL database and sometimes need to modify few entries there. So far I was doing it using SQL language, which is not very convenient in this situation. Is there simple SQL database editor to do that? With a Postgresql database

SQL database editor?

Hi, I have MySQL database and sometimes need to modify few entries there. So far I was doing it using SQL language, which is not very convenient in this situation. Is there simple SQL database editor to do that? Thank you, Sasha.

Re: SQL Database performance

Jeff Noxon [EMAIL PROTECTED] writes: Postgresql runs like greased lightning. In some tests involving 0.5 million records of a few K in size, it blew away MS SQL Server. I think it was version 6. Postgresql runs well, although it does have some limitations. ODBC was the main weakness I

SQL Database performance

Does anyone have a feel for the relative performance of the various SQL databases in Debian ? I'd also be interested to know how these compare to something like Oracle (under either NT or Linux). I'm looking to manage two databases: one of roughly ten thousand records a few k in size, the other

Re: SQL Database performance

On Thu, Nov 19, 1998 at 04:58:00PM +, Martin Oldfield wrote: Does anyone have a feel for the relative performance of the various SQL databases in Debian ? I'd also be interested to know how these compare to something like Oracle (under either NT or Linux). I'm looking to manage two

Re: SQL Database performance

See http://www.tcx.se/benchmark.html for some interesting benchmarks comparing several common db systems including oracle, ms-sql, pgsql, and others. For a pretty comprehensive comparison of database system limitations and capabilities, see http://www.tcx.se/crash-me-choose.htmy I use MySQL for

sql database

Hi, Has anyone done any benchmark/comparison between these databases? mSQL, MySQL, PostGres95 in term of performance, application interfaces such as perl, tcl, and drivers such as odbc, jdbc, etc. Thanks! -- Timothy C. Phan ([EMAIL PROTECTED])

Re: sql database

Timothy Phan wrote: Hi, Has anyone done any benchmark/comparison between these databases? mSQL, MySQL, PostGres95 in term of performance, application interfaces such as perl, tcl, and drivers such as odbc, jdbc, etc. There have been some comparisons on the PostgreSQL